Altair® Panopticon

 

Common Databases and their JNDI Configurations

Database

Description

Oracle 11

Using ojdbc6.jar

·         driverClassName="oracle.jdbc.OracleDriver"

·         url="jdbc:oracle:thin:@[HostName]:1521:[DatabaseName]"/>

MS SQL Server

Using sqljdbc4.jar

·         driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

·         url="jdbc:sqlserver://[Server]\[Instance];databaseName=[DatabaseName]"/>

Sybase ASE

Using jconn4.jar

·         driverClassName="com.sybase.jdbc4.jdbc.SybDriver"

·         url="jdbc:sybase:Tds:[HostName]:5000/[DatabaseName]"

PostgreSQL

Using postgresql-9.4.1208.jar

·         driverClassName="org.postgresql.Driver"

·         url="jdbc:postgresql://[HostName]:5432/[DatabaseName]"

MySQL

Using mysql-connector-java-5.1.38-bin.jar

·         driverClassName="com.mysql.jdbc.Driver"

·         url="jdbc:mysql://[HostName]:3306/[DatabaseName]"/>