Subject Strange errors with JDBC driver
Author Jan Aleman
I have three strange errors with the new JDBC driver.
Any help is appreciated.

1) crash on second row
sql select ORDERID from ORDERS order by ORDERID
sql select ORDERID, SHIPVIA, SHIPNAME, SHIPCITY, SHIPADDRESS,
SHIPCOUNTRY from ORDERS where ORDERID = ?
questiondata[0] 10248
sql select ORDERID, SHIPVIA, SHIPNAME, SHIPCITY, SHIPADDRESS,
SHIPCOUNTRY from ORDERS where ORDERID = ?
questiondata[0] 10249
java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
at
org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.next(FBResultSet.jav
a:2535)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:157)
at com.servoy.j2db.dataprocessing.DataSet.<init>(DataSet.java:92)
at
com.servoy.j2db.dataprocessing.SQLEngine.performQuery(SQLEngine.java:90)
at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja
va:701)
at java.lang.Thread.run(Thread.java:536)
at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRem
oteCall.java:247)
at
sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223
)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
at com.servoy.j2db.dataprocessing.SQLEngine_Stub.performQuery(Unknown
Source)
at
com.servoy.j2db.dataprocessing.FoundSet.queryForState(FoundSet.java:123)
at com.servoy.j2db.dataprocessing.FoundSet.getState(FoundSet.java:108)
at
com.servoy.j2db.dataprocessing.FoundSet.getElementAt(FoundSet.java:254)
at com.servoy.j2db.FormPanel.valueChanged(FormPanel.java:403)
at
com.servoy.j2db.RecordViewController.fireListSelectionChanged(RecordView
Controller.java:112)
at
com.servoy.j2db.RecordViewController.stateChanged(RecordViewController.j
ava:85)
at javax.swing.JSlider.fireStateChanged(JSlider.java:343)
at javax.swing.JSlider$ModelListener.stateChanged(JSlider.java:271)
at
javax.swing.DefaultBoundedRangeModel.fireStateChanged(DefaultBoundedRang
eModel.java:346)
at
javax.swing.DefaultBoundedRangeModel.setRangeProperties(DefaultBoundedRa
ngeModel.java:283)
at
javax.swing.DefaultBoundedRangeModel.setValueIsAdjusting(DefaultBoundedR
angeModel.java:212)
at javax.swing.JSlider.setValueIsAdjusting(JSlider.java:515)
at
javax.swing.plaf.basic.BasicSliderUI$TrackListener.mouseReleased(BasicSl
iderUI.java:1303)
at java.awt.Component.processMouseEvent(Component.java:5021)
at java.awt.Component.processEvent(Component.java:4818)
at java.awt.Container.processEvent(Container.java:1380)
at java.awt.Component.dispatchEventImpl(Component.java:3526)
at java.awt.Container.dispatchEventImpl(Container.java:1437)
at java.awt.Component.dispatchEvent(Component.java:3367)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3214)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2929)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2859)
at java.awt.Container.dispatchEventImpl(Container.java:1423)
at java.awt.Window.dispatchEventImpl(Window.java:1566)
at java.awt.Component.dispatchEvent(Component.java:3367)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:445)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThrea
d.java:190)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.
java:144)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:98)
java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException:
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

2) Absoluty no idea
sql select ORDERID from ORDERS order by ORDERID
sql select ORDERID, SHIPVIA, SHIPNAME, SHIPCITY, SHIPADDRESS,
SHIPCOUNTRY from ORDERS where ORDERID in
(10248,10249,10250,10251,10252,10253,10254,10255,10256,10257,10258,10259
,10260,10261,10262,10263,10264,10265,10266,10267)
java.sql.SQLException: problem closing resultset:
org.firebirdsql.gds.GDSException: request synchronization error
java.sql.SQLException: problem closing resultset:
org.firebirdsql.gds.GDSException: request synchronization error
at org.firebirdsql.jdbc.FBStatement.closeResultSet(FBStatement.java:855)
at
org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.close(FBResultSet.ja
va:2540)
at org.firebirdsql.jdbc.FBResultSet.close(FBResultSet.java:178)
at com.servoy.j2db.dataprocessing.DataSet.<init>(DataSet.java:199)
at
com.servoy.j2db.dataprocessing.SQLEngine.performQuery(SQLEngine.java:90)
at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja
va:701)
at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: problem closing resultset:
org.firebirdsql.gds.GDSException: request synchronization error

3)
When using SQL 'in' and all the requested rows exist only 1 is returned!