org.jboss.deployment.DeploymentException: Error while creating table HardTokenPropertyData; - nested throwable: (java.sql.SQLException: Specified key was too long; max key length is 1000 bytes)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

Unable to create HardTokenPropertyData table

Error while creating table HardTokenPropertyData; - nested throwable: (java.sql.SQLException: Specified key was too long; max key length is 1000 bytes)

Entity Bean Error

Error while creating table QA_USER

Deploying with Postgresql

Error while creating table; - nested throwable: (java.sql.SQLException: ERROR: Type "varbinary" does not exist )

BINARY in statement exception

Error while creating table MLMEMBER; - nested throwable: (java.sql.SQLException: Unexpected token: BINARY in statement [CREATE TABLE MLMEMBER (email VARCHAR(250) BINARY NOT NULL, name VARCHAR(250) BINARY, CONSTRAINT PK_MLMEMBER PRIMARY KEY (email))])

Error installing EJBCA @ ant bootstrap

Error while creating table LogConfigurationData; - nested throwable: (com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 ' logEntryRowNumber INTEGER NOT NULL, CONSTRAINT pk\_LogConfigurationData PRIMARY ' at line 1)

deploying CMP on JBOSS

Error while creating table; - nested t hrowable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQ LServer]Incorrect syntax near the keyword 'order'.)

java.sql.SQLException: Specified key was too long; max key length is 1000 bytes	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)	at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935)	at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873)	at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229)	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:527)	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:196)	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484)	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:381)	at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157)	at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)	at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:585)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)	at $Proxy0.start(Unknown Source)	at org.jboss.system.ServiceController.start(ServiceController.java:418)	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:585)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)	at $Proxy49.start(Unknown Source)	at org.jboss.ejb.EjbModule.startService(EjbModule.java:395)	at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)	at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:222)	at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:585)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)	at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)	at $Proxy0.start(Unknown Source)	at org.jboss.system.ServiceController.start(ServiceController.java:418)	at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:585)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)	at $Proxy22.start(Unknown Source)	at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:605)	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:956)	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)	at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:585)	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)	at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)	at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)	at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)	at $Proxy8.deploy(Unknown Source)	at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:325)	at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:501)	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:215)	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:194)