Hello,
I have found a workaround but want to post the problem.
DbForms is taking the default connection from one tomcat context and applying it to another.
For instance in dbforms-config.xml for context A I have:
<dbconnection
id="local"
name = "java:comp/env/jdbc/contextA_datasource"
isJndi = "true"
/>And in context B:
<dbconnection
name = "jdbc:mysql://localhost/TESOL?useUnicode=true&characterEncoding=Shift_JIS"
isJndi = "false"
conClass = "org.gjt.mm.mysql.Driver"
username = "not_real"
password = "qwerty"
/>
Then when I try to access a page in contect B I get:
org.apache.jasper.JasperException: JDBC-Troubles: was not able to create connection from DbConnection = id=local,....
which is of course because the A connection is for a different database. Just adding id="context_b" to dbforms-config.xml and <db:dbform dbConnectionName="context_b" to my page solved it.
-- Shawn
Karma is immutable, so act accordingly!
------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
