Weblogic JDBC Drivers with jBoss3.0.0alpha (Resource Excepti
stflourd Jan 10, 2002 6:00 PMI 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&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)