Oracle Pool Connection problem

[Former Member]

Hello.

I am experiencing a problem trying to retrieve data from an oracle database.

I am using ep6 sp2 and have set up a connection pool using the com.sap.portals.jdbc.oracle.OracleDriver as a driver.

The problem is that when trying to get a connection that my service can use (in the java code), I keep receiving this error message:

java.sql.SQLException: [SAP_Portals][Oracle JDBC Driver]No more data available to read.

The error appears to come from the Statement initialization with con.createStatement() in the code.

Anyone has any idea of what I might be doing wrong?

Thank you in advance.

Silviu.

[guru_subramanian]

Hi again,

I see no problem with your code.

Jus a hint:-

Try java.sql.connection,java.sql.statement instead of connection & statement.

Instead of stat.excuteQuery try stat.executeUpdate("...");

Hope it works this time for you.

Regards,

Guru