Connect to the data source using JNDI in Tomcat

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