Re: problem accessing datasource in 5.5.4 application
On Tue, 16 Nov 2004 02:54:23 -0500, Scott Mueller [EMAIL PROTECTED] wrote: Someone please help me. The same code that was working fine in tomcat 5.0.19 does not work anymore in 5.5.4 for accessing the database. I don't see how it could have worked without a ResourceLink element for your context. You can define the ResourceLink globally in conf/context.xml if all your contexts will need it. -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: problem accessing datasource in 5.5.4 application
this is all in my blog .. http://www.adcworks.com/blog/index.php/archives/2004/11/14/getting-up-and-running-with-tomcat-55 -Original Message- From: Remy Maucherat [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 11:06 To: Tomcat Users List Subject: Re: problem accessing datasource in 5.5.4 application On Tue, 16 Nov 2004 02:54:23 -0500, Scott Mueller [EMAIL PROTECTED] wrote: Someone please help me. The same code that was working fine in tomcat 5.0.19 does not work anymore in 5.5.4 for accessing the database. I don't see how it could have worked without a ResourceLink element for your context. You can define the ResourceLink globally in conf/context.xml if all your contexts will need it. -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE --- QAS Ltd. Developers of QuickAddress Software a href=http://www.qas.com;www.qas.com/a Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- /FONT - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: problem accessing datasource in 5.5.4 application
Actually, your log was pretty nice. I didn't know about that ROOT issue thanks. It turned out that I had the following in my ispmanager.xml file: Context docBase=ispmanager path= Realm className=org.apache.catalina.realm.DataSourceRealm dataSourceName=data/ispmanagerpg debug=99 roleNameCol=Rolename userCredCol=Password userNameCol=Username userRoleTable=Account_Roles userTable=Account/ Resource auth=Container description=IspManager database name=data/ispmanagerpg type=javax.sql.DataSource/ ResourceLink global=data/ispmanagerpg name=data/ispmanagerpg type=javax.sql.DataSource/ /Context That worked fine in 5.0.x. Not in 5.5.4, so I removed the 2 Resource* elements and it still didn't work. What finally worked was ONLY removing the Resource element. -Original Message- From: Allistair Crossley [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 6:09 AM To: Tomcat Users List; Remy Maucherat Subject: RE: problem accessing datasource in 5.5.4 application this is all in my blog .. http://www.adcworks.com/blog/index.php/archives/2004/11/14/getting-up-and-ru nning-with-tomcat-55 -Original Message- From: Remy Maucherat [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 11:06 To: Tomcat Users List Subject: Re: problem accessing datasource in 5.5.4 application On Tue, 16 Nov 2004 02:54:23 -0500, Scott Mueller [EMAIL PROTECTED] wrote: Someone please help me. The same code that was working fine in tomcat 5.0.19 does not work anymore in 5.5.4 for accessing the database. I don't see how it could have worked without a ResourceLink element for your context. You can define the ResourceLink globally in conf/context.xml if all your contexts will need it. -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE --- QAS Ltd. Developers of QuickAddress Software a href=http://www.qas.com;www.qas.com/a Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- /FONT - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: problem accessing datasource in 5.5.4 application
Hi Remy, Yes, what you said worked thanks! I had a ResourceLink previously, but I ALSO had a Resource element without the attributes in my context.xml file. That didn't work, so I removed both Resource* elements from my context.xml. That didn't work either. Removing JUST the Resource element worked: Resource auth=Container description=IspManager database name=data/ispmanagerpg type=javax.sql.DataSource/ ResourceLink global=data/ispmanagerpg name=data/ispmanagerpg type=javax.sql.DataSource/ /Context That worked fine in 5.0.x. Not in 5.5.4, so I removed the 2 Resource* elements and it still didn't work. What finally worked was ONLY removing the Resource element. -Original Message- From: Remy Maucherat [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 6:06 AM To: Tomcat Users List Subject: Re: problem accessing datasource in 5.5.4 application On Tue, 16 Nov 2004 02:54:23 -0500, Scott Mueller [EMAIL PROTECTED] wrote: Someone please help me. The same code that was working fine in tomcat 5.0.19 does not work anymore in 5.5.4 for accessing the database. I don't see how it could have worked without a ResourceLink element for your context. You can define the ResourceLink globally in conf/context.xml if all your contexts will need it. -- x Rémy Maucherat Developer Consultant JBoss Group (Europe) SàRL x - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]