[jboss-user] [JBoss Messaging] - Re: JBoss Messaging and MySQL

Carl Trusiak ctrusiak at sescollc.com
Fri Nov 2 12:07:05 EDT 2007 

What version of MYSQL are you using?  I was able to create this in mine.
My version is 5.045.

Perhaps you need yo update your MYSQL version


-----Original Message-----
From: jboss-user-bounces at lists.jboss.org
[mailto:jboss-user-bounces at lists.jboss.org] On Behalf Of haagenhasle
Sent: Friday, November 02, 2007 11:54 AM
To: jboss-user at lists.jboss.org
Subject: [jboss-user] [JBoss Messaging] - Re: JBoss Messaging and MySQL

I see from my logs that the reason the "Table 'juddidb.jbm_postoffice'
doesn't exist" message appears, is initially because JBoss is not able to
create the table.  The first errormessage in my log is the following:

2007-11-02 16:45:35,335 DEBUG
[org.jboss.messaging.core.jmx.MessagingPostOfficeService] Starting
jboss.messaging:service=PostOffice
2007-11-02 16:45:35,335 DEBUG
[org.jboss.messaging.core.jmx.MessagingPostOfficeService]
org.jboss.messaging.core.jmx.MessagingPostOfficeService at 1e74fe9 uses
XMLJChannelFactory
2007-11-02 16:45:35,382 DEBUG [org.jboss.messaging.core.impl.JDBCSupport]
Failed to execute: CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME
VARCHAR(255), NODE_ID INTEGER, QUEUE_NAME VARCHAR(255), COND VARCHAR(1023),
SELECTOR VARCHAR(1023), CHANNEL_ID BIGINT, CLUSTERED CHAR(1), ALL_NODES
CHAR(1), PRIMARY KEY(POSTOFFICE_NAME, NODE_ID, QUEUE_NAME)) ENGINE = INNODB
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too
long; max key length is 1024 bytes
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1027)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)
	at
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
	at
com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
	at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatem
ent.java:186)
	at
org.jboss.messaging.core.impl.JDBCSupport.createSchema(JDBCSupport.java:292)
	at
org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:158)
	at
org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(Messaging
PostOffice.java:322)
	at
org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(Messagi
ngPostOfficeService.java:414)
	at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.
java:289)
	at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
	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
:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java
:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOpe
rationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:26
4)
	at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav
a:995)
	at $Proxy0.start(Unknown Source)
	at
org.jboss.system.ServiceController.start(ServiceController.java:417)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	at
org.jboss.system.ServiceController.start(ServiceController.java:435)
	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
:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:26
4)
	at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy27.start(Unknown Source)
	at
org.jboss.deployment.SimpleSubDeployerSupport.startService(SimpleSubDeployer
Support.java:356)
	at
org.jboss.deployment.SimpleSubDeployerSupport.start(SimpleSubDeployerSupport
.java:127)
	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
	at sun.reflect.GeneratedMethodAccessor50.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
:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java
:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOpe
rationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:26
4)
	at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy9.deploy(Unknown Source)
	at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanne
r.java:421)
	at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.
java:634)
	at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(
AbstractDeploymentScanner.java:263)
	at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(Abstract
DeploymentScanner.java:336)
	at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.
java:289)
	at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupp
ort.java:245)
	at sun.reflect.GeneratedMethodAccessor3.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
:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:26
4)
	at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.jav
a:978)
	at $Proxy0.start(Unknown Source)
	at
org.jboss.system.ServiceController.start(ServiceController.java:417)
	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
:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:26
4)
	at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy4.start(Unknown Source)
	at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
	at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
	at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
	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
:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java
:133)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOpe
rationInterceptor.java:142)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
	at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:26
4)
	at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
	at $Proxy5.deploy(Unknown Source)
	at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
	at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
	at org.jboss.Main.boot(Main.java:200)
	at org.jboss.Main$1.run(Main.java:508)
	at java.lang.Thread.run(Thread.java:595)

Has anyone got this working with MySQL?

Regards, Haagen

View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4101375#4101375

Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4101375
_______________________________________________
jboss-user mailing list
jboss-user at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

More information about the jboss-user mailing list