db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicolas Dufour <nicolas.duf...@neometsys.fr>
Subject Function sequence error
Date Wed, 23 Nov 2005 19:13:12 GMT
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

Mime
View raw message