0 Replies Latest reply: Nov 21, 2012 10:48 AM by 975541 RSS

    Oracle ADF with view Links

    975541
      Hello i use Oracle adf framwork to develop my Business logic through Business component and oracle as Database
      i have an error with my View link
      i got this error msg:
      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Meldung.MELDUNG_ID, Meldung.MELDUNG_MESSAGE, Meldung.SACHBEARBEITER_ID, Meldung.MELDUNG_DATUM FROM MELDUNG Meldung WHERE Meldung.SACHBEARBEITER_ID = :Bind_SachbearbeiterId
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1239)
           at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
           at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1078)
           at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2800)
           at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:3058)
           at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2797)
           at oracle.jbo.server.ViewRowSetImpl.refreshRowSet(ViewRowSetImpl.java:7208)
           at oracle.jbo.server.ViewRowSetIteratorImpl.notifyDetailRowSets(ViewRowSetIteratorImpl.java:3555)
           at oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigationToRow(ViewRowSetIteratorImpl.java:3697)
           at oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigation(ViewRowSetIteratorImpl.java:3657)
           at oracle.jbo.server.ViewRowSetIteratorImpl.internalSetCurrentRow(ViewRowSetIteratorImpl.java:3440)
           at oracle.jbo.server.ViewRowSetIteratorImpl.previous(ViewRowSetIteratorImpl.java:1895)
           at oracle.jbo.server.ViewRowSetImpl.previous(ViewRowSetImpl.java:3609)
           at oracle.jbo.server.ViewObjectImpl.previous(ViewObjectImpl.java:10248)
           at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1080)
           at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
           at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
           at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
           at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
           at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
           at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
           at java.awt.Component.processMouseEvent(Component.java:6289)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
           at java.awt.Component.processEvent(Component.java:6054)
           at java.awt.Container.processEvent(Container.java:2041)
           at java.awt.Component.dispatchEventImpl(Component.java:4652)
           at java.awt.Container.dispatchEventImpl(Container.java:2099)
           at java.awt.Component.dispatchEvent(Component.java:4482)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
           at java.awt.Container.dispatchEventImpl(Container.java:2085)
           at java.awt.Window.dispatchEventImpl(Window.java:2478)
           at java.awt.Component.dispatchEvent(Component.java:4482)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
           at java.awt.EventQueue.access$000(EventQueue.java:85)
           at java.awt.EventQueue$1.run(EventQueue.java:603)
           at java.awt.EventQueue$1.run(EventQueue.java:601)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$2.run(EventQueue.java:617)
           at java.awt.EventQueue$2.run(EventQueue.java:615)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
           at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      Caused by: java.sql.SQLException: Invalid column type
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:11256)
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:10605)
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11665)
           at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11631)
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:15891)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:911)
           at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:4665)
           at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3673)
           at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:21459)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1197)
           ... 59 more
      ## Detail 0 ##
      java.sql.SQLException: Invalid column type
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:11256)
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:10605)
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11665)
           at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11631)
           at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:15891)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:911)
           at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:4665)
           at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3673)
           at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:21459)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1197)
           at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:913)
           at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7282)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1227)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1078)
           at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2800)
           at oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:3058)
           at oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2797)
           at oracle.jbo.server.ViewRowSetImpl.refreshRowSet(ViewRowSetImpl.java:7208)
           at oracle.jbo.server.ViewRowSetIteratorImpl.notifyDetailRowSets(ViewRowSetIteratorImpl.java:3555)
           at oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigationToRow(ViewRowSetIteratorImpl.java:3697)
           at oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigation(ViewRowSetIteratorImpl.java:3657)
           at oracle.jbo.server.ViewRowSetIteratorImpl.internalSetCurrentRow(ViewRowSetIteratorImpl.java:3440)
           at oracle.jbo.server.ViewRowSetIteratorImpl.previous(ViewRowSetIteratorImpl.java:1895)
           at oracle.jbo.server.ViewRowSetImpl.previous(ViewRowSetImpl.java:3609)
           at oracle.jbo.server.ViewObjectImpl.previous(ViewObjectImpl.java:10248)
           at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1080)
           at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
           at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
           at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
           at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
           at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
           at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
           at java.awt.Component.processMouseEvent(Component.java:6289)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
           at java.awt.Component.processEvent(Component.java:6054)
           at java.awt.Container.processEvent(Container.java:2041)
           at java.awt.Component.dispatchEventImpl(Component.java:4652)
           at java.awt.Container.dispatchEventImpl(Container.java:2099)
           at java.awt.Component.dispatchEvent(Component.java:4482)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
           at java.awt.Container.dispatchEventImpl(Container.java:2085)
           at java.awt.Window.dispatchEventImpl(Window.java:2478)
           at java.awt.Component.dispatchEvent(Component.java:4482)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
           at java.awt.EventQueue.access$000(EventQueue.java:85)
           at java.awt.EventQueue$1.run(EventQueue.java:603)
           at java.awt.EventQueue$1.run(EventQueue.java:601)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$2.run(EventQueue.java:617)
           at java.awt.EventQueue$2.run(EventQueue.java:615)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
           at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)





      (oracle.jbo.SQLStmtException) JBO-27122: SQL error during statement preparation. Statement: SELECT Termin.TERMIN_ID, Termin.TERMIN_BEGIN_DATUM, Termin.SACHBEARBEITER_ID, Termin.TERMIN_MESSAGE, Termin.TERMIN_END_DATUN FROM TERMIN Termin WHERE Termin.SACHBEARBEITER_ID = :Bind_SachbearbeiterId