1 Reply Latest reply on Jan 10, 2002 9:33 PM by David Jencks

    Weblogic JDBC Drivers with jBoss3.0.0alpha (Resource Excepti

    Denis St Flour Newbie

      I am having a ResourceException when deploying an application using the JDBC type 4 Driver for MSSQL with jBoss3.0.0 alpha. Note: I used a similar descriptor file and succesfully deployed an application using the ATINAV JDBC Driver instead of Weblogic. I have tried all sorts of approaches in defining the url including combining URL with user name an password such as jdbc:weblogic:mssqlserver4:mydb@localhost:1433?user=myusername&password=mypassword
      but to no avail.


      My descriptor file is as follows
      <?xml version="1.0" encoding="UTF-8"?>

      <!-- mssqlds-service.xml -->






      URL=jdbc:weblogic:mssqlserver4:mydb@localhost:1433;
      user=mypassword;password=mypassword;
      DriverClass=weblogic.jdbc.mssqlserver4.Driver
      DefaultDS
      java:/TransactionManager

      <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
      <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
      #
      #Wed Aug 15 16:17:29 EDT 2001
      MinSize=0
      MaxSize=10
      BlockingTimeoutMillis=5000
      IdleTimeoutMinutes=30
      CleanupIntervalMinutes=10
      MaxIdleTimeoutPercent=1.0


      <!-- connectionURL=jdbc:weblogic:mssqlserver4:mydb@localhost:1433?user=myusername&amp;password=mypassword
      -->

      org.jboss.resource.security.ManyToOnePrincipalMapping

      connectionURL=jdbc:weblogic:mssqlserver4:mydb@localhost:1433;
      userName=myusername;password=mypassword





      The error is as follows:

      javax.resource.ResourceException: Unable to create DB connection for url: null, user: dsf1;password=dsf, exception: java.sql.SQLException: The url cannot be null
      at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.createManagedConnection(JDBCManagedConnectionFactory.java:392)
      at org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.createObject(ManagedConnectionPoolFactory.java:77)
      at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1010)
      at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:670)
      at org.jboss.resource.connectionmanager.SharedLocalConnectionManager.allocateConnection(SharedLocalConnectionManager.java:124)
      at org.jboss.resource.adapter.jdbc.JDBCDataSource.getConnection(JDBCDataSource.java:110)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.getConnection(JDBCStoreManager.java:303)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:65)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:41)
      at org.jboss.ejb.plugins.cmp.CMPStoreManager.start(CMPStoreManager.java:142)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:137)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:186)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:354)
      at org.jboss.ejb.Application.start(Application.java:206)
      at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:382)
      at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:308)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:467)
      at org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:444)
      at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:215)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      at org.jboss.deployment.AutoDeployer.deploy(AutoDeployer.java:654)
      at org.jboss.deployment.AutoDeployer.run(AutoDeployer.java:327)
      at java.lang.Thread.run(Unknown Source)

        • 1. Re: Weblogic JDBC Drivers with jBoss3.0.0alpha (Resource Exc
          David Jencks Master

          I think the ManagedConnectionFactoryProperties need to be in properties file format and have at least one different attribute. Try more like this:

          ConnectionURL=jdbc:weblogic:mssqlserver4:mydb@localhost:1433
          user=mypassword
          password=mypassword
          DriverClass=weblogic.jdbc.mssqlserver4.Driver

          and also



          userName=myusername
          password=mypassword


          you should be able to leave out the userName/password in the ManagedConnectionFactoryProperties if you don't need a minsize in your pool.

          (I hope this makes it through ok, this stupid little browser window is acting weird)