JDBC Driver Connection Strings for Java RESTful Engine

note

This is a guide to structuring your connection strings for SQLServer, MySQL, Oracle and DB2 databases, along with an example request bodies for each. If you don't know how to construct a request body, please refer to the template section of our swagger documentation.

SQL Server#

In the request body, you want to have:

Type = ado
ClassName = com.microsoft.sqlserver.jdbc.SQLServerDriver The connection string should look like:

jdbc:sqlserver://{server_address};databaseName={database_name};username={username};password={password};

Here is an example request body:

<Template>
    <ConnectionString>{template_connection_string}</ConnectionString>
    <OutputFormat>pdf</OutputFormat>
     <Datasources>
        <Datasource>
                <Name>{db_name}</Name>
                <Type>ado</Type>
                <ClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</ClassName>
                <ConnectionString>jdbc:sqlserver://{server_address};databaseName={database_name};username={username};password={password};</ConnectionString>
        </Datasource>
    </Datasources>
</Template>

MySQL#

In the request body, you want to have:

Type = ado
ClassName = com.mysql.cj.jdbc.Driver The connection string should look like:

jdbc:mysql://{server_address}/{server_name};username={username};password={password};

Here is an example request body:

<Template>
    <ConnectionString>{template_connection_string}</ConnectionString>
    <OutputFormat>pdf</OutputFormat>
    <Datasources>
        <Datasource>
            <Type>ado</Type>
            <Name>MYSQL</Name>
            <ClassName>com.mysql.cj.jdbc.Driver</ClassName>
            <ConnectionString>jdbc:mysql://{server_address}/{server_name};username={username};password={password};</ConnectionString>
        </Datasource>
    </Datasources>
</Template>

Oracle#

In the request body, you want to have:

Type = ado
ClassName = oracle.jdbc.OracleDriver The connection string should look like:

jdbc:oracle:thin:@//{server_address};username={username};password={password};

Here is an example request body:

<Template>
    <ConnectionString>{template_connection_string}</ConnectionString>
    <OutputFormat>pdf</OutputFormat>
     <Datasources>
        <Datasource>
                <Name>{db_name}</Name>
                <Type>ado</Type>
                <ClassName>oracle.jdbc.OracleDriver</ClassName>
                <ConnectionString>jdbc:oracle:thin:@//{server_address};username={username};password={password};</ConnectionString>
        </Datasource>
    </Datasources>
</Template>

DB2#

In the request body, you want to have:

Type = ado
ClassName = com.ibm.db2.jcc.DB2Driver The connection string should look like:

jdbc:db2://{server_address}/{server_name};username={username};password={password};

Here is an example request body:

<Template>
    <ConnectionString>{template_connection_string}</ConnectionString>
    <OutputFormat>pdf</OutputFormat>
    <Datasources>
        <Datasource>
            <Type>ado</Type>
            <ClassName>com.ibm.db2.jcc.DB2Driver</ClassName>
            <ConnectionString>jdbc:db2://{server_address}/{server_name};username={username};password={password};</ConnectionString>
        </Datasource>
    </Datasources>
</Template>