java - 使用串联和Varray将值插入表中

这是我的代码，其中METHODARGDATATYPE_VARRAY是表中第5列的varray，第一列具有自动生成的序列，并与't'连接。

 String arrayElements[] = { "Test3", "Test4" };
   ArrayDescriptor desc = ArrayDescriptor.createDescriptor
                                        ("METHODARGDATATYPE_VARRAY", conn);
   ARRAY newArray = new ARRAY(desc, conn, arrayElements);

   String sql="insert into TestCaseIDDetails values (concat('t',TestCaseID_sequence.nextval),?,?,?,?)";
   PreparedStatement ps =
     conn.prepareStatement (sql);
   ps.setString(2,testCaseIDandDetailsBean.getClass_name()) ;
   ps.setString(3,testCaseIDandDetailsBean.getMethod_name()) ;
   ps.setString(4,testCaseIDandDetailsBean.getMethodReplacement()) ;
   ((OraclePreparedStatement)ps).setARRAY (5, newArray);

   ps.execute ();

我试图执行此代码，但再次我得到如下错误：

      java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OraclePreparedStatement.setARRAYInternal(OraclePreparedStatement.java:5906)
at oracle.jdbc.driver.OraclePreparedStatement.setARRAY(OraclePreparedStatement.java:5898)
at implementation.TestCaseIDandDetailsDAOImpl.addTestCaseIDandDetails(TestCaseIDandDetailsDAOImpl.java:54)
at implementation.TestCaseIDandDetailsDAOImpl.main(TestCaseIDandDetailsDAOImpl.java:134)

我的表是：

     CREATE or replace TYPE METHODARGDATATYPE_VARRAY AS VARRAY(20) OF varchar2(30);
     create table TestCaseIDDetails(
       testcaseID varchar2(20) primary key,
       classname varchar2(20) not null,
       methodname varchar2(20) not null,
       MethodReplacement char(2) check(MethodReplacement in ('y','n')),
       MethodArgDataType METHODARGDATATYPE_VARRAY);

     Create sequence TestCaseID_sequence minvalue 1 start with 1 increment by 1 ;

最佳答案

改变以下

ps.setString(2,testCaseIDandDetailsBean.getClass_name()) ;
   ps.setString(3,testCaseIDandDetailsBean.getMethod_name()) ;
   ps.setString(4,testCaseIDandDetailsBean.getMethodReplacement()) ;
   ((OraclePreparedStatement)ps).setARRAY (5, newArray);

至

ps.setString(1,testCaseIDandDetailsBean.getClass_name()) ;
   ps.setString(2,testCaseIDandDetailsBean.getMethod_name()) ;
   ps.setString(3,testCaseIDandDetailsBean.getMethodReplacement()) ;
   ((OraclePreparedStatement)ps).setARRAY (4, newArray);

关于java - 使用串联和Varray将值插入表中，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/33429848/