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

Dameng 7JDBC driver is divided into Dm7JdbcDriver14, Dm7JdbcDriver15, Dm7JdbcDriver16, sub-

Do not correspond to Jdk1.4, Jdk1.5, Jdk1.6

Dameng 7 provides dialect packs of different hibernate and jdk versions. Users can choose the corresponding dialect packs according to the development environment.

Version, the related dialect package driver is located in the dialect directory

Hibernate.cfg.xml configuration requirements:

Driver name

Dm.jdbc.driver.DmDriver

Dialect package name

Org.hibernate.dialect.DmDialect

1. Configure JDBC driver

Copy DmJdbcDriver.jar (located in the jdbc directory of the Damon database installation directory)

To the / u01/Middleware/wlserver_10.3/server/lib directory

PS: whether you copy 14,15,16 jdbcdriver files, you need to rename them to lib.

DmJdbcDriver.jar

Modify the jdbcdriver.xml file and copy the following code into it.

two。 You need to modify the startup script under the weblogic installation directory

The entry path is: / u01/Middleware/wlserver_10.3/common/bin

Modify file: commEnv.sh startManagedWebLogic.sh

WEBLOGIC_CLASSPATH=

CLASSPATH=

Add to these two parameters

${CLASSPATHSEP} ${WL_HOME} / server/lib/DmJdbcDriver.jar

3. Start the weblogic server to configure the Dameng data source

Start the weblogic service with a path similar to the following:

/ root/Oracle/Middleware/user_projects/domains/dmdb_domain/startWebLogic.sh

Select Dameng for database type

Database driver chooses something else

Click next

Click next

Click next

Driver class name: (be sure to modify the connection string of URL)

Dm.jdbc.driver.DmDriver

URL:jdbc:dm://10.51.102.10:5236?ignoreCase=true

& user=FMIS9999&password=FMIS9999

If the URL above does not work, change the & to &

Click the test configuration prompt that the connection test was successful

Click next

Click finish

Click the activation change prompt to complete the configuration after success.

Note:

1. The user name and password must be passed as parameters. Otherwise, an incorrect password will be prompted when it is created.

two。 Parameters are connected using & match, but in web pages & belong to special symbols and sometimes parameters

An error in the connection string prevented the data source from being created. So it's safest to use it directly.

3. In the case of oracle in the original application, it is generally configured to be case-sensitive when it reaches the dream database. Like this

The parameter ignoreCase=true, which is sensitive to the size of the source information, needs to be added to the parameter, otherwise it will be accessed by the application.

An error such as an invalid table name or column name occurred.

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.