Configuring Database Connection Information
In order to connect with the database to
run the scripts, you need to specify the database connection information for
the scripts.
To configure database connection information
-
Right-click the Database Scripts folder under the Business Process,
and then click Properties.
-
Enter the properties.
-
Click OK.
Property
|
Description
|
Database Type
|
The database vendor and version you are using.
|
JDBC URL
|
The URL to connect with the database. Enter one of the following:
-
For Oracle: jdbc:SeeBeyond:oracle://<host>:<port>;SID=<SID>
-
For Sybase: jdbc:SeeBeyond:sybase://<host>:<port>
-
For SQL Server: jdbc:SeeBeyond:sqlserver://<host>:<port>;DatabaseName=
<dbname>
-
For DB2: jdbc:SeeBeyond:db2://<host>:<port>;DatabaseName=<SID>;collectionId=JDBCPKG;packageName=JDBCPKG;embedded=true;createDefaultPackage=FALSE
where <host> is the machine on which the database resides,
<port> is the port number on which the database is listening, and <SID>
and <dbname> are the name of the database.
|
User
|
The login ID of the user created by the monitoring and recovery database
scripts. You can find the user name in the scripts in the Project Explorer
under CAPS Components Library > Sun Business Process
Manager > Run Database Scripts > Database Scripts.
|
Password
|
The password for the user created by the monitoring and recovery database
scripts.
|