hello darranl,
thank you for your help. removing the uuid-key-generator.sar removes only the
warning about th HILOSEQUENCES table. the warnings/exceptions about the TIMERS
table still comes up each restart. for me, it looks like there is a bug when
the JMS comes up and checks for the tables.
here is my setup :
os : slowlaris 9 04/04
jdk : jdk1.5.0_02
mysql : mysql-max-4.1.14-sun-solaris2.9-sparc-64bit
mysql connector/j : mysql-connector-java-3.1.11
jboss : jboss-4.0.3SP1.zip
the setup procedure :
# (g)unzip (and untar) the jboss package
$ unzip jboss-4.0.3SP1.zip
# gunzip and untar the mysql connector/j package
$ gunzip mysql-connector-java-3.1.11.tar.gz
$ tar -xvf mysql-connector-java-3.1.11.tar
# copy the mysql connector in the server/all/lib folder
$ cp mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar
jboss-4.0.3SP1/server/all/lib/
# configure jboss to run with mySql as Default Database
$ cp jboss-4.0.3SP1/docs/examples/jca/mysql-ds.xml
jboss-4.0.3SP1/server/all/deploy/
# edit jdbc connection
#
$ vi jboss-4.0.3SP1/server/all/deploy/mysql-ds.xml
.
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>nobody</user-name>
jboss
.
.
# remove hibernate datasource
$ rm jboss-4.0.3SP1/server/all/deploy/hsqldb-ds.xml
# configure jms
$ cp jboss-4.0.3SP1/docs/examples/jms/mysql-jdbc2-service.xml
jboss-4.0.3SP1/server/all/deploy-hasingleton/jms/
# edit mysql-jdbc2-service.xml and change to DataSource DefaultDS
# correct the table Alias bug
$ vi jboss-4.0.3SP1/server/all/deploy-hasingleton/jms/mysql-jdbc2-service.xml
.
.
<depends
optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS
.
.
.
SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM
JMS_TRANSACTIONS UNION SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES) AS TR_TABLE
.
.
# remove default hibernate jms service description
$ rm jboss-4.0.3SP1/server/all/deploy-hasingleton/jms/hsqldb-jdbc2-service.xml
# make MySQL as standard database
$ vi jboss-4.0.3SP1/server/all/conf/standardjaws.xml
.
.
.
java:/DefaultDS
<type-mapping>mySQL</type-mapping>
false
.
.
# (optional, )
# vi jboss-4.0.3SP1/server/all/conf/standardjbosscmp-jdbc.xml
# start/stop scripts need the x flag, zip does not know this ;-)
$ chmod +x jboss-4.0.3SP1/bin/run.sh
$ chmod +x jboss-4.0.3SP1/bin/shutdown.sh
# setup ownership etc.
$ chown -R nobody:nogroup jboss-4.0.3SP1
# install and configure start/stop script
# startup the jboss instance :
$ /etc/init.d/jboss4.server start
# this calls jboss-4.0.3SP1/bin/run.sh -c all
an now parts from the log :
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /opt/jboss-4.0.3SP1
JAVA: /opt/jdk1.5.0_02/bin/sparcv9/java
JAVA_OPTS: -server -Xms128m -Xmx128m -Dprogram.name=run.sh
CLASSPATH: /opt/jboss-4.0.3SP1/bin/run.jar:/opt/jdk1.5.0_02/lib/tools.jar
=========================================================================
19:45:37,775 INFO [Server] Starting JBoss (MX MicroKernel)...
19:45:37,782 INFO [Server] Release ID: JBoss [Zion] 4.0.3SP1 (build:
CVSTag=JBoss_4_0_3_SP1 date=200510231054)
19:45:37,794 INFO [Server] Home Dir: /opt/jboss-4.0.3SP1
19:45:37,795 INFO [Server] Home URL: file:/opt/jboss-4.0.3SP1/
19:45:37,801 INFO [Server] Patch URL: null
19:45:37,802 INFO [Server] Server Name: all
19:45:37,803 INFO [Server] Server Home Dir:
.
.
.
java.sql.SQLException: Table 'TIMERS' already exists
.
.
19:49:00,491 WARN [ServiceController] Problem starting service
jboss:service=KeyGeneratorFactory,type=HiLo
java.sql.SQLException: Table 'HILOSEQUENCES' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
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:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
.
.
.
19:49:06,247 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: FAILED
Reason: java.sql.SQLException: Table 'TIMERS' already exists
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: FAILED
Reason: java.sql.SQLException: Table 'HILOSEQUENCES' already exists
I Depend On:
jboss:service=TransactionManager
jboss.jca:service=DataSourceBinding,name=DefaultDS
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: FAILED
Reason: java.sql.SQLException: Table 'HILOSEQUENCES' already exists
I Depend On:
jboss:service=TransactionManager
jboss.jca:service=DataSourceBinding,name=DefaultDS
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: FAILED
Reason: java.sql.SQLException: Table 'TIMERS' already exists
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3903864#3903864
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3903864
-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
