java.sql.SQLException: unexpected token: C$_COMMDAILY required: (

Oracle Community | 2655429 | 2 years ago
  1. 0

    Issue while writing xml file

    Oracle Community | 2 years ago | 2655429
    java.sql.SQLException: unexpected token: C$_COMMDAILY required: (
  2. 0

    ODI not able to detect primary/foreign keys from XML- user lacks privilege or object not found

    Oracle Community | 10 months ago | 3162137
    java.sql.SQLException: user lacks privilege or object not found: SHIPORDER.SHIPORDERPK
  3. 0

    error loading mutiple xml files in odi 11g

    Oracle Community | 3 years ago | user6322937
    java.sql.SQLException: user lacks privilege or object not found: PMCDS_PHASE_EVENT.DEVICETYPE
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Date data load error while loading xml data to oracle db

    Oracle Community | 4 years ago | user705850
    java.sql.SQLException: user lacks privilege or object not found: TO_DATE
  6. 0

    odi 11g - malformed numeric constant thru view data

    Oracle Community | 3 years ago | user645637
    java.sql.SQLException: malformed numeric constant

  1. WoodenDoors 10 times, last 8 months ago
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    unexpected token: C$_COMMDAILY required: (

    at org.hsqldb.jdbc.Util.sqlException()
  2. HSQLDB
    JDBCConnection.prepareStatement
    1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    2. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    3. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    3 frames
  3. com.sunopsis.jdbc
    SnpsXmlConnection.prepareStatement
    1. com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.prepareStatement(SnpsXmlConnection.java:1177)
    1 frame
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  5. oracle.odi.core
    OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke
    1. oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:200)
    1 frame
  6. Unknown
    $Proxy2.prepareStatement
    1. $Proxy2.prepareStatement(Unknown Source)
    1 frame
  7. oracle.odi.runtime
    SQLCommand.getStatement
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:83)
    2. oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:117)
    2 frames