Invalid sql handle error

Hi all,

I have a problem with Integration Server. A couple of days ago, our server went down by itself early morning however server was almost idle, not many transactions at that time. I found a lot of “java.sql.SQLException:Invalid handle” error the error log and audit log. This error has happened every 20 minutes even the service that has created this error runs every minute. So I checked to see if there’s any timed schedule or timeout setting on jdbc:odbc configuration, I couldn’t find anything at all.

Two questions here:

  1. what is java.sql.SQLException:Invalid handle error?
    why does it happen? how can I fix this problem?
  2. This invalid sl handle can make b2b server(java.exe)
    down?

Please advise me…
Thanks

Hi All,

Recently we have restarted our OS (HP-UX) server. After server restart, our IS’s (wM 7.1.2) were started. But in all IS It was not starting the schedulers. I was getting below error.

[wm-cjdbc36-0007][Oracle JDBC Driver]Invalid SQL specified.

Cause of the error:
This is due to the JDBC Pool that for some reasons does not work.Resolution:

Simple server restart should resolve the issue. If not, follow below steps.

- Create a new JDBC Pool.

  • Assign it to ISInternal of IS and restart the server
  • Access the SCHEDULER page of IS Admin and you will see that the error "
    [wm-cjdbc36-0007][Oracle JDBC Driver]Invalid SQL specified" disapperas.
  • Use then the old JDBC Pool and everything works fine.

Regards,

Suresh Rao

Hi, I have the same error and by restarting the IS Internal JDBC Pool alias, its resolved.