3.0.2 do not connect to the database (DB2/400
fbiaggi Sep 1, 2002 4:07 PMHello,
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
<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" />
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 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 -->
<!-- -->
<!-- ===================================================================== -->
<!-- ==================================================================== -->
<!-- New ConnectionManager setup for DB2/400 -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- ==================================================================== -->
<!-- Include a login module configuration named AS400DbRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "AS400DbRealm">
<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>
</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
AS400DbRealm
-->
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
legacy
<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"/>
<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
0
50
5000
15
<!--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)-->
ByContainer
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
java:/TransactionManager
<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer
Thanks for any help.