I am trying to run the Seam 3 examples in AS 7 and PostgreSQL backend. Specifically I am trying to get the IDMCONSOLE example and then Seambooking example to run with PostgreSQL backend instead of the default H2. But I am not able to.

I have successfully created the PostgreSQL data source. (Thanks to this discussion group)

Now I try to use this data source and the updated the persistence.xml as follows. But I do not see any updates to my PostgreSQL database. I think <property name="hibernate.hbm2ddl.auto" value="update"/> from persistence.xml is working as I am able preserve new users added to the database. But I think it is happening in the default H2 database than PostgreSQL. I will appreciate any help. Thank you.

Try enabling TRACE logging for org.jboss.as.jpa and org.hibernate (follow instructions here). The log output will be in as7/standalone/log/server.log (you can restart the AS7 app server after configuring the logging settings). The trace output will give you a better idea of what is occurring when you deploy and use the demo app.

If that doesn't help, try switching to the latest AS7 build (download from here).

If that doesn't help, write back with more details here. Include any error exceptions that show up in the AS7 console and the datasource definition (without the password).

Thank you for the quick response. I tried turning on the log. I have enclosed the extract of the log file as attachement here. But I see the interesting portion of the log. I am not referring to ExampleDS in my persistence.xml at all. It shows up in the log. I do not know how. Any insight will help. Meanwhile I will try to download the latest AS 7 build and try and let you know more. Thank you again.

I tried the lattest build as suggested by Scott. First of all I could not even build. Please see the errors below. Let me know how I can try this better. Thank you.

Actually you don't have to build it yourself. Follow the link that Scott pointed you to and just download the already build latest binary and just use it like you would use a released JBoss AS version.

TThank you. I am not building the application server. I am using the application server from the link pointed by Scott. I was trying to rebuild the IDMCONSOLE application. That is the only way I know I could get the application loaded in the server. That is when I get this build error. I have known to have the war files in deployment directory to get them running the application server. But the seam3 examples are magically running from somewhere. I have not figured out that yet. If you can point that out I will really appreciate it. I see there are entrees of the IDMCONSOLE.WAR mentioned in the standalone.xml deployment section. I do not understand anything further. The reason I am rebuilding the IDMCONSOLE sample again is so that I can load it to the new application server I downloaded from Scotts link. I do not know how to move the war file from the older server installation to the new server and get it running. Hope I am making it clear. Thank you again.

Try finding the idmconsole.war file (it should be in a subfolder under the idmconsole source folder that you are building from). You can copy it from there to the as7/standalone/deployments folder.

In addition, verify that the contents of the idmconsole.war are what you are expecting. Do something like:

mkdir \FOO

copy IDMCONSOLE.WAR \FOO

cd \FOO

jar xf IDMCONSOLE.WAR

The above will extract the contents of IDMCONSOLE.WAR in your \FOO folder (I assume your using Windows since you used upper case). Then you can look at the persistence.xml and see if its what you expected. If not, my first guess is that maybe you didn't change the persistence.xml source (instead you changed the one that gets built by maven).

Please ignore this issue as an user error. I am a SQL Server guy predominantly with experience in Microsoft stack. New to PostgreSQL and JBoss. I did not realize PostgreSQL table names are case sensitive. Once I fixed it 7.1.1 also works.

I am sorry again. Actually 7.1.1 final is not working with PostgreSQL backend. I think I did not test properly in 7.1.1. I am able to consistently reproduce PostgreSQL backend not working. If I move the same VAR to the current build which I downloaded last week it works. So 7.1.1 has connectivity problems with PostgreSQL. Please let me know if you want to me test anything more or suggestions for next step. I am counting on JBoss AS 7 for my next big thing. I need a version that works well with PostgreSQL. Please let me know. Thank you.