File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Another Question about datetime Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Another Question about datetime" Watch "Another Question about datetime" New topic

Another Question about datetime

Anurag Saxena

Joined: Oct 29, 2002
Posts: 13
I am using-
if coulmn is of type 'datetime', 'nvarchar' or 'numeric' what
corrosponding getXXX() methods should I use?
My database is in MS SQL server.
Also, When I am doing these statements seperately
it works by when running together it gives an error: Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
here what I am doing:
tr.tranDate = rs.getDate("TR_DATE");
tr.chipTranId = rs.getInt("CHIPTRAN_ID");
Thanks for the help.
[ November 14, 2002: Message edited by: Anurag Saxena ]
I agree. Here's the link:
subject: Another Question about datetime
It's not a secret anymore!