0 Replies Latest reply on Oct 11, 2001 8:21 PM by toddengr

    Datasource problems with Jboss 2.4.1

    toddengr

      Hi All,

      I've noticed what *looks like* a bug to me in Jboss 2.4.1 with tomcat.

      I'm using the Weblogic JDBC driver. I tried to create mappings like this:/comp/jdbc/OrdersDataSource

      This mapping doesn't work.
      (from the startup log)
      XA Connection pool comp/jdbc/OrdersDataSource bound to java:/comp/jdbc/OrdersDataSource

      With this one, the code fails on ejbload creating a prepared statement even though the datasource creation is successful.

      This one does work: java:/jdbc/OrdersDataSource

      But, why does this one work where the first one fails. If I expand it to the JNDI name comp/env/jdbc/XXX I get a jdbc not bound error. Is there a limit to the number of levels the JNDI name can have in JBOSS? Or is jdbc not allowed in the context of env for some reason?

      Also, if I specify the name as comp/env/OrdersDataSource
      The server tries to use the hsql driver even though the WEBLOGIC driver is mapped to this JNDI name path. Is there a configuration option I missed somewhere?

      --using the hsql connection
      java:/comp/env/OrdersDataSource
      [Default] at org.hsql.Trace.getError(Trace.java:124)
      [Default]
      [Default] at org.hsql.Result.(Result.java:70)
      [Default]
      [Default] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644)
      [Default]
      [Default] at org.hsql.jdbcConnection.execute(jdbcConnection.java:540)

      Could someone with more experience with JBOSS illuminate me as to why this is happening?

      Thanks.

      Todd