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

[bu...@apache.org]

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: tomcat-dev@jakarta.apache.org
        ReportedBy: ssafris@hotmail.com


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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>