실행하면 아래처럼 에러가 나네요..메소드는 다음과 같고요..
에러는 그 밑에 있어요..
그럼 수고하세요.
private void setDB()
throws SQLException, Exception
{
query = "set isolation to dirty read";
try{
stmt = conn.createStatement();
//rest = stmt.executeQuery(query);
stmt.executeUpdate(query);
stmt.close(); stmt = null;
rest.close(); rest = null;
} catch (SQLException e) {
e.printStackTrace();
throw new DataBaseException("set isolation error : " + e.getMessage());
} catch (Exception e) {
e.printStackTrace();
throw new DataBaseException("set isolation : " + e.getMessage());
} finally {
if (stmt != null) try { stmt.close(); } catch(Exception e) { }
if (rest != null) try { rest.close(); } catch(Exception e) { }
}
}
에러는 이거네요..
executeQuery()메소드를 사용하면 이 에러가 나고요..
java.sql.SQLException: Transaction not available.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:310)
at com.informix.jdbc.IfxSqli.errorDone(IfxSqli.java:3149)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3022)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2106)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2035)
at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:679)
at com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:275)
at com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.java:736)
at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:198)
at com.db.database.setDB(database.java:139)
at com.db.database.getConnection(database.java:62)
at com.db.database.<init>(database.java:29)
at com.db.database.main(database.java:452)
executeQuery()메소드들 쓰면 이 에러가 나고요..
java.sql.SQLException: Method only for queries
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:310)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1245)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1165)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:218)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:707)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:117)
at com.db.database.setDB(database.java:138)
at com.db.database.getConnection(database.java:62)
at com.db.database.<init>(database.java:29)
at com.db.database.main(database.java:452)
|