com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO Warehouse(W_ZIP, DISTRICTSX, W_CITY, W_ID, W_STREET_2, W_TAX, W_STATE, W_NAME, W_STREET_1, W_DESC) VALUES (NULL, NULL, NULL, 'W4', NULL, NULL, NULL, 'WH 4', NULL, NULL)] ORA-00904: invalid column name

Oracle Community | 3004 | 1 decade ago
  1. 0

    Using Application Identity for Datastore

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO Warehouse(W_ZIP, DISTRICTSX, W_CITY, W_ID, W_STREET_2, W_TAX, W_STATE, W_NAME, W_STREET_1, W_DESC) VALUES (NULL, NULL, NULL, 'W4', NULL, NULL, NULL, 'WH 4', NULL, NULL)] ORA-00904: invalid column name
  2. 0

    Insert failing

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO COB_SESSIONS (COBRAND_ID, SESSION_DATA, ID, DB_SESSION_ID, LAST_ACCESS, LENGTH, COBRAND_ID, CREATE_DATE, COBRAND_ID, A_SESSION, SOURCE) VALUES (4, NULL, 'id 6', NULL, NULL, NULL, 150, NULL, NULL, NULL, NULL)] ORA-00957: duplicate column name
  3. 0

    Table alreacy exists

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO MONEYX(JDOCLASSX, JDOLOCKX, JDOIDX, AMOUNTX) VALUES ('com.almostthere.utils.Money', 0, 173, [B@26f75b)] INSERT INTO MONEYX(JDOCLASSX, JDOLOCKX, JDOIDX, AMOUNTX) VALUES ('com.almostthere.utils.Money', 0, 173, [B@26f75b) Don't understand SQL after: "INSERT" Expected: "{" found: "["
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Schematool not creating all tables?

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO MANAGEDENTITYVALUEIMPLX(JDOCLASSX, USERLABELX, LOCATIONNAMEX, IPADDRESSX, INVENTORYSTATEX, LASTMODIFIEDONSERVERX, JDOIDX, SYSTEMLEVELVERSIONX, JDOLOCKX) VALUES ('ossj.inventory.infomodel.resource.impl.ManagedElementValueImpl', NULL, NULL, '42', 0, NULL, 150, NULL, 0)] Table not found: MANAGEDENTITYVALUEIMPLX
  6. 0

    Error - invalid column name

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO BP_ENTRADA(IN_SIMPAS, CD_ORGAO, CD_VERSAO, CD_CONTRATO, CD_TP_BEM, CD_TP_FORMA_OP, CD_TP_OPERACAO, DT_INCLUSAO, DT_AQUISICAO, CD_AGENTE, DT_CONTABIL, CD_UG, CD_ENTRADA) VALUES ('N', '001', 0, NULL, '01', '03', '01', {ts '2002-11-20 15:25:03.326'}, {ts '2002-11-20 15:25:03.326'}, '000002', NULL, '000001', '0000000006')] ORA-00904: invalid column name

    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. com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper

      [SQL=INSERT INTO Warehouse(W_ZIP, DISTRICTSX, W_CITY, W_ID, W_STREET_2, W_TAX, W_STATE, W_NAME, W_STREET_1, W_DESC) VALUES (NULL, NULL, NULL, 'W4', NULL, NULL, NULL, 'WH 4', NULL, NULL)] ORA-00904: invalid column name

      at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.insert()
    2. com.solarmetric.kodo
      PersistenceManagerImpl.commit
      1. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.insert(JDBCStoreManager.java:305)
      2. com.solarmetric.kodo.runtime.StateManagerImpl.storeFields(StateManagerImpl.java:1219)
      3. com.solarmetric.kodo.runtime.PNewState.flush(PNewState.java:37)
      4. com.solarmetric.kodo.runtime.StateManagerImpl.flush(StateManagerImpl.java:348)
      5. com.solarmetric.kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:337)
      6. com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:245)
      6 frames
    3. com.amol.persistence
      PopulateDB.main
      1. com.amol.persistence.jdo.PopulateDB.main(PopulateDB.java:32)
      1 frame