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&amp;useUnicode=true&amp;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

Reply via email to