DO NOT REPLY [Bug 15946] New: - Documentation change

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15946>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15946

Documentation change

           Summary: Documentation change
           Product: Tomcat 4
           Version: Unknown
          Platform: All
               URL: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-
                    datasource-examples-howto.html
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Unknown
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


Hi, this is my first bug that I am filing for Tomcat, but it's not even a bug. 
I dont know who to contact for a documentation change.

On the following page...

http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-
howto.html

is a DataSource guideline for the Oracle database. There was a comment there 
that had insired me to file this bug: "We would appreciate comments on this 
section as I'm not an Oracle DBA :-)"

I had no success with the suggested configuration that was provided, but after 
long hours of trial, error, and stabbing in the dark, I have found the only 
solution that works.

This is for Oracle9i (probably the same for Oracle8i as well):

server.xml:

<Resource name="jdbc/oracledb" auth="Container" 
type="oracle.jdbc.pool.OracleDataSource"/>

<ResourceParams name="jdbc/oracledb">
        <parameter>
                <name>factory</name>
                <value>oracle.jdbc.pool.OracleDataSourceFactory</value>
        </parameter>
        <parameter>
                <name>driverType</name>
                <value>thin</value>
        </parameter>
        <parameter>
                <name>networkProtocol</name>
                <value>tcp</value>
        </parameter>
        <parameter>
                <name>serverName</name>
                <value>nameOfServerRunningDB</value>
        </parameter>
        <parameter>
                <name>databaseName</name>
                <value>putDBNameHere</value>
        </parameter>
        <parameter>
                <name>portNumber</name>
                <value>1521</value>
        </parameter>
        <parameter>
                <name>user</name>
                <value>putUserHere</value>
        </parameter>
        <parameter>
                <name>password</name>
                <value>putPassHere</value>
        </parameter>
        <parameter>
                <name>maxActive</name>
                <value>20</value>
        </parameter>
        <parameter>
                <name>maxIdle</name>
                <value>10</value>
        </parameter>
        <parameter>
                <name>maxWait</name>
                <value>-1</value>
        </parameter>
</ResourceParams>


web.xml:

<resource-ref>
        <description>Oracle Datasource example</description>
        <res-ref-name>jdbc/oracledb</res-ref-name>
        <res-type>oracle.jdbc.pool.OracleDataSource</res-type>
        <res-auth>Container</res-auth>
</resource-ref>

I hate this configuration as much as anyone else should because of the Oracle 
specific classes having to be used. However, the example code can stay the 
same - which is a plus.

Tomcat is the best :)

Thanks,

Seva

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>