Jbuilder9 + weblogic7 tools (JDBC 2)

Jbuilder9 + weblogic7 practice

Tools (configure JDBC 2)

Author:Huang Kai

E_mail:Hk_sz@163.com

Configure JDBC 2 in weblogic7

3.2 use the jdatastore Database

Jdatastore is a high-performance, small-scale, pure Java database provided by JBuilder. The jdatastore database file extension is JDS. In the C:/jbuilder9/samples/jdatastore/datastores (My jbuilder9 is installed on disk C) directory, you can find the jdatastore database file that comes with JBuilder, for example, employee. JDS.

To use it in WebLogic, first in the startup file C:/BEA/weblogic700/Server/bin/startwls of WebLogic Server (My Weblogic is installed on drive C. add the jdatastore driver C:/jbuilder9/lib/jdsremote to the CMD file. jar, so Add the following in the classpath statement:

Set classpath = % java_home %/lib/tools. jar; % wl_home %/Server/lib/weblogic_sp.jar; % wl_home %/Server/lib/weblogic. jar;C:/jbuilder9/lib/jdsremote. Jar; % Classpath %

3.2.1 start jdatastore Server

3.2.1.1 start jbuilder9

Start JBuilder:Start/Program/Borland JBuilder 9 Enterprise trial/Borland JBuilder 9 Enterprise trial;

3.2.1.2 clickTools/JdataSTore Server

3.2.2 start WebLogic Server

ClickStart/Program/BEA Weblogic Platform 7.0/user projects/testdomain/start server(For the establishment of testdomain, refer to the article jbuilder9 + weblogic7 practical tools (WebLogic );

3.2.3 start IE and enter it in the address barHttp: // localhost: 7001/console, Press Enter. the WebLogic Server logon page is displayed. EnterUsername:AndPassword:Here, I use training. Please remember, because this user name and password will be used in the future. ClickSign inEnter;

3.2.4 clickConnection pools;

3.2.5 clickConfigure a new JDBC connection poolCreate a connection pool and set it in the General tab of the Connection Pool:

Name:Jdatastorepool

URL:JDBC: BORLAND: dsremote: // localhost/C:/jbuilder9/samples/jdatastore/datastores/employee. JDS

Driver classname:Com. Borland. datastore. JDBC. datastoredriver

Properties:User = example

Password = example

ClickCreateCreate;

 

InConnectionsTab to make the following settings:

Initial capacity:5

Maximum capacity:10

ClickApplyApplication;

 

InTestingSet "employee" as the test table on the tab:

Test Table Name:Employee

Click Apply;

 

SetTargetsTab

SetTargets-ServerThat is, set the target server of the connection pool. From leftAvailableSelect a server from the list and select it toChosenList. ClickApplyApplication.

3.2.6 configure the data source mydatasource

ClickJDBC/Data SourceItem, clickConfigure a new JDBC data source...;

 

SetConfigurationTab

Name:Mydatasource

JNDI Name:Mydatasource

Pool Name:Jdatastorepool

ClickApplyApplication;

 

SetTargetsTab

SetTargets-ServerThat is, set the target server of the connection pool. From leftAvailableSelect a server from the list and select it toChosenList. ClickApplyApplication.

3.2.7 check whether the configuration is successful

Restart Weblogic server. If no error is reported, the above configuration is correct. Start jdatastore server. On the monitoring page, you can see five connections to employee. JDS. These five connections are established by the WebLogic Server connection pool (the initial capacity is set to 5 ).

 

Iv. Description

This document is adapted from JDBC in Chapter 4th of J2EE Application Development (WebLogic + JBuilder) by the Electronic Industry Publishing House. It is integrated with the online materials I have found and other materials. My jbuilder9 and weblogic7 are both installed on the C drive. The above parameters must be modified based on the actual configuration of your machine. Otherwise, the Operation will fail.

 

My article was first published on the Niuer Forum (www.newer.com.cn/bbs) and the programmer Forum (www.csdn.net). You are welcome to repost it. However, please keep the author and author's name. Thank you.