#1028 DBA_SCHEDULER_JOBS

[Edgar Civil]

Hi... when SELECT * FROM DBA_SCHEDULER_JOBS, (11g R1) occurs follow error:

Error: Violation of protocol
SQLState: null
ErrorCode: 17401

after, with any sentence...

Error: El valor del cursor de referencia no es válido
SQLState: null
ErrorCode: 17442

.... it necesary close session an reconnect session in oracle....

regards....

[Stefan Willinger]

Hi, I assume, that this is not a bug of SQuirreL. This is a exception thrown by the JDBC driver.
Please, tell us, which jdbc driver and java version you are using.
Does other SQL statements work?

[Edgar Civil]

Hi Stefan...thanks...

The version JDBC is the provide for oracle, is "ojdbc14.jar" in the information the squirrelsql is

getDatabaseProductName Oracle
getDriverName Oracle JDBC driver
getDriverVersion 9.2.0.1.0

....and the java version is a jdk 1.6.0_27...

thanks

[Edgar Civil]

Other SQL statements work, is in any statements.... for example SELECT SYSDATE FOR DUAL; any ALTER .... SELECT * FROM ANY TABLE....

Thanks...

[Stefan Willinger]

ojdbc14.jar is a pretty old driver.
For Oracle 11g R1, you should use ojdbc6.jar if you are running Java6. Please, try it with the newer driver.
For a list of available drivers, please visit http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
Stefan

[Edgar Civil]

Thanks Stephan...

I Tried with the new ojdbc6.jar driver and any sentence run after the action SELECT * FROM DBA_SCHEDULER_JOBS ...

SOLVED....

thanks for your help...

Regards....