Issue with Hibernate and Spring Integration

[echarish Kumar]

hi all,

I tried to integrate hibernate with Spring and still trying it. I m using hibernate 3 and Spring 2. my application server is jboss and my DB is sql server. I use annotations here.

this is my spring configuration file and its name is application_config.xml and it is in /src directory.

<beans xmlns="http://www.springframework.org/schema/beans"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://www.springframework.org/schema/beans      
               http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
               
   <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" scope="singleton">
      <property name="jndiName" value="jdbc/sample" />
      <property name="resourceRef" value="true" />
   </bean>

   <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
      <property name="dataSource" ref="dataSource"></property>
      <property name="annotatedClasses">
         <list>
            <value>com.trn.Caller.java</value>
            <value>com.trn.Passenger.java</value>
            <value>com.trn.Question.java</value>
            <value>com.trn.CallerQuestions.java</value>
         </list>
      </property>
      <property name="hibernateProperties">
         <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
         </props>
      </property>
   </bean>
   
   <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
       <property name="mySessionFactory">
           <ref bean="sessionFactory"/>
       </property>
   </bean>
   
   <bean id="callerDao" class="com.dao.CallerDAOImpl">
       <property name="hibernateTemplate">
           <ref bean="hibernateTemplate"/>    
       </property>
   </bean>
   
   
</beans>

this is my jboss-web.xml file. it is in applications WEB-INF folder

<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
   <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/sample</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <jndi-name>java:comp/jdbc/sample</jndi-name>
      <res-auth>Container</res-auth>
   </resource-ref>
</jboss-web>

this is my web.xml file

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
   <display-name>
   Sample_Project1</display-name>
   <servlet>
      <description>
      </description>
      <display-name>
      ControllerServlet</display-name>
      <servlet-name>ControllerServlet</servlet-name>
      <servlet-class>
      com.util.ControllerServlet</servlet-class>
   </servlet>
   <servlet-mapping>
      <servlet-name>ControllerServlet</servlet-name>
      <url-pattern>/ControllerServlet</url-pattern>
   </servlet-mapping>
   <welcome-file-list>
      <welcome-file>index.html</welcome-file>
      <welcome-file>index.htm</welcome-file>
      <welcome-file>index.jsp</welcome-file>
      <welcome-file>default.html</welcome-file>
      <welcome-file>default.htm</welcome-file>
      <welcome-file>default.jsp</welcome-file>
   </welcome-file-list>
   <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/sample</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
   </resource-ref>
</web-app>

this is mssql-ds.xml file inside server\default\deploy directory in jboss distribution.

<?xml version="1.0" encoding="UTF-8"?>


<datasources>
<local-tx-datasource>

   <jndi-name>jdbc/sample</jndi-name>

   <connection-url>jdbc:jtds:sqlserver://ipOfDBServer;DILAN_TEST;</connection-url>
   <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
   <user-name>sa</user-name>
   <password>bdcadmin</password>
   <min-pool-size>1</min-pool-size>
   <max-pool-size>5</max-pool-size>
</local-tx-datasource>

</datasources>

All libraries are inside relevant folders. But it gives this error inside this ControllerServlet.java

1. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'callerDao' defined in class path resource [application_config.xml]: Cannot resolve reference to bean 'hibernateTemplate' while setting bean property 'hibernateTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateTemplate' defined in class path resource [application_config.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'mySessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [application_config.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/slf4j/impl/StaticLoggerBinder

2. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateTemplate' defined in class path resource [application_config.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'mySessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [application_config.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/slf4j/impl/StaticLoggerBinder

3. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [application_config.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/slf4j/impl/StaticLoggerBinder

4. org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/slf4j/impl/StaticLoggerBinder
   org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115)

5. java.lang.NoClassDefFoundError: org/slf4j/impl/StaticLoggerBinder

6. java.lang.ClassNotFoundException: No ClassLoaders found for: org.slf4j.impl.StaticLoggerBinder

Please help regarding this.

[Iwein Fuld]

Great that you're using SI.

It looks like this error is related to you slf4j dependencies and neither related to Spring Integration nor Hibernate. I'm sure if you share a simple project online you can get help with this.

[Mark Spritzler]

"java.lang.ClassNotFoundException: No ClassLoaders found for: org.slf4j.impl.StaticLoggerBinder "

Yeah you either are missing the org.slf4j jar files, or you have two different versions in your classpath.

Also, in your configuration, I didn't see a bean for TransactionManager.

Also, if you are using Hibernate 3.1 or higher, there is absolutely no reason to use HibernateTemplate. There is nothing you will get from that class.

Mark

[echarish Kumar]

I have solved some issues here,

1. I removed slf4j-api-1.5.2.jar from lib and add

slf4j-api-1.5.6.jar and
slf4j-log4j12-1.5.6.jar

and I also add one line to my mssql-ds.xml file, that is

<use-java-context>false</use-java-context>


ok now I have two different errors,

1. java.lang.ClassNotFoundException: com.trn.Caller.java
2. java.lang.IllegalArgumentException: Cannot find class [com.trn.Caller.java]

and earlier 1, 2, 3 errors (these are error numbers which I mentioned earlier post)
so im still finding a solution.

please help me.

[Mark Spritzler]

Looks like those are your classes. Are they not being placed in your classpath?

Mark