Function sequence error

Wed, 23 Nov 2005 11:15:26 -0800 

Hi

I have a very strange exception I dont understand at all !

Here it is.
Error with Flown XY query results.java.sql.SQLException: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010 

Query
as [call get_map_flown_track_batch
('362430903,362417493,362396877,362416037,362426968,362402729,362409152,362431708,362438311,362423838,362403122,362447641,362384606,362380184')]
java.sql.SQLException: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=S1010
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at com.metronaviation.poet.map.tools.PoetTrackLoader$WorkThread.loadFlownRouteXY(PoetTrackLoader.java:1846)
at com.metronaviation.poet.map.tools.PoetTrackLoader$WorkThread.loadTracks(PoetTrackLoader.java:1623)
at com.metronaviation.poet.map.tools.PoetTrackLoader$WorkThread.checkAndAdd(PoetTrackLoader.java:1551)
at com.metronaviation.poet.map.tools.PoetTrackLoader$WorkThread.showTracks(PoetTrackLoader.java:1292)
at com.metronaviation.poet.map.tools.PoetTrackLoader$WorkThread.executeNextQueuedMessage(PoetTrackLoader.java:1156)
at com.metronaviation.poet.map.tools.PoetTrackLoader$WorkThread.run(PoetTrackLoader.java:1122) 


The java code behind the procedure is :

   public static void get_map_flown_track_batch(String fidList, ResultSet[] rs) 
throws SQLException {

       Connection conn = DriverManager.getConnection("jdbc:default:connection");


       String request =

           "SELECT  fid, orig_time, eta, cur_lat, cur_lon, groundspeed, altitude, 
altitude_type " +

           "FROM  track " +

           "WHERE  fid IN ("+fidList+") " +

           "ORDER BY fid, orig_time";


       PreparedStatement pSt = conn.prepareStatement(request);


       rs[0] = pSt.executeQuery();

       conn.close();

   }


If you have any ideas

Thank you

Nicolas

begin:vcard
fn:Nicolas Dufour
n:Dufour;Nicolas
org:NeoMetSys;Linux
adr:;;7 rue du theatre;Massy;;91300;France
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:+1 973 379 3522
x-mozilla-html:FALSE
url:http://www.neometsys.fr/
version:2.1
end:vcard

Reply via email to