Just prepare the statement with '?' for parameters Do
PreparedStatement.setXXX () for all parameters PreparedStatement.addBatch() Do the above in a loop, when you reach the required rowset size PreparedStatement.executeBatch(). Selva ________________________________ From: Eric Owhadi <[email protected]> Sent: Friday, January 13, 2017 3:52 PM To: [email protected] Subject: jdbc rowset usage? Hello, I am struggling to find the jdbc syntax to set an dynamic array parameter: Assuming I prepared this statement s with "Insert into t (a,b,c) values( ?[1000], ?[1000], ?[1000])" How do I set each parameter? Assuming a is INT, b is CHAR[10], c is INT? Am I doing something not really supported? Should I use AddBatch instead? Thanks in advance for the help, Eric
