Configure JNDI in eclipse + MySQL + Tomcat

Configuration environment: tomcat5.5, mysql4.1, mysql-connector-java-5.0.0-beta, commons-dbcp-1.2.1, jdk1.5 above the "Dongdong" can go to the Internet.

Then in D: \ tomcat5.5 \ webapps \ new directory dbtest folder, dbtest to create such directories: Web-INF, META-INF, create two folders and two files under the WEB-INF: classes, Lib, Web. XML, test. JSP, create context under the META-INF. XML (I am not sure why I want to create this file. If anyone knows this, please advise me)

Next, we will take the JDBC driverProgramMysql-connector-java-5.0.0-beta and commons-dbcp-1.2.1 decompress, respectively decompress the. Jar files are copied to D: \ tomcat5.5 \ common \ Lib, the above work can be done to configure the connection pool.

1. Configure D: \ Tomcat 5.5 \ conf \ Server. XML to add the following configuration information to server. xml:

Type = "javax. SQL. datasource"
Driverclassname = "com. MySQL. JDBC. Driver"
Password = "yang"
Maxidle = "2"
Maxwait = "5000"
Username = "root"
Url = "JDBC: mysql: // localhost: 3306/math"
Maxactive = "4"/>

Note: "name" indicates the name of the connection pool. "type" indicates the type of the data source. "driverclassname" indicates the class name of the driver. "url" indicates the database path. "math" indicates the database name.

2. Configure D: \ Tomcat 5.5 \ webapps \ dbtest \ WEB-INF \ WEB. XML to add information such

DB connection
Test
Javax. SQL. datasource
Container

Note: The res-ref-name must be the same as the connection pool name.

3. Configure D: \ Tomcat 5.5 \ webapps \ dbtest \ META-INF \ context. XML as follows

DEBUG = "5"
Reloadable = "true"
Crosscontext = "true">

Note: path is the path of the workspace. resourcelink name and global seem to have to be the same as the name of the previous connection pool. I am not quite sure about the global here. Sorry, hey !!

JavaCode

2. Package app;
10. Import java. SQL .*;
14. Import javax. Naming .*;
18. Import javax. SQL. datasource;
22. /*
26. Public class dbmanager
30. {
34. Public static synchronized connection getconnection () throws exception
38. {
42. Try
46. {
50. Context initctx = new javax. Naming. initialcontext ();
54. Context envctx = (context) initctx. Lookup ("Java: COMP/ENV ");
58. Datasource DS = (datasource) envctx. Lookup ("JDBC/test ");
62. Return Ds. getconnection ();
66. }
70. Catch (exception ex)
74. {
78. Throw ex;
82. }
86. }
90. }
94. */
98. Import javax. Naming. context;
102. Import javax. Naming. initialcontext;
106. Import javax. SQL. datasource;
110. Public class dbmanager
114. {
118. Final Static private Boolean verbose = true; // print console Control
122. // Static logger = logger. getlogger (dbmanager. Class. getname ());
126. Private context initctx = NULL;
130. Private context CTX = NULL;
134. Private datasource DS = NULL;
138. Private long timeout = 5000;
142. Public dbmanager ()
146. {
150. Try
154. {
158. Initctx = new initialcontext ();
162. // Init context, read config web. xml
166. If (initctx = NULL)
170. {
174. Throw new exception ("Initial failed! ");
178. }
182. CTX = (context) initctx. Lookup ("Java: COMP/ENV ");
186. // Find "JDBC/sqlserverdb" object this configruation in the server. xml of Tomcat
190. If (CTX! = NULL)
194. {
198. DS = (datasource) CTX. Lookup ("JDBC/test ");
202. }
206. If (DS = NULL)
210. {
214. Throw new exception ("Look up datasource failed! ");
218. }
222. }
226. Catch (exception E)
230. {
238. Log (E, "can't get the context! ");
246. }
250. }
254. Public synchronized connection getconnection (){
258. // Get connection and set to delay time
262. Long starttime = new java. util. Date (). gettime ();
266. Connection con = NULL;
270. While (con = NULL ){
274. Con = newconnection ();
278. If (con! = NULL ){
282. // Log ("create new connection! ");
286. Break;
290. }
294. Try {
298. Log ("connection timeout, reconnect, wait" + timeout + "Ms ");
302. Wait (timeout );
306. }
310. Catch (interruptedexception e ){
314. Log (E, "connection timeout! ");
318. }
322. If (New java. util. Date (). gettime ()-starttime)> = timeout ){
326. Log ("connection timeout! ");
330. Break;
334. }
338. }
342. Return con;
346. }
350. Private connection newconnection (){
354. Connection con = NULL;
358. Try {
362. Con = Ds. getconnection ();
366. If (con = NULL ){
370. Throw new exception ("create connection failed! ");
374. }
378. }
382. Catch (exception e ){
386. Log ("create connection failed! ");
390. System. Out. println (E. getmessage ());
394. }
398. Return con;
402. }
406. Public synchronized void freeconnection (connection Conn,
410. Statement stmt,
414. Preparedstatement pstmt ){
418. Try {
422. // Close statement
426. If (stmt! = NULL ){
430. Stmt. Close ();
434. Stmt = NULL;
438. // Log ("Close statement ......");
442. }
446. // Close preparedstatement
450. If (pstmt! = NULL ){
454. Pstmt. Close ();
458. Pstmt = NULL;
462. // Log ("Close preparedstatement ......");
466. }
470. }
474. Catch (exception e ){
478. System. Out. println (E. getmessage ());
482. }
486. Try {
490. // Close connection
494. If (Conn! = NULL ){
498. Conn. Close ();
502. Conn = NULL;
506. // Log ("close connection ......");
510. }
514. }
518. Catch (sqlexception e ){
522. Log (E, "An error occurred while releasing the resource! ");
526. }
530. }
534. /************************************
538. * Write log file.
542. * @ Param s string
546. ************************************/
550. Private void log (string S)
554. {
558. If (verbose)
562. {
566. System. Out. println (New java. util. Date () + ":" + S );
570. // Logger.info (New java. util. Date () + S );
574. }
578. }
582. Private void log (throwable E, string MSG)
586. {
590. System. Out. println (New java. util. Date () + ":" + MSG );
594. }
598. }

Triman.rar

Description:
Eclipse + MySQL + Tomcat configuration JNDI implementation example

Download

File Name:
Triman.rar

File Size:
1007 KB

Http://uuplace.javaeye.com/blog/88878