Hi Mark, Thanks for your reply. Actually, the database is going to have records inserted on a continous basis by another program and my code has to read the new records and pass them to another program. The problem is that I should not read the old data again and again but only read the latest inserts. Thanks in advance, -Deb
Hi, You need the DSN. If you are using JDBC DBC as I do with MS access, you can do the following: Your connection String will be "jdbc dbc: (write DSN name here)" connection = DriverManager.getConnection(ConnectString,username, password); Hope this helps, -Deb
Hi, I need to read some data from a database and then mark the old data as read so that I don't read the same data over and over again, only the new data. I am using jbdc dbc to connect to MS Access. MS Access does not allow me to update records while I read them. Any other ideas? Thanks, -Deb
HI Michael, Thanks for the explanation or I might have been trying to do that forever! My problem with a homegrown server is that it keeps refusing connections or has them reset or has someother I/O problem. Hence the Uncle Sam server. I know I haven't described the problem accurately but please let me know if you know why I get these problems. Thanks, -Deb
Hi, Is there a way to write a PreparedStatement that will let you assign the data values to an alias? If the datacolumn in the database is called Name, can you map it to the alias "CustomerName", through the prepared statement? Is there any other way to do this? Thanks, -Deb
Hi, Are there any downsides to using the System.gc(); command in your program, for instance when you create an object (say socket) and are finished calling that object (after socket.close() . You may still create other instances of the object (say socket2). This may be a simple question, but I really need to know before I liberally sprinkle my code with System.gc(); Thanks, -Deb
Hi, I am testing out a sample client Socket that displays time and it works fine :
but I am trying to write a class that separates each function 1) Obtain a socket 2) Obtain a connection to host,port (Socket sock, String address,int portNo) 3) Read from server (Socket sock) 4) Write to server (Socket sock) 5) Close connections (Socket sock) 6) Close sockets (Socket sock)
but when I break the above code into these functions and call them from main it does't work anymore. Any suggestions? Thanks -Deb
DBC as I do with MS access, you can do the following:
. You may still create other instances of the object (say socket2). 