Implement the method of configuring oracle and mysql through weblogic data source
The following is mainly about configuring oracle and mysql methods through weblogic data sources. I hope these contents can bring you practical use. This is also the main purpose of this article that I edit to configure oracle and mysql methods through weblogic data sources. All right, don't talk too much nonsense, let's just read the following.
Install the weblogic data source-oracle
Configuring the data source mainly configures the information in the connection pool:
1. URL: jdbc:oracle:thin:@10.1.102.12:1521:stat
Note: stat database name
2. Driver Class: Name: oracle.jdbc.OracleDriver
3. Properties: user=xin
Install the weblogic data source-MySQL
Configuring the data source mainly configures the information in the connection pool:
1. URL: jdbc:mysql//10.1.80.2:3306/xin?characterEncoding=utf8
Note: xin database name
CharacterEncoding=utf8 is a character set to prevent garbled code.
10.1.80.2 is a virtual IP address
2. Driver Class: Name: com.mysq.jdbcDriver driver type
3. Properties: user=tiantian
Tiantian is the user name
Note: error configuring weblogic data source (mysql database): reject username or password link
This experiment is a testing machine built locally.
Solution:
View the user name and password:
Mysql > select host,user,password from user
+-- +
| | host | user | password | |
+-- +
| | localhost | root | * 41DA2FB717B0761640FBDD9C889C372DC8CB6FAA |
| | 10.1.80.3 | rep | * FE28814B4A8B3309DAC6ED7D3237ADED6DA1E515 |
+-- +
Idea: I open the weblogic console in a 360 browser outside the virtual machine and configure the data source on the console.
If you configure it outside, you must at least have link permissions, so you need to change the host to unlimited, because my local IP address
The localhost in the diagram is local to the virtual machine, not to my book. So you need to change the host to unlimited.
Mysql > select host,user,password from user
+-- +
| | host | user | password | |
+-- +
| |% | root | * 41DA2FB717B0761640FBDD9C889C372DC8CB6FAA |
| |% | rep | * FE28814B4A8B3309DAC6ED7D3237ADED6DA1E515 |
+-- +
Retest the data source and link normally.
Do you find it very helpful to configure the oracle and mysql method through the weblogic data source above? If you need to know more, please continue to follow our industry information. I'm sure you'll like it.
