Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.8.4
-
None
-
None
-
Windows XP, Oracle 11.2.0.2
Description
the following script works with groovy 1.8.2 but not with 1.8.4 oci connection has an error (oci_error.txt) – thin connection works
import groovy.sql.Sql import java.sql.SQLException def dbc = Sql.newInstance('jdbc:oracle:oci:@b003', 'system', 'system', "oracle.jdbc.driver.OracleDriver") //def dbc = Sql.newInstance('jdbc:oracle:thin:@//server:1521/b003', 'system', 'system', "oracle.jdbc.driver.OracleDriver") println dbc.properties def row = dbc.firstRow("SELECT count(*) FROM all_users WHERE username = 'SYSTEM'") println row dbc.connection.autoCommit = false