API Support

The e6data JDBC driver is a JDBC type 4 driver designed to support the core functionality of e6data in alignment with version 1.0 of the e6data API. While you are welcome to explore methods from later versions of the API, please note that e6data does not guarantee the support of these methods.

The e6data JDBC driver necessitates Java LTS (Long-Term Support) versions 1.8 or higher. It relies on the java.sql package, which is included in both the Standard Edition (SE) and the Enterprise Edition (EE) of Java. As of August 2019, the documentation for the java.sql package is available at java.sql package documentation.

The e6data JDBC driver can seamlessly integrate with most client tools and applications that support JDBC, facilitating connections to the e6data server.

This documentation does not encompass the entire e6data API. Instead, it serves to enumerate the supported interfaces from the e6data API and the methods supported within each interface.

In general, if a method is called and encounters an issue, the method will raise an exception (e.g., SQLException).

The supported e6data interfaces are listed alphabetically and paired with their corresponding e6data extension classes, where applicable.

Objects

• Connection

• Database MetaData

• ResultSet

• ResultSet MetaData

Object: Connection

A Connection object represents a connection to a database server. The connection object allows users not only to connect to a particular database server, but also create Statement objects, which can be used to execute SQL statements.

• PreparedStatement prepareStatement(String sql)

• void close()

• boolean isClosed()

• DatabaseMetaData getMetaData()

• String getCatalog()

• Statement createStatement(int resultSetType, int resultSetConcurrency)

• PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency)

• Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)

• PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

• PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)

• PreparedStatement prepareStatement(String sql, int columnIndexes[])

• PreparedStatement prepareStatement(String sql, String columnNames[])

• String getSchema()

• void abort(Executor executor)

Object: DatabaseMetaData

The DatabaseMetaData class provides information about the features that the database server (in this case, e6data) supports.

• String getURL()

• String getUserName()

• String getDatabaseProductName()

• String getDatabaseProductVersion()

• String getDriverName()

• String getDriverVersion()

• int getDriverMajorVersion()

• int getDriverMinorVersion()

• String getIdentifierQuoteString()

• String getSQLKeywords()

• String getSchemaTerm()

• String getProcedureTerm()

• String getCatalogTerm()

• int getMaxCharLiteralLength()

• int getMaxColumnNameLength()

• int getMaxColumnsInGroupBy()

• int getMaxColumnsInIndex()

• int getMaxColumnsInOrderBy()

• int getMaxColumnsInSelect()

• int getMaxColumnsInTable()

• int getMaxConnections()

• int getMaxCursorNameLength()

• int getMaxIndexLength()

• int getMaxProcedureNameLength()

• int getMaxCatalogNameLength()

• int getMaxRowSize()

• ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

• ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

• ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)

• ResultSet getSchemas()

• ResultSet getCatalogs()

• ResultSet getTableTypes()

• ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

• ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

• ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)

• ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)

• Connection getConnection()

• ResultSet getSchemas(String catalog, String schemaPattern)

Object:ResultSet

The ResultSet interface documents methods that retrieve the results of queries, for example, to read the rows and columns returned by a SELECT statement.

e6data ResultSet is a read-only object; it is not updatable.

• boolean next()

• void close()

• boolean wasNull()

• String getString(int columnIndex)

• boolean getBoolean(int columnIndex)

• byte getByte(int columnIndex)

• short getShort(int columnIndex)

• int getInt(int columnIndex)

• long getLong(int columnIndex)

• float getFloat(int columnIndex)

• double getDouble(int columnIndex)

• BigDecimal getBigDecimal(int columnIndex, int scale)

• byte[] getBytes(int columnIndex)

• java.sql.Date getDate(int columnIndex)

• java.sql.Time getTime(int columnIndex)

• java.sql.Timestamp getTimestamp(int columnIndex)

• String getString(String columnLabel)

• boolean getBoolean(String columnLabel)

• byte getByte(String columnLabel)

• short getShort(String columnLabel)

• int getInt(String columnLabel)

• long getLong(String columnLabel)

• float getFloat(String columnLabel)

• double getDouble(String columnLabel)

• BigDecimal getBigDecimal(String columnLabel, int scale)

• byte[] getBytes(String columnLabel)

• java.sql.Date getDate(String columnLabel)

• java.sql.Time getTime(String columnLabel)

• java.sql.Timestamp getTimestamp(String columnLabel)

• ResultSetMetaData getMetaData()

• Object getObject(int columnIndex)

• Object getObject(String columnLabel)

• int findColumn(String columnLabel)

• BigDecimal getBigDecimal(int columnIndex)

• BigDecimal getBigDecimal(String columnLabel)

• boolean isAfterLast()

• boolean isLast()

• int getRow()

• int getFetchSize()

• Array getArray(String columnLabel)

• java.sql.Date getDate(int columnIndex, Calendar cal)

• java.sql.Date getDate(String columnLabel, Calendar cal)

• java.sql.Time getTime(int columnIndex, Calendar cal)

• java.sql.Time getTime(String columnLabel, Calendar cal)

• java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal)

• java.sql.Timestamp getTimestamp(String columnLabel, Calendar cal)

  boolean isClosed()

Object:ResultSetMetaData

This provides information about a ResultSet, for example, the number of columns in the ResultSet.

• int getColumnCount()

• int getColumnDisplaySize(int column)

• String getColumnLabel(int column)

• String getColumnName(int column)

• String getSchemaName(int column)

• int getColumnType(int column)

• String getColumnTypeName(int column)

• String getColumnClassName(int column)