Skip to Content
avatar image
Former Member

Sender JDBC channel Error while polling?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Mar 25, 2011 at 07:48 AM

    Hi,

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

    Regards,

    P.Rajesh

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2011 at 07:55 AM

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

    User and password correct?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 25, 2011 at 10:33 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2011 at 12:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2011 at 01:46 PM

    >>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.

    Add comment
    10|10000 characters needed characters exceeded