[JDBC Progress Driver]:Table/View/Synonym not found (7519)

[kasundha]

I tried to setup eMessenger program with progress DB using JDBC driver and error log views following error continually.
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
java.sql.SQLException: [JDBC Progress Driver]:Table/View/Synonym not found (7519)
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6501)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6675)
at com.progress.sql.jdbc.JdbcProgress.SQLExecUTFDirect(JdbcProgress.java:2749)
at com.progress.sql.jdbc.JdbcProgressStatement.execute(JdbcProgressStatement.java:340)
at com.progress.sql.jdbc.JdbcProgressStatement.executeQuery(JdbcProgressStatement.java:234)
at lk.openarc.db.JDBCDBConfig.queryAndEnqueue(JDBCDBConfig.java:106)
at lk.openarc.db.JDBCDBConfig.<init>(JDBCDBConfig.java:64)
at lk.openarc.db.Main.start(Main.java:80)
at org.tanukisoftware.wrapper.WrapperManager$12.run(WrapperManager.java:2788)



Model of the Vodafone Modem = GLOBESURFER Icon
Progress Version = 9.1D
Java = jdk1.5.0_06

I think all configurations have done properly. Leave your comments.

Thanks

 

[RealHeavyDude]

Since you don't reveal the sql command that caused the error, if I must, I would speculate that the schema is missing from the table name. If you're trying to access tables which are defined using the 4GL data dictionary you must use the PUB schema.

BTW, you don't really want to use SQL92 with Progress 9.1d - it's almost 10 years old, unsupported software. Especially the SQL engine has a lousy performance and is everything but stable. You should upgrade to a recent OpenEdge version ...

Heavy Regards, RealHeavyDude.