Quoting James Mitchell <[EMAIL PROTECTED]>: > > P.S. > > I'll be adding a few more items later tonight and/or this weekend: > - a build script in resources/contrib that let's us produce > a distribution of any single one of the implementations under > contrib > - a few docs > - tutorial on how to setup and use these impls. > - a plugin (location: jakarta-struts/contrib ????) that acts as > a wrapper to the current (Struts 1.1) message resources api. > This would let anyone use a current distribution of > commons-resources with Struts 1.1 (going for the > backwards-compatibility crowd) > > > Future: > - an iBatis implementation > - a Torque implementation > - a basic LDAP implementation > - a [?? enter your choice ??] implementation > - mods to all the current database impls that allow > datasource configuration/pooling via JNDI > > > Did I miss anything? >
This list sounds awesome ... thanks James! I agree that the Struts 1.1 wrapper should go in jakarta-struts/contrib ... perhaps a new "resources-wrapper" subdirectory? Craig > > -- > James Mitchell > Software Engineer / Struts Evangelist > http://www.struts-atlanta.org > 678.910.8017 (cell) > AIM: jmitchtx > MSN: [EMAIL PROTECTED] > > > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 06, 2004 8:26 AM > Subject: cvs commit: jakarta-commons-sandbox/resources/contrib/hibernate/sql > mysql.sql > > > > jmitchell 2004/02/06 05:26:09 > > > > Added: resources/contrib/hibernate/src/test hibernate.cfg.xml > > hibernate.properties log4j.properties > > oscache.properties > > > resources/contrib/hibernate/src/java/org/apache/commons/resources/impl > > HibernateBasicMessage.hbm.xml > > HibernateBasicMessage.java HibernateResources.java > > HibernateResourcesFactory.java > > > resources/contrib/hibernate/src/test/org/apache/commons/resources/impl > > HibernateResourcesTestCase.java > > resources/contrib/hibernate/sql mysql.sql > > Log: > > Add new Database implementation that uses the > > Hibernate O/R mapping framework. This particular > > contribution was fully tested with the latest release > > (2.1.2). > > > > Revision Changes Path > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/test/hibernate.cfg.x > ml > > > > Index: hibernate.cfg.xml > > =================================================================== > > <?xml version='1.0' encoding="UTF-8"?> > > <!DOCTYPE hibernate-configuration > > PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" > > "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd";> > > > > <hibernate-configuration> > > > > <session-factory> > > > > <!-- database connection --> > > <property > name="hibernate.dialect">net.sf.hibernate.dialect.MySQLDialect.java</propert > y> > > <property > name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property> > > <property > name="hibernate.connection.url">jdbc:mysql://localhost/resources</property> > > <property > name="hibernate.connection.username">resourcesTest</property> > > <property > name="hibernate.connection.password">resourcesTest</property> > > <property name="hibernate.connection.pool_size">4</property> > > <property name="hibernate.statement_cache.size">100</property> > > <property name="hibernate.show_sql">true</property> > > <property name="hibernate.jdbc.batch_size">0</property> > > <property > name="hibernate.cglib.use_reflection_optimizer">true</property> > > > > <mapping > resource="org/apache/commons/resources/impl/HibernateBasicMessage.hbm.xml"/> > > > > </session-factory> > > > > </hibernate-configuration> > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/test/hibernate.prope > rties > > > > Index: hibernate.properties > > =================================================================== > > ###################### > > ### Query Language ### > > ###################### > > > > ## define query language constants / function names > > > > hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N' > > > > > > > > ################# > > ### Platforms ### > > ################# > > > > ## JNDI Datasource > > > > #hibernate.connection.datasource jdbc/test > > #hibernate.connection.username db2 > > #hibernate.connection.password db2 > > > > > > ## HypersonicSQL > > > > hibernate.dialect net.sf.hibernate.dialect.HSQLDialect > > hibernate.connection.driver_class org.hsqldb.jdbcDriver > > hibernate.connection.username sa > > hibernate.connection.password > > hibernate.connection.url jdbc:hsqldb:hsql://localhost > > hibernate.connection.url jdbc:hsqldb:test > > hibernate.connection.url jdbc:hsqldb:. > > > > > > ## PostgreSQL > > > > #hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect > > #hibernate.connection.driver_class org.postgresql.Driver > > #hibernate.connection.url jdbc:postgresql:template1 > > #hibernate.connection.username pg > > #hibernate.connection.password > > #hibernate.query.substitutions yes 'Y', no 'N' > > > > > > ## DB2 > > > > #hibernate.dialect net.sf.hibernate.dialect.DB2Dialect > > #hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver > > #hibernate.connection.url jdbc:db2:test > > #hibernate.connection.username db2 > > #hibernate.connection.password db2 > > > > > > ## DB2/400 > > > > #hibernate.dialect net.sf.hibernate.dialect.DB2400Dialect > > #hibernate.connection.username user > > #hibernate.connection.password password > > > > ## Native driver > > #hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver > > #hibernate.connection.url jdbc:db2://systemname > > > > ## Toolbox driver > > #hibernate.connection.driver_class com.ibm.as400.access.AS400JDBCDriver > > #hibernate.connection.url jdbc:as400://systemname > > > > > > ## MySQL > > > > #hibernate.dialect net.sf.hibernate.dialect.MySQLDialect > > #hibernate.connection.driver_class org.gjt.mm.mysql.Driver > > #hibernate.connection.driver_class com.mysql.jdbc.Driver > > #hibernate.connection.url jdbc:mysql:///test > > #hibernate.connection.username root > > #hibernate.connection.password > > > > > > ## Oracle > > > > #hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect > > #hibernate.dialect net.sf.hibernate.dialect.OracleDialect > > #hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver > > #hibernate.connection.username ora > > #hibernate.connection.password ora > > #hibernate.connection.url jdbc:oracle:thin:@localhost:1521:test > > > > > > ## Sybase > > > > #hibernate.dialect net.sf.hibernate.dialect.SybaseDialect > > #hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver > > #hibernate.connection.username sa > > #hibernate.connection.password sasasa > > #hibernate.connection.rl jdbc:sybase:Tds:co3061835-a:5000/tempdb > > > > > > ## Mckoi SQL > > > > #hibernate.dialect net.sf.hibernate.dialect.MckoiDialect > > #hibernate.connection.driver_class com.mckoi.JDBCDriver > > #hibernate.connection.url jdbc:mckoi:/// > > #hibernate.connection.url jdbc:mckoi:local://C:/mckoi1.00/db.conf > > #hibernate.connection.username admin > > #hibernate.connection.password nimda > > > > > > ## SAP DB > > > > #hibernate.dialect net.sf.hibernate.dialect.SAPDBDialect > > #hibernate.connection.driver_class com.sap.dbtech.jdbc.DriverSapDB > > #hibernate.connection.url jdbc:sapdb://localhost/TST > > #hibernate.connection.username TEST > > #hibernate.connection.password TEST > > #hibernate.query.substitutions yes 'Y', no 'N' > > > > > > ## MS SQL Server > > > > #hibernate.dialect net.sf.hibernate.dialect.SQLServerDialect > > #hibernate.connection.username sa > > #hibernate.connection.password sa > > > > ## JSQL Driver > > #hibernate.connection.driver_class com.jnetdirect.jsql.JSQLDriver > > #hibernate.connection.url jdbc:JSQLConnect://1E1/test > > > > ## JTURBO Driver > > #hibernate.connection.driver_class com.newatlanta.jturbo.driver.Driver > > #hibernate.connection.url jdbc:JTurbo://1E1:1433/test > > > > ## WebLogic Driver > > #hibernate.connection.driver_class weblogic.jdbc.mssqlserver4.Driver > > #hibernate.connection.url jdbc:weblogic:mssqlserver4:1E1:1433 > > > > ## Microsoft Driver (not recommended!) > > #hibernate.connection.driver_class > com.microsoft.jdbc.sqlserver.SQLServerDriver > > #hibernate.connection.url > jdbc:microsoft:sqlserver://1E1;DatabaseName=test;SelectMethod=cursor > > > > ## jTDS (not supported!) > > #hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver > > #hibernate.connection.url > jdbc:jtds:sqlserver://1E1/test;SelectMethod=cursor > > #hibernate.jdbc.use_scrollable_resultset false > > > > ## Interbase > > > > #hibernate.dialect net.sf.hibernate.dialect.InterbaseDialect > > #hibernate.connection.username sysdba > > #hibernate.connection.password masterkey > > > > ## DO NOT specify hibernate.connection.sqlDialect > > > > ## InterClient > > > > #hibernate.connection.driver_class interbase.interclient.Driver > > #hibernate.connection.url > jdbc:interbase://localhost:3060/C:/firebird/test.gdb > > > > ## Pure Java > > > > #hibernate.connection.driver_class org.firebirdsql.jdbc.FBDriver > > #hibernate.connection.url > jdbc:firebirdsql:localhost/3050:/firebird/test.gdb > > > > > > ## Pointbase > > > > #hibernate.dialect net.sf.hibernate.dialect.PointbaseDialect > > #hibernate.connection.driver_class > com.pointbase.jdbc.jdbcUniversalDriver > > #hibernate.connection.url jdbc:pointbase:embedded:sample > > #hibernate.connection.username PBPUBLIC > > #hibernate.connection.password PBPUBLIC > > > > > > > > ################################# > > ### Hibernate Connection Pool ### > > ################################# > > > > hibernate.connection.pool_size 1 > > > > > > > > ########################### > > ### C3P0 Connection Pool### > > ########################### > > > > #hibernate.c3p0.max_size 2 > > #hibernate.c3p0.min_size 2 > > #hibernate.c3p0.timeout 5000 > > #hibernate.c3p0.max_statements 100 > > #hibernate.c3p0.idle_test_period 3000 > > #hibernate.c3p0.acquire_increment 2 > > ##hibernate.c3p0.validate false > > > > > > > > ################################### > > ### Apache DBCP Connection Pool ### > > ################################### > > > > ## connection pool > > > > #hibernate.dbcp.maxActive 100 > > #hibernate.dbcp.whenExhaustedAction 1 > > #hibernate.dbcp.maxWait 120000 > > #hibernate.dbcp.maxIdle 10 > > > > ## prepared statement cache > > > > #hibernate.dbcp.ps.maxActive 100 > > #hibernate.dbcp.ps.whenExhaustedAction 1 > > #hibernate.dbcp.ps.maxWait 120000 > > #hibernate.dbcp.ps.maxIdle 10 > > > > ## optional query to validate pooled connections: > > > > #hibernate.dbcp.validationQuery select 1 from dual > > #hibernate.dbcp.testOnBorrow true > > #hibernate.dbcp.testOnReturn false > > > > > > > > ############################## > > ### Proxool Connection Pool### > > ############################## > > > > ## Properties for external configuration of Proxool > > > > hibernate.proxool.pool_alias pool1 > > > > ## Only need one of the following > > > > #hibernate.proxool.existing_pool true > > #hibernate.proxool.xml proxool.xml > > #hibernate.proxool.properties proxool.properties > > > > ## Or, alternatively, all of these > > ## Standard configuration properties of Proxool > > > > #hibernate.proxool.house-keeping-sleep-time 30000 > > #hibernate.proxool.house-keeping-test-sql > > #hibernate.proxool.maximum-connection-count 4 > > #hibernate.proxool.maximum-connection-lifetime 4 > > #hibernate.proxool.simultaneous-build-throttle 2 > > #hibernate.proxool.maximum-active-time 500 > > #hibernate.proxool.minimum-connection-count 2 > > #hibernate.proxool.fatal-sql-exception > > #hibernate.proxool.prototype-count > > #hibernate.proxool.statistics > > #hibernate.proxool.recently-started-threshold > > #hibernate.proxool.overload-without-refusal-lifetime > > > > > > > > ################################# > > ### Plugin ConnectionProvider ### > > ################################# > > > > ## use a custom ConnectionProvider (if not set, Hibernate will choose a > built-in ConnectionProvider using hueristics) > > > > #hibernate.connection.provider_class > net.sf.hibernate.connection.DriverManagerConnectionProvider > > #hibernate.connection.provider_class > net.sf.hibernate.connection.DatasourceConnectionProvider > > #hibernate.connection.provider_class > net.sf.hibernate.connection.C3P0ConnectionProvider > > #hibernate.connection.provider_class > net.sf.hibernate.connection.DBCPConnectionProvider > > #hibernate.connection.provider_class > net.sf.hibernate.connection.ProxoolConnectionProvider > > > > > > > > ####################### > > ### Transaction API ### > > ####################### > > > > ## the Transaction API abstracts application code from the underlying > JTA or JDBC transactions > > > > #hibernate.transaction.factory_class > net.sf.hibernate.transaction.JTATransactionFactory > > #hibernate.transaction.factory_class > net.sf.hibernate.transaction.JDBCTransactionFactory > > > > > > ## to use JTATransactionFactory, Hibernate must be able to locate the > UserTransaction in JNDI > > ## default is java:comp/UserTransaction > > ## you do NOT need this setting if you specify > hibernate.transaction.manager_lookup_class > > > > #jta.UserTransaction jta/usertransaction > > #jta.UserTransaction javax.transaction.UserTransaction > > #jta.UserTransaction UserTransaction > > > > > > ## to use JCS caching with JTA, Hibernate must be able to obtain the JTA > TransactionManager > > > > #hibernate.transaction.manager_lookup_class > net.sf.hibernate.transaction.JBossTransactionManagerLookup > > #hibernate.transaction.manager_lookup_class > net.sf.hibernate.transaction.WeblogicTransactionManagerLookup > > #hibernate.transaction.manager_lookup_class > net.sf.hibernate.transaction.WebSphereTransactionManagerLookup > > #hibernate.transaction.manager_lookup_class > net.sf.hibernate.transaction.OrionTransactionManagerLookup > > #hibernate.transaction.manager_lookup_class > net.sf.hibernate.transaction.ResinTransactionManagerLookup > > > > > > > > ############################## > > ### Miscellaneous Settings ### > > ############################## > > > > ## print all generated SQL to the console > > > > #hibernate.show_sql true > > > > > > ## auto schema export > > > > #hibernate.hbm2ddl.auto create-drop > > #hibernate.hbm2ddl.auto create > > #hibernate.hbm2ddl.auto update > > > > > > ## specify a JDBC isolation level > > > > #hibernate.connection.isolation 4 > > > > > > ## set the JDBC fetch size > > > > #hibernate.jdbc.fetch_size 25 > > > > > > ## set the maximum JDBC 2 batch size (a nonzero value enables batching) > > > > hibernate.jdbc.batch_size 0 > > > > > > ## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will > cause Hibernate to use a sensible default) > > > > #hibernate.jdbc.use_scrollable_resultset true > > > > > > ## use streams when writing binary types to / from JDBC > > > > hibernate.jdbc.use_streams_for_binary true > > > > > > ## use JDBC 3 PreparedStatement.getGeneratedKeys to get the identifier > of an inserted row > > > > #hibernate.jdbc.use_get_generated_keys true > > > > > > ## specify a default schema for unqualified tablenames > > > > #hibernate.default_schema test > > > > > > ## use a custom stylesheet for XML generation (if not specified, > hibernate-default.xslt will be used) > > > > #hibernate.xml.output_stylesheet > C:/Hibernate/net/sf/hibernate/hibernate-default.xslt > > > > > > ## enable outerjoin fetching (specifying a Dialect will cause Hibernate > to use sensible default) > > > > #hibernate.use_outer_join false > > > > > > ## set the maximum depth of the outer join fetch tree > > > > hibernate.max_fetch_depth 1 > > > > > > ## enable CGLIB reflection optimizer (enabled by default) > > > > #hibernate.cglib.use_reflection_optimizer false > > > > > > > > ########################## > > ### Second-level Cache ### > > ########################## > > > > ## optimize chache for minimal "puts" instead of minimal "gets" (good > for clustered cache) > > > > #hibernate.cache.use_minimal_puts true > > > > > > ## enable the query cache > > > > hibernate.cache.use_query_cache true > > > > > > ## choose a cache implementation > > > > #hibernate.cache.provider_class net.sf.ehcache.hibernate.Provider > > #hibernate.cache.provider_class > net.sf.hibernate.cache.EmptyCacheProvider > > hibernate.cache.provider_class > net.sf.hibernate.cache.HashtableCacheProvider > > #hibernate.cache.provider_class net.sf.hibernate.cache.TreeCacheProvider > > #hibernate.cache.provider_class net.sf.hibernate.cache.OSCacheProvider > > #hibernate.cache.provider_class net.sf.hibernate.cache.JCSCacheProvider > > #hibernate.cache.provider_class > net.sf.hibernate.cache.SwarmCacheProvider > > > > > > > > ############ > > ### JNDI ### > > ############ > > > > ## specify a JNDI name for the SessionFactory > > > > #hibernate.session_factory_name hibernate/session_factory > > > > > > ## Hibernate uses JNDI to bind a name to a SessionFactory and to look up > the JTA UserTransaction; > > ## if hibernate.jndi.* are not specified, Hibernate will use the default > InitialContext() which > > ## is the best approach in an application server > > > > #file system > > #hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory > > #hibernate.jndi.url file:/ > > > > #WebSphere > > #hibernate.jndi.class com.ibm.websphere.naming.WsnInitialContextFactory > > #hibernate.jndi.url iiop://localhost:900/ > > > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/test/log4j.propertie > s > > > > Index: log4j.properties > > =================================================================== > > ### direct log messages to stdout ### > > log4j.appender.stdout=org.apache.log4j.ConsoleAppender > > log4j.appender.stdout.Target=System.out > > log4j.appender.stdout.layout=org.apache.log4j.PatternLayout > > log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p > %c{1}:%L - %m%n > > > > ### direct messages to file hibernate.log ### > > #log4j.appender.file=org.apache.log4j.FileAppender > > #log4j.appender.file.File=hibernate.log > > #log4j.appender.file.layout=org.apache.log4j.PatternLayout > > #log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p > %c{1}:%L - %m%n > > > > ### set log levels - for more verbose logging change 'info' to 'debug' > ### > > > > log4j.rootLogger=warn, stdout > > > > log4j.logger.net.sf.hibernate=info > > > > ### log just the SQL > > #log4j.logger.net.sf.hibernate.SQL=debug > > > > ### log JDBC bind parameters ### > > log4j.logger.net.sf.hibernate.type=info > > > > ### log schema export/update ### > > log4j.logger.net.sf.hibernate.tool.hbm2ddl=debug > > > > ### log cache activity ### > > #log4j.logger.net.sf.hibernate.cache=debug > > > > ### enable the following line if you want to track down connection ### > > ### leakages when using DriverManagerConnectionProvider ### > > > #log4j.logger.net.sf.hibernate.connection.DriverManagerConnectionProvider=tr > ace > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/test/oscache.propert > ies > > > > Index: oscache.properties > > =================================================================== > > # CACHE IN MEMORY > > # > > # If you want to disable memory caching, just uncomment this line. > > # > > # cache.memory=false > > > > > > # CACHE KEY > > # > > # This is the key that will be used to store the cache in the > application > > # and session scope. > > # > > # If you want to set the cache key to anything other than the default > > # uncomment this line and change the cache.key > > # > > # cache.key=__oscache_cache > > > > > > # USE HOST DOMAIN NAME IN KEY > > # > > # Servers for multiple host domains may wish to add host name info to > > # the generation of the key. If this is true, then uncomment the > > # following line. > > # > > # cache.use.host.domain.in.key=true > > > > > > # CACHE LISTENERS > > # > > # These hook OSCache events and perform various actions such as logging > > # cache hits and misses, or broadcasting to other cache instances across > a cluster. > > # See the documentation for further information. > > # > > # > cache.event.listeners=com.opensymphony.oscache.plugins.clustersupport.JMSBro > adcastingListener, \ > > # > com.opensymphony.oscache.extra.CacheEntryEventListenerImpl, \ > > # > com.opensymphony.oscache.extra.CacheMapAccessEventListenerImpl, \ > > # > com.opensymphony.oscache.extra.ScopeEventListenerImpl > > > > > > # CACHE PERSISTENCE CLASS > > # > > # Specify the class to use for persistence. If you use the supplied > DiskPersistenceListener, > > # don't forget to supply the cache.path property to specify the location > of the cache > > # directory. > > # > > # If a persistence class is not specified, OSCache will use memory > caching only. > > # > > # > cache.persistence.class=com.opensymphony.oscache.plugins.diskpersistence.Dis > kPersistenceListener > > > > > > # CACHE DIRECTORY > > # > > # This is the directory on disk where caches will be stored by the > DiskPersistenceListener. > > # it will be created if it doesn't already exist. Remember that OSCache > must have > > # write permission to this directory. > > # > > # Note: for Windows machines, this needs \ to be escaped > > # ie Windows: > > # cache.path=c:\\myapp\\cache > > # or *ix: > > # cache.path=/opt/myapp/cache > > # > > # cache.path=c:\\app\\cache > > > > > > # CACHE ALGORITHM > > # > > # Default cache algorithm to use. Note that in order to use an algorithm > > # the cache size must also be specified. If the cache size is not > specified, > > # the cache algorithm will be Unlimited cache. > > # > > # cache.algorithm=com.opensymphony.oscache.base.algorithm.LRUCache > > # cache.algorithm=com.opensymphony.oscache.base.algorithm.FIFOCache > > # cache.algorithm=com.opensymphony.oscache.base.algorithm.UnlimitedCache > > > > > > # CACHE SIZE > > # > > # Default cache size in number of items. If a size is specified but not > > # an algorithm, the cache algorithm used will be LRUCache. > > # > > cache.capacity=1000 > > > > > > # CACHE UNLIMITED DISK > > # Use unlimited disk cache or not. The default value is false, which > means > > # the disk cache will be limited in size to the value specified by > cache.capacity. > > # > > # cache.unlimited.disk=false > > > > > > # JMS CLUSTER PROPERTIES > > # > > # Configuration properties for JMS clustering. See the clustering > documentation > > # for more information on these settings. > > # > > > #cache.cluster.jms.topic.factory=java:comp/env/jms/TopicConnectionFactory > > #cache.cluster.jms.topic.name=java:comp/env/jms/OSCacheTopic > > #cache.cluster.jms.node.name=node1 > > > > > > # JAVAGROUPS CLUSTER PROPERTIES > > # > > # Configuration properites for the JavaGroups clustering. Only one of > these > > # should be specified. Default values (as shown below) will be used if > niether > > # property is set. See the clustering documentation and the JavaGroups > project > > # (www.javagroups.com) for more information on these settings. > > # > > > #cache.cluster.properties=UDP(mcast_addr=231.12.21.132;mcast_port=45566;ip_t > tl=32;mcast_send_buf_size=150000;mcast_recv_buf_size=80000):PING(timeout=200 > 0;num_initial_members=3):MERGE2(min_interval=5000;max_interval=10000):FD_SOC > K:VERIFY_SUSPECT(timeout=1500):pbcast.NAKACK(gc_lag=50;retransmit_timeout=30 > 0,600,1200,2400,4800):pbcast.STABLE(desired_avg_gossip=20000):UNICAST(timeou > t=5000):FRAG(frag_size=8096;down_thread=false;up_thread=false):pbcast.GMS(jo > in_timeout=5000;join_retry_timeout=2000;shun=false;print_local_addr=true) > > #cache.cluster.multicast.ip=231.12.21.132 > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/apache/comm > ons/resources/impl/HibernateBasicMessage.hbm.xml > > > > Index: HibernateBasicMessage.hbm.xml > > =================================================================== > > <?xml version="1.0"?> > > <!DOCTYPE hibernate-mapping SYSTEM > > "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd";> > > > > > > <hibernate-mapping> > > > > <class > name="org.apache.commons.resources.impl.HibernateBasicMessage" > table="resources"> > > > > <composite-id> > > <key-property name="locale" type="java.lang.String" column="locale"/> > > <key-property name="key" type="java.lang.String" column="msgKey"/> > > </composite-id> > > > > <property name="value" type="java.lang.String" column="val"/> > > </class> > > > > <query name="QueryByLocale"> > > > > from > > org.apache.commons.resources.impl.HibernateBasicMessage as msgRes > > where > > msgRes.locale = ? > > > > </query> > > > > </hibernate-mapping> > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/apache/comm > ons/resources/impl/HibernateBasicMessage.java > > > > Index: HibernateBasicMessage.java > > =================================================================== > > /* > > * $Header: > /home/cvs/jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/a > pache/commons/resources/impl/HibernateBasicMessage.java,v 1.1 2004/02/06 > 13:26:09 jmitchell Exp $ > > * $Revision: 1.1 $ > > * $Date: 2004/02/06 13:26:09 $ > > * > > * ==================================================================== > > * > > * The Apache Software License, Version 1.1 > > * > > * Copyright (c) 1999-2003 The Apache Software Foundation. All rights > > * reserved. > > * > > * Redistribution and use in source and binary forms, with or without > > * modification, are permitted provided that the following conditions > > * are met: > > * > > * 1. Redistributions of source code must retain the above copyright > > * notice, this list of conditions and the following disclaimer. > > * > > * 2. Redistributions in binary form must reproduce the above copyright > > * notice, this list of conditions and the following disclaimer in > > * the documentation and/or other materials provided with the > > * distribution. > > * > > * 3. The end-user documentation included with the redistribution, if > > * any, must include the following acknowledgement: > > * "This product includes software developed by the > > * Apache Software Foundation (http://www.apache.org/)." > > * Alternately, this acknowledgement may appear in the software > itself, > > * if and wherever such third-party acknowledgements normally appear. > > * > > * 4. The names, "Apache", "The Jakarta Project", "Commons", and "Apache > Software > > * Foundation" must not be used to endorse or promote products > derived > > * from this software without prior written permission. For written > > * permission, please contact [EMAIL PROTECTED] > > * > > * 5. Products derived from this software may not be called "Apache" > > * nor may "Apache" appear in their name, without prior written > > * permission of the Apache Software Foundation. > > * > > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > > * SUCH DAMAGE. > > * ==================================================================== > > * > > * This software consists of voluntary contributions made by many > > * individuals on behalf of the Apache Software Foundation. For more > > * information on the Apache Software Foundation, please see > > * <http://www.apache.org/>. > > * > > */ > > > > package org.apache.commons.resources.impl; > > > > > > /** > > * BasicMessage to allow standard Hibernate > > * configuration (no complex keys). > > * > > * @author James Mitchell > > * > > */ > > public class HibernateBasicMessage extends BasicMessage { > > > > public HibernateBasicMessage() { > > super(); > > } > > /** > > * > > * @param id The id (primary key) for this message. > > * @param locale The locale used to retrieve the value for the > specified key > > * @param key The key for this message. > > * @param value The value for this message. > > */ > > public HibernateBasicMessage(Long id, String locale, String key, > Object[] values) { > > super(key, values); > > this.id = id; > > this.locale = locale; > > > > } > > > > private Long id = null; > > private String locale = null; > > > > /** > > * @return Returns the id. > > */ > > public Long getId() { > > return id; > > } > > > > /** > > * @param id The id to set. > > */ > > public void setId(Long id) { > > this.id = id; > > } > > /** > > * @return Returns the locale. > > */ > > public String getLocale() { > > return locale; > > } > > /** > > * @param locale The locale to set. > > */ > > public void setLocale(String locale) { > > this.locale = locale; > > } > > > > public void setKey(String key) { > > this.key = key; > > } > > public void setValue(String value) { > > this.values = new String[]{value}; > > } > > public String getValue() { > > if (values == null || values.length < 1) { > > throw new IllegalStateException("The retrived value for msg > " + > > this.key + "was null"); > > } > > if (values.length > 1) { > > throw new IllegalStateException("There were more than one > values " + > > "retrived value for msg " + > > this.key); > > } > > return (String)getValues()[0]; > > } > > > > public boolean equals(Object obj) { > > return super.equals(obj); > > } > > > > public int hashCode() { > > return super.hashCode(); > > } > > } > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/apache/comm > ons/resources/impl/HibernateResources.java > > > > Index: HibernateResources.java > > =================================================================== > > /* > > * $Header: > /home/cvs/jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/a > pache/commons/resources/impl/HibernateResources.java,v 1.1 2004/02/06 > 13:26:09 jmitchell Exp $ > > * $Revision: 1.1 $ > > * $Date: 2004/02/06 13:26:09 $ > > * > > * ==================================================================== > > * > > * The Apache Software License, Version 1.1 > > * > > * Copyright (c) 1999-2003 The Apache Software Foundation. All rights > > * reserved. > > * > > * Redistribution and use in source and binary forms, with or without > > * modification, are permitted provided that the following conditions > > * are met: > > * > > * 1. Redistributions of source code must retain the above copyright > > * notice, this list of conditions and the following disclaimer. > > * > > * 2. Redistributions in binary form must reproduce the above copyright > > * notice, this list of conditions and the following disclaimer in > > * the documentation and/or other materials provided with the > > * distribution. > > * > > * 3. The end-user documentation included with the redistribution, if > > * any, must include the following acknowledgement: > > * "This product includes software developed by the > > * Apache Software Foundation (http://www.apache.org/)." > > * Alternately, this acknowledgement may appear in the software > itself, > > * if and wherever such third-party acknowledgements normally appear. > > * > > * 4. The names, "Apache", "The Jakarta Project", "Commons", and "Apache > Software > > * Foundation" must not be used to endorse or promote products > derived > > * from this software without prior written permission. For written > > * permission, please contact [EMAIL PROTECTED] > > * > > * 5. Products derived from this software may not be called "Apache" > > * nor may "Apache" appear in their name, without prior written > > * permission of the Apache Software Foundation. > > * > > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > > * SUCH DAMAGE. > > * ==================================================================== > > * > > * This software consists of voluntary contributions made by many > > * individuals on behalf of the Apache Software Foundation. For more > > * information on the Apache Software Foundation, please see > > * <http://www.apache.org/>. > > * > > */ > > > > package org.apache.commons.resources.impl; > > > > import java.util.Iterator; > > import java.util.List; > > import java.util.Locale; > > import java.util.Map; > > import java.util.Properties; > > > > import net.sf.hibernate.HibernateException; > > import net.sf.hibernate.Query; > > import net.sf.hibernate.Session; > > import net.sf.hibernate.SessionFactory; > > import net.sf.hibernate.cfg.Configuration; > > > > import org.apache.commons.logging.Log; > > import org.apache.commons.logging.LogFactory; > > import org.apache.commons.resources.ResourcesException; > > > > /** > > * <p>Concrete implementation of > > * [EMAIL PROTECTED] org.apache.commons.resources.Resources} that wraps a > > * Hibernate session and retrieves values for the given > > * <code>Locale</code> and have name suffixes reflecting the > > * <code>Locale</code> for which the document's messages apply. > > * For this specific implementation, resources are looked up in > > * a hierarchy of database values in a manner identical to that > > * performed by <code>java.util.ResourceBundle.getBundle().</code>. > > * </p> > > * > > * <p>The base URL passed to our constructor must contain the base name > > * of a the hibernate configuration file.</p> > > * > > * @author James Mitchell > > * @version $Revision: 1.1 $ $Date: 2004/02/06 13:26:09 $ > > */ > > public class HibernateResources extends CollectionResourcesBase { > > > > /** > > * <p>The <code>Log</code> instance for this class.</p> > > */ > > private static final Log log = > LogFactory.getLog(HibernateResources.class); > > > > // ----------------------------------------------------------- > Constructors > > > > /** > > * <p>Create a new > > * [EMAIL PROTECTED] org.apache.commons.resources.Resources} instance with > > the > specified > > * logical name and base resource URL.</p> > > * > > * @param name Logical name of the new instance > > * @param base Base URL of the Hibernate configuration file. > > */ > > public HibernateResources(String name, String base) { > > super(name, base); > > } > > > > > > // ------------------------------------------------------ Protected > Methods > > > > > > /** > > * <p>Return a <code>Map</code> containing the name-value mappings > for > > * the specified base URL and requested <code>Locale</code>, if > there > > * are any. If there are no defined mappings for the specified > > * <code>Locale</code>, return an empty <code>Map</code> > instead.</p> > > * > > * <p>Concrete subclasses must override this method to perform the > > * appropriate lookup. A typical implementation will construct an > > * absolute URL based on the specified base URL and > <code>Locale</code>, > > * retrieve the specified resource file (if any), and parse it into > > * a <code>Map</code> structure.</p> > > * > > * <p>Caching of previously retrieved <code>Map</code>s (if any) > should > > * be performed by callers of this method. Therefore, this method > should > > * always attempt to retrieve the specified resource and load it > > * appropriately.</p> > > * > > * @param baseUrl Base URL of the resource files for this > > * [EMAIL PROTECTED] org.apache.commons.resources.Resources} instance > > * @param locale <code>Locale</code> for which name-value mappings > > * are requested > > */ > > protected Map getLocaleMap(String baseUrl, Locale locale) { > > > > if (log.isDebugEnabled()) { > > log.debug("Loading database configuration'" + locale + "' > resources from base '" + > > baseUrl + "'"); > > } > > > > Properties props = new Properties(); > > Session session = null; > > try { > > // TODO - change this to load the specified hibernate config > file (baseUrl) > > SessionFactory sessionFactory = > > new Configuration().configure().buildSessionFactory(); > > session = sessionFactory.openSession(); > > Query q = session.getNamedQuery("QueryByLocale"); > > q.setString(0, locale.toString()); > > q.list(); > > List msgs = q.list(); > > for (Iterator iter = msgs.iterator(); iter.hasNext();) { > > HibernateBasicMessage msg = (HibernateBasicMessage) > iter.next(); > > props.put(msg.getKey(), msg.getValue()); > > } > > session.close(); > > > > } catch (HibernateException e) { > > e.printStackTrace(); > > } > > > > return props; > > > > > > > > } > > > > > > public void init() throws ResourcesException { > > super.init(); > > } > > } > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/apache/comm > ons/resources/impl/HibernateResourcesFactory.java > > > > Index: HibernateResourcesFactory.java > > =================================================================== > > /* > > * $Header: > /home/cvs/jakarta-commons-sandbox/resources/contrib/hibernate/src/java/org/a > pache/commons/resources/impl/HibernateResourcesFactory.java,v 1.1 2004/02/06 > 13:26:09 jmitchell Exp $ > > * $Revision: 1.1 $ > > * $Date: 2004/02/06 13:26:09 $ > > * > > * ==================================================================== > > * > > * The Apache Software License, Version 1.1 > > * > > * Copyright (c) 1999-2003 The Apache Software Foundation. All rights > > * reserved. > > * > > * Redistribution and use in source and binary forms, with or without > > * modification, are permitted provided that the following conditions > > * are met: > > * > > * 1. Redistributions of source code must retain the above copyright > > * notice, this list of conditions and the following disclaimer. > > * > > * 2. Redistributions in binary form must reproduce the above copyright > > * notice, this list of conditions and the following disclaimer in > > * the documentation and/or other materials provided with the > > * distribution. > > * > > * 3. The end-user documentation included with the redistribution, if > > * any, must include the following acknowledgement: > > * "This product includes software developed by the > > * Apache Software Foundation (http://www.apache.org/)." > > * Alternately, this acknowledgement may appear in the software > itself, > > * if and wherever such third-party acknowledgements normally appear. > > * > > * 4. The names, "Apache", "The Jakarta Project", "Commons", and "Apache > Software > > * Foundation" must not be used to endorse or promote products > derived > > * from this software without prior written permission. For written > > * permission, please contact [EMAIL PROTECTED] > > * > > * 5. Products derived from this software may not be called "Apache" > > * nor may "Apache" appear in their name, without prior written > > * permission of the Apache Software Foundation. > > * > > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > > * SUCH DAMAGE. > > * ==================================================================== > > * > > * This software consists of voluntary contributions made by many > > * individuals on behalf of the Apache Software Foundation. For more > > * information on the Apache Software Foundation, please see > > * <http://www.apache.org/>. > > * > > */ > > > > package org.apache.commons.resources.impl; > > > > import org.apache.commons.resources.Resources; > > import org.apache.commons.resources.ResourcesException; > > > > /** > > * <p>Concrete implementation of > > * [EMAIL PROTECTED] org.apache.commons.resources.ResourcesFactory} that creates > > * [EMAIL PROTECTED] org.apache.commons.resources.Resources} instances that wraps > > * a Hibernate session and retrieves values for the given > > * <code>Locale</code> and have name suffixes reflecting the > > * <code>Locale</code> for which the document's messages apply. > > * For this specific implementation, resources are looked up in > > * a hierarchy of database values in a manner identical to that > > * performed by <code>java.util.ResourceBundle.getBundle().</code>. > > * > > * @author James Mitchell > > * @version $Revision: 1.1 $ > > */ > > public class HibernateResourcesFactory extends ResourcesFactoryBase { > > > > > > // ------------------------------------------------------ Protected > Methods > > > > > > /** > > * <p>Create and return a new [EMAIL PROTECTED] > org.apache.commons.resources.Resources} > > * instance with the specified logical name, after calling its > <code>init()</code> > > * method and delegating the relevant properties.</p> > > * > > * @param name Logical name of the [EMAIL PROTECTED] > org.apache.commons.resources.Resources} > > * instance to create > > * > > * @param config Configuration string for this resource (if any) > > * > > * @exception ResourcesException if a [EMAIL PROTECTED] > org.apache.commons.resources.Resources} > > * instance of the specified logical name cannot be created. > > */ > > protected Resources createResources(String name, String config) > > throws ResourcesException { > > > > Resources res = new HibernateResources(name, config); > > res.setReturnNull(isReturnNull()); > > res.init(); > > return (res); > > > > } > > > > > > } > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/src/test/org/apache/comm > ons/resources/impl/HibernateResourcesTestCase.java > > > > Index: HibernateResourcesTestCase.java > > =================================================================== > > /* > > * $Header: > /home/cvs/jakarta-commons-sandbox/resources/contrib/hibernate/src/test/org/a > pache/commons/resources/impl/HibernateResourcesTestCase.java,v 1.1 > 2004/02/06 13:26:09 jmitchell Exp $ > > * $Revision: 1.1 $ > > * $Date: 2004/02/06 13:26:09 $ > > * > > * ==================================================================== > > * > > * The Apache Software License, Version 1.1 > > * > > * Copyright (c) 1999-2003 The Apache Software Foundation. All rights > > * reserved. > > * > > * Redistribution and use in source and binary forms, with or without > > * modification, are permitted provided that the following conditions > > * are met: > > * > > * 1. Redistributions of source code must retain the above copyright > > * notice, this list of conditions and the following disclaimer. > > * > > * 2. Redistributions in binary form must reproduce the above copyright > > * notice, this list of conditions and the following disclaimer in > > * the documentation and/or other materials provided with the > > * distribution. > > * > > * 3. The end-user documentation included with the redistribution, if > > * any, must include the following acknowledgement: > > * "This product includes software developed by the > > * Apache Software Foundation (http://www.apache.org/)." > > * Alternately, this acknowledgement may appear in the software > itself, > > * if and wherever such third-party acknowledgements normally appear. > > * > > * 4. The names, "Apache", "The Jakarta Project", "Commons", and "Apache > Software > > * Foundation" must not be used to endorse or promote products > derived > > * from this software without prior written permission. For written > > * permission, please contact [EMAIL PROTECTED] > > * > > * 5. Products derived from this software may not be called "Apache" > > * nor may "Apache" appear in their name, without prior written > > * permission of the Apache Software Foundation. > > * > > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > > * SUCH DAMAGE. > > * ==================================================================== > > * > > * This software consists of voluntary contributions made by many > > * individuals on behalf of the Apache Software Foundation. For more > > * information on the Apache Software Foundation, please see > > * <http://www.apache.org/>. > > * > > */ > > package org.apache.commons.resources.impl; > > > > import java.net.URL; > > > > import junit.framework.Test; > > import junit.framework.TestSuite; > > > > /** > > * <p>Unit tests for > > * <code>org.apache.commons.resources.impl.HibernateResources</code>. > > * </p> > > * > > * @author James Mitchell > > * @version $Revision: 1.1 $ $Date: 2004/02/06 13:26:09 $ > > */ > > > > public class HibernateResourcesTestCase > > extends CollectionResourcesBaseTestCase { > > > > > > // ----------------------------------------------------- Instance > Variables > > > > > > // ----------------------------------------------------------- > Constructors > > > > > > public HibernateResourcesTestCase(String name) { > > super(name); > > } > > > > > > // --------------------------------------------------- Overall Test > Methods > > > > > > // Set up instance variables required by this test case > > public void setUp() throws Exception { > > factory = new HibernateResourcesFactory(); > > resources = factory.getResources( > > NAME, > > "hibernate.cfg.xml"); > > } > > > > // Return the tests included in this test suite > > public static Test suite() { > > return (new TestSuite(HibernateResourcesTestCase.class)); > > } > > > > // Tear down the instance variables required by this test case > > public void tearDown() { > > resources = null; > > factory = null; > > } > > > > > > // ------------------------------------------------ Individual Test > Methods > > > > > > // ------------------------------------------------------ Protected > Methods > > protected String getBase() throws Exception > > { > > // default file name > > URL url = > > HibernateResourcesTestCase.class.getResource > > ("hibernate.cfg.xml"); > > > > if (url == null) { > > fail("URL NOT FOUND"); > > } > > String string = url.toExternalForm(); > > String base = string.substring(0, string.length() - 11); > > return base; > > } > > > > > > > > } > > > > > > > > 1.1 > jakarta-commons-sandbox/resources/contrib/hibernate/sql/mysql.sql > > > > Index: mysql.sql > > =================================================================== > > use the same script from the JDBC implementation. > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
