Debbie Argulkar

Hi Mark,
Thanks. That most certainly helps. I will try it out and let you know how it goes.
Thanks,
-Deb

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 pointers. I will try exactly that.
-Deb

Hi Veena,
Thanks. I will try that out.
-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,
Thanks for the prompt and helpful replies.
I do have a GUI which should start and stop the data transmission (from db) by a socket.
Thanks,
-Deb

Hi,
Take a look at this. It might be helpful:
http://www.visualmining.com/developers/programming/netcharts-jsp-jdbc.html
Rgds,
-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,
I meant close the streams not connections ( Line 5).
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 :
Socket s = new Socket("time-A.timefreq.bldrdoc.gov", 13); BufferedReader in = new BufferedReader(new InputStreamReader(s.getInputStream())); String line; while(( line = in.readLine()) != null) System.out.println(line); }
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

Hi,
I just modified the data in the DefaultTableModel and it worked!!!
Thanks,
-Deb

Hi Avi,
Thanks a lot for your prompt and helpful reply. I am going through those chapters now and will hopefully solve the problem.
Thanks
-Deb