com.inductiveautomation.ignition.gateway.util

Class DBUtilities

java.lang.Object

com.inductiveautomation.ignition.gateway.util.DBUtilities

public class DBUtilities
extends java.lang.Object

Static utility functions pertaining to the database.

Constructor Summary

Constructors

Constructor and Description
DBUtilities()

Method Summary

Modifier and Type	Method and Description
static void	close(java.sql.Connection conn)
static void	close(java.sql.Connection conn, java.sql.Statement stmt) Silently close the given connection and statement.
static void	close(java.sql.ResultSet rs)
static void	close(java.sql.Statement stmt)
static java.lang.Object	getParameterValue(java.sql.CallableStatement stmt, int index, int dbType)
static java.lang.Object	getParameterValue(java.sql.CallableStatement stmt, java.lang.String paramName, int dbType) This class is necessary because some db connectors don't correctly support CallableStatement.getObject(string) [MYSQL is one, which always returns byte[2]]
static boolean	isDataManipulationQuery(java.lang.String query) Returns false if query is SELECT, otherwise true.
static void	rollback(java.sql.Connection conn)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBUtilities

public DBUtilities()

Method Detail

getParameterValue

public static java.lang.Object getParameterValue(java.sql.CallableStatement stmt,
                                                 java.lang.String paramName,
                                                 int dbType)
                                          throws java.sql.SQLException

This class is necessary because some db connectors don't correctly support CallableStatement.getObject(string) [MYSQL is one, which always returns byte[2]]

Throws:

java.sql.SQLException

getParameterValue

public static java.lang.Object getParameterValue(java.sql.CallableStatement stmt,
                                                 int index,
                                                 int dbType)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

close

public static void close(java.sql.Connection conn,
                         java.sql.Statement stmt)

Silently close the given connection and statement.

rollback

public static void rollback(java.sql.Connection conn)

close

public static void close(java.sql.Connection conn)

close

public static void close(java.sql.Statement stmt)

close

public static void close(java.sql.ResultSet rs)

isDataManipulationQuery

public static boolean isDataManipulationQuery(java.lang.String query)

Returns false if query is SELECT, otherwise true.