SQL error

[Gandi]

Anyone ever seen this error before ? becasue i cant find anything about it.

Except: com.borland.dx.dataset.DataSetException: [interclient][interbase] conversion error from string "TN 256"

See com.borland.dx.dataset.DataSetException error code: BASE+66
com.borland.dx.dataset.DataSetException: [interclient][interbase] conversion error from string "TN 256"

at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)
at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)
at com.borland.dx.sql.dataset.Database.executeStatement(Unknown Source)
at dsl_comp.DSL_Comp_fm.executeGetExport(DSL_Comp_fm.java:728)
at dsl_comp.DSL_Comp_fm.main(DSL_Comp_fm.java:110)
at dsl_comp.DSL_Comp_fm.jButton1_actionPerformed(DSL_Comp_fm.java:127)
at dsl_comp.DSL_Comp_fm$1.actionPerformed(DSL_Comp_fm.java:46)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Chained exception:

This error happens when i move my InterBase Database and java application to another computer (running windows NT) and try run the program there. It runs perfect on the computer i'm working on, allso windows NT.
Dunno if it's a version problem with the InterServer or ?? well i'm lost =)

Thx
Gandi

 

[MartijnTonies]

Are you accidently trying to insert "TN256" into a numerical column? Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

http://www.interbaseworkbench.com

 

[alzoid]

I had this error before. It's just a data type conflict. Check your SQL (I didn't have quotes around my date)