I was beginning to think that I was talking to myself here :-)
It looks like
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections
has the same problem.
I will make this change and let you know. At the moment, I changed the
above function plus LocalManagedConnection to compare the "user" and
"password" properties for equality instead.
On Wednesday, May 1, 2002, at 02:44 PM, David Jencks wrote:
> I was assuming that a driver would not change the properties passed to
> it
> on a getConnection(properties) call, but I was WRONG!! Oracle in their
> infinite wisdom is adding some more properties.
>
> Can you check if changing line 115 of LocalManagedConnectionFactory to
>
> Connection con =
> getDriver().connect(internalGetConnectionURL(),
> new Properties(props));
>
>
> fixes the problem?
>
> Thanks
> david jencks
>
>
> On 2002.04.30 23:59:29 -0400 Stephen Coy wrote:
>> Futher investigation reveals the following code in jboss-
>> all/connector/src/main/org/jboss/resource/adapter/jdbc/local/LocalManagedConnection.
>> java:
>>
>> private void checkIdentity(Subject subject, ConnectionRequestInfo
>> cri)
>> throws ResourceException
>> {
>> Properties newProps = mcf.getConnectionProperties(subject, cri);
>> if (!props.equals(newProps))
>> {
>> props.list(System.err);
>> newProps.list(System.err);
>> throw new ResourceException("Wrong credentials passed to
>> getConnection! ");
>> } // end of if ()
>> }
>>
>> You can see that I've added some debugging statements which reveal:
>>
>> 13:51:32,730 ERROR [STDERR] -- listing properties --
>> 13:51:32,731 ERROR [STDERR] user=steve
>> 13:51:32,733 ERROR [STDERR] password=xxxx
>> 13:51:32,733 ERROR [STDERR] dll=ocijdbc9
>> 13:51:32,735 ERROR [STDERR] protocol=thin
>> 13:51:32,735 ERROR [STDERR] -- listing properties --
>> 13:51:32,735 ERROR [STDERR] user=steve
>> 13:51:32,738 ERROR [STDERR] password=xxxx
>> 13:51:32,770 ERROR [EntityContainer] Exception in service lifecyle
>> operation: create
>>
>> so I think it's fair to assume that it is unreasonable to compare these
>> property lists for equality.
>>
>> On Wednesday, May 1, 2002, at 01:40 PM, Stephen Coy wrote:
>>
>>> I'm running the current Branch_3_0 code and the above message has
>>> started appearing in the last few days when deploying my ejb jar file.
>>>
>>> I have an Oracle DS setup as per the example in jboss-
>>> all/connector/src/etc/example-config/oracle-service.xml and the
>>> appropriate security realm set up in login-config.xml. What could have
>>> changed that would stop this from working?
>>>
>>> Here's the console output:
>>>
>>> 13:35:57,139 ERROR [EntityContainer] Exception in service lifecyle
>>> operation: create
>>> 13:35:57,144 ERROR [STDERR] java.sql.SQLException: ResourceException
>>> javax.resource.ResourceException: Wrong credentials passed to
>>> getConnection!
>>> 13:35:57,146 ERROR [STDERR] at
>>> org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection
>>> (LocalDataSource.java:105)
>>> 13:35:57,148 ERROR [STDERR] at
>>> org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:38)
>>> 13:35:57,148 ERROR [STDERR] at
>>> org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.<init>
>>> (JDBCEntityBridge.java:103)
>>> 13:35:57,184 ERROR [STDERR] at
>>> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.create
>>> (JDBCStoreManager.java:
>>> 333)
>>> 13:35:57,186 ERROR [STDERR] at
>>> org.jboss.ejb.plugins.CMPPersistenceManager.create
>>> (CMPPersistenceManager.java:
>>> 155)
>>> 13:35:57,188 ERROR [STDERR] at
>>> org.jboss.ejb.EntityContainer.create(EntityContainer.java:337)
>>> 13:35:57,189 ERROR [STDERR] at
>>> org.jboss.ejb.Container.invoke(Container.java:790)
>>> 13:35:57,190 ERROR [STDERR] at
>>> org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
>>> 13:35:57,192 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,193 ERROR [STDERR] at
>>> org.jboss.system.ServiceController$ServiceProxy.invoke
>>> (ServiceController.java:
>>> 867)
>>> 13:35:57,195 ERROR [STDERR] at $Proxy0.create(Unknown Source)
>>> 13:35:57,196 ERROR [STDERR] at
>>> org.jboss.system.ServiceController.create(ServiceController.java:271)
>>> 13:35:57,198 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,200 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,202 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,203 ERROR [STDERR] at
>>> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
>>> 13:35:57,204 ERROR [STDERR] at $Proxy19.create(Unknown Source)
>>> 13:35:57,206 ERROR [STDERR] at
>>> org.jboss.ejb.EjbModule.createService(EjbModule.java:392)
>>> 13:35:57,207 ERROR [STDERR] at
>>> org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:134)
>>> 13:35:57,209 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,210 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,212 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,213 ERROR [STDERR] at
>>> org.jboss.system.ServiceController$ServiceProxy.invoke
>>> (ServiceController.java:
>>> 867)
>>> 13:35:57,215 ERROR [STDERR] at $Proxy0.create(Unknown Source)
>>> 13:35:57,216 ERROR [STDERR] at
>>> org.jboss.system.ServiceController.create(ServiceController.java:271)
>>> 13:35:57,218 ERROR [STDERR] at
>>> org.jboss.system.ServiceController.create(ServiceController.java:211)
>>> 13:35:57,219 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,221 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,263 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,265 ERROR [STDERR] at
>>> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
>>> 13:35:57,267 ERROR [STDERR] at $Proxy5.create(Unknown Source)
>>> 13:35:57,268 ERROR [STDERR] at
>>> org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:376)
>>> 13:35:57,269 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.create(MainDeployer.java:651)
>>> 13:35:57,271 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:526)
>>> 13:35:57,272 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:490)
>>> 13:35:57,274 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,275 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,277 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,278 ERROR [STDERR] at
>>> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
>>> 13:35:57,280 ERROR [STDERR] at $Proxy4.deploy(Unknown Source)
>>> 13:35:57,282 ERROR [STDERR] at
>>> org.jboss.deployment.scanner.URLDeploymentScanner.deploy
>>> (URLDeploymentScanner.java:405)
>>> 13:35:57,283 ERROR [STDERR] at
>>> org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory
>>> (URLDeploymentScanner.java:586)
>>> 13:35:57,285 ERROR [STDERR] at
>>> org.jboss.deployment.scanner.URLDeploymentScanner.scan
>>> (URLDeploymentScanner.java:465)
>>> 13:35:57,286 ERROR [STDERR] at
>>> org.jboss.deployment.scanner.AbstractDeploymentScanner.startService
>>> (AbstractDeploymentScanner.java:237)
>>> 13:35:57,287 ERROR [STDERR] at
>>> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
>>> 13:35:57,289 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,290 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,292 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,293 ERROR [STDERR] at
>>> org.jboss.system.ServiceController$ServiceProxy.invoke
>>> (ServiceController.java:
>>> 867)
>>> 13:35:57,295 ERROR [STDERR] at $Proxy0.start(Unknown Source)
>>> 13:35:57,297 ERROR [STDERR] at
>>> org.jboss.system.ServiceController.start(ServiceController.java:341)
>>> 13:35:57,298 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,300 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,301 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,303 ERROR [STDERR] at
>>> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
>>> 13:35:57,343 ERROR [STDERR] at $Proxy3.start(Unknown Source)
>>> 13:35:57,345 ERROR [STDERR] at
>>> org.jboss.deployment.SARDeployer.start(SARDeployer.java:281)
>>> 13:35:57,347 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.start(MainDeployer.java:692)
>>> 13:35:57,348 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:527)
>>> 13:35:57,350 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:490)
>>> 13:35:57,351 ERROR [STDERR] at
>>> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:472)
>>> 13:35:57,353 ERROR [STDERR] at
>>> java.lang.reflect.Method.invoke(Native Method)
>>> 13:35:57,354 ERROR [STDERR] at
>>> org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke
>>> (ReflectedMBeanDispatcher.java:284)
>>> 13:35:57,356 ERROR [STDERR] at
>>> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
>>> 13:35:57,357 ERROR [STDERR] at
>>> org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:320)
>>> 13:35:57,359 ERROR [STDERR] at
>>> org.jboss.system.server.ServerImpl.start(ServerImpl.java:218)
>>> 13:35:57,360 ERROR [STDERR] at org.jboss.Main.boot(Main.java:142)
>>> 13:35:57,362 ERROR [STDERR] at org.jboss.Main$1.run(Main.java:375)
>>> 13:35:57,364 ERROR [STDERR] at
>> java.lang.Thread.run(Thread.java:496)
>>> org.jboss.deployment.DeploymentException: Error while fixing table
>>> name; - nested throwable: (java.sql.SQLException: ResourceException
>>> javax.resource.ResourceException: Wrong credentials passed to
>>> getConnection! )
>>>
>>
>>
>>
>>