SELECT * FROM ITEM WHERE ITEM.ITEM=:ITEM (java.sql.DataTruncation: Data truncation)


2006-08-04 12:27:34 AM
delphi208
This query in IBConsole works fine
SELECT ITEM.FROM_ITEM,ITEM.BIN,ITEM.ITEM FROM ITEM WHERE
ITEM.ITEM='X010000149';
but in JBuilderX it gives an exception (same query with a parameterRow
value)
SELECT ITEM.FROM_ITEM,ITEM.BIN,ITEM.ITEM FROM ITEM WHERE ITEM.ITEM=:ITEM
item is a key column, defined as varchar.
===========================
See com.borland.dx.dataset.DataSetException error code: BASE+62
com.borland.dx.dataset.DataSetException: Execution of query failed.
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.queryFailed(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
at mbl.DataAccess.openRefreshTheTable(DataAccess.java:578)
at
mbl.Ticketing.TicketProcessing.getKrollNumber(TicketProcessing.java:1851)
at mbl.Ticketing.TicketProcessing._setTagTbl(TicketProcessing.java:924)
at
mbl.Ticketing.TicketProcessing._processWorkFileForOneOrder(TicketProcessing.java:503)
at mbl.Ticketing.TicketProcessing.printTicket(TicketProcessing.java:312)
at
mbl.OrderMaintenance.FromOrderPrintTicket.viewOrder(FromOrderPrintTicket.java:905)
at
mbl.OrderMaintenance.FromOrderPrintTicket.displayOrderView(FromOrderPrintTicket.java:865)
at
mbl.OrderMaintenance.ResidentialOrders.orderTabbedPane_mouseClicked(ResidentialOrders.java:9037)
at
mbl.OrderMaintenance.ResidentialOrders$2.mouseClicked(ResidentialOrders.java:1813)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
at java.awt.Component.processMouseEvent(Component.java:5103)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3207)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
Chained exception:
java.sql.DataTruncation: Data truncation
at interbase.interclient.PreparedStatement.setString(Unknown Source)
at com.borland.dx.sql.dataset.o.b(Unknown Source)
at com.borland.dx.sql.dataset.o.e(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
at mbl.DataAccess.openRefreshTheTable(DataAccess.java:578)
at
mbl.Ticketing.TicketProcessing.getKrollNumber(TicketProcessing.java:1851)
at mbl.Ticketing.TicketProcessing._setTagTbl(TicketProcessing.java:924)
at
mbl.Ticketing.TicketProcessing._processWorkFileForOneOrder(TicketProcessing.java:503)
at mbl.Ticketing.TicketProcessing.printTicket(TicketProcessing.java:312)
at
mbl.OrderMaintenance.FromOrderPrintTicket.viewOrder(FromOrderPrintTicket.java:905)
at
mbl.OrderMaintenance.FromOrderPrintTicket.displayOrderView(FromOrderPrintTicket.java:865)
at
mbl.OrderMaintenance.ResidentialOrders.orderTabbedPane_mouseClicked(ResidentialOrders.java:9037)
at
mbl.OrderMaintenance.ResidentialOrders$2.mouseClicked(ResidentialOrders.java:1813)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
at java.awt.Component.processMouseEvent(Component.java:5103)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3207)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)