oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT FIELD1, FIELD2 FROM

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 941130, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT FIELD1, FIELD2 FROM
via Oracle Community by 397648, 3 months ago
JBO-27122: SQL error during statement preparation. Statement: SELECT RsactivityV.ACT_PROJ_ORASEQ, RsactivityV.ACT_ACT_CODE, RsactivityV.ACT_CTRL_CODE, RsactivityV.ACT_DESC, RsactivityV.ACT_START_DATE, RsactivityV.ACT_DURATION
via Oracle Community by 692402, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PARAMETER_ID PARAMETER_ID, PARAMETER_NAME PARAMETER_NAME, PARAMETER_TYPE_ID PARAMETER_TYPE_ID, COMPLEX_FLAG, IS_CONDITION, IS_NOT_CONDITION FROM VSOE_PARAMETERS_V
via Oracle Community by ArashJ, 1 year ago
JBO-27122: SQL error during statement preparation. Statement: rollback
via Oracle Community by 432734, 3 months ago
JBO-27122: SQL error during statement preparation. Statement: select * from test_instances where instance_identifier=?
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT FIELD1, FIELD2 FROM
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:703)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:669)
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1777)
at com.ibm.as400.access.AS400JDBCPreparedStatement.(AS400JDBCPreparedStatement.java:316)
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2166)
at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3671)
at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:399)
at oracle.jbo.server.DBTransactionImpl.createReUsePreparedStatement(DBTransactionImpl.java:4981)
at oracle.jbo.server.ViewObjectImpl.getPreparedStatement(ViewObjectImpl.java:13391)
at oracle.jbo.server.ViewObjectImpl.getPreparedStatement(ViewObjectImpl.java:13366)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1123)
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.ensureRefreshed(ViewRowSetIteratorImpl.java:2777)
at oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1606)
at oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:3556)
at oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:10288)
at oracle.adf.model.binding.DCIteratorBinding.setupRSIstate(DCIteratorBinding.java:808)
at oracle.adf.model.binding.DCIteratorBinding.refreshControlAndNotifyDCE(DCIteratorBinding.java:707)
at oracle.adf.model.binding.DCIteratorBinding.refreshControl(DCIteratorBinding.java:676)
at oracle.jbo.uicli.binding.JUIteratorBinding.refreshControl(JUIteratorBinding.java:485)
at oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4555)
at oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(DCExecutableBinding.java:347)
at oracle.adf.model.binding.DCIteratorBinding.getRowSetIterator(DCIteratorBinding.java:1634)
at oracle.jbo.jbotester.panel.BindingPanel.setBindingContext(BindingPanel.java:131)
at oracle.jbo.jbotester.panel.OverviewPanel.setBindingContext(OverviewPanel.java:176)
at oracle.jbo.jbotester.panel.BindingPanel.(BindingPanel.java:101)
at oracle.jbo.jbotester.panel.OverviewPanel.(OverviewPanel.java:68)
at oracle.jbo.jbotester.form.OverviewForm.createMasterPanel(OverviewForm.java:53)
at oracle.jbo.jbotester.form.BindingForm.init(BindingForm.java:126)
at oracle.jbo.jbotester.form.JTForm.(JTForm.java:72)
at oracle.jbo.jbotester.form.BindingForm.(BindingForm.java:52)
at oracle.jbo.jbotester.form.OverviewForm.(OverviewForm.java:46)
at oracle.jbo.jbotester.form.FormType$2.createForm(FormType.java:76)
at oracle.jbo.jbotester.form.FormType.createForm(FormType.java:199)
at oracle.jbo.jbotester.form.FormType.createTab(FormType.java:270)
at oracle.jbo.jbotester.form.FormType.showForm(FormType.java:248)
at oracle.jbo.jbotester.form.FormType.showForm(FormType.java:207)
at oracle.jbo.jbotester.form.FormType.showForm(FormType.java:203)
at oracle.jbo.jbotester.tree.ObjTreeNode.showForm(ObjTreeNode.java:135)
at oracle.jbo.jbotester.tree.BindingContainerTreeNode$1.doAction(BindingContainerTreeNode.java:114)
at oracle.jbo.jbotester.AbstractJboAction.actionPerformed(AbstractJboAction.java:97)
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.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
2 times, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
3 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.