java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got DATE

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 Hibernate JIRA by Shawn Clowater, 1 year ago
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
via Hibernate JIRA by Shawn Clowater, 1 year ago
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
via Hibernate JIRA by Madhusudan M Krishnamurthy, 1 year ago
ORA-00936: missing expression
via Hibernate JIRA by Madhusudan M Krishnamurthy, 1 year ago
ORA-00936: missing expression
via Hibernate JIRA by George Gaviotis, 1 year ago
ORA-00920: invalid relational operator
via hibernate.org by Unknown author, 2 years ago
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:103)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1065)
at org.hibernate.loader.Loader.doQuery(Loader.java:344)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:190)
at org.hibernate.loader.Loader.doList(Loader.java:1271)
at org.hibernate.loader.Loader.list(Loader.java:1254)
at org.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:169)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:2100)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:274)
at com.entero.enterovision.framework.service.AbstractService.fetch(AbstractService.java:340)
at com.entero.enterovision.framework.service.AbstractService.fetch(AbstractService.java:315)
at com.entero.enterovision.framework.service.AbstractService.fetch(AbstractService.java:281)
at com.entero.enterovision.service.agmt.AgmtService.fetchAgmtContractLines(AgmtService.java:488)
at com.entero.enterovision.components.agreementitemprice.AgreementController.find(AgreementController.java:71)
at com.entero.enterovision.components.AbstractController.findByParameters(AbstractController.java:32)
at com.entero.enterovision.components.ActiveWorkbench.populate(ActiveWorkbench.java:329)
at com.entero.enterovision.components.AbstractPMAWorkbench.populate(AbstractPMAWorkbench.java:30)
at com.entero.enterovision.components.AbstractSidebarSearchPanel.populateWorkbench(AbstractSidebarSearchPanel.java:241)
at com.entero.enterovision.components.agreementitemprice.AgreementItemPriceSearchSidebar.find(AgreementItemPriceSearchSidebar.java:203)
at com.entero.infrastructure.ui.sidebar.SidebarPanel.executeFunction(SidebarPanel.java:158)
at com.entero.enterovision.components.AbstractSidebarSearchPanel.search(AbstractSidebarSearchPanel.java:183)
at com.entero.enterovision.components.AbstractSidebarSearchPanel.access$000(AbstractSidebarSearchPanel.java:32)
at com.entero.enterovision.components.AbstractSidebarSearchPanel$2.actionPerformed(AbstractSidebarSearchPanel.java:112)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 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, 2 years ago
Samebug visitor profile picture
Unknown user
2 times, 6 months ago
30 more bugmates

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