JDBC error

[Former Member]

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

[bhavesh_kantilal · Accepted solution]

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

[prateek]

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

Regards,

Prateek