JDBC

The BLUE JDBC driver lets you connect to BLUE using many Java applications and tools.

Before You Begin

• The BLUE JDBC driver requires Java 1.8 or newer

• Download the BLUE JDBC driver here

• We recommend using Oracle Java or OpenJDK

Connection String

JDBC drivers rely on a connection string.

URL Template:

jdbc:Sqream://{host}:{port}/{database};accessToken=<YourToken>;[<optional parameters>; ...]

JDBC driver class name:

com.sqream.jdbc.BlueDriver

Connection Parameters

The following table shows the connection string parameters:

Item	State	Default	Description
host:port	Mandatory	None	FQDN and port of the Blue cluster. For example, blue-cluster.isqream.com:443
database	Mandatory	None	Database name to connect to. For example, master
accessToken	Mandatory	None	A BLUE client access token
fetchSize	Optional	true	Enables on-demand loading, and defines double buffer size for the result. The fetchSize parameter is rounded according to chunk size. For example, fetchSize=1 loads one row and is rounded to one chunk. If the fetchSize is 100,600, a chunk size of 100,000 loads, and is rounded to, two chunks
insertBuffer	Optional	true	Defines the bytes size for inserting a buffer before flushing data to the server. Clients running a parameterized insert (network insert) can define the amount of data to collect before flushing the buffer
loggerLevel	Optional	true	Defines the logger level as either debug or trace
logFile	Optional	true	Enables the file appender and defines the file name. The file name can be set as either the file name or the file path

Sample Java Program

You can download the JDBC Application Sample File

JDBC Application Sample

import java.sql.Connection;  
import java.sql.DatabaseMetaData;  
import java.sql.DriverManager;  
import java.sql.Statement;  
import java.sql.ResultSet;  

import java.io.IOException;  
import java.security.KeyManagementException;  
import java.security.NoSuchAlgorithmException;  
import java.sql.SQLException;  



public  class  SampleTest  {  

    // Replace with your connection string
    static  final  String  url  =  "jdbc:Sqream://blue_cluster:443/master;accessToken=######################";  

    // Allocate objects for result set and metadata
    Connection  conn    =  null;  
    Statement  stmt  =  null;  
    ResultSet  rs  =  null;  
    DatabaseMetaData  dbmeta  =  null;  

    int  res  =  0;  

    public  void  testJDBC()  throws  SQLException,  IOException  {  

        // Create a connection
        conn  =  DriverManager.getConnection(url);  

        // Create a table with a single integer column
        String sql  =  "CREATE TABLE test (x INT)";
        stmt = conn.createStatement();  // Prepare the statement
        stmt.execute(sql); // Execute the statement
        stmt.close(); // Close the statement handle

        // Insert some values into the newly created table
        sql = "INSERT INTO test VALUES (5),(6)";
        stmt = conn.createStatement();
        stmt.execute(sql);
        stmt.close();

        // Get values from the table
        sql = "SELECT * FROM test";
        stmt = conn.createStatement();
        rs  = stmt.executeQuery(sql);
        // Fetch all results one-by-one
        while(rs.next()) {
            res = rs.getInt(1);
            System.out.println(res); // Print results to screen
        }
        rs.close(); // Close the result set
        stmt.close(); // Close the statement handle
    }


    public  static  void  main(String[]  args)  throws  SQLException,  KeyManagementException,  NoSuchAlgorithmException,  IOException,  ClassNotFoundException{  

        // Load Blue JDBC driver
        Class.forName("com.sqream.jdbc.BlueDriver");  

        // Create test object and run
        SampleTest  test  =  new  SampleTest();  
        test.testJDBC();  
    }  
}