Oracle 10 et PreparedStatement
Salut à tous!
J'essai d'exécuter le code suivant:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
Connection con = null;
PreparedStatement pstmt = null;
//Statement st = null;
ResultSet rs = null;
String sql = "SELECT * FROM CLIENT WHERE ID=? ";
DBConnection dbConnection = new DBConnection();
con = dbConnection.getDBConnection(USER, PWD, URL, DRIVER);
try {
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, 62);
rs = pstmt.executeQuery(sql);
while (rs.next()) {
System.out.println("Client name: " + rs.getString(2));
}
rs.close();
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
if (con != null) {
try {
con.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
} finally {
dbConnection.closeConnection(con);
} |
et j'obtiens toujours l'erreur suibante:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:419)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:895)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:451)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:985)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1124)
at generation.OracleDBConnection.main(OracleDBConnection.java:35) |
Quelqu'un a une idée, svp ?Merci!