ESB and DB2 - DB config change needed to handle quartz?
ldimaggio May 15, 2008 4:47 PMI'm wondering if someone has already seen and worked thru this problem.
I'm trying to use DB2 as the message store DB for ESB. I believe that I have various datasource and persistence XML files correct. (I'm intentionally only looking at the JBM Db right now - not jBPM.)
The server starts up cleanly, but soom goes into a very tight loop with this SQLexception:
16:32:07,607 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
16:32:07,767 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
16:32:07,783 INFO [Server] JBoss (MX MicroKernel) [4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)] Started in 3m:47s:138ms
16:32:25,278 WARN [JDBCSupport] SQLException caught, SQLState 07001 code:-313- assuming deadlock detected, try:1
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -313, SQLSTATE: 07001, SQLERRMC: null
at com.ibm.db2.jcc.b.hh.b(hh.java:1369)
at com.ibm.db2.jcc.b.hh.c(hh.java:1356)
at com.ibm.db2.jcc.c.db.k(db.java:352)
at com.ibm.db2.jcc.c.db.a(db.java:60)
at com.ibm.db2.jcc.c.t.a(t.java:52)
at com.ibm.db2.jcc.c.tb.b(tb.java:202)
at com.ibm.db2.jcc.b.ih.ab(ih.java:1898)
at com.ibm.db2.jcc.b.ih.d(ih.java:2467)
at com.ibm.db2.jcc.b.ih.W(ih.java:525)
at com.ibm.db2.jcc.b.ih.executeUpdate(ih.java:508)
Files created/modified:
1) New: server/default/deploy/db2-ds.xml
2) Modify: server/default/deploy/jbossesb.sar/juddi-ds.xml
3) Modify: server/default/deploy/jbossesb.sar/esb.juddi.xml
4) Modify: server/default/deploy/jbossesb.esb/message-store-ds.xml
5) Modify: server/default/deploy/jbossesb.esb/jbossesb-service.xml
6) New: server/default/deploy/jbossesb.esb/message-store-sql/db2/create_database.sql
7) New: server/default/deploy/jbossesb.esb/message-store-sql/db2/drop_database.sql
8) New: server/default/deploy/jboss-messaging.sar/db2-persistence-service.xml
And - I'm seeing these tables created in the DB:
db2 => list tables
Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
ADDRESS SOAPUSER T 2008-05-15-16.29.42.258649
ADDRESS_LINE SOAPUSER T 2008-05-15-16.29.43.100286
AUTH_TOKEN SOAPUSER T 2008-05-15-16.30.02.727883
BINDING_CATEGORY SOAPUSER T 2008-05-15-16.29.50.632705
BINDING_DESCR SOAPUSER T 2008-05-15-16.29.51.632281
BINDING_TEMPLATE SOAPUSER T 2008-05-15-16.29.49.796659
BUSINESS_CATEGORY SOAPUSER T 2008-05-15-16.29.37.564684
BUSINESS_DESCR SOAPUSER T 2008-05-15-16.29.36.597666
BUSINESS_ENTITY SOAPUSER T 2008-05-15-16.29.35.716044
BUSINESS_IDENTIFIER SOAPUSER T 2008-05-15-16.29.38.588355
BUSINESS_NAME SOAPUSER T 2008-05-15-16.29.39.432440
BUSINESS_SERVICE SOAPUSER T 2008-05-15-16.29.46.402271
CONTACT SOAPUSER T 2008-05-15-16.29.40.408214
CONTACT_DESCR SOAPUSER T 2008-05-15-16.29.41.432802
DISCOVERY_URL SOAPUSER T 2008-05-15-16.29.45.580508
EMAIL SOAPUSER T 2008-05-15-16.29.43.923577
HILOSEQUENCES SOAPUSER T 2008-05-15-16.30.47.352144
INSTANCE_DETAILS_DESCR SOAPUSER T 2008-05-15-16.29.54.633428
INSTANCE_DETAILS_DOC_DESCR SOAPUSER T 2008-05-15-16.29.55.803235
JBM_COUNTER SOAPUSER T 2008-05-15-16.29.07.928850
JBM_DUAL SOAPUSER T 2008-05-15-16.29.01.086111
JBM_MSG SOAPUSER T 2008-05-15-16.29.04.377379
JBM_MSG_REF SOAPUSER T 2008-05-15-16.29.02.313723
JBM_POSTOFFICE SOAPUSER T 2008-05-15-16.29.15.568942
JBM_ROLE SOAPUSER T 2008-05-15-16.29.10.298685
JBM_TX SOAPUSER T 2008-05-15-16.29.05.802298
JBM_USER SOAPUSER T 2008-05-15-16.29.09.283838
MESSAGE SOAPUSER T 2008-05-15-16.28.59.290604
PHONE SOAPUSER T 2008-05-15-16.29.44.731446
PUBLISHER SOAPUSER T 2008-05-15-16.30.01.771883
PUBLISHER_ASSERTION SOAPUSER T 2008-05-15-16.30.01.294869
SERVICE_CATEGORY SOAPUSER T 2008-05-15-16.29.48.077022
SERVICE_DESCR SOAPUSER T 2008-05-15-16.29.47.247411
SERVICE_NAME SOAPUSER T 2008-05-15-16.29.48.950602
TMODEL SOAPUSER T 2008-05-15-16.29.56.601222
TMODEL_CATEGORY SOAPUSER T 2008-05-15-16.29.58.473195
TMODEL_DESCR SOAPUSER T 2008-05-15-16.29.57.423168
TMODEL_DOC_DESCR SOAPUSER T 2008-05-15-16.30.00.429197
TMODEL_IDENTIFIER SOAPUSER T 2008-05-15-16.29.59.450008
TMODEL_INSTANCE_INFO SOAPUSER T 2008-05-15-16.29.52.750093
TMODEL_INSTANCE_INFO_DESCR SOAPUSER T 2008-05-15-16.29.53.811966
41 record(s) selected.