[Resin-interest] OraclePreparedStatement under Resin 4.0.22

2011-09-20 Thread Alan Wright
I am migrating from 2 to 4.00.22 We make use of OraclePreparedStatement to take advantage of setting parameters by name. This worked fine under Resin 2. We get the datasource try { Context env = (Context) new InitialContext().lookup(Constants.CONTEXT_ENV_ROOT);

Re: [Resin-interest] OraclePreparedStatement under Resin 4.0.22

2011-09-20 Thread Scott Ferguson
On 09/20/2011 09:12 AM, Alan Wright wrote: I am migrating from 2 to 4.00.22 We make use of OraclePreparedStatement to take advantage of setting parameters by name. You should use the JDBC unwrap() method (which is newer than Resin 2): PreparedStatement pStmt = conn.prepareStatement(sql);

Re: [Resin-interest] OraclePreparedStatement under Resin 4.0.22

2011-09-20 Thread Alan Wright
Thank you Scott - your speedy response is appreciated - I will try it first thing tomorrow. Regards Alan On 20/09/2011 17:41, Scott Ferguson wrote: On 09/20/2011 09:12 AM, Alan Wright wrote: I am migrating from 2 to 4.00.22 We make use of OraclePreparedStatement to take advantage of