1) Configure <resourceparams> in Tomcat <context> </context>, where name = "JDBC/datasource"
The JNDI name.
2) JavaCodeCall
Initialcontext CTX = new initialcontext ();
Context envctx = (context) CTX. Lookup ("Java: COMP/ENV ");
Datasource DS = (datasource) envctx. Lookup ("JDBC/datasource ");
Conn = Ds. getconnection ();
<Resourceparams name = "JDBC/datasource">
<Parameter>
<Name> factory </Name>
<Value> org. Apache. commons. DBCP. basicperformancefactory </value>
</Parameter>
Configure your mysqld max_connections large enough to handle
all of your DB connections. set to 0 for no limit.
-->
maxactive
100
set to 0 for no limit.
-->
maxidle
30
In MS, in this example 10 seconds. an exception is thrown if
this timeout is exceeded. set to-1 to wait indefinitely.
-->
maxwait
10000
<! -- MySQL db username and password for DB connections -->
<Parameter>
<Name> username </Name>
<Value> zlgl </value>
</Parameter>
<Parameter>
<Name> password </Name>
<Value> zlgl </value>
</Parameter>
<! -- Class name for mm. MySQL JDBC driver -->
<Parameter>
<Name> driverclassname </Name>
<Value> oracle. JDBC. Driver. oracledriver </value>
</Parameter>
the autoreconnect = true argument to the URL makes sure that
MM. mySQL JDBC driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours. -->
URL
JDBC: oracle: thin: zlgl/ZLGL@192.168.0.166: 1521: zlgl