METIN ZAVRAK wrote:
Hi,
Is there a way to maintain a database connection pool or a socket connection pool within Axis?
2 - Could I maintain a connection pool in order to use existing connections? I am using Tomcat as web server and it has its own db connection pool but how can I register resource to JNDI? I have to maintain two different connection pools (one for mysql and one for oracle)
In your webapps' META-INF/context.xml (Oracle):
<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="D:\<TOMCAT_HOME>\webapp" path="/axis_app" reloadable="true">
<Resource name="jdbc/xdb" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/xdb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- DBCP database connection settings -->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.0.1:1521:ORA_SID</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>dbuser</value>
</parameter>
<parameter>
<name>password</name>
<value>dbpass</value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>100</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
</ResourceParams>
</Context>
Make sure the Oracle JDBC jar file ( ojdbc14_g.jar ) is located under:
<TOMCAT_HOME>/common/endorsed
-- Lyndon Tiu
