On 2002.05.01 00:54:02 -0400 Stephen Coy wrote:
> 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.

Looking at the code I think my suggestion will be enough.  The properties
stored in the LocalManagedConnection are the ones we constructed, we sent a
copy to Oracle and we forgot about them.

david

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

Reply via email to