3 Replies Latest reply on Aug 16, 2009 2:35 AM by chris.simons

Initial success with WebLogic 10.3.1 (11g); need help with H2

chris.simons Aug 14, 2009 5:42 PM

All,

Perhaps Oracle/BEA has made some fixes with the latest release of WebLogic AS (10.3.1).

Thus far, I've been able to deploy the jee5/booking example without having to use the jboss-seam-wls-compatible.jar, nor did I have to add each EJB as a separate SeamInterceptor (sections 39.2.2.2 and 39.2.2.3).

I was able to deploy the application without issue and view the start/login page of the Booking example.

Pretty cool, considering the last time I tried this with WebLogic 10.3, I had to navigate the maze of .jar changes and adding each EJB as a separate SeamInterceptor in ejb-jar.xml.

However, I have overriden the Booking example to use H2. This works with WebLogic. But I'm finding that, even though the Booking example successfully deploys, it is not populating my H2 database with tables. Furthermore, it seems to be setting the password to something other than sa, even though that is the password I gave the JDBC DataSource via WebLogic.

Does anyone have any hints for this? The reason I am using H2 is due to my application using H2, and I figured the best way to start would be to use H2 with the Booking example.

Thanks.

1. Re: Initial success with WebLogic 10.3.1 (11g); need help with H2

chris.simons Aug 14, 2009 5:47 PM (in response to chris.simons)

I should also mention that I am using Sun JDK 1.6_11, which ships with Oracle WebLogic 11g.
Actions
2. Re: Initial success with WebLogic 10.3.1 (11g); need help with H2

chris.simons Aug 16, 2009 1:29 AM (in response to chris.simons)

Upon closer inspection, my H2 datasource issues seem to have to be caused by WebLogic.

WebLogic is encrypting the password to the database connection, even though I am setting it manually in the datasource. I'm not sure H2 is capable of working with encrypted user passwords. Does anyone know?
Actions
3. Re: Initial success with WebLogic 10.3.1 (11g); need help with H2

chris.simons Aug 16, 2009 2:35 AM (in response to chris.simons)

Okay, my new thought here is that upon deploying, the JEE5-Booking example EJB's are not creating the tables in the supplied database.

I am now using the HSQLDB JDBC URL and have this connection/JDBC Source working via WebLogic. However, when I connect to this database, I can see that none of the tables have been created (CUSTOMERS, USERS, etc.).

What can possibly be causing this? I also added all of the individual EJB information in ejb-jar.xml to no avail.
Actions

Go to original post