The dialect was not set. Set the property hibernate.dialect.

[jlaskowski]

Hi,

I know I can change the property in jboss-portal.sar\conf\hibernate\hibernate.cfg.xml, but is there another way to set the default Hibernate dialect so that I don't have to extract/modify/save the file?

The change is required as without it JBoss AS 4.0.3RC2 refuses the portal sar to be deployed.

15:47:11,138 WARN [ServiceController] Problem starting service portal:service=Hibernate
org.hibernate.HibernateException: The dialect was not set. Set the property hibernate.dialect.
at org.hibernate.dialect.Dialect.getDialect(Dialect.java:540)
at org.hibernate.dialect.Dialect.getDialect(Dialect.java:562)
at org.hibernate.tool.hbm2ddl.SchemaExport.(SchemaExport.java:77)
at org.hibernate.tool.hbm2ddl.SchemaExport.(SchemaExport.java:53)
at org.jboss.portal.core.hibernate.SessionFactoryBinder.createSchema(SessionFactoryBinder.java:278)
at org.jboss.portal.core.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:181)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:287)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:187)
at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)

Jacek

[julien1]

unfortunately no, but you should use the exploded version of JBoss Portal.

if you use the cvs build, you can do sh build.sh explode, which explodes the sar file and its content and provide you easy configuration.

[jlaskowski]

Hi Julien,

$ pwd
/cygdrive/c/projs/jboss-portal-2.2/build

$ ./build.sh explode
build.sh: *WARNING* Ignoring environment value for $ANT_HOME
build.sh: Executing: /cygdrive/c/projs/jboss-portal-2.2/tools/bin/ant -logger org.apache.tools.ant.NoBannerLogger explode
Buildfile: build.xml

BUILD FAILED
Target `explode' does not exist in this project.

Total time: 0 seconds

p.s. Thanks for your thorough explanation of JBoss Portal during today's conference!

Jacek

[julien1]

Hello Jacek,

actually you need to do it in the core module where the sar portal-service.sar is built.

I hope that the explanations were clear enough even if I had to go quickly on the subject. That was a pleasure for me to expose my work to all of you guys.

cheers

[jlaskowski]

Hi,

It's getting worse with the latest changes to JBoss Portal 2.2 deployed onto JBoss AS 4.0.3RC2.

Now, there're 3 directories - instance, portal and user - with Hibernate configuration files and it's a tedious task to change the dialect to org.hibernate.dialect.HSQLDialect every time I update and build Portal. It's 5 files to change.

I wonder how developers work. Do they change these files, too or is there a way to work it out? There must be a simpler solution.

Jacek

[julien1]

One solution would be too code the dialect in the mbean service SessionFactoryBinder.

<attribute name="Dialect">some.dialect</attribute>

Each service would have that property, this property could eventually be overriden by a system property.

What do you think ?

[julien1]

The other option is to use a property file that would be in conf and setup the mapping for the sessions.

[julien1]

I update the code of 2.2 in order to make the detection effective for schema export and improved the code of the persistence too.