org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation '    l          to a valid JDBC level.); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation '    l          to a valid JDBC level.)))

ejbca | *anonymous | 1 decade ago
  1. 0

    What versions of softs are tested?

    ejbca | 1 decade ago | *anonymous
    org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation '    l          to a valid JDBC level.); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not map transaction isolation '    l          to a valid JDBC level.)))
  2. 0

    connection close problem with JBoss + MySQL

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: No operations allowed after connection closed)
  3. 0

    Error: Creating a Connection Pool: issue with valid transaction levels

    Oracle Community | 1 decade ago | 807581
    java.sql.SQLException: Error in allocating a connection. Cause: The isolation level could not be set: READ_COMMITTED and SERIALIZABLE are the only valid transaction levelsError Code: 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ability to turn off isolation level setting on connect?

    GitHub | 1 month ago | danoyoung
    java.sql.SQLException: [Simba][JDBC](11975) Unsupported transaction isolation level: 4.
  6. 0

    JDBC And Concurrency Issues

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: The coordinator has rolled back the transaction. No further JDBC access is allowed within this transaction. You can expect this to come randomly from JTS transactional JDBC code when the transaction timeout has been reached. The JTS driver colludes with the transaction coordinator in a way that allows the coordiinator (running in a totally separate thread) do know when a given JTS/EJB transaction has not completed by the time the timeout has expired. At this point the coordinator will roll back the transaction, and close all the JDBC resources right out from under the thread running the transaction. This can occur at any time while the transaction thread is in the middle of any JDBC call at all. At this time the call in-progress, and any subsequent one if the thread running the now-defunct transaction tries it, will get this exception. As to why a given JDBC call may hang for a long time, causing the tx to timeout, it's not JDBC concurrency, it's probably DBMS concurrency that is the issue. The first place to look is in the DBMS to see whether this transaction is waiting for locks that another tx is holding. If you are running a transaction isolation level of SERIALIZABLE, that could cause very bad Oracle performance, and not even provide the benefits one would hope for with this isolation level. I recommend explicitly setting the transaction isolalation level to the default-and-only-non-buggy setting for Oracle, READ_COMMITTED. Let me know if this helps. Joe

    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

      Could not map transaction isolation '    l          to a valid JDBC level.

      at com.mysql.jdbc.Connection.getTransactionIsolation()
    2. MySQL jdbc
      Connection.getTransactionIsolation
      1. com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:892)
      1 frame
    3. JBoss Application Server Connector
      LocalDataSource.getConnection
      1. org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.<init>(LocalManagedConnection.java:74)
      2. org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:139)
      3. org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:259)
      4. org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:106)
      5. org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:323)
      6. org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:467)
      7. org.jboss.resource.connectionmanager.LocalTxConnectionManager.getManagedConnection(LocalTxConnectionManager.java:221)
      8. org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:532)
      9. org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:822)
      10. org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)
      10 frames
    4. JBoss Application Server Server
      EntityContainer.invoke
      1. org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:38)
      2. org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.<init>(JDBCEntityBridge.java:103)
      3. org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:397)
      4. org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
      5. org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      6. org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      7. org.jboss.ejb.Container.invoke(Container.java:756)
      8. org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
      8 frames
    5. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    6. JBoss Application Server System
      ServiceController$ServiceProxy.invoke
      1. org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
      1 frame
    7. Unknown
      $Proxy4.start
      1. $Proxy4.start(Unknown Source)
      1 frame
    8. JBoss Application Server System
      ServiceController.start
      1. org.jboss.system.ServiceController.start(ServiceController.java:413)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    10. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    11. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    12. org.jboss.util
      MBeanProxy.invoke
      1. org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      1 frame
    13. Unknown
      $Proxy19.start
      1. $Proxy19.start(Unknown Source)
      1 frame
    14. JBoss Application Server Server
      EjbModule.startService
      1. org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
      1 frame
    15. JBoss Application Server System
      ServiceMBeanSupport.start
      1. org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
      1 frame
    16. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    17. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    18. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    19. JBoss Application Server System
      ServiceController$ServiceProxy.invoke
      1. org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
      1 frame
    20. Unknown
      $Proxy4.start
      1. $Proxy4.start(Unknown Source)
      1 frame
    21. JBoss Application Server System
      ServiceController.start
      1. org.jboss.system.ServiceController.start(ServiceController.java:413)
      1 frame
    22. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    23. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    24. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    25. org.jboss.util
      MBeanProxy.invoke
      1. org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      1 frame
    26. Unknown
      $Proxy9.start
      1. $Proxy9.start(Unknown Source)
      1 frame
    27. JBoss Application Server Server
      EJBDeployer.start
      1. org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:395)
      1 frame
    28. JBoss Application Server System JMX
      MainDeployer.deploy
      1. org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
      2. org.jboss.deployment.MainDeployer.start(MainDeployer.java:806)
      3. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
      4. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
      4 frames
    29. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    30. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    31. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    32. org.jboss.util
      MBeanProxy.invoke
      1. org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      1 frame
    33. Unknown
      $Proxy3.deploy
      1. $Proxy3.deploy(Unknown Source)
      1 frame
    34. org.jboss.deployment
      AbstractDeploymentScanner.startService
      1. org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:435)
      2. org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:656)
      3. org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
      4. org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:261)
      4 frames
    35. JBoss Application Server System
      ServiceMBeanSupport.start
      1. org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
      1 frame
    36. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    37. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    38. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    39. JBoss Application Server System
      ServiceController$ServiceProxy.invoke
      1. org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
      1 frame
    40. Unknown
      $Proxy0.start
      1. $Proxy0.start(Unknown Source)
      1 frame
    41. JBoss Application Server System
      ServiceController.start
      1. org.jboss.system.ServiceController.start(ServiceController.java:413)
      1 frame
    42. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:324)
      3 frames
    43. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    44. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    45. org.jboss.util
      MBeanProxy.invoke
      1. org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      1 frame
    46. Unknown
      $Proxy2.start
      1. $Proxy2.start(Unknown Source)
      1 frame
    47. JBoss Application Server System JMX
      MainDeployer.deploy
      1. org.jboss.deployment.SARDeployer.start(SARDeployer.java:230)
      2. org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
      3. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
      4. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
      5. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:575)
      5 frames
    48. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    49. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    50. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      1 frame
    51. JBoss Application Server System JMX
      ServerImpl.start
      1. org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:325)
      2. org.jboss.system.server.ServerImpl.start(ServerImpl.java:222)
      2 frames
    52. JBoss Application Server Server
      Main$1.run
      1. org.jboss.Main.boot(Main.java:148)
      2. org.jboss.Main$1.run(Main.java:381)
      2 frames
    53. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:536)
      1 frame