oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT XWBCCD, XWG4TX, XWB2CD, XWB3CD, XWHITX, XWE0NB, XWJUN0, XWDVCD, XWBNCD, PERSON, DSDCDE, XWBTCD, XWGIVA, XWAOCD, XWBBCD, XWG4T0, XWC7ST, XWDAST, XWBPD0, XWBAD0, XWARDT, XWF0VA, XWASDT, XWF0V0, XWBQDT, XWF1VA, XWF1V0, XWF2VA, XWF3VA, XWF4VA, XWF6VA, XWIDV0, XWGAVA, XWGBVA, XWGCVA, XWGDVA, XWGEVA, XWGFVA, XWGGVA, CUSNO 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 XWBCCD, XWG4TX, XWB2CD, XWB3CD, XWHITX, XWE0NB, XWJUN0, XWDVCD, XWBNCD, PERSON, DSDCDE, XWBTCD, XWGIVA, XWAOCD, XWBBCD, XWG4T0, XWC7ST, XWDAST, XWBPD0, XWBAD0, XWARDT, XWF0VA
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 XWBCCD, XWG4TX, XWB2CD, XWB3CD, XWHITX, XWE0NB, XWJUN0, XWDVCD, XWBNCD, PERSON, DSDCDE, XWBTCD, XWGIVA, XWAOCD, XWBBCD, XWG4T0, XWC7ST, XWDAST, XWBPD0, XWBAD0, XWARDT, XWF0VA, XWASDT, XWF0V0, XWBQDT, XWF1VA, XWF1V0, XWF2VA, XWF3VA, XWF4VA, XWF6VA, XWIDV0, XWGAVA, XWGBVA, XWGCVA, XWGDVA, XWGEVA, XWGFVA, XWGGVA, CUSNO FROM
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
at com.ibm.as400.access.AS400JDBCConnection.checkOpen(AS400JDBCConnection.java:460)
at com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2941)
at com.ibm.as400.access.AS400JDBCStatement.close(AS400JDBCStatement.java:474)
at com.ibm.as400.access.AS400JDBCPreparedStatement.close(AS400JDBCPreparedStatement.java:631)
at com.ibm.as400.access.AS400JDBCPreparedStatement.(AS400JDBCPreparedStatement.java:318)
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, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years 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.