AnsweredAssumed Answered

JAVA general error [PLEX0092]

Question asked by Gavin on Apr 3, 2013
Latest reply on Apr 4, 2013 by Gavin
I have a simple JAVA application using Plex 7, JDK1.7.0_15, JDBC bridge to Oracle 11G (tried SQl server 2008, and MYSQL, got the same error)

I can read the data but cannot create any records, the full error I get is:

[PLEX0092] If SQLException mentioned about "overflow" for Date, Time or TimeStamp field, properties file's empty value for Date, Time and TimeStamp may be too small for you database.

I have a simple table with a Code and Description, there is no use of dates, times or timestamps. I use a RelationalTable and EditDetail.

Is there any reason why I should be getting this error?

The Stack trace is given below:

java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6985)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:3148)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedState
ment.java:215)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPrepare
dStatement.java:137)
at ObRun.ObDatabase.ObView.insertOrDelete(ObView.java:932)
at ObRun.ObDatabase.ObDatabaseMgr.insertOrDelete(ObDatabaseMgr.java:1125
)
at ObRun.ObDatabase.ObDatabaseMgr.insertx(ObDatabaseMgr.java:957)
at Vulindlela7.AA44F_ObFnc.ObSbr_AA44F4(Unknown Source)
at Vulindlela7.AA44F_ObFnc.ObRun(Unknown Source)
at Vulindlela7PNL.AAxF_ObFnc.ObSbr_AAxF28(Unknown Source)
at Vulindlela7PNL.AAxF_ObFnc.ObSbr_AAxF12(Unknown Source)
at Vulindlela7PNL.AAxF_ObFnc$AAxF_ObPnl.eventsHandler(Unknown Source)
at ObRun.ObPanel.ObCtrlData.ObCtrlData.testEvent(ObCtrlData.java:1286)
at ObRun.ObPanel.ObCtrlGui.ObPushbuttonGui.actionPerformed(ObPushbuttonG
ui.java:485)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:20
18)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:252)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:2
89)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:688)
at java.awt.EventQueue$3.run(EventQueue.java:686)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo
main.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo
main.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:702)
at java.awt.EventQueue$4.run(EventQueue.java:700)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo
main.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
ad.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Outcomes