Re: how to implement OraclePreparedStatement?

2017-05-14 Thread gkk gb
If it helps, this is what I used to use for GlassFish: OracleDataSource ods = ds.unwrap(OracleDataSource.class); OracleConnection conn = (OracleConnection) ods.getConnection(); conn = ds.getConnection(); sql_a ="INSERT INTO MY_TABLE (my_value1, my_value2) VALUES (?,?)"; ps_a = (OraclePreparedSt

how to implement OraclePreparedStatement?

2017-05-14 Thread gkk gb
I'm porting my code from GlassFish to Tomcat 8.5.9, and have mostly everything working for my web app. I've created a JDBC pool, and can access oracle 11.2G stored procedures, etc. The one issue remaining is accessing oracle 11.2G database from java code directly using an OraclePreparedStatement