org.objectweb.jonas.resource
Interface SQLManager

All Known Implementing Classes:

ConnectionManagerImpl

public interface SQLManager

SQL Manager to be used with PreparedStatment

Author:

ehardesty

Method Summary

int	getMaxPstmtPoolSize()
java.sql.PreparedStatement	getPStatement(MCInfo mcinfo, java.lang.Object conn, java.lang.String user, java.lang.String sql) Get the specified PreparedStatement
java.sql.PreparedStatement	getPStatement(MCInfo mcinfo, java.lang.Object conn, java.lang.String user, java.lang.String sql, int autoGeneratedKeys) Get the specified PreparedStatement
java.sql.PreparedStatement	getPStatement(MCInfo mcinfo, java.lang.Object conn, java.lang.String user, java.lang.String sql, int[] columnIndexes) Get the specified PreparedStatement
java.sql.PreparedStatement	getPStatement(MCInfo mcinfo, java.lang.Object conn, java.lang.String user, java.lang.String sql, int resultSetType, int resultSetConcurrency) Get the specified PreparedStatement
java.sql.PreparedStatement	getPStatement(MCInfo mcinfo, java.lang.Object conn, java.lang.String user, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Get the specified PreparedStatement
java.sql.PreparedStatement	getPStatement(MCInfo mcinfo, java.lang.Object conn, java.lang.String user, java.lang.String sql, java.lang.String[] columnNames) Get the specified PreparedStatement

Method Detail

getPStatement

java.sql.PreparedStatement getPStatement(MCInfo mcinfo,
                                         java.lang.Object conn,
                                         java.lang.String user,
                                         java.lang.String sql)
                                         throws java.sql.SQLException

Get the specified PreparedStatement

Parameters:

mcinfo - MCInfo

conn - Object connection

user - String

sql - String

Returns:

PreparedStatment

Throws:

java.sql.SQLException - if an Exception occurs

getPStatement

java.sql.PreparedStatement getPStatement(MCInfo mcinfo,
                                         java.lang.Object conn,
                                         java.lang.String user,
                                         java.lang.String sql,
                                         int resultSetType,
                                         int resultSetConcurrency)
                                         throws java.sql.SQLException

Get the specified PreparedStatement

Parameters:

mcinfo - MCInfo

conn - Object connection

user - String

sql - String

resultSetType - int

resultSetConcurrency - int

Returns:

PreparedStatment

Throws:

java.sql.SQLException - if an Exception occurs

getPStatement

java.sql.PreparedStatement getPStatement(MCInfo mcinfo,
                                         java.lang.Object conn,
                                         java.lang.String user,
                                         java.lang.String sql,
                                         int autoGeneratedKeys)
                                         throws java.sql.SQLException

Get the specified PreparedStatement

Parameters:

mcinfo - MCInfo

conn - Object connection

user - String

sql - String

autoGeneratedKeys - key

Returns:

PreparedStatment

Throws:

java.sql.SQLException - if an Exception occurs

getPStatement

java.sql.PreparedStatement getPStatement(MCInfo mcinfo,
                                         java.lang.Object conn,
                                         java.lang.String user,
                                         java.lang.String sql,
                                         int[] columnIndexes)
                                         throws java.sql.SQLException

Get the specified PreparedStatement

Parameters:

mcinfo - MCInfo

conn - Object connection

user - String

sql - String

columnIndexes - int []

Returns:

PreparedStatment

Throws:

java.sql.SQLException - if an Exception occurs

getPStatement

java.sql.PreparedStatement getPStatement(MCInfo mcinfo,
                                         java.lang.Object conn,
                                         java.lang.String user,
                                         java.lang.String sql,
                                         int resultSetType,
                                         int resultSetConcurrency,
                                         int resultSetHoldability)
                                         throws java.sql.SQLException

Get the specified PreparedStatement

Parameters:

mcinfo - MCInfo

conn - Object connection

user - String

sql - String

resultSetType - int

resultSetConcurrency - int

resultSetHoldability - int

Returns:

PreparedStatment

Throws:

java.sql.SQLException - if an Exception occurs

getPStatement

java.sql.PreparedStatement getPStatement(MCInfo mcinfo,
                                         java.lang.Object conn,
                                         java.lang.String user,
                                         java.lang.String sql,
                                         java.lang.String[] columnNames)
                                         throws java.sql.SQLException

Get the specified PreparedStatement

Parameters:

mcinfo - MCInfo

conn - Object connection

user - String

sql - String

columnNames - String []

Returns:

PreparedStatment

Throws:

java.sql.SQLException - if an Exception occurs

getMaxPstmtPoolSize

int getMaxPstmtPoolSize()

Returns:

Returns the maxPstmtPoolSize