Skip to Content
author's profile photo Former Member
Former Member

JDBC error

Hi,

We are getting a jdbc error.

Database-level error reported by JDBC driver while executing statement 'SELECT * FROM Interface WHERE intf_processstatus = '0' and intf_interfaceid > (select max(intf_interfaceid)-6 from interface where intf_processstatus = '0')'. The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'Interface'.'. For details, contact your database server vendor.

What is the exact reason for error?

'Intreface' mentioned in the query should be a table, right?

As far as my understanding goes, this table name is not identified in the database.

Could there be other reasons or areas to look into?

Please help.

Thanks,

John

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 19, 2008 at 09:29 AM

    John,

    This seems to be some issue with the query. Either the table/ view Interface does not exist.

    Log on to the database using a Database client using the same user id and password as in XI's comm channel and execute the same query to see what is the error you get.

    This should help understand if the problem is on XI or on the database / query

    Regards

    Bhavesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 19, 2008 at 09:37 AM

    Have you tested this query directly on the database? Try that and let us now the result.

    Regards,

    Prateek

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.