如何在JDBC上执行此Oracle语句 [英] How to execute this Oracle statement on JDBC

问题描述

我无法使用JDBC准备的语句执行以下操作:

I have trouble executing the following using a JDBC prepared statement:

CREATE OR REPLACE TRIGGER Time_trg BEFORE INSERT ON Time FOR EACH ROW 
BEGIN 
  SELECT Time_seq.NEXTVAL INTO :new.id FROM dual; 
END;

代码:

try {
   PreparedStatement statement = connection.prepareStatement( sql );
   preparedStatement.executeUpdate();
} finally {
   statement.close();
}

我收到此错误:

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

我正在研究数据库不可知的解决方案，因此我需要一些可移植的东西.那么甲骨文的问题是什么?

I'm working on a database agnostic solution so I need something that is portable. So what is oracle's problem?

推荐答案

使用oracle.jdbc.OraclePreparedStatement

OraclePreparedStatement statement = (OraclePreparedStatement)connection.prepareStatement( sql );

由于这是Oracle特有的，常规的PrepareStatement没有帮助. Oracle提供了相同的包装器，同时还具有其他功能.

As this is much specific to Oracle, regular PrepareStatement doesn't help. Oracle provides a wrapper for the same, with additional functionalities as well.

类似地，Oracle提供与CallableStatement

Similarly, Oracle provides OracleCallableStatement similar to CallableStatement

工作环境:((当必须使用PreparedStatement时-可能会被滥用

WorkAround: (When PreparedStatement has to be used - Risk of being misused

 CREATE PROCEDURE EXECUTE_MY_DDL(INSTRING VARCHAR2)
 AS
 BEGIN
    EXECUTE IMMEDIATE INSTRING;
 END;

参考JavaDoc

这篇关于如何在JDBC上执行此Oracle语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！