br.com.sankhya.jape.dao

Class JdbcWrapper

java.lang.Object

br.com.sankhya.jape.dao.JdbcWrapper

public class JdbcWrapper
extends java.lang.Object

Author:

root To change the template for this generated type comment go to Window - Preferences - Java - Code Generation - Code and Comments

Constructor Summary

Constructors

Constructor and Description
JdbcWrapper(DataSourceDescriptor dsDescriptor, int maxRows, int queryTimeout)

Method Summary

Modifier and Type	Method and Description
void	closeSession()
static void	closeSession(JdbcWrapper jdbc)
java.lang.String	doTranslateMacros(java.lang.String s)
void	doWithCachedStatement(java.lang.String key, java.lang.String sql, boolean scrollableResult, com.sankhya.util.Worker w)
void	doWithCachedStatement(java.lang.String key, java.lang.String sql, com.sankhya.util.Worker w)
java.sql.Connection	getConnection()
java.lang.String	getDatabaseVendor()
javax.sql.DataSource	getDataSource()
int	getDialect()
DataSourceDescriptor	getDsDescriptor()
java.lang.String	getDSJndiName()
int	getMaxRows()
java.sql.PreparedStatement	getPreparedStatement(java.lang.String sql)
java.sql.PreparedStatement	getPreparedStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	getPreparedStatementForSearch(java.lang.String sql)
java.sql.PreparedStatement	getPreparedStatementForSearch(java.lang.String sql, boolean scrollableResult)
int	getQueryTimeout()
boolean	getTranslateMacros()
java.lang.String	getUserName() Deverá ser chamado apenas após o openSession, pois é lá que a variável é iniciada.
boolean	isMysql()
boolean	isOracle()
boolean	isSQLServer()
void	openSession()
void	setBindNewConnectionToJapeSession(boolean bindNewConnectionToSession)
void	setMaxRows(int maxRows)
void	setQueryTimeout(int queryTimeout)
void	setTranslateMacros(boolean translateMacros)

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcWrapper

public JdbcWrapper(DataSourceDescriptor dsDescriptor,
                   int maxRows,
                   int queryTimeout)

Method Detail

closeSession

public void closeSession()

closeSession

public static void closeSession(JdbcWrapper jdbc)

getConnection

public java.sql.Connection getConnection()

getDialect

public int getDialect()
               throws java.lang.Exception

Throws:

java.lang.Exception

getDsDescriptor

public DataSourceDescriptor getDsDescriptor()

getDatabaseVendor

public java.lang.String getDatabaseVendor()

getMaxRows

public int getMaxRows()

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sql)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sql,
                                                       int resultSetType,
                                                       int resultSetConcurrency)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

getPreparedStatementForSearch

public java.sql.PreparedStatement getPreparedStatementForSearch(java.lang.String sql)
                                                         throws java.lang.Exception

Throws:

java.lang.Exception

getPreparedStatementForSearch

public java.sql.PreparedStatement getPreparedStatementForSearch(java.lang.String sql,
                                                                boolean scrollableResult)
                                                         throws java.lang.Exception

Throws:

java.lang.Exception

getQueryTimeout

public int getQueryTimeout()

openSession

public void openSession()
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getDSJndiName

public java.lang.String getDSJndiName()

getDataSource

public javax.sql.DataSource getDataSource()

setMaxRows

public void setMaxRows(int maxRows)

setQueryTimeout

public void setQueryTimeout(int queryTimeout)

getTranslateMacros

public boolean getTranslateMacros()

setTranslateMacros

public void setTranslateMacros(boolean translateMacros)

getUserName

public java.lang.String getUserName()

Deverá ser chamado apenas após o openSession, pois é lá que a variável é iniciada.

Returns:

usuário do banco

doTranslateMacros

public java.lang.String doTranslateMacros(java.lang.String s)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

doWithCachedStatement

public void doWithCachedStatement(java.lang.String key,
                                  java.lang.String sql,
                                  com.sankhya.util.Worker w)
                           throws java.lang.Exception

Throws:

java.lang.Exception

doWithCachedStatement

public void doWithCachedStatement(java.lang.String key,
                                  java.lang.String sql,
                                  boolean scrollableResult,
                                  com.sankhya.util.Worker w)
                           throws java.lang.Exception

Throws:

java.lang.Exception

setBindNewConnectionToJapeSession

public void setBindNewConnectionToJapeSession(boolean bindNewConnectionToSession)

isOracle

public boolean isOracle()

isSQLServer

public boolean isSQLServer()

isMysql

public boolean isMysql()