Tomcat _ configure jdbc (small example) and tomcat configure jdbc
Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/47043975
Example of jdbc configuration under tomcat
When you use tomcat to manually configure jdbc, The jdbc. properties file is generally found in the "Application name \ WEB-INF \ classes" folder under the application webapps.
Configure jdbc as follows:
Jdbc. driverClassName = oracle. jdbc. driver. OracleDriver
Jdbc. url = jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.60) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.61) (PORT = 1521) (CONNECT_DATA = (FAILOVER_MODE = (TYPE = select) (METHOD = basic )) (SERVICE_NAME = hyldb )))
# Jdbc. url = jdbc \: oracle \: thin \: @ localhost \: 1521 \: orcl
Jdbc. username = hyl_old_user
Jdbc. password = hyl_old_1
Hylnowdb. driverClassName = oracle. jdbc. driver. OracleDriver
Hylnowdb. url = jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.60) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.61) (PORT = 1521) (CONNECT_DATA = (FAILOVER_MODE = (TYPE = select) (METHOD = basic )) (SERVICE_NAME = hyldb )))
Hylnowdb. username = hyl_now_user
Hylnowdb. password = hyl_now_1
Hylnewdb. driverClassName = oracle. jdbc. driver. OracleDriver
Hylnewdb. url = jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.60) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.61) (PORT = 1521) (CONNECT_DATA = (FAILOVER_MODE = (TYPE = select) (METHOD = basic )) (SERVICE_NAME = hyldb )))
Hylnewdb. username = hyl_new_user
Hylnewdb. password = hyl_new_1
DeployCode = 23
Title = \ u9ED1 \ u9F99 \ u6C5F \ u5211 \ u4FA6 \ u4FE1 \ u606F \ u4E13 \ u4E1A \ u5E94 \ u7528 \ u7CFB \ u7EDF
Area = \ u9ED1 \ u9F99 \ u6C5F
UploadPlace = C:/fileUpload/
UploadUrl = C \:/uploadImg/UploadAccountImg/
A brief explanation of the meaning of this part is as follows:
1. The program's JNDI names are jdbc, hylnowdb, and hylnewdb;
2. jdbc. url indicates the database address;
3. jdbc. username indicates the username used to access the database;
4. jdbc. password indicates the password used to access the database;
5. jdbc. the url represents the part after the database ADDRESS "jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.60) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.56.61) (PORT = 1521) (CONNECT_DATA = (FAILOVER_MODE = (TYPE = select) (METHOD = basic) (SERVICE_NAME = hyldb) ", which is the connected rac cluster database and uses the manual configuration of the client to implement Load Balancing Fault Tolerance configuration;
**************************************** * ** Blue growth series ********************************* *******************
Original works, from the blog of "Deep Blue". You are welcome to reprint them. Please indicate the source (Http://blog.csdn.net/huangyanlong).
Blue growth note-chasing DBA (1): traveling on the road to Shandong
Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs.
Blue growth note-chasing DBA (3): importing and exporting data on antiques becomes a problem
Blue growth note-chasing DBA (4): recalling the sorrow of teenagers, and exploring oracle Installation (10g and 11g in Linux)
Blue growth note-chasing DBA (5): Not talking about technology or business, annoying Application Systems
Blue growth note-chasing DBA (6): doing things and being human: Small technology, great human
Blue growth note-Chase DBA (7): Basic commands, foundation stone
Blue growth notes-chasing DBA (8): repicking SP reports and recalling oracle's STATSPACK Experiment
Blue growth note-chasing DBA (9): Chasing DBA, new planning, new departure
Blue growth note-chasing DBA (10): Flying knife defense, familiarity rather than expertise: Playing with middleware Websphere
Blue growth note-chasing DBA (11): It's easy to go home and wake up.
Blue growth notes-Chase DBA (12): seven days and seven gains of SQL
Blue growth note-chasing DBA (13): Coordinating hardware manufacturers, six stories: what you see as "servers, storage, switches ......"
Blue growth note-chasing DBA (14): An unforgettable "Cloud" end, started hadoop deployment
Blue growth note-chasing DBA (15): Who thinks FTP is "simple" and thinks it is a trigger
Blue growth note-chasing DBA (16): DBA also drank alcohol and was rejected
Blue growth note-Chase DBA (17): whether to share or consume, learn to grow in the Post-IOE Era
**************************************** **************************************** **********************************
**************************************** ******************************** *****************
Original works, from the blog of "Deep Blue". You are welcome to reprint them. Please indicate the source (Http://blog.csdn.net/huangyanlong).
Football and oracle series (1): 32-way zhoudianbing, overall view of group A Brazil smon process of oracle32 process Alliance
Football and oracle series (2)
Football and oracle series (3): oracle process rankings, the World Cup round is about to fight!
Football and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison!
Football and oracle series (5): The directX library missing in the voda14 game is similar to the oracle rpm package!
Football and oracle series (6): Asian Cup with database creation-come on, Chinese Team
**************************************** **************************************** **********************************
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.