where do I put hibernate.properties? in jar, sar, etc?

btarbox · **Joined:** Tue Jul 27, 2004 1:17 pm **Posts:** 12

I get this error when I run which implies that my hibernate.properties has not been recognized...i.e. I put it in the wrong place.

net.sf.hibernate.connection.UserSuppliedConnectionProvider#configure No connection properties specified - the user must supply JDBC connections

I'm running hibernate2.1 and jboss.3.2.3. and here is my hibernate.properties:

hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.url jdbc:oracle:thin:@localhost:1521:bmcs
hibernate.connection.username foo
hibernate.connection.password bar
hibernate.show_sql true

I've put copies of this file at the top level of my hibernateStartup.sar and at the top level of the jar for my session bean.

Any pointers would be appreciated.

Brian

michael · **Posted:** Tue Jul 27, 2004 5:51 pm

The Hibernate MBEan is not configured through a hibernate.properties. Please have a look at the JBoss documentation page in the Wiki.

btarbox · **Joined:** Tue Jul 27, 2004 1:17 pm **Posts:** 12

I'm actually trying to configure my class as opposed to the Hibernate MBean. The mbean seems to be fine.

What I've tried is just putting the hibernate.properties directly into the jboss/server/default/deploy directory....and this worked. The file got deployed and my test case successfully called my session bean which called the pojo which hibernated itself into the database.

I'm still a bit puzzled why my hibernate pojo class (which was deployed inside a jar) did not find the hibernate.properties when I put it inside the jar.

Perhaps I'm missing a basic concept? (I did read the jboss doc on the wiki but it kind of skimmed over hibernate.properties. I also tried to configure the connection via the jmx console but still got the 'no connection info' error).

Thank you.

Brian

sgwood · **Posted:** Tue Jul 27, 2004 11:27 pm

The hibernate.properties is used for configuring the session factory, so the POJO class has nothing to do with it.

IMHO, the MBean is the easiest way to go for JBoss.

Sherman

btarbox · **Joined:** Tue Jul 27, 2004 1:17 pm **Posts:** 12

Ok, I like mbeans and jmx...but how do I setup the system so it 'just works' after installation, i.e. without requiring the using to use the jmx-console to configure the connection properties? I know the correct values and ought to be able to preload them. Can I do that somehow via the mbean as opposed to via hibernate.properties? (thank you).

Brian Tarbox

sgwood · **Posted:** Thu Jul 29, 2004 12:18 pm

http://www.hibernate.org/66.html

This will produce a SAR that you can drop into the JBoss deployment direcotry or include in an EAR. JBoss will deploy the SAR and you will have a SessionFactory in JNDI...

Sherman

btarbox · **Joined:** Tue Jul 27, 2004 1:17 pm **Posts:** 12

I have read that document, and its great but not complete.

I created the sar and deployed it..and still got 'no connection info found' until I included hibernate.properties.

Using just the sar where can I specify connection properties such as user and password (remember, I want this to work out of the box)?

Thank you.

Brian

david · **Posted:** Thu Jul 29, 2004 9:58 pm

The configuration (as document on the above URL) uses the containers configured datasource. The datasource configuration has the user and password etc. JBoss has a number of examples that you can used as a starting point.

Kaneda · **Posted:** Thu Aug 05, 2004 11:14 am

Take the default-ds.xml and edit it to your needs afterwards save it as you like and put this name into your bean descriptor.

regards

Olaf

apsoto · **Posted:** Fri Aug 13, 2004 5:49 pm

If using JBoss 3.2.6 you can use a hibernate archive
Here is a sample .har layout
foo.har/
---User.hbm.xml
---Role.hbm.xml
---META-INF/
------hibernate-service.xml
---com/
------foo/
---------model/
------------User.class
------------Role.class

Sample hibernate-service.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE server>
<server>
    <mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=fooapp-hibernate">
                <depends>jboss.jca:service=RARDeployer</depends>
        <!-- so it won't deploy until the datasrouce is available -->
        <depends>jboss.jca:service=LocalTxCM,name=fooappDS</depends>

        <attribute name="DatasourceName">java:/fooappDS</attribute>
        <attribute name="SessionFactoryName">java:/fooapp/hibernate/SessionFactory</attribute>
        <attribute name="Dialect">net.sf.hibernate.dialect.MySQLDialect</attribute>
        <attribute name="CacheProviderClass">net.sf.ehcache.hibernate.Provider</attribute>
        <attribute name="QueryCacheEnabled">true</attribute>
        <attribute name="ShowSqlEnabled">true</attribute>
        <attribute name="MaxFetchDepth">1</attribute>
    </mbean>

</server>

btarbox wrote:

I have read that document, and its great but not complete.

I created the sar and deployed it..and still got 'no connection info found' until I included hibernate.properties.

Using just the sar where can I specify connection properties such as user and password (remember, I want this to work out of the box)?

Thank you.

Brian

Code: