wood burning stoves 2.0*
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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 ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Another Question about datetime