OK, cool. Good to hear all around. Except for those admin pages, it seems to work for me, so I'll just assume that it'll be OK as of the next release, and then I'll dive into testing it.
Despite all appearances, I actually feel that this forum topic was pretty helpful. With a slight addition to the docs, and a working HSQL script (you can use mine if you want, might save you 15 minutes of porting work), I think I'll be good to go for the next release. Just as a recap for everyone, here are the HSQL versions of the Hibernate files.... >From /portal-core.sar/portal-core.har/META-INF/hibernate-service.xml <?xml version="1.0" encoding="UTF-8"?> java:DefaultDS java:portal/SessionFactory net.sf.hibernate.dialect.HSQLDialect net.sf.hibernate.cache.TreeCacheProvider jboss.jca:service=DataSourceBinding,name=DefaultDS >From portal-forums.sar/portal-forums.har/META-INF/hibernate-service.xml <?xml version="1.0" encoding="UTF-8"?> java:DefaultDS java:portal/ForumSessionFactory net.sf.hibernate.dialect.HSQLDialect net.sf.hibernate.cache.TreeCacheProvider jboss.jca:service=DataSourceBinding,name=DefaultDS I changed them to use the DefaultDS, to dispense with YADB (Yet Another Database). Change those two files and don't bother to copy over the Portal-ds.xml file. None of the tables collide with the JMS tables, so everything should be OK if you haven't dumped too much junk in your DefaultDS. Then you need to apply the SQL script. You can either just hack it into your HSQL files directly (probably not a good idea....), or.... 1) make sure your deploy/hsql-ds.xml file is set up to allow network connections. 2) Open up Squirrel (a SQL editor/DB manager), point it at the URL in you hsql-ds.xml file. 3) Cut and paste in the entire script from the first post on this thread. 4) Close SQuirreL 5) Start up your JBoss instance. you're done.... BTW, Fred, Jboss guys, when can we expect to see a HSQL 1.8 included with JBoss? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3863299#3863299 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3863299 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
