Has anyone run into a problem with acquiring write access to a db using the
jndi setup with tomcat 4.1.24.
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
Everything works beautifully except that I can't write to my Oracle 9 db. I
was able to write without a problem using the Struts DBCP BasicDataSource.
I don't see any parameters to set in the ResourceParams having to do with
read/write/transactions/autocommit
I've tried all permutations of setAutoCommit(true) and setAutoCommit(false)
and commit(). The setReadOnly(false) fails to actually set this property --
which is the only clue I can find -- thanks much
System.out.println("AutoCommit is set to " + cn.getAutoCommit());
System.out.println("ReadOnly is set to " + cn.getAutoCommit());
cn.setAutoCommit(false);
cn.setReadOnly(false);
System.out.println("AutoCommit is set to " + cn.getAutoCommit());
System.out.println("ReadOnly is set to " + cn.getAutoCommit());
Results of the above:
AutoCommit is set to true
ReadOnly is set to true
AutoCommit is set to false
ReadOnly is set to true
My web.xml:
<resource-ref>
<description>Oracle Datasource</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
My server.xml:
<Context path="/scmn" docBase="scmn"
debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_scmn_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/scmn" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/scmn">
<!-- Connection Pool -->
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Class name for Oracle JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<!-- Oracle JDBC url -->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@localhost:1521:mn</value>
</parameter>
<parameter>
<name>username</name>
<value>mn</value>
</parameter>
<parameter>
<name>password</name>
<value>mn</value>
</parameter>
<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to
handle
all of your db connections. Set to 0 for no limit. -->
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in
pool.
Set to 0 for no limit. -->
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become
available
in ms, in this example 10 seconds. An Exception is
thrown if
this timeout is exceeded. Set to -1 to wait
indefinitely. -->
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
</Context>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
