Connect to the data source using JNDI in Tomcat

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.