wood burning stoves 2.0*
The moose likes JDBC and the fly likes Woes with ResultSets and Arrays Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Woes with ResultSets and Arrays" Watch "Woes with ResultSets and Arrays" New topic

Woes with ResultSets and Arrays

Alan Watts

Joined: May 14, 2001
Posts: 28
HI there,
I am using JDBC to interrogate an Access DB with the goal of retrieving the data in one column of the DB as a java.sql.Array Array object, and then casting that Array object into an array of int, before assigning it to a variable (called "currentbid").
This ain't a trivial syntax etc error, as the code compiles fine, and runs up until the commented statement. I suspect the connection object might be interfering, although it has been tested and is working OK independently.
Any help gratefully appreciated
Alan Watts
I am having trouble executing the following block of statements:
Note that "con" is the database connection variable.
PreparedStatement pstmt1 = con.prepareStatement("SELECT Amount FROM Bids WHERE Spec = 200011;");
ResultSet r = pstmt1.executeQuery();
while (r.next()) {
Array currentbidarray = r.getArray("Amount");//This is the problem block.
int [] currentbid = (int [])currentbidarray.getArray();
Alan Watts

Joined: May 14, 2001
Posts: 28

PS. The following SQL Exception is being generated. Does this mean that this is a driver-related problem?
java.sql.SQLException: SQL 3 Data types are not supported
at easysoft.sql.jobResultSet.getArray(UnknownSource)
Alan Watts

Joined: May 14, 2001
Posts: 28
OK people,
No need for anyone to respond on this topic, as I have solved the problem. If you are interested, the problem occurred because my commercial JDBC driver does not support the JDBC 2.0 API (but rather is still at JDBC 1.2). In other words, it cannot support advanced data types such as Array objects.
I agree. Here's the link: http://aspose.com/file-tools
subject: Woes with ResultSets and Arrays
Similar Threads
Servlet hang when performing to much insert function
SQLException encountered while executing the query - however, at random situations
import data from large csv file. Help.
Help. Problem inserting Clob into Oracle 9i
Auto Commit option fails to work