Error in JDBC Sender adapter

[Former Member]

I am grtting this error in sender adapter:

Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Io exception: Got minus one from a read call. : SQLException: Io exception: Got minus one from a read call

Any suggestions about the possible cause please?

[baskar_gopalakrishnan2]

Any suggestions about the possible cause please?

I believe your installation of jdbc driver jar is not appropriate. This might be the reason. Also check the syntax of connection string in the channel.   Jdbc driver jar depends on the PI version. If your PI version is xi 3.0 or Pi 7.0 you need to use jdbc driver that support jdk 1.4 or less version. If your PI version is 7.1 and above (7.3) you need to use jdbc driver that supporst jdk 1.5 and above.  This might be one reason.  Plus oracle normally sends this message "Got minus one from a read call " If there is session leaks on the oracle server too. Please also check with dba for this.

Hope this helps.

[naveen_chichili]

Hi,

    1.Check if JDBC Drivers are correctly installed and configured.

     2. check if there is any firewall issues both ways to your PI server and DB Server.

     3.Also check the User credentials you are using to connect to your DB is working correctlly.

Regards,

Naveen.

[asdasd_asdasd]

what is the connection string you're using?

[Former Member]

JDBC Driver:     oracle.jdbc.driver.OracleDriver

Connection:     jdbc:oracle:thin:@serverid:nnnnn:SCHEMA