[jboss-user] Fail to get tables by a remote Datasource deployed in JBOSS

[Zeke]

Hi, all:

      I try to use DatabaseMetaData to get all tables and views from a
Oracle database. But exception is thrown at the red line. You can see that I
look up a remote DataSource and get connection from the data source. But if
I use *DriverManager.getConnection(url, user, pwd)* way to get connection.
This issue does not exist. I can get all the tables and views successfully…

      Any help from you will be much appreciated!

*public* *class* Test {

    *public* *static* *void* main(String[] args) *throws* Exception {

        Properties props = *new* Properties();

        props.put(Context.*PROVIDER_URL*, "jnp://10.111.3.161:1099");

        props.put(Context.*INITIAL_CONTEXT_FACTORY*,
"org.jnp.interfaces.NamingContextFactory");

        Context ctx = *new* InitialContext(props);

        DataSource ds = (DataSource)ctx.lookup("OracleDS");

        Connection conn = ds.getConnection();

        DatabaseMetaData dbmd = conn.getMetaData();

        ResultSet *rs* = dbmd.getTables(*null*, "%", "%", *new* String[] {
"TABLE", "VIEW" });

    }

}

      Exception:

       Exception in thread "main" *java.lang.ClassCastException*: $Proxy3

    at $Proxy2.getTables(Unknown Source)

    at Test.main(*Test.java:62*)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20090826/6d7000f0/attachment.html