aspose file tools
The moose likes JDBC and the fly likes BaseResultSet being returned instead of a resultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "BaseResultSet being returned instead of a resultSet" Watch "BaseResultSet being returned instead of a resultSet" New topic
Author

BaseResultSet being returned instead of a resultSet

Mitch Robinson
Ranch Hand

Joined: Oct 29, 2009
Posts: 30
Hello all,

Quick question, I'm connecting to an SQL Server database and when I execute my query it is returning my resultSet which is defined as a ResultSet as a BaseResultSet. This seems to have limited functionality and I cannot access the data using getNString(ColumnName)?

I have since noted that when I use connection.createStatement it at this point creates a BaseStatement?

Any ideas why this is happening? My guess is it's something driver related but I'm using the same driver as another application which works correctly?

Thanks,

Mitch
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

JDBC drivers should return the types the specification defines. What is the full name of the type you are getting back? What driver are you using?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: BaseResultSet being returned instead of a resultSet
 
Similar Threads
Weblogic 8.1: Configure a new JDBC Connection Pool
Problem accessing MetaData with DB2
ResultSet.next()
CachedRowSet?
ORA-01000: maximum open cursors exceeded