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