aspose file tools*
The moose likes JDBC and the fly likes JDBC-SQL- resultset retreival Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC-SQL- resultset retreival" Watch "JDBC-SQL- resultset retreival" New topic
Author

JDBC-SQL- resultset retreival

shailja mishra
Greenhorn

Joined: Mar 06, 2001
Posts: 5
I have a problem.I got the user defined type of variale in MS SQL for a filed 'material_qty' the data type of the field is of type 'QTY' which is an integer.
when I an retieving it through rs.getInt('material_qty') then it gives an exception -'Invalid descriptor Index'.Can you please help me & let me know that how should I retrive such user defined data types.
Thanx in advance
Shailja
Shripad Bokil
Greenhorn

Joined: Jan 30, 2001
Posts: 13
Hi
Pls first insure that the field 'material_qty' is an integer or String.If it is string field than use rs.getString otherwise try giving the column no.for the field 'material_qty' instead of its name. like...rs.getInt(1)...remember column index starts from 1 & not from 0.
Hope it works.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC-SQL- resultset retreival
 
Similar Threads
Type Definitions in java
How to pass class object in call to pl/sql procedure ?
org.hibernate.MappingException: Could not determine type for...
Result Set problems
parsing in servlet