java.sql.SQLException: incompatible data type in operation

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 1170064, 1 year ago
incompatible data type in operation
via hsqldb by goraxan
, 1 year ago
java.lang.RuntimeException: unsupported internal operation: RowStoreAVL unsupported internal operation: RowStoreAVL
via Google Groups by Matthew Smith, 2 years ago
Three part identifiers prohibited in statement [select * from portdb.dbo.]
via Atlassian JIRA by Jeff Curry [Atlassian], 1 year ago
Constraint not found FK_AO_E8B6CC_MESSAGE_QUEUE_ITEM_MESSAGE_ID in table: AO_E8B6CC_MESSAGE_QUEUE_ITEM in statement [ALTER TABLE PUBLIC.AO_E8B6CC_MESSAGE_QUEUE_ITEM DROP CONSTRAINT fk_ao_e8b6cc_message_queue_item_message_id]
via Atlassian JIRA by Jeff Curry [Atlassian], 1 year ago
Constraint not found FK_AO_E8B6CC_MESSAGE_QUEUE_ITEM_MESSAGE_ID in table: AO_E8B6CC_MESSAGE_QUEUE_ITEM in statement [ALTER TABLE PUBLIC.AO_E8B6CC_MESSAGE_QUEUE_ITEM DROP CONSTRAINT fk_ao_e8b6cc_message_queue_item_message_id]
via hsqldb by zhaozhihua2008
, 1 year ago
data exception: invalid datetime format: YYYYMMDDh
org.hsqldb.HsqlException: incompatible data type in operation
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SetFunction.getType(Unknown Source)
at org.hsqldb.ExpressionAggregate.resolveTypes(Unknown Source)
at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source)
at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
at org.hsqldb.QuerySpecification.resolveTypes(Unknown Source)
at org.hsqldb.QueryExpression.resolve(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at com.sunopsis.jdbc.driver.xml.SnpsXmlStatementRedirector.executeQuery(SnpsXmlStatementRedirector.java:126)
at com.sunopsis.jdbc.driver.xml.SnpsXmlStatement.executeQuery(SnpsXmlStatement.java:49)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:196)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:204)
at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:100)
at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:38)
at oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:309)
at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:51)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Once, 2 months ago
5 times, 3 months ago
2 times, 6 months ago
2 times, 7 months ago
24 times, 8 months ago

Write tip

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