Jdbc Statement.cancel does not work in 11.1.0.6 with 9.2 on Windows
Jdbc Statement.cancel does not work in 11.1.0.6 while connecting to 9.2 Database running on Windows. However, this issue as been fixed in 11.1.0.7 through bug 6279736.
There is a workaround for this issue in 11.1.0.6. You could turn off the out-of-band breaks by doing,
java -Doracle.net.disableOob=true ...
or
Include "oracle.net.disableOob" as one of the connection properties while getting the connection.
Properties prop = new Properties();
prop.put("oracle.net.disableOob", true);
...
connection = ...getConnection(..., prop);