Administering the Sun Business Process Manager Database

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.

ProcedureTo configure the database connection

  1. In the Project Explorer, expand Sun BPM, and then expand Run Database Scripts.

  2. Right-click Run Database Scripts, click Check Out, and then click Check Out on the dialog box.

  3. Right-click Database Scripts and then click Properties.

  4. Enter the database configuration information described in Configuring the Database Connection.

  5. 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.