001: /*
002: * JOnAS: Java(TM) Open Application Server
003: * Copyright (C) 1999 Bull S.A.
004: * Contact: jonas-team@objectweb.org
005: *
006: * This library is free software; you can redistribute it and/or
007: * modify it under the terms of the GNU Lesser General Public
008: * License as published by the Free Software Foundation; either
009: * version 2.1 of the License, or any later version.
010: *
011: * This library is distributed in the hope that it will be useful,
012: * but WITHOUT ANY WARRANTY; without even the implied warranty of
013: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
014: * Lesser General Public License for more details.
015: *
016: * You should have received a copy of the GNU Lesser General Public
017: * License along with this library; if not, write to the Free Software
018: * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
019: * USA
020: *
021: * --------------------------------------------------------------------------
022: * $Id: SQLManager.java 8044 2006-02-21 22:15:41Z ehardesty $
023: * --------------------------------------------------------------------------
024: */
025: package org.objectweb.jonas.resource;
026:
027: import java.sql.PreparedStatement;
028: import java.sql.SQLException;
029:
030: /**
031: * SQL Manager to be used with PreparedStatment
032: * @author ehardesty
033: *
034: */
035: public interface SQLManager {
036:
037: /**
038: * Get the specified PreparedStatement
039: * @param mcinfo MCInfo
040: * @param conn Object connection
041: * @param user String
042: * @param sql String
043: * @return PreparedStatment
044: * @throws SQLException if an Exception occurs
045: */
046: PreparedStatement getPStatement(MCInfo mcinfo, Object conn,
047: String user, String sql) throws SQLException;
048:
049: /**
050: * Get the specified PreparedStatement
051: * @param mcinfo MCInfo
052: * @param conn Object connection
053: * @param user String
054: * @param sql String
055: * @param resultSetType int
056: * @param resultSetConcurrency int
057: * @return PreparedStatment
058: * @throws SQLException if an Exception occurs
059: */
060: PreparedStatement getPStatement(MCInfo mcinfo, Object conn,
061: String user, String sql, int resultSetType,
062: int resultSetConcurrency) throws SQLException;
063:
064: // JDK 1.4
065: /**
066: * Get the specified PreparedStatement
067: * @param mcinfo MCInfo
068: * @param conn Object connection
069: * @param user String
070: * @param sql String
071: * @param autoGeneratedKeys key
072: * @return PreparedStatment
073: * @throws SQLException if an Exception occurs
074: */
075: PreparedStatement getPStatement(MCInfo mcinfo, Object conn,
076: String user, String sql, int autoGeneratedKeys)
077: throws SQLException;
078:
079: /**
080: * Get the specified PreparedStatement
081: * @param mcinfo MCInfo
082: * @param conn Object connection
083: * @param user String
084: * @param sql String
085: * @param columnIndexes int []
086: * @return PreparedStatment
087: * @throws SQLException if an Exception occurs
088: */
089: PreparedStatement getPStatement(MCInfo mcinfo, Object conn,
090: String user, String sql, int[] columnIndexes)
091: throws SQLException;
092:
093: /**
094: * Get the specified PreparedStatement
095: * @param mcinfo MCInfo
096: * @param conn Object connection
097: * @param user String
098: * @param sql String
099: * @param resultSetType int
100: * @param resultSetConcurrency int
101: * @param resultSetHoldability int
102: * @return PreparedStatment
103: * @throws SQLException if an Exception occurs
104: */
105: PreparedStatement getPStatement(MCInfo mcinfo, Object conn,
106: String user, String sql, int resultSetType,
107: int resultSetConcurrency, int resultSetHoldability)
108: throws SQLException;
109:
110: /**
111: * Get the specified PreparedStatement
112: * @param mcinfo MCInfo
113: * @param conn Object connection
114: * @param user String
115: * @param sql String
116: * @param columnNames String []
117: * @return PreparedStatment
118: * @throws SQLException if an Exception occurs
119: */
120: PreparedStatement getPStatement(MCInfo mcinfo, Object conn,
121: String user, String sql, String[] columnNames)
122: throws SQLException;
123:
124: /**
125: * @return Returns the maxPstmtPoolSize
126: */
127: int getMaxPstmtPoolSize();
128: }
|