From: | "sc0698" <sc0698(at)sina(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: rsetMetaData.getColumnCount(); |
Date: | 2003-09-17 04:56:45 |
Message-ID: | bk8pin$e6e$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
the jdbc driver version :
7.4beta3(build 209)(2003-09-12) JDBC3 JDK 1.4 includes support for SSL
database verion:
7.4beta3 and 7.3.4
In the create2DArray I want to use rsetMetaData.getColumnCount(),
SQL.append("{?=call Fuc_Test4Query(");
SQL.append("'"+name+"','"+value+"'");
SQL.append(")}");
m_query = SQL;
public boolean executeProc() {
boolean ret = false;
Connection conn = null;
CallableStatement cstmt = null;
if ( (m_query != null) && !m_query.equals("")) {
conn = getConnection();
if (conn != null) {
try {
conn.setAutoCommit(false);
cstmt = conn.prepareCall(m_query);
if (m_flag.toUpperCase() != UPDATE) {
cstmt.registerOutParameter(1, Types.OTHER);
cstmt.execute();
// ResultSet resultSet = cstmt.executeQuery();
ResultSet resultSet = (ResultSet)cstmt.getObject(1);
// org.postgresql.PGRefCursorResultSet refcurs
// = (PGRefCursorResultSet) con.getObject(1);
//String cursorName = refcurs.getRefCursor();
//resultset to 2D Array
m_twoDArray = create2DArray(resultSet);
resultSet.close();
}
else {
cstmt.registerOutParameter(1, Types.INTEGER);
cstmt.execute();
m_return = cstmt.getInt(1);
}
conn.commit();
// close CallableStatement handle
cstmt.close();
conn.close();
ret = true;
}
catch (SQLException e) {
e.printStackTrace();
try {
if (cstmt != null) {
cstmt.close();
}
conn.close();
}
catch (Exception se) {
}
throw new RuntimeException(e.getMessage());
}
}
}
return ret;
}
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2003-09-17 07:00:55 | Re: ToBoolean method return correct Boolean values as per |
Previous Message | sc0698 | 2003-09-17 04:35:49 | Re: Stored Procedure returns a ResultSet |