Page tree

Versions Compared

Key

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

...

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.

Info

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 (smile)

DatabaseDriver classConnection URL
   
   

...

Also, check the Atlassian website with helpful hints on troublshooting your database connections: https://confluence.atlassian.com/doc/troubleshooting-external-database-connections-9906.html


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;

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=

...