Sender JDBC channel Error while polling?

[Former Member]

Hi Guys,

I am facing an issue with Sender JDBC channel while polling? It's giving below error.

3/25/11 6:54:23 AM Retry interval started. Length: 900.0 seconds

3/25/11 6:54:23 AM Error during conversion of query result to XML: java.sql.SQLException: Must be logged on to server

3/25/11 6:49:23 AM Processing started

Please provide possible solutions to resolve the issue. Thanks

Regards,

Sreeramulu Konjeti.

[former_member463616 · Accepted solution]

Hi,

It seems to like your select query might be wrong. Once again check it with that query.

Regards,

P.Rajesh

[baskar_gopalakrishnan2]

>>3/25/11 6:54:23 AM Error during conversion of query result to XML: java.sql.SQLException: Must be logged on to server

I'm thinking ... this could be your reason..

a) When one more than one thread is trying to use thin oracle jdbc driver via the same connection object. This happens

What is your jdbc version? Upgrade jdbc drivers installed in PI.

Also, in the advanced mode of jdbc channel check disconnect from database after every message. Test and see how it behaves.

[former_member4985]

Hi,

Check if you are using the "ojdbc14.jar" file that corresponds to your DV version.

I believe you're using Oracle, hence if the version is the correct one and in case it's

not, check in the installation folder, something like /oracle/client/<version>/instantclient/ojdbc14.jar

and use this.

After, restart the system and check if the error persists.

Regards,

Caio Cagnani

[naveen_chichili]

Hi Sreeramulu,

3/25/11 6:54:23 AM Retry interval started. Length: 900.0 seconds 
3/25/11 6:54:23 AM Error during conversion of query result to XML: java.sql.SQLException: Must be logged on to server 
3/25/11 6:49:23 AM Processing started 

Could you please check your login credentials while connecting to DB.

Thanks and Regards,

Naveen.

[stefan_grube]

> java.sql.SQLException: Must be logged on to server

User and password correct?