2 Replies Latest reply on Sep 2, 2002 11:28 AM by fbiaggi

    3.0.2 do not connect to the database (DB2/400

    fbiaggi

      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
      <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.

        • 1. Re: 3.0.2 do not connect to the database (DB2/400
          stevewink

          Hi,

          I've used DB2/400 but not in EJBs - maybe you could test your resource in a simple test program to see if its the datasource or EJBs that cause the problem.

          Heres my configuration that worked for local transactions, hope it helps ( this is on JBoss 3.0.1 BTW ):

          <?xml version="1.0" encoding="UTF-8"?>


          <depends optional-attribute-name="ManagedConnectionFactoryName">
          <!--embedded mbean-->


          DB2LocalDS


          <config-property name="ConnectionURL" type="java.lang.String">jdbc:as400://HOSTNAME;libraries = MYLIBRARYNAME</config-property>
          <config-property name="DriverClass" type="java.lang.String">com.ibm.as400.access.AS400JDBCDriver</config-property>
          <config-property name="UserName" type="java.lang.String">USERNAME</config-property>
          <config-property name="Password" type="java.lang.String">PASSWORD</config-property>



          <!--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)-->
          ByApplication


          <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



          • 2. Re: 3.0.2 do not connect to the database (DB2/400
            fbiaggi

            Thanks,
            but I do not see any important differences.

            The problem is that JBoss do not connect to the database. If I try to start it disconnected, the database is bound without any errors.

            If mySQL is not active I receive an error.

            Thanks for further help