com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver fo r JDBC]Can't start a cloned connection while in manual transaction mode. {SELECT SEQUENCE_VALUE FROM JDO_SEQUENCE WHERE ID = ?} [code=0, state=08007]

Oracle Community | 3004 | 1 decade ago
  1. 0

    SQL Server error

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver fo r JDBC]Can't start a cloned connection while in manual transaction mode. {SELECT SEQUENCE_VALUE FROM JDO_SEQUENCE WHERE ID = ?} [code=0, state=08007]
  2. 0

    Multiple Kodo Datasources in WebLogic 8.1 using JCA - How?

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-00942: table or view does not exist {prepstmnt 7569347 SELECT SEQUENCEX FROM MARY.JDO_SEQUENCEX WHERE PKX = ? FOR UPDATE [reused=0]} [code=942, state=42000]
  3. 0

    Webstart Issue

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not declared.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Query under Transaction Exception....

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: DB2 SQL error: SQLCODE: -511, SQLSTATE: 42829, SQLERRMC: null {prepstmnt 107840951 SELECT t0.GROUPSETTINGID, t0.ALLOWDRAW, t0.ALLOWSTRIKE, t0.ALLOWTRANSFER, t0.ASCENDONLY, t0.AUTOAPPROVE, t0.BARVISIBLE, t0.DEFAULTLEVELNAME, t0.LASTMODIFY, t0.MAXDRAW, t0.MAXRECHARGE, t0.MAXROWS, t0.MAXSTRIKE, t0.MAXTRANSFER, t0.MINDRAW, t0.MINRECHARGE, t0.MINSTRIKE, t0.MINTRANSFER, t0.GROUPID, t0.RECHARGEABLE, t0.USERTYPEMODIFICATION FROM OLTP.GROUPSETTING t0 INNER JOIN OLTP.ORGANGROUP t1 ON t0.GROUPID = t1.GROUPID WHERE (t1.GROUPID = ?) FOR UPDATE [reused=0]} [code=-511, state=42829]
  6. 0

    kodo.persistence.PersistenceException: expression must have same datatype

    Oracle Community | 1 decade ago | 666705
    kodo.persistence.PersistenceException: ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]

    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.jdbc.ReportingSQLException

      [Microsoft][SQLServer 2000 Driver fo r JDBC]Can't start a cloned connection while in manual transaction mode. {SELECT SEQUENCE_VALUE FROM JDO_SEQUENCE WHERE ID = ?} [code=0, state=08007]

      at kodo.jdbc.schema.DBSequenceFactory.getNext()
    2. kodo.jdbc.schema
      DBSequenceFactory.getNext
      1. kodo.jdbc.schema.DBSequenceFactory.getNext(DBSequenceFactory.java:227)
      2. kodo.jdbc.schema.DBSequenceFactory.getNext(DBSequenceFactory.java:192)
      2 frames
    3. kodo.jdbc.runtime
      JDBCStoreManager.newDataStoreId
      1. kodo.jdbc.runtime.JDBCStoreManager.nextSequenceValue(JDBCStoreManager..java:672)
      2. kodo.jdbc.runtime.JDBCStoreManager.newDataStoreId(JDBCStoreManager.java:649)
      2 frames
    4. kodo.runtime
      PersistenceManagerImpl.makePersistentAll
      1. kodo.runtime.DelegatingStoreManager.newDataStoreId(DelegatingStoreManager.java:176)
      2. kodo.runtime.PersistenceManagerImpl.makePersistentInternal(PersistenceManagerImpl.java:1938)
      3. kodo.runtime.PersistenceManagerImpl.makePersistent(PersistenceManagerImpl.java:1881)
      4. kodo.runtime.PersistenceManagerImpl.makePersistentAll(PersistenceManagerImpl.java:1857)
      4 frames
    5. tutorial
      SeedDatabase.main
      1. tutorial.SeedDatabase.main(SeedDatabase.java:34)
      1 frame