Problems integrating with JBoss and Mckoi
joel.rosi-schwartz May 19, 2002 4:14 PMHi,
[Note: the previous post with the "Subject null" contains the files I wanted to attach to this post. What is the problem with the posting feature? Or is just my browser that is broken? ]
I have modified Howard Ship's integration with the Mckoi Database to work with the new com.mckoi.database.control API. When I start JBoss it seems as if Mckoi is starting alright, but then an exception is thrown while JBoss is setting up XA after which the JBoss startup freezes. At least I think that is where the exception is occurring. The problem I am having in sorting this out is that I have insufficient information in the logs to pin point the cause. Also my understanding of both Mckoi and the JBoss JMX loader are a bit slim to be tackling these. So, I sure could use some insight.
I am pretty sure that I have the new classes right and the JBoss log indicates that the database startup is successful. I believe that the Mckoi config file is okay; I have tested it stand alone and it works okay.
It is the java.sql.SQLException: Connection refused in the JBoss log that has me stumped. Does this mean that the database has not actually started or does it indicate that JBoss is trying to connect to the database on the wrong port or with inappropriate credentials or ....?
The relevant part of the JBoss log is below:
[Default] McKoiDB starting
[Default] McKoiDB started
[XADataSourceLoader] Starting
[McKoiDB] XA Connection pool McKoiDB bound to java:/McKoiDB
[McKoiDB] java.sql.SQLException: Connection refused
[McKoiDB] Pool McKoiDB factory org.jboss.pool.jdbc.xa.XAConnectionFactory@fced4 unable to create new object!
[McKoiDB] Pool McKoiDB [0/0/10] waiting for a free object
I have turned Mckoi's debug up to 10 and here is the output of the run:
**** Debug log started: Sun May 19 21:20:20 BST 2002 ****
% Internal Data Cache size: 4194304
% Internal Data Cache max cell size: 8192
% lookup_comparison_list = true
% read_only = false
% dont_synch_filesystem = false
% transaction_error_on_dirty_select = true
% ignore_case_for_identifiers = false
% Java regex API not available.
% No 'function_factories' config property found.
% statement_cache = true
% Max worker threads set to: 4
% Starting Database Server: ../db/useme/data
> com.mckoi.database.LockingMechanism ( lvl: 10 )
Locked into ** EXCLUSIVE MODE **
> com.mckoi.database.LockingMechanism ( lvl: 10 )
UnLocked from ** EXCLUSIVE MODE **
I have also attached the source files for the Mbeans service and the Mckoi config file. The relevant portion of the JBoss jcml file is:
<!-- ==================================================================== -->
<!-- JDBC: McKoiDB -->
<!-- ==================================================================== -->
com.mckoi.JDBCDriver
<!-- 9157 -->
../db/useme/data
../conf/catalina/useme-db.conf
McKoiDB
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:mckoi://localhost/
1200000
test
test
10
false
false
false
true
120000
1800000
false
true
1.0
0
Any ideas on how to track this down would be much appreciated.
Tia,
Joel