AppletTalk.com

Amir · Guest

Hi *

I need help before I go nuts. I've been using the batch mode
quite often for insert/updates. However I now have the case where I
need to execute multiple selects on the database. So I planned to put
them in a batch for evident performance reasons (instead of having a
loop)

Basically I have a table (my_table) with a varchar column called my_nb
I also have a list on numbers (there could be more that 300 of them)
and I need to know for each number if it's already in the table.

I created a little test class to see how I could deal with the problem
with a simple hard codded example:

import java.sql.* ;

public class DBTest {

public static void main(String[] args) {

System.out.println("Start test") ;

try {

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
Connection conn = DriverManager.getConnection
("jdbc:sybase:Tds:***:***","myUser","myPassword");

String sql = "select count(*) from my_table where my_nb =
?";

PreparedStatement stmt = conn.prepareStatement(sql) ;

stmt.setString(1, "3000") ;
stmt.addBatch() ;

stmt.setString(1, "3001") ;
stmt.addBatch() ;

stmt.execute() ;

ResultSet rs = null ;
do {
rs = stmt.getResultSet() ;
System.out.println("ResultSet") ;
while(rs.next()) {
System.out.println(rs.getString(1)) ;
}
} while(stmt.getMoreResults()) ;

if (rs != null) {
rs.close() ;
}

stmt.close() ;
conn.close() ;
rs = null ;
stmt = null ;
conn = null ;

} catch (Exception ex) {
ex.printStackTrace() ;
}

System.out.println("Stop test") ;
}
}

Now when I execute this It looks as if only the last sql in the batch
returns a result so instead of getting two result sets I only get one.

Even worse when I try using executeBatch() instead of execute() I get
a ClassCastException from the JDBC driver

Does anyone know how to make things work properly ?

Daniel Dittmar · Guest

Amir wrote:

Andree Große · Guest

Amir wrote:

lordy · Guest

[email]ajavanshir (AT) hotmail (DOT) com[/email] (Amir) wrote in news:189931e0.0307080534.6cb0ccf9
@posting.google.com: