Jive Forums stores all data in a back-end database that you must setup and manage. This document provides setup instructions for all of the currently supported databases.

JDBC 2.0 drivers are required for Jive to communicate with your database. Suggested drivers for particular databases are noted below where applicable. However, the JDBC-ODBC bridge will not work with Jive under any circumstances. For a full list of available JDBC drivers, please see: http://industry.java.sun.com/products/jdbc/drivers

Choose your database from the list below for setup details:

• MySQL
• Oracle 8
• Microsoft SQLServer
• PostgreSQL
• Interbase 6
• IBM DB2
• hsql db (Hypersonic)
• Cloudscape

MySQL

JDBC Drivers

A free JDBC driver for mySQL that has been thoroughly tested with Jive can be found at:

http://mmmysql.sourceforge.net/

You should refer to this page for driver documentation and updates. Please use version 2.0.4 or higher.

In the Jive setup tool, use the following values:

• driver: org.gjt.mm.mysql.Driver
• server: jdbc:mysql://[YOUR_HOST]/[DATABSE_NAME]

where [YOUR_HOST] and [DATABASE_NAME] are the actual values for you server. In many cases localhost is a suitable value for [YOUR_HOST] when your database is running on the same server as your webserver.

Setup Instructions

1. Make sure that you are using MySQL 3.23.2 or later and the MyISAM table type (default).
2. Create a database for the Jive tables:
   mysqladmin create [databaseName]
   (note: "databaseName" can be something like 'Jive')
3. Import the schema file:
   Unix/Linux: cat Jive_mysql.sql | mysql [databaseName];
   Windows: type Jive_mysql.sql | mysql [databaseName];
4. Start the Jive setup tool, and use the appropriate JDBC connection settings.

Further Help

If you need help setting up MySQL, refer to the following sites:

http://www.mysql.com/doc.html
http://www.devshed.com/Server_Side/MySQL

Oracle

JDBC Drivers

For most users, the best drivers for Oracle are the ones written by Oracle (which come with the database or can be downloaded from Oracle's website). You should use the "thin" drivers that are in the the classes12.zip file.

In the Jive setup tool, use the following values:

• driver: oracle.jdbc.driver.OracleDriver
• server: jdbc:oracle:thin:@[YOUR_HOST]:1521:[DATABSE_NAME]

where [YOUR_HOST] and [DATABASE_NAME] are the actual values for you server. In many cases localhost is a suitable value for [YOUR_HOST] when your database is running on the same server as your webserver.

Setup Instructions

First, create a "Jive" user or some other user that will "own" the Jive tables. This isn't necessary, but doing so will allow your tables to exist in a seperate tablespace.

Next import the schema using sqlplus (or your favorite Oracle tool such as Toad). For sqlplus: copy the "Jive_oracle_8.sql" file to the same directory where sqlplus is installed (should be something like /Oracle/Ora81/bin/). Next, log into sqlplus and then execute the command:
@ Jive_oracle_8
That will import the schema file. Your database is now setup.

SQL Server

JDBC Drivers

Unfortunately, no freely available driver for SQL Server is high-quality enough to work with Jive. Specifically, the "Free-TDS" driver on freetds.org will not currently work. Many users turn to the JDBC-ODBC bridge instead; however, that will not work either as noted above. Do not bother to even try either driver!

Instead, use one of the many commercial drivers for SQLServer that are listed on the Sun site. Connection settings in the Jive setup tool for specific drivers are as follows:

Merant DataDirect
• driver -- com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
• server -- jdbc:sqlserver://[HOST_NAME]:[PORT_NUMBER]

where [HOST_NAME] is the host name or IP address of your database server, and [PORT_NUMBER] is the port that SQLServer is listening on (normally 1433). Please use the Merant drivers version 2.1 or greater. JRun 3.x ships with the 2.0 version of the Merant drivers, so if you would like to use the built-in JRun database drivers, please contact Jive Software for an update that has been made available by Allaire.

I-net Opta

• driver -- com.inet.tds.TdsDriver
• server -- jdbc:inetdae7:[HOST_NAME]:[PORT_NUMBER]

where [HOST_NAME] is the host name or IP address of your database server, and [PORT_NUMBER] is the port that SQLServer is listening on (normally 1433). You must use version 4.13 or higher.

Setup Instructions

1. Create a new database using Enterprise Manager if you do not already have a database you want to use. You may wish to name the database "jive".
2. Create a user to access the database if you do not already have one you'd like to use. Consider making the default database for the user be the one you created in step 1.
3. Open the Query Analyser and connect to the server.
4. Select the database you want to use for Jive from the DB drop down (the one you created in step 1 if you're using a new database).
5. Open the [jive]/database/Jive_sqlserver_7.sql file.
6. Press F5 to run the script. The script will run and create the necessary tables.
7. Proceed to the Jive setup tool and use the appropriate JDBC settings when prompted. PostgreSQL
   JDBC Drivers

   JDBC Drivers for PostgreSQL can be found in various distribution packages at PostgreSQL's Home Page. This installation in particular refers to "jdbc7.0-1.2.jar" driver for accessing PostgreSQL 7.0.3. Refer to the JDBC documentation at that site for more information. A couple of notes, however:

   • The correct driver name to use when running Jive's admin setup is "org.postgresql.Driver. The documentation is apparently a little out of date and omits the "org".
   • The JDBC URL format, including host and port, is: "jdbc:postgresql://host:port/dbname". The documentation omits the ":" between the host and port.

   Setup Instructions

   1. Create the database. For example, using the PostgreSQL "createdb" utility:
      createdb jive
   2. Import the schema. Use psql (or your favorite Postgres sql utility) to import the Jive database schema:
      psql -d jive -f Jive_postgres.sql
   3. Proceed to Jive setup and use the appropriate JDBC settings when prompted.

   Interbase 6.0

   JDBC Drivers

   JDBC drivers and other files for Interbase can be downloaded at http://www.borland.com/devsupport/interbase/opensource/. The JDBC JAR file is called interclient.jar, and should be put in the classpath of your application server.

   Values for the admin tool are:

   • driver: interbase.interclient.Driver
   • server: jdbc:interbase://host/fullpath

   Setup Instructions

   1. Create a new database by connecting to your Interbase server with IBConsole then use the Database/Create Database menu option.
   2. Execute the Jive SQL script using Interactive SQL. This can be started from the Tools/Interactive SQL menu. Within Interactive SQL load the Jive_interbase_6.sql script (Query/Load Script) and execute it (Query/Execute). The database will now have been constructed.

   Notes: It would probably be a good idea to create a new user for Jive or at least to change the password.

   To use JDBC with interbase you have to have install the Interbase InterServer which enables the InterClient JDBC driver to access the database.

   IBM DB2 7

   JDBC Drivers

   Use the JDBC 1.2 compliant driver, db2java.zip (1293KB), located in the "%DB2PATH%\java2" directory.

   Values for the admin tool are:

   • driver: COM.ibm.db2.jdbc.app.DB2Driver
   • server: jdbc:db2:[DB NAME, e.g. JIVE]

   Setup Instructions

   You have to create a new database (e.g. JIVE) or use an existing one. Connect to the database using any valid username allowed to create tables and indexes. Keep in mind that DB2 UDB applies the user name as the table schema. Use the same user when you configure Jive with the administration interface. Commands are as follows:

   DB2 CREATE DB JIVE ALIAS JIVE
DB2 CONNECT TO JIVE USER [DBUSER] USING [DBPASSWORD]
   (or you can use the Command Center GUI)

   Start the DB2 command window (in Windows), or the user's shell in Unix and import the schema with:

   db2 -tvf Jive_db2_7.sql

   Or, use the DB2 Command Center and run the script through the "Replication Sources" folder in the Database tree.

   The database is now setup.

   HSQL 1.6.1 (Hypersonic)

   JDBC Drivers

   Values for the admin tool are:

   • driver: org.hsqldb.jdbcDriver
   • server: jdbc:hsqldb:[PATH_TO_DB_FILES/DB_NAME]

   For example, the server URL might be jdbc:hsqldb:../database/defaultdb

   Setup Instructions

   Create a database for the Jive Tables:

   1. Run the HSQL Database Manager by navigating to the folder where hsqldb.jar is located and type the following
      java -cp hsqldb.jar org.hsqldb.util.DatabaseManager
      then hit enter. You will now see a GUI application.
   2. When prompted with the connect window, enter org.hsqldb.jdbcDriver as the Driver, and specify the URL of your database in the URL field. The default password is already entered.
   3. Now copy and paste the contents of Jive_hsql.sql into the command window, and hit execute. If no errors are reported, then your database is setup properly.
   4. Finally, you should change the username and password login for your database: just open the .script file in your database folder and change the appropriate values. Make sure that you don't use a blank password, as the Jive setup tool will not accept one.

   Cloudscape 3.6.4

   Note: The following procedure will use the embedded version of Cloudscape, but a similar process can be used to setup the client/server version. The downloaded zip file supports both embedded and client/server modes.

   Setup Instructions

   Cloudscape and the JDBC drivers can be downloaded at http://www.cloudscape.com/products/fdkreg.jsp, the zip file is cloudscape364.zip. After downloading, unzip the file into \cloudscape directory and add the following JARs to the CLASSPATH of your system and your application server, or put them in the WEB-INF/lib directory created for the Jive web application.

   For Windows:

   	md \cloudscape
   	cd \cloudscape
   	jar xvf cloudscape364.zip
   	set CLASSPATH=%CLASSPATH%;\cloudscape\lib\cloudscape.jar;\cloudscape\lib\tools.jar
   

   1. Change into your Cloudscape directory, i.e. cd \cloudscape
   2. Copy in the file jive_cloudscape_364.sql.
   3. Using the Cloudscape Interactive JDBC scripting tool (ij), create the database:

      	java COM.cloudscape.tools.ij
      	ij version 3.6 (c) 1997-2001 Informix Software, Inc.
      	ij> connect 'jdbc:cloudscape:jiveDB;create=true';
      	ij> run 'jive_cloudscape_364.sql';
      	ij> select * from jiveuser;
      	ij> exit;
      

   JDBC Drivers

   Values for the admin tool are:

   • driver: COM.cloudscape.JDBCDriver
   • server: jdbc:cloudscape:/cloudscape/jiveDB
   • username: APP
   • password: APP