Some progress but still not working.
1. Using my connection parameters I can open a connection to the database in
the standard JDBC way.
2. I have to moved the DataSource configuration from GlobalNamingResources
to the apps Context area of server.xml. This seems to have allowed the JNDI
look-up
to the database.
Doug
- Original Message -
From: Paul Mahoney [EMAIL PROTECTED]
To: 'Parsons Technical Services' [EMAIL PROTECTED];
'Tomcat Users List' [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 8:35 AM
Subject: RE: Problem using JNDI/DBCP to get DataSouce
Some progress but still
16:01
To: Tomcat Users List; [EMAIL PROTECTED]
Subject: Re: Problem using JNDI/DBCP to get DataSouce
Paul,
Since you have done several changes, please repost your current context
section of the server.xml, exception you receive and code you use to access
the DB both with conventional JDBC
-To: Tomcat Users List [EMAIL PROTECTED], [EMAIL PROTECTED]
To: 'Parsons Technical Services' [EMAIL PROTECTED],
'Tomcat Users List' [EMAIL PROTECTED]
Subject: RE: Problem using JNDI/DBCP to get DataSouce
Here goes Cut and paste, but blanked out the password bits.
I hope your eyes can
Users List; [EMAIL PROTECTED]
Subject: Re: Problem using JNDI/DBCP to get DataSouce
Paul,
Since you have done several changes, please repost your current context
section of the server.xml, exception you receive and code you use to access
the DB both with conventional JDBC and DBCP. At this point
Alex,
Chase the thread. He is on 4.1.30 and no the pool does not work at all.
Doug
- Original Message -
From: Alex [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 11:19 AM
Subject: RE: Problem using JNDI/DBCP to get DataSouce
This is what
: Re: Problem using JNDI/DBCP to get DataSouce
Paul,
Replace this:
if (dataSource == null)
{
Context initContext = new InitialContext ();
Context envContext = (Context) initContext.lookup
(java:comp/env);
dataSource = (DataSource
Check your validation query in your resource definition.
-Original Message-
From: Paul Mahoney [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 12:57 PM
To: 'Parsons Technical Services'; 'Tomcat Users List'
Subject: RE: Problem using JNDI/DBCP to get DataSouce
Tried
Message-
From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED]
Sent: 17 March 2004 18:00
To: Tomcat Users List; [EMAIL PROTECTED]; Parsons Technical Services
Subject: RE: Problem using JNDI/DBCP to get DataSouce
Check your validation query in your resource definition.
-Original Message
, Arthur; 'Tomcat Users List'; 'Parsons Technical
Services'
Subject: RE: Problem using JNDI/DBCP to get DataSouce
I agree, but it looks good and I've tried without one being specified.
In
addition, I've never see a connection raised at the database server end.
This makes me think the DataSource
Technical
Services' [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 1:05 PM
Subject: RE: Problem using JNDI/DBCP to get DataSouce
I agree, but it looks good and I've tried without one being specified. In
addition, I've never see a connection raised at the database server end.
This makes me think
)
-Original Message-
From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED]
Sent: 17 March 2004 18:07
To: [EMAIL PROTECTED]; Tomcat Users List; Parsons Technical Services
Subject: RE: Problem using JNDI/DBCP to get DataSouce
Would you include any resource definitions and/or any
resourcelinks
Technical
Services'
Subject: RE: Problem using JNDI/DBCP to get DataSouce
To get this far I had to more the datasource resource defiition to the
context. I've rasie the debug to 9 but could see no additional loging
that
would help. Here is the context ...
Context className
.
-Original Message-
From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED]
Sent: 17 March 2004 19:37
To: [EMAIL PROTECTED]; Tomcat Users List; Parsons Technical Services
Subject: RE: Problem using JNDI/DBCP to get DataSouce
For future, recommend snipping any real host/username/passwords
To: Tomcat Users List; [EMAIL PROTECTED]
Subject: Re: Problem using JNDI/DBCP to get DataSouce
Paul,
Add this to the context for each application that needs the database.
ResourceLink name=jdbc/OscarsDB global=jdbc/OscarsDB
type=javax.sql.DataSource/
Doug Parsons
Paul,
Add this to the context for each application that needs the database.
ResourceLink name=jdbc/OscarsDB global=jdbc/OscarsDB
type=javax.sql.DataSource/
Doug Parsons
www.parsonstechnical.com
- Original Message -
From: Paul Mahoney [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL
PROTECTED]
Subject: Re: Problem using JNDI/DBCP to get DataSouce
Paul,
Add this to the context for each application that needs the database.
ResourceLink name=jdbc/OscarsDB global=jdbc/OscarsDB
type=javax.sql.DataSource/
Doug Parsons
www.parsonstechnical.com
- Original Message -
From
]
To: 'Parsons Technical Services' [EMAIL PROTECTED];
'Tomcat Users List' [EMAIL PROTECTED]
Sent: Monday, March 15, 2004 5:31 PM
Subject: RE: Problem using JNDI/DBCP to get DataSouce
Thanks for the tip. I put it in the server.xml in the /CustomFares context
but it didn't help. Is there are equivalent
18 matches
Mail list logo