[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Howto move jbm and quartz tables to postgresql schema?

[PeterJ]

How many *-ds.xml files do you have? If only one, what is the jndi name within it? Is it DeafultDS?

I usually recommend that you retain DefaultDS for the JBoss services and use a second data source (in a second *-ds.xml) for your databases.

For postgresql-persistence.xml, you need to make two changes: set "Clustered" to false (unless you are running the 'all' configuration), and comment out the depends on ChannelFactoryName.

The only other thing needed to be done is change the SQL statements for Quartz to be valid for PostgreSQL, and it looks like you did that.

Post the contents of your *-ds.xml files. Remember to enclose the XML text with 'code' tags (select the text, click the Code button above the editor window).   

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

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