Please send a test case that I can compile and run on my machine to
debug this problem. The code you included below doesn't even have the
call to getColumnCount().
thanks,
--Barry
sc0698 wrote:
> 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;
> }
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
