Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
Brian many thanks problem solved - I had changed server.xml to show that the Resource jdbc/mydb was of type type="DataSource" not type="javax.sql.DataSource" ! This solved it now works and shows output from both databases. Many, many thanks! Cheers, Iain I D B Major wrote: Hi again, H

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
Hi again, Having renamed both the context-params I get the following error org.apache.jasper.JasperException: Unable to get connection, DataSource invalid: "java.lang.NullPointerException" Which sort of implies that the default name of 'javax.servlet.jsp.jstl.sql.dataSource' must be used on

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
Hi Brian, many thanks for the suggestions, I'm sure I'm now close, but I'm not quite out of the trees yet. I have looked up the spec and followed your suggestion to specify the datasource and I have changed one of the context-params to simply dataSource. This means I now no longer get the sam

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread Brian Buchanan
-Original Message- From: I D B Major <[EMAIL PROTECTED]> Date: Mon, 26 Jun 2006 09:44:37 +0100 > Hi all, > > please can someone confirm whether I need to clarify anything in my > question or take a different approach since I have had no replies and > am > anxious to make sure I am doi

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
. Regards Tejas -Original Message- From: I D B Major [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 2:15 PM To: Tomcat Users List Subject: Re: Problem accessing two McKoi databases from Tomcat Hi all, please can someone confirm whether I need to clarify anything in my question

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
notify the sender immediately by telephone or email and destroy the original message without making a copy. Thank you. - Original Message ----- From: "I D B Major" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Monday, June 26, 2006 4:44 AM Subject: Re: Probl

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
: I D B Major [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 2:15 PM To: Tomcat Users List Subject: Re: Problem accessing two McKoi databases from Tomcat Hi all, please can someone confirm whether I need to clarify anything in my question or take a different approach since I have had no

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread Martin Gainty
gt; To: "Tomcat Users List" Sent: Monday, June 26, 2006 4:44 AM Subject: Re: Problem accessing two McKoi databases from Tomcat Hi all, please can someone confirm whether I need to clarify anything in my question or take a different approach since I have had no replies and am anxio

RE: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread Tejas Bavishi
Message- From: I D B Major [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 2:15 PM To: Tomcat Users List Subject: Re: Problem accessing two McKoi databases from Tomcat Hi all, please can someone confirm whether I need to clarify anything in my question or take a different approach since

Re: Problem accessing two McKoi databases from Tomcat

2006-06-26 Thread I D B Major
Hi all, please can someone confirm whether I need to clarify anything in my question or take a different approach since I have had no replies and am anxious to make sure I am doing all I can to seek help in the correct way. Please correct me if my approach is wrong! many thanks Iain I D