9 Replies Latest reply on Jun 13, 2007 11:15 AM by Gyanendra Hyoju

    Jboss Portal with EnterpriseDB

    Gyanendra Hyoju Newbie

      Hi,

      I am trying to use JBOSS AS 4.0.5GA and JBOSS PORTAL 2.4.1 with EnterpriseDB. I have following entry in server\default\deploy\portal-edb-ds.xml:


      <local-tx-datasource>
      <jndi-name>PortalDS</jndi-name>
      <connection-url>jdbc:edb://localhost:5432/edb</connection-url>
      <driver-class>com.edb.Driver</driver-class>
      <user-name>enterprisedb</user-name>
      manager1
      </local-tx-datasource>


      I have following entry in server\default\deploy\jboss-portal.sar\conf\hibernate\**\hibernate.cfg.xml:

      org.hibernate.dialect.PostgreSQLDialect

      and I added following entry in server\default\conf\standardjbosscmp-jdbc.xml

      <type-mapping>
      EnterpriseDB
      <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
      <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
      <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
      <auto-increment-template>?1</auto-increment-template>
      <alias-header-prefix>t</alias-header-prefix>
      <alias-header-suffix>_</alias-header-suffix>
      <alias-max-length>32</alias-max-length>
      <subquery-supported>true</subquery-supported>
      <true-mapping>TRUE</true-mapping>
      <false-mapping>FALSE</false-mapping>

      <function-mapping>
      <function-name>concat</function-name>
      <function-sql>(?1 || ?2)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>substring</function-name>
      <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>lcase</function-name>
      <function-sql>lower(?1)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>length</function-name>
      <function-sql>length(?1)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>locate</function-name>
      <function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>abs</function-name>
      <function-sql>abs(?1)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>sqrt</function-name>
      <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>ucase</function-name>
      <function-sql>upper(?1)</function-sql>
      </function-mapping>
      <function-mapping>
      <function-name>count</function-name>
      <function-sql>count(?1)</function-sql>
      </function-mapping>


      <java-type>java.lang.Boolean</java-type>
      <jdbc-type>CHAR</jdbc-type>
      <sql-type>BOOLEAN</sql-type>


      <java-type>java.lang.Byte</java-type>
      <jdbc-type>TINYINT</jdbc-type>
      <sql-type>INT2</sql-type>


      <java-type>java.lang.Short</java-type>
      <jdbc-type>SMALLINT</jdbc-type>
      <sql-type>INT2</sql-type>


      <java-type>java.lang.Integer</java-type>
      <jdbc-type>INTEGER</jdbc-type>
      <sql-type>INT4</sql-type>


      <java-type>java.lang.Long</java-type>
      <jdbc-type>BIGINT</jdbc-type>
      <sql-type>INT8</sql-type>


      <java-type>java.lang.Float</java-type>
      <jdbc-type>FLOAT</jdbc-type>
      <sql-type>FLOAT(7)</sql-type>


      <java-type>java.lang.Double</java-type>
      <jdbc-type>DOUBLE</jdbc-type>
      <sql-type>FLOAT8</sql-type>


      <java-type>java.lang.Character</java-type>
      <jdbc-type>CHAR</jdbc-type>
      <sql-type>CHAR(1)</sql-type>


      <java-type>java.lang.String</java-type>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>TEXT</sql-type>


      <java-type>java.util.Date</java-type>
      <jdbc-type>TIMESTAMP</jdbc-type>
      <sql-type>TIMESTAMP with time zone</sql-type>


      <java-type>java.sql.Date</java-type>
      <jdbc-type>DATE</jdbc-type>
      <sql-type>DATE</sql-type>


      <java-type>java.sql.Time</java-type>
      <jdbc-type>TIME</jdbc-type>
      <sql-type>TIME</sql-type>


      <java-type>java.sql.Timestamp</java-type>
      <jdbc-type>TIMESTAMP</jdbc-type>
      <sql-type>TIMESTAMP with time zone</sql-type>


      <java-type>java.math.BigDecimal</java-type>
      <jdbc-type>NUMERIC</jdbc-type>
      <sql-type>NUMERIC</sql-type>


      <java-type>java.lang.Object</java-type>
      <jdbc-type>VARBINARY</jdbc-type>
      <sql-type>BYTEA</sql-type>

      </type-mapping>

      I get following error when I try run the JBOSS AS:

      org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: EnterpriseDB
      at org.jboss.portal.jems.hibernate.DialectFactory.determineDialect(DialectFactory.java:61)
      at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:233)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
      at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
      at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy99.start(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
      at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy8.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
      at org.jboss.Main.boot(Main.java:200)
      at org.jboss.Main$1.run(Main.java:490)
      at java.lang.Thread.run(Thread.java:534)
      2007-02-26 14:01:04,578 WARN [org.jboss.system.ServiceController] Problem starting service portal:service=Hibernate,type=CMS
      org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: EnterpriseDB
      at org.jboss.portal.jems.hibernate.DialectFactory.determineDialect(DialectFactory.java:61)
      at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:233)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
      at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
      at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at org.jboss.system.ServiceController.start(ServiceController.java:435)
      at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy99.start(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
      at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy8.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:417)
      at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
      at org.jboss.Main.boot(Main.java:200)
      at org.jboss.Main$1.run(Main.java:490)
      at java.lang.Thread.run(Thread.java:534)

      What am I missing?

      Thanks a lot

        • 1. Re: Jboss Portal with EnterpriseDB
          Thomas Heute Master

          Make sure you do "ant clean" before you rebuild.

          Also in the furure if you need to paste some XML file please use [ code ] [ /code ] (without the spaces)

          • 2. Re: Jboss Portal with EnterpriseDB
            Gyanendra Hyoju Newbie

            Hi thomas

            sorry for the xml part.

            By the way I am not trying to build the jboss portal or jboss as. I am just trying to run the run.bat file.

            Thanks a lot

            • 3. Re: Jboss Portal with EnterpriseDB
              Thomas Heute Master

              ok sorry i read too fast, i didn't see that you were editing the binaries.

              Editing the hibernate.cfg.xml files should be enough.

              Could you show more of the stacktrace in Debug mode ? Just take the part of server/default/log/server.log before and after the stack trace.

              • 4. Re: Jboss Portal with EnterpriseDB
                Gyanendra Hyoju Newbie

                here is it:

                2007-02-26 15:06:22,312 DEBUG [org.jboss.system.ServiceController] Creating service portal:deploymentFactory=PortletApp
                2007-02-26 15:06:22,312 DEBUG [org.jboss.portal.core.deployment.jboss.PortletAppDeploymentFactory] Creating portal:deploymentFactory=PortletApp
                2007-02-26 15:06:22,312 DEBUG [org.jboss.portal.core.deployment.jboss.PortletAppDeploymentFactory] Created portal:deploymentFactory=PortletApp
                2007-02-26 15:06:22,312 DEBUG [org.jboss.system.ServiceController] Creating dependent components for: portal:deploymentFactory=PortletApp dependents are: []
                2007-02-26 15:06:22,312 DEBUG [org.jboss.system.ServiceController] Creating service jboss.jca:name=PortalDS,service=DataSourceBinding
                2007-02-26 15:06:22,312 DEBUG [org.jboss.system.ServiceController] Ignoring create request for service: jboss.jca:name=PortalDS,service=DataSourceBinding
                2007-02-26 15:06:22,328 DEBUG [org.jboss.deployment.MainDeployer] Done with create step of deploying portal-edb-ds.xml
                2007-02-26 15:06:22,328 DEBUG [org.jboss.deployment.MainDeployer] Begin deployment start file:/C:/jboss-4.0.5.GA-edb/server/default/deploy/portal-edb-ds.xml
                2007-02-26 15:06:22,328 DEBUG [org.jboss.deployment.SARDeployer] Deploying SAR, start step: url file:/C:/jboss-4.0.5.GA-edb/server/default/deploy/portal-edb-ds.xml
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] starting service jboss.jca:name=PortalDS,service=LocalTxCM
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] waiting in start jboss.jca:name=PortalDS,service=LocalTxCM on jboss.jca:name=PortalDS,service=ManagedConnectionPool
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] starting service jboss.jca:name=PortalDS,service=ManagedConnectionPool
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] waiting in start jboss.jca:name=PortalDS,service=ManagedConnectionPool on jboss.jca:name=PortalDS,service=ManagedConnectionFactory
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] starting service jboss.jca:name=PortalDS,service=ManagedConnectionFactory
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Starting jboss.jca:name=PortalDS,service=ManagedConnectionFactory
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'TransactionQueryTimeout'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'CheckValidConnectionSQL'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'TrackStatements'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'ValidConnectionCheckerClassName'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'ConnectionURL'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'ConnectionProperties'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'PreparedStatementCacheSize'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'UserName'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'NewConnectionSQL'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'Password'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'ValidateOnMatch'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'ExceptionSorterClassName'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'QueryTimeout'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'TransactionIsolation'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'SharePreparedStatements'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Not setting config property 'DriverClass'
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] setting property: ConnectionURL to value jdbc:edb://localhost:5432/edb
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property ConnectionURL to value jdbc:edb://localhost:5432/edb
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] setting property: DriverClass to value com.edb.Driver
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property DriverClass to value com.edb.Driver
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] setting property: UserName to value enterprisedb
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property UserName to value enterprisedb
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] setting property: Password to value manager1
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property Password to value manager1
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] setting property: ValidateOnMatch to value true
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] set property ValidateOnMatch to value true
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.RARDeployment] Started jboss.jca:name=PortalDS,service=ManagedConnectionFactory
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.jca:name=PortalDS,service=ManagedConnectionFactory dependent components: [ObjectName: jboss.jca:name=PortalDS,service=ManagedConnectionPool
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=ManagedConnectionFactory
                Depends On Me:
                jboss.jca:name=PortalDS,service=LocalTxCM
                ]
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] starting service jboss.jca:name=PortalDS,service=ManagedConnectionPool
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Starting jboss.jca:name=PortalDS,service=ManagedConnectionPool
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started jboss.jca:name=PortalDS,service=ManagedConnectionPool
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.jca:name=PortalDS,service=ManagedConnectionPool dependent components: [ObjectName: jboss.jca:name=PortalDS,service=LocalTxCM
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=ManagedConnectionPool
                jboss.jca:service=CachedConnectionManager
                jboss:service=TransactionManager
                Depends On Me:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                ]
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] starting service jboss.jca:name=PortalDS,service=LocalTxCM
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.TxConnectionManager] Starting jboss.jca:name=PortalDS,service=LocalTxCM
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.connectionmanager.TxConnectionManager] Started jboss.jca:name=PortalDS,service=LocalTxCM
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.jca:name=PortalDS,service=LocalTxCM dependent components: [ObjectName: jboss.jca:name=PortalDS,service=DataSourceBinding
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=LocalTxCM
                jboss:service=invoker,type=jrmp
                Depends On Me:
                portal:service=Hibernate,type=CMS
                portal:service=CMS
                portal:service=Hibernate
                portal:service=Hibernate,type=Instance
                portal:service=Hibernate,type=PortalObject
                portal:service=Hibernate,type=Portlet
                ]
                2007-02-26 15:06:22,328 DEBUG [org.jboss.system.ServiceController] starting service jboss.jca:name=PortalDS,service=DataSourceBinding
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Starting jboss.jca:name=PortalDS,service=DataSourceBinding
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Using delegate: org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy@199939 for invoker=jboss:service=invoker,type=jrmp
                2007-02-26 15:06:22,328 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Created proxy for invoker=jboss:service=invoker,type=jrmp, targetName=jboss.jca:name=PortalDS,service=DataSourceBinding, nameHash=-1055207024
                2007-02-26 15:06:22,359 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Binding object 'org.jboss.resource.adapter.jdbc.WrapperDataSource@1b4543c' into JNDI at 'java:PortalDS'
                2007-02-26 15:06:22,359 INFO [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:name=PortalDS,service=DataSourceBinding' to JNDI name 'java:PortalDS'
                2007-02-26 15:06:22,359 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Started jboss.jca:name=PortalDS,service=DataSourceBinding
                2007-02-26 15:06:22,359 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.jca:name=PortalDS,service=DataSourceBinding dependent components: [ObjectName: portal:service=Hibernate,type=CMS
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=CMS
                cms.pm.cache:service=TreeCache
                , ObjectName: portal:service=CMS
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                portal:service=JAASLoginModule
                portal:service=Hibernate,type=CMS
                Depends On Me:
                portal:commandFactory=CMSObject
                cms.pm.cache:service=TreeCache
                , ObjectName: portal:service=Hibernate
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=Module,type=User
                portal:service=Module,type=Role
                , ObjectName: portal:service=Hibernate,type=Instance
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:container=Instance
                , ObjectName: portal:service=Hibernate,type=PortalObject
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:container=PortalObject
                , ObjectName: portal:service=Hibernate,type=Portlet
                State: CREATED
                I Depend On:
                jboss.jca:name=PortalDS,service=DataSourceBinding
                Depends On Me:
                portal:service=StateStore,type=Producer
                ]
                2007-02-26 15:06:22,359 DEBUG [org.jboss.system.ServiceController] starting service portal:service=Hibernate,type=CMS
                2007-02-26 15:06:22,359 DEBUG [org.jboss.portal.jems.hibernate.SessionFactoryBinder] Starting portal:service=Hibernate,type=CMS
                2007-02-26 15:06:22,359 DEBUG [org.jboss.portal.jems.hibernate.SessionFactoryBinder] Detecting dialect with datasource java:PortalDS ...
                2007-02-26 15:06:22,375 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
                2007-02-26 15:06:22,375 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to notify thread: old next: 1172528032375, new next: 1172528032375
                2007-02-26 15:06:22,703 DEBUG [org.jboss.portal.jems.hibernate.SessionFactoryBinder] Starting failed portal:service=Hibernate,type=CMS
                org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: EnterpriseDB
                at org.jboss.portal.jems.hibernate.DialectFactory.determineDialect(DialectFactory.java:61)
                at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:233)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
                at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
                at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
                at $Proxy0.start(Unknown Source)
                at org.jboss.system.ServiceController.start(ServiceController.java:417)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy4.start(Unknown Source)
                at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy99.start(Unknown Source)
                at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
                at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy8.deploy(Unknown Source)
                at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
                at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
                at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
                at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
                at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
                at $Proxy0.start(Unknown Source)
                at org.jboss.system.ServiceController.start(ServiceController.java:417)
                at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy4.start(Unknown Source)
                at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy5.deploy(Unknown Source)
                at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
                at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
                at org.jboss.Main.boot(Main.java:200)
                at org.jboss.Main$1.run(Main.java:490)
                at java.lang.Thread.run(Thread.java:534)
                2007-02-26 15:06:22,734 WARN [org.jboss.system.ServiceController] Problem starting service portal:service=Hibernate,type=CMS
                org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: EnterpriseDB
                at org.jboss.portal.jems.hibernate.DialectFactory.determineDialect(DialectFactory.java:61)
                at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:233)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
                at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:73)
                at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
                at $Proxy0.start(Unknown Source)
                at org.jboss.system.ServiceController.start(ServiceController.java:417)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at org.jboss.system.ServiceController.start(ServiceController.java:435)
                at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy4.start(Unknown Source)
                at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy99.start(Unknown Source)
                at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
                at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy8.deploy(Unknown Source)
                at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
                at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
                at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
                at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
                at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
                at $Proxy0.start(Unknown Source)
                at org.jboss.system.ServiceController.start(ServiceController.java:417)
                at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy4.start(Unknown Source)
                at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy5.deploy(Unknown Source)
                at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
                at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
                at org.jboss.Main.boot(Main.java:200)
                at org.jboss.Main$1.run(Main.java:490)
                at java.lang.Thread.run(Thread.java:534)
                2007-02-26 15:06:22,750 DEBUG [org.jboss.system.ServiceController] starting service portal:service=CMS
                2007-02-26 15:06:22,750 DEBUG [org.jboss.system.ServiceController] waiting in start portal:service=CMS on portal:service=Hibernate,type=CMS
                2007-02-26 15:06:22,750 DEBUG [org.jboss.system.ServiceController] starting service portal:service=Hibernate
                2007-02-26 15:06:22,750 DEBUG [org.jboss.portal.jems.hibernate.SessionFactoryBinder] Starting portal:service=Hibernate
                2007-02-26 15:06:22,750 DEBUG [org.jboss.portal.jems.hibernate.SessionFactoryBinder] Using dialect org.hibernate.dialect.PostgreSQLDialect
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] Preparing to build session factory with filters : {}
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] processing extends queue
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] processing collection mappings
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.CollectionSecondPass] Second pass for collection: org.jboss.portal.identity.db.UserImpl.dynamic
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.CollectionSecondPass] Mapped collection key: jbp_uid, index: jbp_name, element: jbp_value
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.CollectionSecondPass] Second pass for collection: org.jboss.portal.identity.db.UserImpl.roles
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.CollectionSecondPass] Mapped collection key: jbp_uid, element: jbp_rid
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.CollectionSecondPass] Second pass for collection: org.jboss.portal.identity.db.RoleImpl.users
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.CollectionSecondPass] Mapped collection key: jbp_rid, element: jbp_uid
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] processing native query and ResultSetMapping mappings
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] processing association property references
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] processing foreign key constraints
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] resolving reference to class: org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] resolving reference to class: org.jboss.portal.identity.db.RoleImpl
                2007-02-26 15:06:22,750 DEBUG [org.hibernate.cfg.Configuration] resolving reference to class: org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:22,765 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{}
                2007-02-26 15:06:22,765 INFO [org.hibernate.connection.DatasourceConnectionProvider] Using datasource: java:PortalDS
                2007-02-26 15:06:22,765 INFO [org.hibernate.cfg.SettingsFactory] RDBMS: EnterpriseDB, version: 8.1.4.19
                2007-02-26 15:06:22,765 INFO [org.hibernate.cfg.SettingsFactory] JDBC driver: EnterpriseDB Native Driver, version: EnterpriseDB 8.1.4.19
                2007-02-26 15:06:22,859 INFO [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect
                2007-02-26 15:06:22,875 INFO [org.hibernate.transaction.TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
                2007-02-26 15:06:22,890 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{}
                2007-02-26 15:06:22,890 INFO [org.hibernate.transaction.TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
                2007-02-26 15:06:22,890 INFO [org.hibernate.transaction.TransactionManagerLookupFactory] instantiated TransactionManagerLookup
                2007-02-26 15:06:22,890 INFO [org.hibernate.transaction.TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
                2007-02-26 15:06:22,890 INFO [org.hibernate.transaction.TransactionManagerLookupFactory] instantiated TransactionManagerLookup
                2007-02-26 15:06:22,890 INFO [org.hibernate.cfg.SettingsFactory] Automatic flush during beforeCompletion(): enabled
                2007-02-26 15:06:22,890 INFO [org.hibernate.cfg.SettingsFactory] Automatic session close at end of transaction: disabled
                2007-02-26 15:06:22,890 INFO [org.hibernate.cfg.SettingsFactory] JDBC batch size: 15
                2007-02-26 15:06:22,890 INFO [org.hibernate.cfg.SettingsFactory] JDBC batch updates for versioned data: disabled
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] Scrollable result sets: enabled
                2007-02-26 15:06:22,906 DEBUG [org.hibernate.cfg.SettingsFactory] Wrap result sets: disabled
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] JDBC3 getGeneratedKeys(): disabled
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] Connection release mode: auto
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] Default batch fetch size: 1
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] Generate SQL with comments: disabled
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] Order SQL updates by primary key: disabled
                2007-02-26 15:06:22,906 INFO [org.hibernate.cfg.SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
                2007-02-26 15:06:22,921 INFO [org.hibernate.hql.ast.ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Query language substitutions: {}
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] JPA-QL strict compliance: disabled
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Second-level cache: enabled
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Query cache: enabled
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Optimize cache for minimal puts: disabled
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Structured second-level cache entries: disabled
                2007-02-26 15:06:22,921 INFO [org.hibernate.cfg.SettingsFactory] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
                2007-02-26 15:06:22,953 INFO [org.hibernate.cfg.SettingsFactory] Statistics: disabled
                2007-02-26 15:06:22,953 INFO [org.hibernate.cfg.SettingsFactory] Deleted entity synthetic identifier rollback: disabled
                2007-02-26 15:06:22,953 INFO [org.hibernate.cfg.SettingsFactory] Default entity-mode: pojo
                2007-02-26 15:06:23,109 INFO [org.hibernate.impl.SessionFactoryImpl] building session factory
                2007-02-26 15:06:23,109 DEBUG [org.hibernate.impl.SessionFactoryImpl] Session factory constructed with filter configurations : {}
                2007-02-26 15:06:23,109 DEBUG [org.hibernate.impl.SessionFactoryImpl] instantiating session factory with properties: {java.vendor=Sun Microsystems Inc., show_sql=false, catalina.base=C:\jboss-4.0.5.GA-edb\server\default, catalina.useNaming=false, connection.datasource=java:PortalDS, hibernate.transaction.flush_before_completion=true, os.name=Windows XP, sun.boot.class.path=C:\jboss-4.0.5.GA-edb\bin\\..\lib\endorsed\resolver.jar;C:\jboss-4.0.5.GA-edb\bin\\..\lib\endorsed\serializer.jar;C:\jboss-4.0.5.GA-edb\bin\\..\lib\endorsed\xalan.jar;C:\jboss-4.0.5.GA-edb\bin\\..\lib\endorsed\xercesImpl.jar;C:\jboss-4.0.5.GA-edb\bin\\..\lib\endorsed\xml-apis.jar;C:\j2sdk1.4.2_12\jre\lib\rt.jar;C:\j2sdk1.4.2_12\jre\lib\i18n.jar;C:\j2sdk1.4.2_12\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_12\jre\lib\jsse.jar;C:\j2sdk1.4.2_12\jre\lib\jce.jar;C:\j2sdk1.4.2_12\jre\lib\charsets.jar;C:\j2sdk1.4.2_12\jre\classes, sso-lookup-user-principal=cn=Directory Manager, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2_12-b03, hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider, user.name=ghyoju, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, jboss.bind.address=0.0.0.0, tomcat.util.buf.StringCache.byte.enabled=true, hibernate.session_factory_name=java:/portal/UserSessionFactory, transaction.auto_close_session=true, jboss.home.dir=C:\jboss-4.0.5.GA-edb, user.language=en, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, sun.boot.library.path=C:\j2sdk1.4.2_12\jre\bin, dialect=org.hibernate.dialect.PostgreSQLDialect, jboss.home.url=file:/C:/jboss-4.0.5.GA-edb/, sso-provider-url=ldap://localhost:59221/ou=people,dc=tmx,dc=com, java.version=1.4.2_12, user.timezone=America/Denver, jboss.server.home.dir=C:\jboss-4.0.5.GA-edb\server\default, sun.arch.data.model=32, sso-lookup-user-credentials=manager1, java.endorsed.dirs=C:\jboss-4.0.5.GA-edb\bin\\..\lib\endorsed, jboss.server.home.url=file:/C:/jboss-4.0.5.GA-edb/server/default/, sun.cpu.isalist=pentium i486 i386, file.encoding.pkg=sun.io, package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans., file.separator=\, cache.use_query_cache=true, java.specification.name=Java Platform API Specification, java.class.version=48.0, jboss.server.config.url=file:/C:/jboss-4.0.5.GA-edb/server/default/conf/, user.country=US, java.home=C:\j2sdk1.4.2_12\jre, java.vm.info=mixed mode, jboss.lib.url=file:/C:/jboss-4.0.5.GA-edb/lib/, os.version=5.1, hibernate.transaction.factory_class=org.hibernate.transaction.JTATransactionFactory, hibernate.connection.datasource=java:PortalDS, cache.provider_configuration_file_resource_path=conf/hibernate/user/ehcache.xml, sso-source=local, path.separator=;, java.vm.version=1.4.2_12-b03, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, user.variant=, java.protocol.handler.pkgs=org.jboss.net.protocol, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper., jboss.server.temp.dir=C:\jboss-4.0.5.GA-edb\server\default\tmp, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, sun.rmi.dgc.client.gcInterval=3600000, user.home=C:\Documents and Settings\ghyoju, java.rmi.server.RMIClassLoaderSpi=org.jboss.system.JBossRMIClassLoader, java.specification.vendor=Sun Microsystems Inc., sso-class=tomax.sso.server.AuthLDAP, java.library.path=C:\j2sdk1.4.2_12\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\tools\grep20d_win;C:\EnterpriseDB\8.1\dbserver\bin;C:\oracle\product\10.2.0\db_1\bin;C:\WebSphere\AppServer\WebSphere MQ\Java\lib;C:\j2sdk1.4.2_12\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\tools\apache-ant-1.7.0\bin;C:\tools\maven-1.0.2\bin;C:\WebSphere\AppServer\WebSphere MQ\bin;C:\WebSphere\AppServer\WebSphere MQ\WEMPS\bin;C:\tools\maven-2.0.4\bin;C:\Sun\jwsdp-1.6\jwsdp-shared\bin, java.vendor.url=http://java.sun.com/, program.name=run.bat, java.vm.vendor=Sun Microsystems Inc., sun.rmi.dgc.server.gcInterval=3600000, hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect, common.loader=${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=C:\j2sdk1.4.2_12\lib\tools.jar;C:\jboss-4.0.5.GA-edb\bin\\run.jar, hibernate.bytecode.use_reflection_optimizer=false, jboss.server.log.dir=C:\jboss-4.0.5.GA-edb\server\default\log, jbossmx.loader.repository.class=org.jboss.mx.loading.UnifiedLoaderRepository3, java.vm.specification.name=Java Virtual Machine Specification, catalina.home=C:\jboss-4.0.5.GA-edb\server\default, java.vm.specification.version=1.0, jboss.server.lib.url=file:/C:/jboss-4.0.5.GA-edb/server/default/lib/, sun.cpu.endian=little, sun.os.patch.level=Service Pack 2, hibernate.cache.use_query_cache=true, java.io.tmpdir=C:\DOCUME~1\ghyoju\LOCALS~1\Temp\, java.rmi.server.codebase=http://DV-1GHYOJU:8083/, org.w3c.dom.DOMImplementationSourceList=org.apache.xerces.dom.DOMXSImplementationSourceImpl, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, jboss.server.data.dir=C:\jboss-4.0.5.GA-edb\server\default\data, transaction.flush_before_completion=true, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, os.arch=x86, cache.use_second_level_cache=true, java.ext.dirs=C:\j2sdk1.4.2_12\jre\lib\ext, user.dir=C:\jboss-4.0.5.GA-edb\bin, line.separator=
                , java.vm.name=Java HotSpot(TM) Server VM, jboss.server.base.dir=C:\jboss-4.0.5.GA-edb\server, hibernate.cache.use_second_level_cache=true, hibernate.cache.provider_configuration_file_resource_path=conf/hibernate/user/ehcache.xml, jboss.server.base.url=file:/C:/jboss-4.0.5.GA-edb/server/, cache.provider_class=org.hibernate.cache.EhCacheProvider, javax.management.builder.initial=org.jboss.mx.server.MBeanServerBuilderImpl, file.encoding=Cp1252, sso-user-lookup-attritbute=uid, catalina.ext.dirs=C:\jboss-4.0.5.GA-edb\server\default\lib, hibernate.transaction.manager_lookup_class=org.hibernate.transaction.JBossTransactionManagerLookup, java.specification.version=1.4, jboss.server.name=default, hibernate.show_sql=false}
                2007-02-26 15:06:23,109 DEBUG [org.hibernate.cache.EhCacheProvider] Creating EhCacheProvider from a specified resource: conf/hibernate/user/ehcache.xml Resolved to URL: file:/C:/jboss-4.0.5.GA-edb/server/default/deploy/jboss-portal.sar/conf/hibernate/user/ehcache.xml
                2007-02-26 15:06:23,125 DEBUG [net.sf.ehcache.config.ConfigurationFactory] Configuring ehcache from URL: file:/C:/jboss-4.0.5.GA-edb/server/default/deploy/jboss-portal.sar/conf/hibernate/user/ehcache.xml
                2007-02-26 15:06:23,125 DEBUG [net.sf.ehcache.config.ConfigurationFactory] Configuring ehcache from InputStream
                2007-02-26 15:06:23,171 DEBUG [net.sf.ehcache.config.DiskStoreConfiguration] Disk Store Path: C:\DOCUME~1\ghyoju\LOCALS~1\Temp\/user
                2007-02-26 15:06:23,187 DEBUG [net.sf.ehcache.config.ConfigurationHelper] No CacheManagerEventListenerFactory class specified. Skipping...
                2007-02-26 15:06:23,187 DEBUG [net.sf.ehcache.config.ConfigurationHelper] No CachePeerListenerFactoryConfiguration specified. Not configuring a CacheManagerPeerListener.
                2007-02-26 15:06:23,187 DEBUG [net.sf.ehcache.config.ConfigurationHelper] No CachePeerProviderFactoryConfiguration specified. Not configuring a CacheManagerPeerProvider.
                2007-02-26 15:06:23,203 DEBUG [net.sf.ehcache.config.ConfigurationHelper] No BootstrapCacheLoaderFactory class specified. Skipping...
                2007-02-26 15:06:23,281 DEBUG [org.hibernate.cache.CacheFactory] instantiating cache region: org.jboss.portal.identity.db.UserImpl usage strategy: read-write
                2007-02-26 15:06:23,281 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.jboss.portal.identity.db.UserImpl]; using defaults.
                2007-02-26 15:06:23,296 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:23,296 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.jboss.portal.identity.db.UserImpl Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:23,296 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:23,296 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:24,312 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Static SQL for entity: org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:24,312 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Version select: select jbp_uid from jbp_users where jbp_uid =?
                2007-02-26 15:06:24,312 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Snapshot select: select userimpl_.jbp_uid, userimpl_.jbp_givenname as jbp3_11_, userimpl_.jbp_familyname as jbp4_11_, userimpl_.jbp_password as jbp5_11_, userimpl_.jbp_realemail as jbp6_11_, userimpl_.jbp_fakeemail as jbp7_11_, userimpl_.jbp_viewrealemail as jbp9_11_, userimpl_.jbp_enabled as jbp10_11_ from jbp_users userimpl_ where userimpl_.jbp_uid=?
                2007-02-26 15:06:24,312 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Insert 0: insert into jbp_users (jbp_uname, jbp_givenname, jbp_familyname, jbp_password, jbp_realemail, jbp_fakeemail, jbp_regdate, jbp_viewrealemail, jbp_enabled, jbp_uid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                2007-02-26 15:06:24,312 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Update 0: update jbp_users set jbp_givenname=?, jbp_familyname=?, jbp_password=?, jbp_realemail=?, jbp_fakeemail=?, jbp_viewrealemail=?, jbp_enabled=? where jbp_uid=?
                2007-02-26 15:06:24,312 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Delete 0: delete from jbp_users where jbp_uid=?
                2007-02-26 15:06:24,328 DEBUG [org.hibernate.cache.CacheFactory] instantiating cache region: org.jboss.portal.identity.db.RoleImpl usage strategy: read-write
                2007-02-26 15:06:24,328 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.jboss.portal.identity.db.RoleImpl]; using defaults.
                2007-02-26 15:06:24,328 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.jboss.portal.identity.db.RoleImpl
                2007-02-26 15:06:24,328 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.jboss.portal.identity.db.RoleImpl Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:24,328 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.jboss.portal.identity.db.RoleImpl
                2007-02-26 15:06:24,328 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.jboss.portal.identity.db.RoleImpl
                2007-02-26 15:06:24,343 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Static SQL for entity: org.jboss.portal.identity.db.RoleImpl
                2007-02-26 15:06:24,359 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Version select: select jbp_rid from jbp_roles where jbp_rid =?
                2007-02-26 15:06:24,359 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Snapshot select: select roleimpl_.jbp_rid, roleimpl_.jbp_displayname as jbp3_14_ from jbp_roles roleimpl_ where roleimpl_.jbp_rid=?
                2007-02-26 15:06:24,359 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Insert 0: insert into jbp_roles (jbp_name, jbp_displayname, jbp_rid) values (?, ?, ?)
                2007-02-26 15:06:24,359 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Update 0: update jbp_roles set jbp_displayname=? where jbp_rid=?
                2007-02-26 15:06:24,359 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Delete 0: delete from jbp_roles where jbp_rid=?
                2007-02-26 15:06:24,359 DEBUG [org.hibernate.cache.CacheFactory] instantiating cache region: org.jboss.portal.identity.db.UserImpl.roles usage strategy: read-write
                2007-02-26 15:06:24,359 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.jboss.portal.identity.db.UserImpl.roles]; using defaults.
                2007-02-26 15:06:24,375 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.jboss.portal.identity.db.UserImpl.roles
                2007-02-26 15:06:24,375 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.jboss.portal.identity.db.UserImpl.roles Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:24,375 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.jboss.portal.identity.db.UserImpl.roles
                2007-02-26 15:06:24,375 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.jboss.portal.identity.db.UserImpl.roles
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Static SQL for collection: org.jboss.portal.identity.db.UserImpl.roles
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row insert: insert into jbp_role_membership (jbp_uid, jbp_rid) values (?, ?)
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row update: update jbp_role_membership set jbp_rid=? where jbp_uid=? and jbp_rid=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row delete: delete from jbp_role_membership where jbp_uid=? and jbp_rid=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] One-shot delete: delete from jbp_role_membership where jbp_uid=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.cache.CacheFactory] instantiating cache region: org.jboss.portal.identity.db.UserImpl.dynamic usage strategy: read-write
                2007-02-26 15:06:24,390 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.jboss.portal.identity.db.UserImpl.dynamic]; using defaults.
                2007-02-26 15:06:24,390 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.jboss.portal.identity.db.UserImpl.dynamic
                2007-02-26 15:06:24,390 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.jboss.portal.identity.db.UserImpl.dynamic Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:24,390 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.jboss.portal.identity.db.UserImpl.dynamic
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.jboss.portal.identity.db.UserImpl.dynamic
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Static SQL for collection: org.jboss.portal.identity.db.UserImpl.dynamic
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row insert: insert into jbp_user_prop (jbp_uid, jbp_name, jbp_value) values (?, ?, ?)
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row update: update jbp_user_prop set jbp_value=? where jbp_uid=? and jbp_name=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row delete: delete from jbp_user_prop where jbp_uid=? and jbp_name=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] One-shot delete: delete from jbp_user_prop where jbp_uid=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.cache.CacheFactory] instantiating cache region: org.jboss.portal.identity.db.RoleImpl.users usage strategy: read-write
                2007-02-26 15:06:24,390 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.jboss.portal.identity.db.RoleImpl.users]; using defaults.
                2007-02-26 15:06:24,390 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.jboss.portal.identity.db.RoleImpl.users
                2007-02-26 15:06:24,390 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.jboss.portal.identity.db.RoleImpl.users Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:24,390 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.jboss.portal.identity.db.RoleImpl.users
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.jboss.portal.identity.db.RoleImpl.users
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Static SQL for collection: org.jboss.portal.identity.db.RoleImpl.users
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row insert: insert into jbp_role_membership (jbp_rid, jbp_uid) values (?, ?)
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row update: update jbp_role_membership set jbp_uid=? where jbp_rid=? and jbp_uid=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row delete: delete from jbp_role_membership where jbp_rid=? and jbp_uid=?
                2007-02-26 15:06:24,390 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] One-shot delete: delete from jbp_role_membership where jbp_rid=?
                2007-02-26 15:06:24,500 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_ from jbp_users userimpl0_ where userimpl0_.jbp_uid=?
                2007-02-26 15:06:24,500 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_ from jbp_users userimpl0_ where userimpl0_.jbp_uid=?
                2007-02-26 15:06:24,500 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_ from jbp_users userimpl0_ where userimpl0_.jbp_uid=? for update
                2007-02-26 15:06:24,500 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_ from jbp_users userimpl0_ where userimpl0_.jbp_uid=? for update
                2007-02-26 15:06:24,500 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_ from jbp_users userimpl0_ where userimpl0_.jbp_uid=? for update
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for action ACTION_MERGE on entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_, dynamic1_.jbp_uid as jbp1_2_, dynamic1_.jbp_value as jbp2_2_, dynamic1_.jbp_name as jbp3_2_ from jbp_users userimpl0_ left outer join jbp_user_prop dynamic1_ on userimpl0_.jbp_uid=dynamic1_.jbp_uid where userimpl0_.jbp_uid=?
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for action ACTION_REFRESH on entity org.jboss.portal.identity.db.UserImpl: select userimpl0_.jbp_uid as jbp1_11_0_, userimpl0_.jbp_uname as jbp2_11_0_, userimpl0_.jbp_givenname as jbp3_11_0_, userimpl0_.jbp_familyname as jbp4_11_0_, userimpl0_.jbp_password as jbp5_11_0_, userimpl0_.jbp_realemail as jbp6_11_0_, userimpl0_.jbp_fakeemail as jbp7_11_0_, userimpl0_.jbp_regdate as jbp8_11_0_, userimpl0_.jbp_viewrealemail as jbp9_11_0_, userimpl0_.jbp_enabled as jbp10_11_0_, dynamic1_.jbp_uid as jbp1_2_, dynamic1_.jbp_value as jbp2_2_, dynamic1_.jbp_name as jbp3_2_ from jbp_users userimpl0_ left outer join jbp_user_prop dynamic1_ on userimpl0_.jbp_uid=dynamic1_.jbp_uid where userimpl0_.jbp_uid=?
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=?
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=?
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=? for update
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=? for update
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=? for update
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for action ACTION_MERGE on entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=?
                2007-02-26 15:06:24,546 DEBUG [org.hibernate.loader.entity.EntityLoader] Static select for action ACTION_REFRESH on entity org.jboss.portal.identity.db.RoleImpl: select roleimpl0_.jbp_rid as jbp1_14_0_, roleimpl0_.jbp_name as jbp2_14_0_, roleimpl0_.jbp_displayname as jbp3_14_0_ from jbp_roles roleimpl0_ where roleimpl0_.jbp_rid=?
                2007-02-26 15:06:24,593 DEBUG [org.hibernate.loader.collection.BasicCollectionLoader] Static select for collection org.jboss.portal.identity.db.UserImpl.dynamic: select dynamic0_.jbp_uid as jbp1_0_, dynamic0_.jbp_value as jbp2_0_, dynamic0_.jbp_name as jbp3_0_ from jbp_user_prop dynamic0_ where dynamic0_.jbp_uid=?
                2007-02-26 15:06:24,593 DEBUG [org.hibernate.loader.collection.BasicCollectionLoader] Static select for collection org.jboss.portal.identity.db.UserImpl.roles: select roles0_.jbp_uid as jbp1_1_, roles0_.jbp_rid as jbp2_1_, roleimpl1_.jbp_rid as jbp1_14_0_, roleimpl1_.jbp_name as jbp2_14_0_, roleimpl1_.jbp_displayname as jbp3_14_0_ from jbp_role_membership roles0_ left outer join jbp_roles roleimpl1_ on roles0_.jbp_rid=roleimpl1_.jbp_rid where roles0_.jbp_uid=?
                2007-02-26 15:06:24,593 DEBUG [org.hibernate.loader.collection.BasicCollectionLoader] Static select for collection org.jboss.portal.identity.db.RoleImpl.users: select users0_.jbp_rid as jbp2_0_, users0_.jbp_uid as jbp1_0_ from jbp_role_membership users0_ where users0_.jbp_rid=?
                2007-02-26 15:06:24,593 DEBUG [org.hibernate.impl.SessionFactoryObjectFactory] initializing class SessionFactoryObjectFactory
                2007-02-26 15:06:24,609 DEBUG [org.hibernate.impl.SessionFactoryObjectFactory] registered: 8a8a8a8a1100170f0111001715510000 (java:/portal/UserSessionFactory)
                2007-02-26 15:06:24,609 INFO [org.hibernate.impl.SessionFactoryObjectFactory] Factory name: java:/portal/UserSessionFactory
                2007-02-26 15:06:24,625 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{}
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.impl.SessionFactoryImpl] Returning a Reference to the SessionFactory
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.util.NamingHelper] Found subcontext: java:
                2007-02-26 15:06:24,625 INFO [org.hibernate.util.NamingHelper] Creating subcontext: portal
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.impl.SessionFactoryImpl] Returning a Reference to the SessionFactory
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.util.NamingHelper] Bound name: java:/portal/UserSessionFactory
                2007-02-26 15:06:24,625 INFO [org.hibernate.impl.SessionFactoryObjectFactory] Bound factory to JNDI name: java:/portal/UserSessionFactory
                2007-02-26 15:06:24,625 WARN [org.hibernate.impl.SessionFactoryObjectFactory] InitialContext did not implement EventContext
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.impl.SessionFactoryImpl] instantiated session factory
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.impl.SessionFactoryImpl] obtaining JTA TransactionManager
                2007-02-26 15:06:24,625 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{}
                2007-02-26 15:06:24,625 INFO [org.hibernate.cache.UpdateTimestampsCache] starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
                2007-02-26 15:06:24,625 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
                2007-02-26 15:06:24,625 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.hibernate.cache.UpdateTimestampsCache
                2007-02-26 15:06:24,625 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.hibernate.cache.UpdateTimestampsCache Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:24,625 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.hibernate.cache.UpdateTimestampsCache
                2007-02-26 15:06:24,625 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.hibernate.cache.UpdateTimestampsCache
                2007-02-26 15:06:24,640 INFO [org.hibernate.cache.StandardQueryCache] starting query cache at region: org.hibernate.cache.StandardQueryCache
                2007-02-26 15:06:24,640 WARN [org.hibernate.cache.EhCacheProvider] Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
                2007-02-26 15:06:24,640 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.hibernate.cache.StandardQueryCache
                2007-02-26 15:06:24,640 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.hibernate.cache.StandardQueryCache Cache: Using SpoolingLinkedHashMap implementation
                2007-02-26 15:06:24,640 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.hibernate.cache.StandardQueryCache
                2007-02-26 15:06:24,640 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.hibernate.cache.StandardQueryCache
                2007-02-26 15:06:24,640 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named HQL queries
                2007-02-26 15:06:24,640 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
                2007-02-26 15:06:24,812 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4802672986685440
                2007-02-26 15:06:24,984 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: from org.jboss.portal.identity.db.UserImpl
                2007-02-26 15:06:25,015 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
                \-[QUERY] 'query'
                \-[SELECT_FROM] 'SELECT_FROM'
                \-[FROM] 'from'
                \-[RANGE] 'RANGE'
                \-[DOT] '.'
                +-[DOT] '.'
                | +-[DOT] '.'
                | | +-[DOT] '.'
                | | | +-[DOT] '.'
                | | | | +-[IDENT] 'org'
                | | | | \-[IDENT] 'jboss'
                | | | \-[IDENT] 'portal'
                | | \-[IDENT] 'identity'
                | \-[IDENT] 'db'
                \-[IDENT] 'UserImpl'

                200

                • 5. Re: Jboss Portal with EnterpriseDB
                  Thomas Heute Master

                  Did you also edit: server/default/deploy/jboss-portal.sar/portal-cms.sar/conf/hibernate/cms/hibernate.cfg.xml: ?

                  • 6. Re: Jboss Portal with EnterpriseDB
                    Gyanendra Hyoju Newbie

                    Thanks, that was the problem. after editing the file, it is working.

                    I did not know I have to edit the file. I was only thinking of portal. Is portal-cms.sar for the content management ?

                    Thanks a lot.

                    • 7. Re: Jboss Portal with EnterpriseDB
                      Thomas Heute Master

                      Yes it is for Content management.

                      Is the info about the other hibernate.cfg.xml missing from some documentation/wiki ? (so i can update)

                      • 8. Re: Jboss Portal with EnterpriseDB
                        Gyanendra Hyoju Newbie

                        Hi Thomas,

                        Document which you can download (http://labs.jboss.com/portal/jbossportal/docs) only mentions about the sample portal-*-ds.xml. I found out about the "hibernate.cfg.xml" from another user forum.

                        Thanks a lot

                        • 9. Re: Jboss Portal with EnterpriseDB
                          Gyanendra Hyoju Newbie

                          That was the case. Thanks a lot