jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Date Type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Date Type" Watch "Date Type" New topic

Date Type

sandy yang

Joined: Jan 26, 2001
Posts: 8
I using MS SQL Server's Northwind database as my simple database,
I try to display information form Employees table, the data type is "TEXT" for employee's name in SQL Server. My question is: What's the matching java type for it? when I use resultSet.getObject, the program runs, and the column is blank, no employee's name will display. when I use ResultSetMetaData.getColumnTypeName, I get the data is "nvarchar". I can't find the matching java data type for it.
David Freels
Ranch Hand

Joined: Feb 01, 2001
Posts: 102
Try using resultSet.getString. The Oracle JDBC driver has problems with the getObject method so maybe your driver does as well.

I was just informed by a SQL Server admin that the nvarchar is a UNICODE field.
Hope this helps.
[This message has been edited by David Freels (edited March 09, 2001).]
I agree. Here's the link: http://aspose.com/file-tools
subject: Date Type
It's not a secret anymore!