File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes help!! ResultSet error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
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: 61106

"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] [Bear's FrontMan] [About Bear] [Books by Bear]
wood burning stoves
subject: help!! ResultSet error