I had problems using oracle connection pooling when I was using transactions. So I scrapped that and went back to poolman. There is/was something funny in the way it was doing things, I'd commit the transaction, but it'd still be dirty or something. As I explicitly set the isolation mode prior to starting work I'd be getting these "commit prior to changing transaction mode" exceptions back from oracle (don't remember exactly the wording or the ora error code, but you get the idea). I tried putting a rollback or commit into the connection setup logic, but then I had other strange results.
Sorry, I can't answer your question about your config, it could be ok, it might not be. --mikej -=----- mike jackson [EMAIL PROTECTED] > -----Original Message----- > From: Alexey Yastremskiy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 19, 2003 9:04 PM > To: Tomcat Users List > Subject: Oracle connection pooling + Tomcat 4.1.12 > > > Hi. > > I've got a problem: I tried to setup oracle connection pooling in my > tomcat configuration, but didn't succeed. I checked Tomcat docs and Oracle > docs to produce this, but nothing helped :( > Does anyone have in production such a configuration, using > Oracle-implemented connection pooling? Please, help me to do the > same... > > Here is my configs.... > > [server.xml] > .... > <Resource auth="Container" name="jdbc/DB" > scope="Shareable" type="javax.sql.ConnectionPoolDataSource"/> > <ResourceParams name="jdbc/DB"> > <parameter> > <name>factory</name> > > <value>oracle.jdbc.pool.OracleDataSourceFactory</value> > </parameter> > <parameter> > <name>dataSourceName</name> > > <value>oracle.jdbc.pool.OracleConnectionPoolDataSource</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:oracle:thin:@dbserver:1521:SID</value> > </parameter> > <parameter> > <name>description</name> > <value>my datasource</value> > </parameter> > <parameter> > <name>user</name> > <value>...</value> > </parameter> > <parameter> > <name>password</name> > <value>...</value> > </parameter> > </ResourceParams> > ... > [end server.xml] > > [web.xml] > ... > <resource-env-ref> > <description>my db</description> > <resource-env-ref-name>jdbc/DB</resource-env-ref-name> > > <resource-env-ref-type>javax.sql.ConnectionPoolDataSource</resourc > e-env-ref-type> > </resource-env-ref> > ... > [end web.xml] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
