jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes help!! ResultSet error 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 "help!! ResultSet error" Watch "help!! ResultSet error" New topic

help!! ResultSet error

yashko yashko

Joined: Apr 20, 2004
Posts: 2
help! I get an Unexpected Exception: java.lang.ArrayIndexOutOfBoundsException message given: 65603 on the line rs=stmt.executeQuery(sqlString). where sqlString="SELECT * from <table>". The table that I query has a column that is of "text" type. my database is MySQL.
what's the problem with this? is it the jdbc driver that i use?
Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Send the full code
yashko yashko

Joined: Apr 20, 2004
Posts: 2
Connection conn = DBConnnector.getConnection();
Statement stmt=conn.createStatement();
String sql="SELECT * from article";
ResultSet rs;
}catch(Exception ex){
Sorry, but this is only what I can show. DBConnector
is a class where I get the Connection to the database.
My database is MySQL. In the table article, I have a
column of "text" type.The actual code is very much like
this. The exception was thrown at rs=stmt.executeQuery(sql);
sandesh bangera

Joined: Nov 13, 2002
Posts: 12
have you tried running this code by seleting just a single column from the your table.
try this out and see if you code can handle this.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63533

"yashko yashko",
We're pleased to have you here with us in the JSP forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Forum Bartender

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link: http://aspose.com/file-tools
subject: help!! ResultSet error
It's not a secret anymore!