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

    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    Insert failing

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT COBRAND.CONFIGFEATURECOLLECTIONFORCONX FROM COBRAND WHERE COBRAND.COBRAND_ID = 1] 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=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