There's something wrong with how you are specifying the character set
somewhere. I hope one of the two experts on this will tell you what;-)

david jencks

On 2002.05.01 09:56:30 -0400 Jan Aleman wrote:
> 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!
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>