[dbforms] JNDI Datapool with MS SQL Server JDBC driver

[Baer, Dominik {VIT-~Kaiseraugst}]

Hi there

I do not get dbforms working with JNDI Datasource. Any idea? 
Would apprecciate your input very much.

Configurations:

-Tomcat 5
-DBForms 2.3
-JDBC Drivers for SQLServer 2000
-My localhost is rkawv1245a
-SQLServer on same machine port 1433
-Database of interest is "dbformstest"
-User "testsuite" has default database "dbformstest", pwd = "dbformstest"


working configuration:
<!-- ========== Connection =================================== -->
            <dbconnection
                isPow2                                  = "true"
                connectionProviderClass = 
"org.dbforms.conprovider.JakartaConnectionProvider"
                name                                    = 
"jdbc:microsoft:sqlserver://rkawv1245a:1433;Database=dbformstest"
                        isJndi                                  = "false"
                        conClass                                = 
"com.microsoft.jdbc.sqlserver.SQLServerDriver"
                        username                                = "testsuite"
                        password                                = "dbformstest"
                />


not working configuration:
<!-- ========== Connection =================================== -->
            <dbconnection
                isPow2                                  = "true"
                name                                    = "jdbc/dbformstest"
                isJndi                                  = "true"
                        
            />

I configured the DataConnection Pool using the admin console in Tomcat 5.
part of web.xml:

  <GlobalNamingResources>
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
    <Resource auth="Container" description="User database that can be updated and 
saved" name="UserDatabase" type="org.apache.catalina.UserDatabase"/>
    <Resource name="jdbc/dbformstest" type="javax.sql.DataSource"/>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
      </parameter>
      <parameter>
        <name>pathname</name>
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>
    <ResourceParams name="jdbc/dbformstest">
      <parameter>
        <name>url</name>
        
<value>jdbc:microsoft:sqlserver://rkawv1245a:1433;DatabaseName=dbformstest</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>dbformstest</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>testsuite</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>


This e-mail is for the intended recipient only.
If you have received it by mistake please let us know by reply and then
delete it from your system; access, disclosure, copying, distribution or
reliance on any of it by anyone else is prohibited.
If you as intended recipient have received this e-mail incorrectly, please
notify the sender (via e-mail) immediately.