i get error while using hibernate2.1.6 on jboss4.0
jboss.mq:service=InvocationLayer,type=JVM
state: CREATED
I Depend On: jboss.mq:service=Invoker
Depends On Me:
ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
state: CREATED
I Depend On: jboss.mq:service=Invoker
Depends On Me:
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.ejb
ersistencePolicy=database,service=EJBTimerService
state:FAILED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding
Depends On Me: 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 'INTERVAL bigint,
INSTANCEPK other,
INFO o"
ObjectName: jboss.mq:service=PersistenceManager
state: FAILED
I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding
Depends On Me: jboss.mq:service=DestinationManager
org.jboss.mq.SpyJMSException:
Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error, message from server: "Table 'jboss.jms_messages' doesn't exist")
2004-09-29 17:30:46,386 DEBUG [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Notified that enabled: true
2004-09-29 17:30:46,386 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:flavor=URL,type=DeploymentScanner
2004-09-29 17:30:46,386 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.deployment:flavor=URL,type=DeploymentScanner dependent components: []
2004-09-29 17:30:46,566 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: jboss-service.xml
2004-09-29 17:30:46,566 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/C:/jboss-4.0.0/server/default/conf/jboss-service.xml
2004-09-29 17:30:46,566 DEBUG [org.jboss.web.tomcat.tc5.Tomcat5] Saw org.jboss.system.server.started notification, starting connectors
2004-09-29 17:30:46,767 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
2004-09-29 17:30:46,967 INFO [org.apache.jk.common.ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009