tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <yucca...@live.co.za>
Subject tomcat hibernate wiki
Date Tue, 15 Jun 2010 13:37:35 GMT
Please add to the wiki that hibernate dialect must still be set. Wiki says, 
must have NO database configuration properties but just got an exception 
complaining om missing dialect properties

--------------------------------------------------
From: "Mark Eggers" <its_toasted@yahoo.com>
Sent: Monday, June 14, 2010 11:45 PM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: hibernate not finding global resource datasource defined by 
tomcat

> Please read the following for a detailed description on how to configure 
> Hibernate to use JNDI resources supplied by Tomcat.
>
> http://wiki.apache.org/tomcat/TomcatHibernate
>
> Then you will need a <ResourceLink> element in META-INF/context.xml to 
> make the resource in <GlobalNamingResources> available to your 
> application.
>
> The configuration for that information can be found here:
>
> http://tomcat.apache.org/tomcat-6.0-doc/config/context.html#Resource%20Links
>
> Finally, unless you place Tomcat's manager and admin application's 
> authentication and authorization information in your database, removing 
> the UserDatabaseRealm from <GlobalNamingResources> will prevent you from 
> using the manager and admin application.
>
> You can place more than one <Resource> element in the 
> <GlobalNamingResources> element of your server.xml.
>
> I'm trying to finish up a document on DataSourceRealms. Hopefully that 
> will get posted on Tomcat's Wiki today or tomorrow, depending on other 
> time constraints.
>
> just my two cents . . . . .
>
> /mde/
>
> --- On Mon, 6/14/10, yuccanel@live.co.za <yuccanel@live.co.za> wrote:
>
> Hello tomcats!!
>
> Please advise as to why hibernate us unable to find jndi
> datasource configured in tomcat?
>
> Trying 2 different setups here:
>
> 1) server.xml resource as follows:
>
> <GlobalNamingResources>
>
> <!-- Editable user database that can also be used
> by
>          UserDatabaseRealm to
> authenticate users
>
> -->
>
> <Resource
>
> name="jdbc/auth"
>         description="The
> Jar Bar user authentication"
>
> type="javax.sql.DataSource"
>
> auth="Container"
>
> driverClassName="com.mysql.jdbc.Driver"
>
> maxActive="30" maxIdle="10"
>
> maxWait="10000"
>
> password="myPass"
>
> url="jdbc:mysql://localhost:3306/yucca123_thejarbar"
>
> validationQuery="/* ping */ SELECT
> 1"
>
> username="yucca123_tom"/>
>
>
>
>   </GlobalNamingResources>
>
> with 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-3.0.dtd">
> <hibernate-configuration>
>
> <session-factory>
>     <property
> name="connection.url">jdbc:mysql://localhost:3306/yucca123_thejarbar</property>
>
> <property
> name="hibernate.connection.datasource">java:comp/env/jdbc/auth"</property>
>
> <property
> name="connection.driver_class">com.mysql.jdbc.Driver</property>
>
> <property
> name="connection.username">yucca123_tom</property>
>
> <property
> name="current_session_context_class">thread</property>
>
> <property
> name="connection.password">pookie123</property>
>
> <mapping
> resource="org/bar/jar/model/UserRolesEntity.hbm.xml"/>
>
> <mapping
> resource="org/bar/jar/model/UsercommentsEntity.hbm.xml"/>
>
> <mapping
> resource="org/bar/jar/model/UsersEntity.hbm.xml"/>
>
> <!-- DB schema will be updated if needed -->
>     <!-- 
> <property name="hbm2ddl.auto">update</property> -->
>
> </session-factory>
> </hibernate-configuration>
>
> so I try
>
> 2) moving resource and realm element to context.xml with
> adding localdatasource attribute to  resource (true) and get same
> exception?
>
> What am I missing here?
>
> tomcat is latest 6.0.26
> mysql 5 with global connector (inside
> common/lib)
>
> Ideally I want the global(server.xml) config for the
> resource as it WILL be shared among deployed applications, but because 
> this is
> first application I am willing to use just contect configured
> resource.
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message