archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Ernst ...@ae-online.de>
Subject Re: MariaDB
Date Wed, 25 Nov 2015 10:47:53 GMT
Hi Olivier,
Am 23.11.15 um 23:42 schrieb Olivier Lamy:
> Hi,
> I guess jetty.xml is specific to jetty container.
> So as you use Glassfish you must have a look at the Glassfish documentation
> and how to create datasources with Glassfish.

thanks for your answer. I know this, but i got the following entries in 
Glassfish:

jdbc/__default
mail/Session
mailSession
jdbc/users
jdbc/usersShutdown

But Archiva uses jdbc/__default and not jdbc/users. That is the issue. 
This seems to be the default. I can ping jdbc/users.

apache-archiva/WEB-INF/applicationContext.xml has this entry:

   <bean name="jdoFactory#users" 
class="org.apache.archiva.redback.components.jdo.DataSourceConfigurableJdoFactory">
     <property name="connectionFactoryName" 
value="java:comp/env/jdbc/users"/>
     <property name="shutdownConnectionFactoryName" 
value="java:comp/env/jdbc/usersShutdown"/>
     <property name="persistenceManagerFactoryClass" 
value="org.jpox.PersistenceManagerFactoryImpl"/>
     <property name="otherProperties">
       <props>
         <prop key="org.jpox.autoCreateSchema">true</prop>
         <prop key="org.jpox.validateTables">false</prop>
         <prop key="org.jpox.validateConstraints">false</prop>
         <prop key="org.jpox.validateColumns">false</prop>
         <prop key="org.jpox.autoStartMechanism">None</prop>
         <prop key="org.jpox.transactionIsolation">READ_COMMITTED</prop>
         <prop 
key="org.jpox.poid.transactionIsolation">READ_COMMITTED</prop>
         <prop key="org.jpox.rdbms.dateTimezone">JDK_DEFAULT_TIMEZONE</prop>
         <!-- NEEDED FOR MYSQL UTF-8 Databases -->
         <prop key="org.jpox.rdbms.stringDefaultLength">255</prop>

         <!-- NEEDED FOR POSTGRES, But causes problems in other JDBC 
implementations.
         <prop key="org.jpox.identifier.case">PreserveCase</prop>
         -->

         <!-- cache activation -->
         <prop key="org.jpox.cache.level2">true</prop>
         <prop key="org.jpox.cache.level2.type">ehcacheclassbased</prop>
         <prop key="org.jpox.cache.level2.cacheName">defaultJpox</prop>
         <prop 
key="org.jpox.cache.level2.configurationFile">/ehcache.xml</prop>
       </props>
     </property>
   </bean>


I got no idea, where to put the jdbc configuration. The Redback site 
http://archiva.apache.org/redback/configuration.html is not really helpful:

jdbc.driver.name=org.apache.derby.jdbc.EmbeddedDriver
jdbc.url=jdbc:derby:$plexus.home/database;create=true
jdbc.username=sa
jdbc.password=

Thanks
Andy
-- 
ae | Andreas Ernst | IT Spektrum
Postfach 5, 65612 Beselich
Schupbacher Str. 32, 65614 Beselich, Germany
Tel: +49-6484-91002 Fax: +49-6484-91003
ae@ae-online.de | www.ae-online.de
www.tachyon-online.de

Mime
View raw message