Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 1 Preparing Databases and Web Containers for Deployment : Preparing a Database for Deployment

Preparing a Database for Deployment
After installing TIBCO ActiveMatrix Runtime UDDI Server, you must install one of the databases listed in Database.
To conveniently explain the TIBCO ActiveMatrix Runtime UDDI Server features, this manual will use uddi as the sample database name, and myuddiuser and myuddisecret as the sample user account.
MYSQL
After installing the MySQL database server on your computer, complete the following preparatory steps:
For detailed information about working with MySQL, refer to MySQL Reference Manual.
Create a Database
To create a MySQL database, run the command below.
mysql> CREATE DATABASE uddi;
Create a User Account and Assign Roles for the Newly Created Account
After a MySQL database is created, you need to create a new user account to connect to the database. In addition, you also need to assign roles for the newly created user account.
The newly created user account must have at least the following privileges in the database.
While configuring the uddi.war file, if you choose to automatically create the database tables or you need to update the database schema during the deployment, append the following privileges to the newly created user account:
Download a Supported JDBC Driver
You may need to download a JDBC driver for your database. At the time of this writing, the JDBC driver mysql-connector-java-5.1.7-bin.jar for the supported MySQL versions is available from the following link: http://dev.mysql.com/downloads/connector/j/5.1.html
Microsoft SQL Server
After installing a Microsoft SQL Server database on your computer, complete the following preparatory steps:
For detailed information about working with Microsoft SQL Server, refer to Server Products and Technologies for SQL Server.
While working with Microsoft SQL Server, you must create a database with case-insensitive collation and create or alter tables with case-sensitive collation.
Create a Database
To create a Microsoft SQL Server database, follow these steps:
1.
2.
3.
Right-click the Databases node and select New Database... from the pop-up menu to open the New Database window.
4.
Enter uddi in the Database name field.
5.
Click the OK button.
Create a User Account
After creating a Microsoft SQL Server database, you must create a new user account to connect to the database.
1.
2.
3.
Right-click the Logins node and select New Login... from the pop-up menu.
4.
a.
Enter myuddiuser in the Login name field.
b.
Select the SQL Server authentication radio button and enter myuddisecret as the password.
c.
Uncheck the Enforce password policy checkbox.
d.
Select the uddi database from the Default database drop-down list.
5.
Click the OK button.
Assign Roles or Privileges for the Newly Created Account
After the database is created, the newly created user account that will be configured in the JNDI resource must have at least the following privileges in the database.
While configuring the uddi.war file, if you choose to automatically create the database tables during the deployment, add the following privileges to the newly created user account:
Download a Supported JDBC Driver
You may need to download a JDBC driver for your database. At the time of this writing, the JDBC driver sqljdbc4.jar for the supported SQL Server versions is available from the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en
Oracle Database
After installing Oracle on your computer, complete the following preparatory steps.
Create a uddi database.
Create a user account, for example, myuddiuser and myuddisecret.
For detailed information about working with Oracle, refer to Server Oracle Database Administrator’s Guide.
Assign Roles or Privileges for the Newly Created Account
After the database is created, the newly created user account that will be configured in the JNDI resource must have at least the following privileges in the database.
While configuring the uddi.war file, if you choose to automatically create the database tables or you need to update the database schema during the deployment, append the following privileges to the newly created user account:
Download a Supported JDBC Driver
You may need to download a JDBC driver for your database. At the time of this writing, the JDBC driver ojdbc5.jar or ojdbc6.jar for the supported Oracle versions is available from the following link:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html
Sybase Database
After installing Sybase on your computer, complete the following preparatory steps.
Create a uddi database.
Create a user account. For example, myuddiuser and myuddisecret.
For detailed information about working with Sybase, refer to Sybase Adaptive Server Enterprise (Archive) .
Assign Roles or Privileges for the Newly Created Account
After the database is created, the newly created user account that will be configured in the JNDI resource must have at least the following privileges in the database.
While configuring the uddi.war file, if you choose to automatically create the database tables or you need to update the database schema during the deployment, append the following privileges to the newly created user account:
Download a Supported JDBC Driver
You may need to download a JDBC driver for your database. At the time of this writing, the JDBC driver (version 6.0.5) jconn3.jar for Sybase ASE 15.0 is available from the following link:
http://downloads.sybase.com/swd/summary.do?client=support&baseprod=63
IBM DB2
After installing IBM DB2 on your computer, complete the following preparatory steps.
Create a uddi database.
Create a user account. For example, myuddiuser and myuddisecret.
When you create a DB2 database, the Pagesize parameter must be set to at least 8k to contain large amounts of data, such as the data with the long string type.
For detailed information about working with IBM DB2, refer to IBM DB2 Information Center .
Assign Roles or Privileges for the Newly Created Account
After the database is created, the newly created user account that will be configured in the JNDI resource must have at least the following privileges in the database.
While configuring the uddi.war file, if you choose to automatically create the database tables or you need to update the database schema during the deployment, append the following privileges to the newly created user account:
Download Supported JDBC Drivers
You may need to download JDBC drivers for your database. At the time of this writing, the JDBC driver db2jcc.jar and the license JAR file db2jcc_license_c.jar for the supported IBM DB2 versions is available from the following link:
http://www.ibm.com/products/finder/us/finders?pg=ddfinder&cm_re=other-_-suprcn-_-download
HSQLDB
After installing HSQLDB on your computer, complete the following preparatory steps:
Create a uddi database.
Create a user account. For example, myuddiuser and myuddisecret.
For detailed information about working with HSQLDB, refer to HSQLDB User Guide.
Download a Supported JDBC Driver
You may need to download JDBC drivers for your database. At the time of this writing, the JDBC driver hsqldb.jar for HSQLDB 1.8 is available from the following link:
http://www.hsqldb.org

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved