com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT t0.COBRAND_ID, t0.FEATURE_ID, t0.CONFIGID_CONFIGOFCONFIGIDX, t0.FEATUREID_FEATURESWITCHOFFEATX, t0.STATE FROM COB_FEATURE t0 WHERE t0.COBRAND_ID = 1] ORA-00904: invalid column name

Oracle Community | 3004 | 1 decade ago
  1. 0

    Problem with same field as PK and FK

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT t0.COBRAND_ID, t0.FEATURE_ID, t0.CONFIGID_CONFIGOFCONFIGIDX, t0.FEATUREID_FEATURESWITCHOFFEATX, t0.STATE FROM COB_FEATURE t0 WHERE t0.COBRAND_ID = 1] ORA-00904: invalid column name
  2. 0

    Deadlock found...

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] [SQL=SELECT t0.JDOIDX, t0.JDOCLASSX, t0.JDOLOCKX, t0.ACCEPTCHARSETX, t0.ACCEPTLANGUAGEX, t0.ACCESSCOUNTERX, t0.BROWSERUSERAGENTX, t0.CREATEDX, t0.EMAILX, t0.EXPIRESX, t0.IPADDRESSX, t0.LASTACCESSEDX, t0.LOGINNAMEX, t0.LOGINNAMEUCX, t0.PASSWORDX, t0.REVOKEDX, t0.VALIDATEDX, t0.ADDRESS1X, t0.ADDRESS2X, t0.CITYX, t0.COUNTRYX, t0.FIRSTNAMEX, t0.LASTNAMEX, t0.SCREENNAMEX, t0.STATEX, t0.ZIPX, t0.CARDHOLDERSNAMEX, t0.CREDITCARDTYPEX, t0.CREDITCARDNUMBERX, t0.CVV2CODEX, t0.EXPIRATIONDATEX, t0.STATUSX, t0.ABOUTX, t0.APPROVEDX, t0.AVAILABLEX, t0.AVAILABLEBANDWIDTHX, t0.BCUSTOM1X, t0.BCUSTOM2X, t0.BCUSTOM3X, t0.BCUSTOM4X, t0.BCUSTOM5X, t0.CATEGORYX, t0.CUSTOM1X, t0.CUSTOM2X, t0.CUSTOM3X, t0.DESCX, t0.DISLIKESX, t0.LANGUAGESX, t0.LIKESX, t0.PERFORMERBLOCKINGX, t0.PERFORMERSITEX, t0.PRICINGPRERECORDEDX, t0.PRICINGPRIVATEX, t0.PRICINGPUBLICX, t0.PRICINGTHEATERX, t0.SERVICEPRERECORDEDX, t0.SERVICEPRIVATEX, t0.SERVICEPUBLICX, t0.SERVICETHEATERX, t0.SSNX FROM SITE_USERX t1, USERX t0 WHERE (t1.JDOIDX = 5100 AND t0.JDOIDX = t1.USERX) FOR UPDATE] null: Deadlock found when trying to get lock; Try restarting transaction
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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=SELECT t0.COBRAND_ID, t0.FEATURE_ID, t0.CONFIGID_CONFIGOFCONFIGIDX, t0.FEATUREID_FEATURESWITCHOFFEATX, t0.STATE FROM COB_FEATURE t0 WHERE t0.COBRAND_ID = 1] ORA-00904: invalid column name

      at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery()
    2. com.solarmetric.kodo
      JDBCStoreManager.executeQuery
      1. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery(JDBCStoreManager.java:513)
      1 frame