Skip to Content
0
Former Member
Apr 20, 2009 at 09:50 AM

JDBC Schema and Table Names Reversed

64 Views

Hi,

We're currently evaluating CR4E but are unable to successfully run/preview any reports.

We have successfully created a JDBC connection using the generic JDBC driver. We are connecting to an Ingres database. The connection is successful and we can browse databases/schemas/tables with no problem. The problem is with the SQL that the reporting engine is generating.

A simple example:

SELECT "currency"."description" FROM   "currency"."john" "currency"

In this statement, "currency" is actually the table and "john" is the schema name.

The query should read:

SELECT "currency"."description" FROM   "john"."currency" "currency"

Help would be appreciated as we're completely stuck.

Many thanks,

Darran Smith