This is something I've always wanted to learn. When I design a system (software or hardware) where multiple components communicate with each other, how can I implement some simple encryption or other features in the protocol for some basic security? I can change the protocol anyhow, since I have low-level access down to the series of by...
I have read a lot of questions regarding this subject on this website however they didn't quiet answer my question. If you can't be ### about my goal or background skip to the question. My Goal Is to build a server that can run on Mac OS X 10.4+ and later, port it to Windows XP/Vista (no idea how to do that yet, but that's a problem f...
Hi, I am sorry if this sounds like a silly question, but I have googled for a while for a solution and no success. I am trying to establish a connection from VS 2008 to SQL Server. I am trying to use an user that my web application has been successfuly using to access the database from in its connection string. But when doing it from VS ...
Hello I recently wrote and deployed a Java web application to a server and I'm finding an unusual problem which didn't appear during development or testing. When a user logs in after so long and goes to display data from the database, the page indicates that there are no records to see. But upon page refresh, the first x records are sh...
I have a j2ee webapp that's being used internally by ~20-30 people. There is no chance of significant growth in the number of users. From what I understood there's a trade-off between opening a new DB connection for each request made to the webapp (expensive, but doesn't block other users when the DB is in use), to using the singleton ...
I'm creating and dropping databases on the fly for some integration tests. I'm doing all the database management at the ADO.NET level. For the tests I'm using Entity Framework because the entities is one part of what I am testing. The problem is that after I do this: using (ProjectEntities db = new ProjectEntities(cs)) { } I cannot dr...
Hi all, I am having problems connecting to an AMI that I created by modifying an existing linux ami, bundling it and registering it. Heres what I did - Launch existing CentOS AMI (ami-cb52b6a2) - this is a Rightscale LAMP image configured Apache, PHP etc and copied over some PHP scripts etc Tested it - all worked as I want it to I bun...
I'm in charge of developing and maintaining a group of Web Applications that are centered around similar data. The architecture I decided on at the time was that each application would have their own database and web-root application. Each application maintains a connection pool to its own database and a central database for shared data ...
I'm writing a server application that's communication with a local sql server. Each client will need to read or write data to the database. Would it be better to have a thread safe class which will enqueue and executes the sql commands on a single sql connection? Or should I open a new connection for each command? Does it matter much f...
Hi All; I am new to Firebird using its Java version Jaybird, But unable to connect from database (.fdb file). The problem comes like this: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544375. unavailable database OR java.lang.RuntimeException: Failed to initilize Jaybird native library. This is most likley due to a failure ...
Is this the correct way to access a MS Office Excel 2007 file? String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file_path + ";Extended Properties=Excel 8.0;"; If so, how do I access a certain worksheet and insert rows? Links are also welcomed. ...
We're having some intermittant connection problems connecting to our few SQL 2000 servers, but only seemingly from our SSMS 2008 workstations - there don't appear to be any actual business applications that aren't able to connect. Most of the time, SSMS connects just fine, but sometimes, I'll need to manually set the connection protocol ...
Hi all, If i connect a device (USB dRIVE,USBcAMERA,ETC) to my system, I should found out which one is connected to the usb port. Is there a way to do it? ...
Hi all, I've struggling to find a way to get and change and excel 2007 workbook connection (Menu Data -> Existing Connections -> Connections on this Workbook).It's a connection (several actually) to a SQL Server and used in a pivot table. I've tried using Application.ActiveWorkbook.Connections or Globals.ThisWorkbook.Connections but th...
I'm writing an ASP.NET web application which will run on Windows Server 2008 (IIS7). Each page's codebehind will need to make at least one synchronous web service call to an external server using HttpWebRequest and GET. My question - is there any limit to the number of outbound HttpWebRequest calls I can make? (assume that the server I...
We are running a websphere commerce site with an oracle DB and facing an issue where we are running out of db connections. We are using a JDBCHelper singleton for getting the prepared statements and cosing the connections. public static JDBCHelper getJDBCHelper() { if (theObject == null){ ...
I have an RMI server and a desktop RMI client. When I restart the server, I get errors in the client. Is it possible to restart the RMI connection without restarting the client? [EDIT] Here is the stacktrace: java.rmi.ConnectException: Connection refused to host: xxx.xxx.xxx.xxx; nested exception is: java.net.ConnectException: Con...
I read about "HTTP persistent connection" but somehow I don't seem to understand what does persistent mean in this context. Could you'll elaborate? ...
hi all, After making a tcp connection to a server, I close my linux application and Socket.close() is called. Checking netstat -pant, I see the connection is in TIME_WAIT status. This prevents me from making an immediate connection back to the server since I'm using the same port to connect from. Instead, I have to wait for the conne...
$con = mysql_connect("localhost:".$LOCAL_DB_PORT, $LOCAL_DB_USER, $LOCAL_DB_PASS); mysql_select_db("hr", $con); mysql_query("set names utf8", $con); while(true) { do_stuff($con); sleep(50); } If connection timesout in 50 seconds,will $con still work? ...