Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.