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
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