Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <4384BF48.3030904@neometsys.fr>
Date: Wed, 23 Nov 2005 14:13:12 -0500
From: Nicolas Dufour <nicolas.dufour@neometsys.fr>
User-Agent: Thunderbird 1.5 (Windows/20051025)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Function sequence error
Content-Type: multipart/mixed;
 boundary="------------060907010302070903010908"

This is a multi-part message in MIME format.
--------------060907010302070903010908
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------060907010302070903010908
Content-Type: text/x-vcard; charset=utf-8;
 name="nicolas.dufour.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="nicolas.dufour.vcf"

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


--------------060907010302070903010908--