Plex 2E

  • Private Community

  • 1.  JAVA general error [PLEX0092]

    Posted Apr 03, 2013 10:48 AM
    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)


  • 2.  RE: JAVA general error [PLEX0092]

    Posted Apr 03, 2013 11:52 AM
    Found this in the help files, I assume this is my issue as I am now picking up other problems.

    Example 2: Oracle 11g on Windows

    The Oracle Database 11g Release 1 JDBC Drivers can be downloaded from:

    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html

    The ojdbc6.jar file, which is a JAR file that contains the JDBC Thin Driver for Oracle 11GR1, must be available to the application, specified using additional classes when starting the Java Dispatcher.

    In the obsvr.properties file, the Oracle connection can be defined as follows:

    Environment.Default.Driver=oracle.jdbc.driver.OracleDriver
    Environment.Default.DataSource=jdb:oracle:thin:@mymachine:1521:orcl
    Environment.Default.User=User
    Environment.Default.User=Password


  • 3.  RE: JAVA general error [PLEX0092]
    Best Answer

    Posted Apr 04, 2013 11:50 AM
    Added the following lines to the properties file

    Environment.Default.Driver=oracle.jdbc.driver.OracleDriver
    Environment.Default.DataSource=jdbc:oracle:thin:@172.25.253.16:1521:TESTOLTPDB
    Environment.Default.User=<UserID>
    Environment.Default.Password=<Password>

    TESTOLTPDB is the Oracle SID

    Ensure the path to the ojdbc6.jar file is set in your build options