Below we have compiled a table with list of databases and JDBC drivers and driver classes
When you configure ConfiDoc with databases as sources you need to specify a driver class and connection URL. These are, very often, quite difficult to find in the first place.
More about step-by-step configuration of Database datasource for ConfiDoc take a look here: Using ConfiDoc to connect to Database
We have made it easier for you
Also, check the Atlassian website with helpful hints on troublshooting your database connections: https://confluence.atlassian.com/doc/troubleshooting-external-database-connections-9906.html
Driver | Connection string |
---|---|
MySql/ com.mysql.jdbc.Driver | jdbc:mysql://:/?user=&password= For mySQL driver you will need to enable "generateSimpleParameterMetadata" parameter jdbc:mysql://localhost:3306/mydb?generateSimpleParameterMetadata=true |
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/ | jdbc:sqlserver://yourserver.database.windows.net:1433;database=YourDatabase;user=yourusername@yourserver;password=yourpassword;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30; https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017 |
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 https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017 |
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= |