Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

ConfiDoc Excerpt Anchor Macro
anchorIddb_drivers
DriverConnection string
MySql/
com.mysql.jdbc.Driver
jdbc:mysql://:/?user=&password=

For mySQL driver you will need to enable "generateSimpleParameterMetadata" parameter

 

PostgreSQL/
org.postgresql.Driver
jdbc:postgresql://:/?user=&password=
IBMDB2/
COM.ibm.db2.jdbc.app.DB2Driver
jdbc:db2://:/?user=&password=
MSSQL(MicrosoftDriver)/
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://:;databaseName=?user=&password=
MSSQL(Weblogic)/
weblogic.jdbc.mssqlserver4.Driver
jdbc:weblogic:mssqlserver4:@:
MSSQL(SprintaDriver)/
com.inet.tds.TdsDriver
jdbc:inetdae::?database=?user=&password=
MicrosoftSQLServer(JTurboDriver)/
com.ashna.jturbo.driver.Driver
jdbc:JTurbo://://user=/password=

Microsoft SQL Server/
com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://yourserver.database.windows.net:1433;database=YourDatabase;user=yourusername@yourserver;password=yourpassword;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
Microsoft SQL Server (aternative, newer) / com.microsoft.jdbc.sqlserver.SQLServerDriver 

jdbc:sqlserver://YourServer:Port;databaseName=YourDatabase

More details on https://docs.microsoft.com/en-us/sql/connect/jdbc/using-the-jdbc-driver

OracleThin/
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:/@::
Oracle(OranhoDriver)/
com.inet.pool.PoolDriver
jdbc:inetpool:inetora:?database=&user=&password=&sid=
Sybase(jConnect5.2)/
ncom.sybase.jdbc2.jdbc.SybDriver
jdbc:sybase:Tds::?user=&password=
PointBaseEmbeddedServer/
com.pointbase.jdbc.jdbcUniversalDriver
jdbc:pointbase://embedded:/?user=&password=
Cloudscape/
COM.cloudscape.core.JDBCDriver
jdbc:cloudscape:?user=&password=
CloudscapeRMI/
RmiJdbc.RJDriver
jdbc:rmi://:/jdbc:cloudscape:?user=&password=
Firebird(JCA-JDBCDriver)/
org.firebirdsql.jdbc.FBDriver
jdbc:firebirdsql://:/?user=&password=
IDSServer/
ids.sql.IDSDriver
jdbc:ids://:/conn?dsn=''
InformixDynamicServer/
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://:/:INFORMIXSERVER=
InstantDB/
org.enhydra.instantdb.jdbc.idbDriver
jdbc:idb:
Interbase(InterClientDriver)/
interbase.interclient.Driver
jdbc:interbase:///
HypersonicSQL/
org.hsql.jdbcDriver
jdbc:HypersonicSQL:?user=&password=
 

...