Bugs item #604950, was opened at 2002-09-05 10:48
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=604950&group_id=22866

Category: JBossCMP
Group: v3.2
Status: Open
Resolution: None
Priority: 5
Submitted By: Franco Biaggi (fbiaggi)
Assigned to: Nobody/Anonymous (nobody)
Summary: 3.0.2 do not connect to the database

Initial Comment:
 Hello,
following problem (wrok fine in JBoss 2.4.7)

The application access both a mySQL db and a DB2/400 db.
During the migration to 3.0.2 I just added 2
-service.xml files and user/passwords.
The mySQL connection work fine, the DB2/400 not AND
WITHOUT ERRORS.
The DB2/400 connection is bound.
The problem is that JBoss do not try to connect to the
database and during deploy of the EJB's hangs without
any error.

stdout.log:

...
20:50:49,112 INFO [MainDeployer] Starting deployment of
package:
file:/E:/jboss/server/default/deploy/as400-service.xml
20:50:49,202 WARN [ServiceController]
jboss.jca:service=LocalTxDS,name=legacy does not
implement any Service methods
20:50:49,202 INFO [JBossManagedConnectionPool] Creating
20:50:49,202 INFO [JBossManagedConnectionPool] Created
20:50:49,212 INFO [JBossManagedConnectionPool] Starting
20:50:49,212 INFO [JBossManagedConnectionPool] Started
20:50:49,212 INFO [MainDeployer] Deployed package:
file:/E:/jboss/server/default/deploy/as400-service.xml
...
20:50:51,475 INFO [legacy] Bound connection factory for
resource adapter 'JBoss LocalTransaction JDBC Wrapper'
to JNDI name 'java:/legacy'
... loop at end :
20:51:00,168 INFO [MainDeployer] Starting deployment of
package:
file:/E:/jboss/server/default/deploy/logistockEDI.jar
20:51:00,598 INFO [EjbModule] Creating
20:51:00,668 INFO [EjbModule] Deploying
IFCSUM_R_001_D01_Details
20:51:00,698 INFO [EjbModule] Deploying
IFCSUM_R_001_H01_Header
20:51:00,698 INFO [EjbModule] Deploying CGL7CPP

server.log:

...
2002-09-01 20:50:49,112 INFO
[org.jboss.deployment.MainDeployer] Starting deployment
of package:
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,112 DEBUG
[org.jboss.deployment.MainDeployer] Starting deployment
(init step) of package at:
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,132 DEBUG
[org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL
with url
file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/as400-service.xml/51.as400-service.xml
2002-09-01 20:50:49,132 DEBUG
[org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL
with url
file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/as400-service.xml/51.as400-service.xml
2002-09-01 20:50:49,132 DEBUG
[org.jboss.mx.loading.UnifiedLoaderRepository2] Adding
org.jboss.mx.loading.UnifiedClassLoader@58c528{
url=file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/as400-service.xml/51.as400-service.xml
}
2002-09-01 20:50:49,132 DEBUG
[org.jboss.deployment.MainDeployer] using deployer
org.jboss.deployment.SARDeployer@29428e
2002-09-01 20:50:49,152 DEBUG
[org.jboss.deployment.SARDeployer] about to copy 0
local directories
2002-09-01 20:50:49,152 DEBUG
[org.jboss.deployment.MainDeployer] found 0 subpackages
of file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,152 DEBUG
[org.jboss.deployment.MainDeployer] Watching new file:
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,152 DEBUG
[org.jboss.deployment.MainDeployer] create step for
deployment
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,152 DEBUG
[org.jboss.deployment.SARDeployer] Deploying SAR,
create step: url
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,152 DEBUG
[org.jboss.deployment.SARDeployer] Registering service
UCL=jmx.loading:UCL=7858936
2002-09-01 20:50:49,162 DEBUG
[org.jboss.system.ServiceCreator] About to create bean:
jboss.jca:service=LocalTxCM,name=legacy
2002-09-01 20:50:49,162 DEBUG
[org.jboss.system.ServiceCreator] code:
org.jboss.resource.connectionmanager.LocalTxConnectionManager
2002-09-01 20:50:49,182 DEBUG
[org.jboss.system.ServiceCreator] Created bean:
jboss.jca:service=LocalTxCM,name=legacy
2002-09-01 20:50:49,182 DEBUG
[org.jboss.system.ServiceCreator] About to create bean:
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,182 DEBUG
[org.jboss.system.ServiceCreator] code:
org.jboss.resource.connectionmanager.RARDeployment
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceCreator] Created bean:
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceConfigurator] JndiName set to
legacy in jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceConfigurator]
ManagedConnectionFactoryProperties set to <properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:as400://10.1.1.50</config-property>
<config-property name="DriverClass"
type="java.lang.String">com.ibm.as400.access.AS400JDBCDriver</config-property>
<!--set these only if you want only default logins, not
through JAAS -->
<config-property name="UserName" type="java.lang.String" />
<config-property name="Password" type="java.lang.String" />
</properties> in jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceController] recording that
jboss.jca:service=LocalTxDS,name=legacy depends on
jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceConfigurator] considering
OldRarDeployment with object name
jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceController] recording that
jboss.jca:service=LocalTxCM,name=legacy depends on
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceConfigurator] considering
ManagedConnectionFactoryName with object name
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceCreator] About to create bean:
jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,192 DEBUG
[org.jboss.system.ServiceCreator] code:
org.jboss.resource.connectionmanager.JBossManagedConnectionPool
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceCreator] Created bean:
jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] MinSize set to 0
in jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] MaxSize set to
50 in jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator]
BlockingTimeoutMillis set to 5000 in
jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator]
IdleTimeoutMinutes set to 15 in
jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] Criteria set to
ByContainer in jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] recording that
jboss.jca:service=LocalTxCM,name=legacy depends on
jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] considering
ManagedConnectionPool with object name
jboss.jca:service=LocalTxPool,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] recording that
jboss.jca:service=LocalTxCM,name=legacy depends on
jboss.jca:service=CachedConnectionManager
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] considering
CachedConnectionManager with object name
jboss.jca:service=CachedConnectionManager
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] recording that
jboss.jca:service=LocalTxCM,name=legacy depends on
jboss.security:service=JaasSecurityManager
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] considering
JaasSecurityManagerService with object name
jboss.security:service=JaasSecurityManager
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator]
TransactionManager set to java:/TransactionManager in
jboss.jca:service=LocalTxCM,name=legacy
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] recording that
jboss.jca:service=LocalTxCM,name=legacy depends on
jboss.jca:service=RARDeployer
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceConfigurator] considering
<anonymous> with object name jboss.jca:service=RARDeployer
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] waiting in create
of jboss.jca:service=LocalTxCM,name=legacy waiting on
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,202 WARN
[org.jboss.system.ServiceController]
jboss.jca:service=LocalTxDS,name=legacy does not
implement any Service methods
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] waiting in create
of jboss.jca:service=LocalTxDS,name=legacy waiting on
jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper
2002-09-01 20:50:49,202 INFO
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Creating
2002-09-01 20:50:49,202 INFO
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Created
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] Starting dependent
components: [ObjectName:
jboss.jca:service=LocalTxCM,name=legacy
state: CONFIGURED
I Depend On: jboss.jca:service=LocalTxDS,name=legacy
jboss.jca:service=LocalTxPool,name=legacy
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer

Depends On Me: ]
2002-09-01 20:50:49,202 DEBUG
[org.jboss.system.ServiceController] waiting in create
of jboss.jca:service=LocalTxCM,name=legacy waiting on
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,212 DEBUG
[org.jboss.deployment.MainDeployer] Done with create
step of deploying as400-service.xml
2002-09-01 20:50:49,212 DEBUG
[org.jboss.deployment.MainDeployer] Begin deployment
start
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,212 DEBUG
[org.jboss.deployment.SARDeployer] Deploying SAR, start
step: url
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,212 DEBUG
[org.jboss.system.ServiceController] waiting in start
jboss.jca:service=LocalTxCM,name=legacy on
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,212 DEBUG
[org.jboss.system.ServiceController] waiting in start
jboss.jca:service=LocalTxDS,name=legacy on
jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper
2002-09-01 20:50:49,212 INFO
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Starting
2002-09-01 20:50:49,212 INFO
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Started
2002-09-01 20:50:49,212 DEBUG
[org.jboss.system.ServiceController] Starting dependent
components: [ObjectName:
jboss.jca:service=LocalTxCM,name=legacy
state: CONFIGURED
I Depend On: jboss.jca:service=LocalTxDS,name=legacy
jboss.jca:service=LocalTxPool,name=legacy
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer

Depends On Me: ]
2002-09-01 20:50:49,212 DEBUG
[org.jboss.system.ServiceController] waiting in start
jboss.jca:service=LocalTxCM,name=legacy on
jboss.jca:service=LocalTxDS,name=legacy
2002-09-01 20:50:49,212 DEBUG
[org.jboss.deployment.MainDeployer] End deployment
start on package: as400-service.xml
2002-09-01 20:50:49,212 INFO
[org.jboss.deployment.MainDeployer] Deployed package:
file:/E:/jboss/server/default/deploy/as400-service.xml
2002-09-01 20:50:49,212 DEBUG
[org.jboss.deployment.scanner.URLDeploymentScanner]
Watch URL for:
file:/E:/jboss/server/default/deploy/as400-service.xml
-> file:/E:/jboss/server/default/deploy/as400-service.xml
...
2002-09-01 20:51:00,168 INFO
[org.jboss.deployment.MainDeployer] Starting deployment
of package:
file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,168 DEBUG
[org.jboss.deployment.MainDeployer] Starting deployment
(init step) of package at:
file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,278 DEBUG
[org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL
with url
file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/logistockEDI.jar/70.logistockEDI.jar
2002-09-01 20:51:00,278 DEBUG
[org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL
with url
file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/logistockEDI.jar/70.logistockEDI.jar
2002-09-01 20:51:00,278 DEBUG
[org.jboss.mx.loading.UnifiedLoaderRepository2] Adding
org.jboss.mx.loading.UnifiedClassLoader@6d079a{
url=file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/logistockEDI.jar/70.logistockEDI.jar
}
2002-09-01 20:51:00,298 DEBUG
[org.jboss.deployment.MainDeployer] using deployer
org.jboss.ejb.EJBDeployer@264eab
2002-09-01 20:51:00,308 DEBUG
[org.jboss.deployment.MainDeployer] found 0 subpackages
of file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,308 DEBUG
[org.jboss.deployment.MainDeployer] Watching new file:
file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,308 DEBUG
[org.jboss.deployment.MainDeployer] create step for
deployment
file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,448 DEBUG
[org.jboss.metadata.EntityMetaData] Bean dependencies: []
2002-09-01 20:51:00,448 DEBUG
[org.jboss.metadata.EntityMetaData] Bean dependencies: []
2002-09-01 20:51:00,448 DEBUG
[org.jboss.metadata.EntityMetaData] Bean dependencies: []
2002-09-01 20:51:00,448 DEBUG
[org.jboss.ejb.EJBDeployer] Verifying
file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,528 DEBUG
[org.jboss.ejb.EJBDeployer] IFCSUM_R_001_D01_Details:
Verified.
2002-09-01 20:51:00,568 DEBUG
[org.jboss.ejb.EJBDeployer] IFCSUM_R_001_H01_Header:
Verified.
2002-09-01 20:51:00,588 DEBUG
[org.jboss.ejb.EJBDeployer] CGL7CPP: Verified.
2002-09-01 20:51:00,598 DEBUG
[org.jboss.ejb.EJBDeployer] Deploying:
file:/E:/jboss/server/default/deploy/logistockEDI.jar
2002-09-01 20:51:00,598 INFO [org.jboss.ejb.EjbModule]
Creating
2002-09-01 20:51:00,618 DEBUG [org.jboss.ejb.EjbModule]
Application.start(), begin
2002-09-01 20:51:00,618 DEBUG
[org.jboss.management.j2ee.EJBModule]
EJBModule.create(), server name: J2EEServer=Single
2002-09-01 20:51:00,618 DEBUG
[org.jboss.management.j2ee.J2EEDeployedObject] File:
file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/logistockEDI.jar/70.logistockEDI.jar,
descriptor: META-INF/ejb-jar.xml
2002-09-01 20:51:00,648 DEBUG
[org.jboss.management.j2ee.EJBModule] Create
EJB-Module, name: logistockEDI.jar, application:
jboss.management.single:J2EEServer=Single,name=
2002-09-01 20:51:00,648 DEBUG
[org.jboss.management.j2ee.J2EEManagedObject]
getObjectName(), name:
jboss.management.single:J2EEApplication=
,J2EEServer=Single,j2eeType=EJBModule,name=logistockEDI.jar
2002-09-01 20:51:00,668 DEBUG
[org.jboss.management.j2ee.J2EEManagedObject]
postRegister(), parent:
jboss.management.single:J2EEServer=Single,name=
2002-09-01 20:51:00,668 INFO [org.jboss.ejb.EjbModule]
Deploying IFCSUM_R_001_D01_Details
2002-09-01 20:51:00,698 INFO [org.jboss.ejb.EjbModule]
Deploying IFCSUM_R_001_H01_Header
2002-09-01 20:51:00,698 INFO [org.jboss.ejb.EjbModule]
Deploying CGL7CPP
2002-09-01 20:51:00,729 DEBUG
[org.jboss.system.ServiceController] adding depends in
ServiceController.create: []
2002-09-01 20:51:00,769 DEBUG
[org.jboss.proxy.ejb.ProxyFactory] Bound
jmxName=jboss.j2ee:service=EJB,jndiName=logisuite/stock/edi/eb/ifcsum_r_001/IFCSUM_R_001_H01_Header,
hash=1632301382into Registry
2002-09-01 20:51:00,769 DEBUG
[org.jboss.proxy.ejb.ProxyFactory] Proxy Factory for
logisuite/stock/edi/eb/ifcsum_r_001/IFCSUM_R_001_H01_Header
initialized
2002-09-01 20:51:00,769 DEBUG
[org.jboss.ejb.plugins.jaws.JAWSPersistenceManager]
Initializing JAWS plugin for IFCSUM_R_001_H01_Header
2002-09-01 20:51:00,799 DEBUG
[org.jboss.ejb.plugins.jaws.metadata.JawsXmlFileLoader]
Loading standardjaws.xml :
file:/E:/jboss/server/default/conf/standardjaws.xml
2002-09-01 20:51:01,049 DEBUG
[org.jboss.ejb.plugins.jaws.metadata.JawsXmlFileLoader]
jar:file:/E:/jboss/server/default/tmp/deploy/server/default/deploy/logistockEDI.jar/70.logistockEDI.jar!/META-INF/jaws.xml
found. Overriding defaults
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Init SQL:
CREATE TABLE SV.CGC6CPP (c6cdnb VARCHAR(35),c6e9tx
VARCHAR(70),c6i1cd VARCHAR(3),c6a8qt
DECIMAL(9,0),c6a9qt DECIMAL(9,1),c6k0cd
VARCHAR(3),c6kzcd VARCHAR(35),c6b7tx VARCHAR(35),c6btcd
VARCHAR(20),c6fatx VARCHAR(35),c6k1cd
VARCHAR(35),c6akce VARCHAR(3),c6baqt
DECIMAL(15,2),c6e8tx VARCHAR(10))
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Destroy
SQL: DROP TABLE SV.CGC6CPP
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Exists
SQL: SELECT COUNT(*) FROM SV.CGC6CPP WHERE c6e8tx=?
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] findAll11
SQL: SELECT SV.CGC6CPP.c6e8tx FROM SV.CGC6CPP where 1=1
ORDER BY c6e8tx
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand]
findAllWithId11 SQL: SELECT SV.CGC6CPP.c6e8tx, c6k1cd
FROM SV.CGC6CPP where c6k1cd <> '' ORDER BY c6k1cd, c6e8tx
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand]
findAllWithoutId11 SQL: SELECT SV.CGC6CPP.c6e8tx FROM
SV.CGC6CPP where c6k1cd = '' ORDER BY c6e8tx
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand]
findAllByTransportNr11 SQL: SELECT SV.CGC6CPP.c6e8tx
FROM SV.CGC6CPP where c6k1cd = ? ORDER BY c6e8tx
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand]
AutoGenerated finders - Home=interface
logisuite.stock.edi.eb.ifcsum_r_001.IFCSUM_R_001_H01_HeaderHome11
-- LocalHome=null
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Create
SQL: INSERT INTO SV.CGC6CPP
(c6cdnb,c6e9tx,c6i1cd,c6a8qt,c6a9qt,c6k0cd,c6kzcd,c6b7tx,c6btcd,c6fatx,c6k1cd,c6akce,c6baqt,c6e8tx)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Remove
SQL: DELETE FROM SV.CGC6CPP WHERE c6e8tx=?
2002-09-01 20:51:01,099 DEBUG
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] Load SQL:
SELECT
SV.CGC6CPP.c6e8tx,SV.CGC6CPP.c6cdnb,SV.CGC6CPP.c6e9tx,SV.CGC6CPP.c6i1cd,SV.CGC6CPP.c6a8qt,SV.CGC6CPP.c6a9qt,SV.CGC6CPP.c6k0cd,SV.CGC6CPP.c6kzcd,SV.CGC6CPP.c6b7tx,SV.CGC6CPP.c6btcd,SV.CGC6CPP.c6fatx,SV.CGC6CPP.c6k1cd,SV.CGC6CPP.c6akce,SV.CGC6CPP.c6baqt
FROM SV.CGC6CPP WHERE c6e8tx=?
2002-09-01 20:51:01,099 DEBUG
[org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: registering pool with interval
900000 old interval: 450000
2002-09-01 20:51:01,099 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Using properties: {user=, password=}
2002-09-01 20:51:01,099 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Checking driver for URL: jdbc:as400://10.1.1.50
2002-09-01 20:51:01,099 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Driver not yet registered for url: jdbc:as400://10.1.1.50
2002-09-01 20:51:01,109 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Driver not yet registered for url: jdbc:as400://10.1.1.50
2002-09-01 20:51:01,139 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Driver already registered for url: jdbc:as400://10.1.1.50

as400-service.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!--
=====================================================================
-->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!--
=====================================================================
-->
<server>
<!--
====================================================================
-->
<!-- New ConnectionManager setup for DB2/400 -->
<!-- Build jmx-api (build/build.sh all) and view for
config documentation -->
<!--
====================================================================
-->
<mbean
code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
name="jboss.jca:service=LocalTxCM,name=legacy">
<!-- Include a login module configuration named
AS400DbRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:

<application-policy name = "AS400DbRealm">
<authentication>
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name =
"principal">yourprincipal</module-option>
<module-option name =
"userName">yourusername</module-option>
<module-option name =
"password">yourpassword</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=legacy</module-option>
</login-module>
</authentication>
</application-policy>

NOTE: the application-policy name attribute must match
SecurityDomainJndiName, and the
module-option name = "managedConnectionFactoryName"
must match the object name of the ConnectionManager you
are configuring here.
-->
<!--uncomment out this line if you are using the
AS400DbRealm above
<attribute
name="SecurityDomainJndiName">AS400DbRealm</attribute>
-->
<depends
optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean
code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=legacy">
<attribute name="JndiName">legacy</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:as400://10.1.1.50</config-property>
<config-property name="DriverClass"
type="java.lang.String">com.ibm.as400.access.AS400JDBCDriver</config-property>
<!--set these only if you want only default logins, not
through JAAS -->
<config-property name="UserName" type="java.lang.String"/>
<config-property name="Password" type="java.lang.String"/>
</properties>
</attribute>
<!--Below here are advanced properties -->
<!--hack-->
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper</depends>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=LocalTxPool,name=legacy">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">50</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--criteria indicates if Subject (from security
domain) or app supplied
parameters (such as from getConnection(user, pw)) are
used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if
adapter supports
reauthentication)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<depends
optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>
<attribute
name="TransactionManager">java:/TransactionManager</attribute>
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>


Thanks for any help.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=604950&group_id=22866


-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to