On Fri, 20 Aug 2004 09:59:50 +0200, <[EMAIL PROTECTED]> wrote:
Hi Henner, I have read this jndi-howto-article and I have tested the jndi/connection as described in the example. --> I works fine. But the dbforms.dbconnection fails with error: Connection errorJDBC-Troubles: was not able to create connection from DbConnection = id=null, name=jdbc/TestDB, jndi=true, conClass=null, username=null, default=true
Ok if we get this working are you going to Wiki it? Just asking.
I've had no trouble with jndi since I got it figured out. Anyway, my entry looks like:
<dbconnection
id="local" name = "java:comp/env/jdbc/Flu_datasource" isJndi = "true" /> id is not necessary though if it is your default...
web.xml
<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/Flu_datasource</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
<Resource name="jdbc/Flu_datasource" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Flu_datasource"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter>
<parameter> <name>maxActive</name> <value>100</value> </parameter>
<parameter> <name>maxIdle</name> <value>30</value> </parameter>
<parameter> <name>maxWait</name> <value>10000</value> </parameter>
<parameter> <name>username</name> <value>myUserName</value> </parameter> <parameter> <name>password</name> <value>MyPassphrase</value> </parameter>
<parameter> <name>driverClassName</name> <value>org.gjt.mm.mysql.Driver</value> </parameter>
<parameter> <name>url</name> <value>jdbc:mysql://localhost:3306/Flu?autoReconnect=true&useUnicode=true&characterEncoding=Shift_JIS</value> </parameter>
<parameter> <name>removeAbandoned</name> <value>true</value> </parameter>
<parameter> <name>logAbandoned</name> <value>true</value> </parameter>
</ResourceParams> -- Shawn
Karma is immutable, so act accordingly!
------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms