geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim McConnell <tim.mcco...@gmail.com>
Subject Re: Runing Apache Roller 3.0 on Geronimo 1.1.1
Date Tue, 27 Feb 2007 23:49:55 GMT
Here is the JUG/Webcast presentation that elaborates some on the instructions in 
Jeff's article. It was pretty straightforward after I got MySql working 
correctly...Let me know if you need additional information

Thanks,
Tim McConnell


Peter Petersson wrote:
> Hi
> 
> I am trying to run  Apache Roller 
> <http://cwiki.apache.org/confluence/display/ROLLER> 3.0 on Geronimo 
> 1.1.1 but soon after startup (during the initial configuration steps) 
> hibernate is starting to throw
> org.hibernate.SessionException: Session is closed! exceptions (I am not 
> sure this is the course of the problems).
> 
> Dose anyone have a tutorial or a working configuration to share with the 
> public available ?
> I have searched the web for it but have only come up with outdated 
> information.
> Any help in resolving the problems is greatly appreciated.
> 
> Roller configuration changes:
> As I am using MySql 5.0.35 with (J/Connector 3.1.12) I have changed the 
> hibernate dialect accordingly
> hibernate.cfg.xml
>  :
> <!-- For MySQL 5.X, use the MySQL5 dialect and J/Connector 3.1.X  -->
> <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
>  :
> 
> Geronimo/Roller configuration
> 
> Created the mysql roller database and deployed the db plan
> Database plan:
> <?xml version="1.0" encoding="UTF-8"?>
> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
>   <dep:environment 
> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
>       <dep:moduleId>
>           <dep:groupId>console.dbpool</dep:groupId>
>           <dep:artifactId>MySqlDB_roller</dep:artifactId>
>           <dep:version>1.0</dep:version>
>           <dep:type>rar</dep:type>
>       </dep:moduleId>
>       <dep:dependencies>
>           <dep:dependency>
>               <dep:groupId>mysql</dep:groupId>
>               <dep:artifactId>mysql-connector-java</dep:artifactId>
>               <dep:version>3.1.12</dep:version>
>               <dep:type>jar</dep:type>
>           </dep:dependency>
>       </dep:dependencies>
>   </dep:environment>
>   <resourceadapter>
>       <outbound-resourceadapter>
>           <connection-definition>
>               
> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>

> 
>               <connectiondefinition-instance>
>                   <name>MySqlDB_roller</name>
>                   <config-property-setting 
> name="Password">thepw</config-property-setting>
>                   <config-property-setting 
> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
>                   <config-property-setting 
> name="UserName">thename</config-property-setting>
>                   <config-property-setting 
> name="ConnectionURL">jdbc:mysql://localhost:3306/roller</config-property-setting>

> 
>                   <connectionmanager>
>                       <local-transaction/>
>                       <single-pool>
>                           <max-size>10</max-size>
>                           <min-size>0</min-size>
>                           <match-one/>
>                       </single-pool>
>                   </connectionmanager>
>               </connectiondefinition-instance>
>           </connection-definition>
>       </outbound-resourceadapter>
>   </resourceadapter>
> </connector>
> 
> 
> geronimo-web.xml
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.1" 
> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1" 
> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1" 
> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
> <sys:environment>
>   <sys:moduleId>
>     <sys:groupId>m4u</sys:groupId>
>     <sys:artifactId>roller</sys:artifactId>
>     <sys:type>war</sys:type>
>   </sys:moduleId>
>     <sys:dependencies>
>     <sys:dependency>
>        <sys:groupId>console.dbpool</sys:groupId>
>        <sys:artifactId>MySqlDB_roller</sys:artifactId>
>     </sys:dependency>      </sys:dependencies>
> <!--    <hidden-classes>
>       <filter>antlr</filter>
>       <filter>org.springframework</filter>
>       <filter>org.apache.xerces</filter>
>       <filter>org.apache.commons.digester</filter>
>   </hidden-classes>
> -->                  </sys:environment>
> 
> <context-root>/roller</context-root>
>   <sys:resource-ref>
>    <sys:ref-name>jdbc/rollerdb</sys:ref-name>
>    <sys:resource-link>MySqlDB_roller</sys:resource-link>
> </sys:resource-ref>
> 
> </web-app>
> 
> setenv.sh:
> JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
> JAVA_OPTS="-Djava.awt.headless=true -XX:MaxPermSize=128m -Xms128M 
> -Xmx512M -server"
> 
> What am I missing or doing wrong here ? (or is there any known issues 
> running Roller on Geronimo)
> 
> /Peter
> 
> 

Mime
View raw message