Re: rsetMetaData.getColumnCount();
От | sc0698 |
---|---|
Тема | Re: rsetMetaData.getColumnCount(); |
Дата | |
Msg-id | bk8pin$e6e$1@news.hub.org обсуждение исходный текст |
Ответ на | rsetMetaData.getColumnCount(); ("sc0698" <sc0698@sina.com>) |
Ответы |
Re: rsetMetaData.getColumnCount();
|
Список | 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; }
В списке pgsql-jdbc по дате отправления: