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, yucca...@live.co.za <yucca...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
