Doubt in using JNDI with Hibernate.

[Siddharth Bhargava]

Please explain me how to use JNDI as a data source provider if I use JBoss as an application server with Hibernate application. Please explain with a hibernate.cfg.xml file example and also what all do we have to do in JBoss application server. I tried with a simple example but it says that data source not found.. Please Help me !!!

[Cameron Wallace McKenzie]

A similar post was answered at hibernate.org:

JNDI and Hibernate Session Question

Well, it's a great idea to bind a Hibernate Session to you JNDI (Java Naming and Directory Interface) server. This way, rather than having to maintain the Session yourself, the JNDI server will, and that resource can then be accessed by any resource that has access and the rights to do a JNDI lookup.

Here you can see it in a sample hibernate.cfg.xml file.

This was loosely stolen from Chapter 3 of the Hibernate documentation. Look it up for more details:

Free Hibernate Documentation for People to Use to Learn Things About Hibernate

 
<?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>
 
    <!-- a SessionFactory instance listed as /jndi/name -->
 
    <session-factory
        name="java:hibernate/SessionFactory">
 
        <!-- properties -->
        <property name="connection.datasource">java:/comp/env/jdbc/MyDB</property>
        <property name="dialect">org.hibernate.dialect.SCJASQLDialect</property>
        <property name="show_sql">true</property>
        <property name="transaction.factory_class">
            org.hibernate.transaction.JTATransactionFactory
        </property>
        <property name="jta.UserTransaction">java:comp/UserTransaction</property>
 
        <!-- mapping files -->
 
 
        <!-- cache settings -->
 
 
    </session-factory>
 
</hibernate-configuration> 

[ July 08, 2008: Message edited by: Cameron Wallace McKenzie ]

[Siddharth Bhargava]

Hi,
I tried mapping with hibernate.cfg.xml like this only , but it said that datasource not found. What could be the cause of this error. I had a file by the name of MySQL-ds.xml in JBoss\server\default\deploy. Please do help me..

[Siddharth Bhargava]

Hi All,
The code is as follows :

    
try {
System.out.println("Hi....");
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
System.out.println("After Hi....");
session = sessionFactory.openSession();
 
System.out.println("Inserting Record");
 
Transaction tx = session.beginTransaction();
 
Contact contact = new Contact();
//contact.setId(7);
contact.setFirstName("Neel");
contact.setLastName("Bhargava");
contact.setEmail("[e-mail]");

Address address = new Address();
address.setAddress1("Flat No. 59");
address.setAddress2("Rajouri Apartments");
address.setCity("New Delhi");
address.setZipcode(110064);

contact.setHomeAddress(address);

session.save(contact);

tx.commit();
 
System.out.println("Done");
 
} catch (Exception e) {
System.out.println(e.getMessage());
} finally {
session.flush();
session.close();
}

hibernate.cfg.xml

   
 
<hibernate-configuration>
 
<session-factory>

<property name="hibernate.connection.datasource">java:MySqlDS</property>
        <property name="hibernate.jndi.url"></property>
      <property name="hibernate.jndi.class"></property>
      <property name="hibernate.connection.username"></property>
      <property name="hibernate.connection.password"></property>
      
      <property name="show_sql">true</property>
      <property name="format_sql">true</property>
      
      <!-- Show and print nice SQL on stdout. -->
<!--   <property name="dialect">org.hibernate.dialect.MySQLDialect</property> -->
      <property name="hibernate.hbm2ddl.auto">create</property>
      
      <!-- List of XML Mapping files -->
      <mapping resource="contact.hbm.xml"/>
<!--   <mapping resource="address.hbm.xml"/> -->

</session-factory>

</hibernate-configuration>

Exception which occurs is :

    
Hi....
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Could not find datasource
Exception in thread "main" java.lang.NullPointerException
at com.example.jndi.SaveExample.main(SaveExample.java:50)

Its gives exception in session.flush(); statement.

mysql-ds.xml contents

    
<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>root</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!-- should only be used on drivers after 3.22.1 with "ping" support
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
    -->
    <!-- sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->
    <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
      -->
 
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>
 

mysql-ds.xml is in deploy directory of JBoss. and JBoss shows

09:09:43,661 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS'

Please help. !!! Any help will be greatly appreciated.
Thanks in advance.

[Jaikiran Pai]

Could not find datasource
Exception in thread "main" java.lang.NullPointerException
at com.example.jndi.SaveExample.main(SaveExample.java:50)

Are you doing this lookup from a standalone java client? By default, the datasources in JBoss are bound to java: namespace and are not visible outside the server JVM, to remote clients. See this for more details.

[Siddharth Bhargava]

Yeah I am doing this lookup from a standalone Java Client program.

[Cameron Wallace McKenzie]

When running stand-along code that access J2EE resource, you need to ensure that you are running from a J2EE client container, otherwise, the various enterprise resources will not be available to you.

-Cameron McKenzie

[Siddharth Bhargava]

Hi,
How can I do this. Please do explain me. I am trying out a simple standalone application using Eclipse. Thanks in advance.