Return-Path: 
 <user-return-6149-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 89811 invoked from network); 1 Mar 2007 08:55:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 1 Mar 2007 08:55:54 -0000
Received: (qmail 40202 invoked by uid 500); 1 Mar 2007 08:56:00 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 40182 invoked by uid 500); 1 Mar 2007 08:56:00 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 40169 invoked by uid 99); 1 Mar 2007 08:56:00 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Mar 2007 00:56:00 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (herse.apache.org: local policy)
Received: from [212.247.90.225] (HELO mail.scandorama.se) (212.247.90.225)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Mar 2007 00:55:48 -0800
Received: from localhost (kreon.scandorama.se [10.48.37.12])
	by mail.scandorama.se (Postfix) with ESMTP id E72E11191C
	for <user@geronimo.apache.org>; Thu,  1 Mar 2007 09:55:25 +0100 (CET)
Received: from mail.scandorama.se ([10.48.37.4])
	by localhost (kreon.scandorama.se [10.48.37.12]) (amavisd-new, port 10025)
	with ESMTP id 15167-02 for <user@geronimo.apache.org>;
	Thu, 1 Mar 2007 09:55:04 +0100 (CET)
Received: from [10.48.37.242] (dator-242.scandorama.se [10.48.37.242])
	by mail.scandorama.se (Postfix) with ESMTP id D643111926
	for <user@geronimo.apache.org>; Thu,  1 Mar 2007 09:54:34 +0100 (CET)
Message-ID: <45E694E9.6030205@pmb.mine.nu>
Date: Thu, 01 Mar 2007 09:55:05 +0100
From: Peter Petersson <peter@pmb.mine.nu>
User-Agent: Thunderbird 1.5.0.9 (X11/20070102)
MIME-Version: 1.0
To: user@geronimo.apache.org
Subject: Re: Runing  Apache Roller 3.0 on Geronimo 1.1.1
References: <45E1E283.3000801@pmb.mine.nu> <45E4C3A3.4060606@gmail.com>
In-Reply-To: <45E4C3A3.4060606@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Debian amavisd-new at kreon.scandorama.se
X-Virus-Checked: Checked by ClamAV on apache.org

Thanks for the info I will try it out but I am afraid there has been 
some changes in Roller 3.0 that may course my problems have you tried to 
install 3.0 ?
When I get time to look at your information and apply fixes to my build 
I will post info here.

Thanks
   Peter

Tim McConnell wrote:
> 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
>>
>>