#1028 DBA_SCHEDULER_JOBS

3.3.0
closed-invalid
nobody
5
2012-03-06
2012-03-05
Edgar Civil
No

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

Discussion

  • Edgar Civil
    Edgar Civil
    2012-03-05

    • milestone: --> 3.3.0
     
  • 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
    Edgar Civil
    2012-03-05

    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
    Edgar Civil
    2012-03-05

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

    Thanks...

     
  • Edgar Civil
    Edgar Civil
    2012-03-06

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

     
    • status: open --> closed-invalid