File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Another Question about datetime Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Another Question about datetime" Watch "Another Question about datetime" New topic
Author

Another Question about datetime

Anurag Saxena
Greenhorn

Joined: Oct 29, 2002
Posts: 13
Hi:
I am using-
resultSet.getXXX("columnName");
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 ]
 
Consider Paul's rocket mass heater.
 
subject: Another Question about datetime