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]

One more thing jus to check urself.I find you are inserting string for column id.Did you declare the column id as string or intin your Oracle DB.Jus check it also.

-Guru

[Former Member]

Hi again.

The id is string. As I said, the query runs fine in the oracle backend.

The Connection and Statement are of course java.sql.Connection and java.sql.Statement.

I switched to executeUpdate. No good, same error.

I do not think the code is the problem. I think maybe some connection pool settings I have to make in the portal, or maybe the oracle drivers in the portal are not compatible with the oracle db... I just thought someone had experienced this problem, cause I would like to have a clue of where to start looking...

Thank you anyway.

Silviu.