Error: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/Vi

Posted by smat-consulting on 12-Apr-2016 13:30

Not sure what forum to post this question...

OE 11.3, Windows 32, DataDirect JDBC driver

I have two tables in my DB comBreadInvoice and comBreadInvocieDetail. If I do a simple select on wither one of them, data is displayed. If I do a join of the two, I get "Error: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)"

the following two work: 

SELECT    "comBreadInvoice"."totalCases"FROM "PUB"."comBreadInvoice"

SELECT  "comBreadInvoiceDetail"."lastUpdateOn" FROM "PUB"."comBreadInvoiceDetail"

The following causes error:

SELECT
"comBreadInvoice"."totalCases",
"comBreadInvoiceDetail"."lastUpdateOn"
FROM "PUB"."comBreadInvoice"
INNER JOIN "comBreadInvoiceDetail"
ON (
"comBreadInvoiceDetail"."breadInvoice#" = "comBreadInvoice"."breadInvoice#"
)

Anybody any ideas?

Thanks...

Posted by Paul Koufalis on 12-Apr-2016 13:33

You're missing a "PUB" on comBreadInvoiceDetail :

INNER JOIN "PUB"."comBreadInvoiceDetail"

Or you can use defaultSchema="PUB" on your JDBC connection.

All Replies

Posted by Paul Koufalis on 12-Apr-2016 13:33

You're missing a "PUB" on comBreadInvoiceDetail :

INNER JOIN "PUB"."comBreadInvoiceDetail"

Or you can use defaultSchema="PUB" on your JDBC connection.

Posted by smat-consulting on 12-Apr-2016 13:50

Man!!!! :| You know how often I reviewed that stuff and didn't see it? Thank you!!!

This thread is closed