Databases Drivers and URLs

New Fire Server supports JDBC connection to major databases. The following databases are certified with JDBC 2.0 drivers.

Database Servers	Vendor	Database Driver	Database URL
Oracle 9.2.0.1*, 10.2.0.1	Oracle Corporation	oracle.jdbc.driver.OracleDriver ojdbc14.jar - Oracle JDBC Driver for 10.2.0.1. Do not use 9.2.0.1 driver. It has incomplete implementation.	jdbc:oracle:thin:@localhost:1521:databasename localhost: change to host name if different databasename: the name of Oracle database instance
Oracle 9.2.0.1*, 10.2.0.1	Oracle Corporation	oracle.jdbc.OracleDriver ojdbc14.jar - Oracle JDBC Driver for 10.2.0.1 Oracle JDBC/OCI is required. Oracle OCI may be required to run on the same host as New Fire Server.	jdbc:oracle:oci:@databasename databasename: the name of Oracle database instance
Oracle7*, 8	Oracle Corporation	oracle.jdbc.driver.OracleDriver Oracle 8.1.7 JDBC 2.0 Oracle 9.2.0.1 JDBC 3 Driver Limitation: This driver only allow up to 4000 characters for Text data type.	jdbc:oracle:thin:@localhost:1521:databasename localhost: change to host name if different databasename: the name of Oracle database instance
Microsoft SQL Server 6.5, 7, 2000	i-net Software	com.inet.tds.TdsDriver Sprinta2000 5.03	jdbc:inetdae:localhost:1433 localhost: change to host name if different
Microsoft SQL Server 2000*	www.microsoft.com	com.microsoft.jdbc.sqlserver.SQLServerDriver Version 2.2 After installation, go to C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib. Unzip jar files into newfire/classes directory such that newfire\classes\com\microsoft\* are created. May cause SQL Server to have memory leak, restart SQL Server after data migration!	jdbc:microsoft:sqlserver://localhost:1433 localhost: change to host name if different
Microsoft SQL Server 2000*	New Atlanta	JTurbo 2.0, see its download package for instruction.	Do not use sql70=ture flag in URL.
Microsoft SQL Server 2000*	JDBC-ODBC Bridge Driver provided by Sun (This driver is already included in New Fire Server)	sun.jdbc.odbc.JdbcOdbcDriver Warning: Use this driver for testing and evaluation only. We do not suppot this driver. Problem arises after adding new attributes which alter the underlying table columns.	jdbc:odbc:databasename databasename is the data source name of the ODBC. see Set up ODBC Data Source to configure your ODBC parameters.
Microsoft SQL Server 2000*	ThinWeb	com.thinweb.tds.Driver TWFreeTDS 1.3, see package for instruction. Warning: Use this driver for testing and evaluation only. We do not suppot this driver.	jdbc:twtds:sqlserver://localhost/databasename localhost: change to host name if different For example: jdbc:twtds:sqlserver://localhost/northwind
Sybase Adaptive Server Enterprise, Sybase Adaptive Server Anywhere*	Sybase, Inc	com.sybase.jdbc2.jdbc.SybDriver JConnect 5.2 for JDBC 2.x	jdbc:sybase:Tds:localhost:2638 localhost: change to host name if different
Informix Dynamic Server*	Informix Corporation	com.informix.jdbc.IfxDriver Informix JDBC Driver 2.1	jdbc:informix-sqli://localhost:port/databasename:informixserver=servername localhost: change to host name if different port is the port number you specified when you create the database server. servername is the database server name.
IBM DB2 (for Windows NT*)	IBM	COM.ibm.db2.jdbc.app.DB2Driver DB2 JDBC Driver 2.0	jdbc:db2:databasename
MySQL 4.1.7* (on Windows), 5.0.27* (on Linux)	MySQL AB	com.mysql.jdbc.Driver MySQL Connector/J 2.0.16 MySQL Connector/J 5.0.4	jdbc:mysql://localhost/databasename?`characterEncoding=utf8` localhost: change to host name if different `characterEncoding=utf8` is required to use unicode. See Setting Up MySQL
QED 3.4*	Quadcap Software	com.quadcap.jdbc.JdbcDriver Copy antlr.jar and qed.jar to lib/jdbc.jar and lib/jdbc.zip. QED is not a high performance database. It is an embeded database which may have limitation on how it can be access from other query tools. You do not need to startup the database. It is started up within New Fire. QED is still under testing, use with caution.	jdbc:qed:../data/QED.database;create=true;isCaseSensitive=false database file reside at data/QED.database No Database Username and Password required
PostgreSQL 7.4.2* (on Linux); 8.2.3* (on Windows)	PostgreSQL	org.postgresql.Driver 7.4.2 8.2-504 JDBC 3	jdbc:postgresql://localhost:5432/databasename localhost: change to host name if different See Setting Up PostgreSQL

* The database on which we tested.

You can obtain these drivers from their vendors or you may also use other JDBC driver and database server combinations if available.

Database Username and Password

This user must have CREATE TABLE, DROP TABLE, ALTER TABLE privilege.

Database	Notes
Oracle	SQL to create a user: create user <username> identified by <password>; grant connect, resource to <username>;
Sybase	Create a user which is allowed to connect has resource (can create databae objects) authorities
Microsoft SQL Server	User must have access to its default database with public and db_owner database roles. On SQL Server 2000, you must use SQL Server authentication and not windows authentication. This option is set during SQL Server installation. We had difficulty changing this option from SQL Server Properties/Security after the installation.

Database Connection

Database can be installed on the same host which you install New Fire software. It can also be installed on a separate host in the network.

Database	Note
Oracle	Oracle TNS listener must be started
Sybase	Sybase database must be started as Network Database Server if the database is installed on a separate host/machine. To make JDBC connection successful, you must install jConnect Meta-data Support during or after database creation.

Set Up ODBC Data Source

Database	Configuration Notes
Microsoft SQL Server 2000	Check: SQL Server authentication using a login ID and password entered by user. Uncheck: Use ANSI nulls, paddings and warning. (If you have this checked during migration, you may not be able to log on to the system again once the server is restarted. To fix this, you must remove all N_* tables from the database and restore the data directory, and redo upgrade again.)