1 Reply Latest reply on Mar 8, 2002 3:13 AM by Jamal Karimi

    Error when creating oracle data source with 3.0 beta

    leo yu Newbie


      Hi,
      I got the following error messages when try to create an oracle datasource with the xml file, oracleds-service.xml, downloaded from CVS. I have set the username and password correct in the xml file but still got user as null.
      Can I get some help ? Here are the messages:
      10:20:40,278 ERROR [OracleDS] Unable to create ManagedConnection:
      javax.resource.ResourceException: Unable to create DBconnection for url:jdbc:oracle:thin:@cerebellum.corpdc.epocrates.com:1521:dev03, user: null, exception: java.sql.SQLException: invalid arguments in call
      at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectinFactory.createManagedConnection(JDBCManagedConnectionFactory.java:392)
      at org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.cre
      ateObject(ManagedConnectionPoolFactory.java:97)
      at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1013)
      at org.jboss.pool.ObjectPool.initialize(ObjectPool.java:730)
      at org.jboss.resource.connectionmanager.PoolManager.createPool(PoolManag
      er.java:43)
      at org.jboss.resource.connectionmanager.PoolManager.access$000(PoolManag
      er.java:15)
      at org.jboss.resource.connectionmanager.PoolManager$FactoryRecord.
      (PoolManager.java:150)
      at org.jboss.resource.connectionmanager.PoolManager.addPerFactoryPool(Po
      olManager.java:106)
      at org.jboss.resource.connectionmanager.BaseConnectionManager.createPerF
      actoryPool(BaseConnectionManager.java:147)
      at org.jboss.resource.connectionmanager.jboss.MinervaSharedLocalCMFactor
      y.addManagedConnectionFactory(MinervaSharedLocalCMFactory.java:128)

        • 1. Re: Error when creating oracle data source with 3.0 beta
          Jamal Karimi Newbie

          Hi,

          just post us your oracleds-service.xml...

          Till then here is the one I use:

          /jamal

          ---8<------
          ?xml version="1.0" encoding="UTF-8"?>
          <!-- ===================================================================== -->
          <!-- -->
          <!-- JBoss Server Configuration -->
          <!-- -->
          <!-- ===================================================================== -->


          <!-- ==================================================================== -->
          <!-- JDBC - Initialize the databases -->
          <!-- to ConnectionFactoryLoader -->
          <!-- ==================================================================== -->



          ConnectionURL=jdbc:oracle:thin:@linux1:1521:Test
          DriverClass=oracle.jdbc.driver.OracleDriver
          UserName=jka
          Password=jka

          OracleDS
          java:/TransactionManager
          <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter

          <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory

          MinSize=0
          MaxSize=10
          BlockingTimeoutMillis=5000
          IdleTimeoutMinutes=30
          CleanupIntervalMinutes=10
          MaxIdleTimeoutPercent=1.0


          org.jboss.resource.security.ManyToOnePrincipalMapping