org.jboss.deployment.DeploymentException: Error while creating table HardTokenPropertyData; - nested throwable: (java.sql.SQLException: Syntax error or access violation,  message from server: "Specified key was too long; max key length is 1000 bytes")

ejbca | zjl6 | 1 decade ago
  1. 0

    Unable to create HardTokenPropertyData table

    ejbca | 1 decade ago | zjl6
    org.jboss.deployment.DeploymentException: Error while creating table HardTokenPropertyData; - nested throwable: (java.sql.SQLException: Syntax error or access violation,  message from server: "Specified key was too long; max key length is 1000 bytes")
  2. 0

    DCM4CHE Support Forums: 2.14.1 Connection error occured ...

    dcm4che.org | 1 year ago
    java.sql.SQLException: Can't create table 'pacsdb.#sql-193_e2' (errno: 150)
  3. 0

    submitting the applet input details to database

    Coderanch | 9 years ago | preethi Ayyappan
    java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`cardid`='23' , `name`='ganesh' , `type`='sse' , `expired` = '2007-11-17' , `ca' at line 1"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Writing object to MySQL

    Oracle Community | 1 decade ago | 843854
    java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax near '' at line 1"
  6. 0

    java.sql.SQLException: Field 'supplier_id' doesn't have a default value

    Stack Overflow | 2 years ago | chendurex
    java.sql.SQLException: Field 'supplier_id' doesn't have a default value

    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

      Syntax error or access violation,  message from server: "Specified key was too long; max key length is 1000 bytes"

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      Statement.executeUpdate
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
      4. com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1070)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:2027)
      6. com.mysql.jdbc.Connection.execSQL(Connection.java:1984)
      7. com.mysql.jdbc.Statement.executeUpdate(Statement.java:1248)
      8. com.mysql.jdbc.Statement.executeUpdate(Statement.java:1194)
      8 frames
    3. JBoss Application Server Connector
      WrappedStatement.executeUpdate
      1. org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229)
      1 frame
    4. JBoss Application Server Server
      EntityContainer.startService
      1. org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:527)
      2. org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:196)
      3. org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)
      4. org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:381)
      5. org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157)
      6. org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)
      6 frames
    5. JBoss Application Server System
      ServiceMBeanSupport.jbossInternalLifecycle
      1. org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
      2. org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    7. org.jboss.mx
      ReflectedDispatcher.invoke
      1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      1 frame
    8. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      2. org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      4 frames
    9. JBoss Application Server System
      ServiceController$ServiceProxy.invoke
      1. org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
      1 frame
    10. Unknown
      $Proxy0.start
      1. $Proxy0.start(Unknown Source)
      1 frame
    11. JBoss Application Server System
      ServiceController.start
      1. org.jboss.system.ServiceController.start(ServiceController.java:418)
      1 frame
    12. 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:585)
      3 frames
    13. org.jboss.mx
      ReflectedDispatcher.invoke
      1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      1 frame
    14. JBoss Application Server J2SE
      MBeanProxyExt.invoke
      1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      2. org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      5. org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      5 frames
    15. Unknown
      $Proxy49.start
      1. $Proxy49.start(Unknown Source)
      1 frame
    16. JBoss Application Server Server
      EjbModule.startService
      1. org.jboss.ejb.EjbModule.startService(EjbModule.java:395)
      1 frame
    17. JBoss Application Server System
      ServiceMBeanSupport.jbossInternalLifecycle
      1. org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
      2. org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)
      2 frames
    18. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    19. org.jboss.mx
      ReflectedDispatcher.invoke
      1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      1 frame
    20. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      2. org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      4 frames
    21. JBoss Application Server System
      ServiceController$ServiceProxy.invoke
      1. org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
      1 frame
    22. Unknown
      $Proxy0.start
      1. $Proxy0.start(Unknown Source)
      1 frame
    23. JBoss Application Server System
      ServiceController.start
      1. org.jboss.system.ServiceController.start(ServiceController.java:418)
      1 frame
    24. 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:585)
      3 frames
    25. org.jboss.mx
      ReflectedDispatcher.invoke
      1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      1 frame
    26. JBoss Application Server J2SE
      MBeanProxyExt.invoke
      1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      2. org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      5. org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      5 frames
    27. Unknown
      $Proxy22.start
      1. $Proxy22.start(Unknown Source)
      1 frame
    28. JBoss Application Server Server
      EJBDeployer.start
      1. org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:605)
      1 frame
    29. JBoss Application Server System JMX
      MainDeployer.deploy
      1. org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
      2. org.jboss.deployment.MainDeployer.start(MainDeployer.java:956)
      3. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
      4. org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
      4 frames
    30. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    31. org.jboss.mx
      ReflectedDispatcher.invoke
      1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      1 frame
    32. JBoss Application Server J2SE
      Invocation.dispatch
      1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      1 frame
    33. org.jboss.mx
      AbstractInterceptor.invoke
      1. org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
      1 frame
    34. JBoss Application Server J2SE
      Invocation.invoke
      1. org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      1 frame
    35. org.jboss.mx
      ModelMBeanOperationInterceptor.invoke
      1. org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      1 frame
    36. JBoss Application Server J2SE
      MBeanProxyExt.invoke
      1. org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      2. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      3. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      4. org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      4 frames
    37. Unknown
      $Proxy8.deploy
      1. $Proxy8.deploy(Unknown Source)
      1 frame
    38. org.jboss.deployment
      AbstractDeploymentScanner$ScannerThread.run
      1. org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:325)
      2. org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:501)
      3. org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)
      4. org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:215)
      5. org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:194)
      5 frames