Configuring the Database Connection
Before you can run the database scripts, you need to configure
the database connection information in the Project Explorer. Configure the
connection for the administrator user who has privileges to your database.
To configure the database connection
-
In the Project Explorer, expand Sun BPM, and then expand Run Database
Scripts.
-
Right-click Run Database Scripts, click Check Out, and then click
Check Out on the dialog box.
-
Right-click Database Scripts and then click Properties.
-
Enter the database configuration information described in Configuring the Database Connection.
-
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 a database administrator. This user must be able to
create users and assign permissions, as well as create and drop tables.
|
Password
|
The password for the administrator user.
|