[jboss-user] [JCA/JBoss] - Re: Problems changing DefaultDS

kevintaute do-not-reply at jboss.com
Fri Sep 26 11:10:15 EDT 2008

The wiki does not mention that you need to ensure the tables are available on the new data source.  The error message java.sql.SQLException: ORA-00942: table or view does not exist indicates that you are trying to retrieve date from a table that does not exist.  Most likely the anonymous wrote : HILOSEQUENCES table is not visable in the Oracle Instance.

Have you tried to retrieve anything from the HILOSEQUENCES table directly (using PL/SQL or Toad or SquirrelSql or something like that).

Best bet is to look at the sample DS for Oracle, and change the SQL in the default DS to match the SQL in the sample.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4179097#4179097

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4179097

More information about the jboss-user mailing list