Connecting OpenEdge database using sonic workbench and use S

Posted by dnessapkota10 on 29-Mar-2012 06:10

I had sucessfully connected the  openedge database named 'sports.db' using connection profile tool of  Sonic workbench 8.0. And it shows all database schema. When i'm trying to execute sql query like 'select *  from ccustomer' then it will throws an exception as,

     java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/View/Synonym not found (7519)
    at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepareProcessReply(Unknown Source)
    at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.prepare(Unknown Source)
    at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.prepare(Unknown Source)
    at com.ddtek.jdbc.openedge.OpenEdgeImplStatement.execute(Unknown Source)
    at com.ddtek.jdbc.openedgebase.BaseStatement.commonExecute(Unknown Source)
    at com.ddtek.jdbc.openedgebase.BaseStatement.executeInternal(Unknown Source)
    at com.ddtek.jdbc.openedgebase.BaseStatement.execute(Unknown Source)
    at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:173)
    at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:102)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

What could be the solution and what should i do?

Thanks,

Dinesh

All Replies

Posted by gus on 29-Mar-2012 20:03

Spell the table name correctly?

Most likely you need to specify the schema name in addition to the table name. So the query should be "select * from pub.customer;". Alternatively, you could set the schem to "PUB" and then you dpn't have specify it in the query.

Posted by dnessapkota10 on 29-Mar-2012 23:07

Thanks Gus,

     Using "PUB" schema it works now.

     Can you please elaborate about why we have to use PUB in this case.

Regards,

Dinesh

Posted by gus on 30-Mar-2012 10:16

Forgot to explain why it works:

Each user has a schema (really a namespace for tables, views, and indexes)

and by default, when you log in you are in your own schema, which beocmes

the current schema. So a reference to a table without the schema name means

a table in the current schema.

The 4GL does not have multiple schemae. All of its objects are in a schema

called PUB, which is the only schema that can (currently) be accessed by 4GL

code.

Posted by dnessapkota10 on 02-Apr-2012 05:55

Thanks Gus.

This thread is closed