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, 5 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, 5 months ago
JBO-27122: SQL error during statement preparation. Statement: select * from test_instances where instance_identifier=?
java.sql.SQLException: The connection does not exist.
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

2 times, 8 months ago
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, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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