Harbir Hundal [http://community.jboss.org/people/adofo] created the discussion

"Data Not retrieved with JBOSS"

To view the discussion, visit: http://community.jboss.org/message/609901#609901

--------------------------------------------------------------
Hi guys, 
 I am new to using JBOSS (http://www.coderanch.com/forums/f-63/JBoss). 
 
 I am a very simple web application, thats is trying to extract some data from 
a table form the Database, using hibernate. 
 
 Now, the database connection is running fine when it is deployed with tomcar, 
and the data is getting retrieved from the Datatbase. 
 When the application is deployed in JBOSS 5.1, there is no data retrieved form 
the database. 
 
 The following is my JDBC (http://www.coderanch.com/forums/f-3/JDBC) properties 
file: 


jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.dialect=org.hibernate.dialect.MySQLDialect
jdbc.url=jdbc:mysql://localhost:3306/deccandatabase
jdbc.username=root
jdbc.password=root5



My spring dispatcher is: 



<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans";
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
xmlns:p="http://www.springframework.org/schema/p";
        xmlns:aop="http://www.springframework.org/schema/aop"; 
xmlns:tx="http://www.springframework.org/schema/tx";
        xmlns:context="http://www.springframework.org/schema/context";
        xsi:schemaLocation="http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
       http://www.springframework.org/schema/aop 
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx 
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/context 
http://www.springframework.org/schema/context/spring-context-3.0.xsd";>

        <!-- packages that will be scanned for annotations -->
        <context:annotation-config />
        <context:component-scan base-package="au.com.deccan" />  <!-- all 
packages under this will be scanned -->
        <tx:annotation-driven transaction-manager="transactionManager" />

        <!-- Defining the default annotation AnnotationHandlerMapping -->
        <bean 
class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping"
 />
        
        <!-- Defining the ClassName annotation ClassNameHandlerMapping -->
        <bean 
class="org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping">
                <property name="interceptors">
                        <list>
                                <ref bean="measurementInterceptor" />
                        </list>
                </property>
        </bean>

        <!-- Defining the AnnotationHandlerAdapter -->
        <bean 
class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"
 />

        <!-- Defining the Interceptor -->
        <bean id="measurementInterceptor" 
class="au.com.deccan.interceptor.MeasurementInterceptor" />

        <!-- Defining the Viewresolver -->
        <bean id="jspViewResolver" 
class="org.springframework.web.servlet.view.InternalResourceViewResolver"
                p:prefix="/WEB-INF/jsp/" p:suffix=".jsp" />
        
        <!-- Defining the JDBC properties -->
        <bean id="propertyConfigurer" 
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
                p:location="/WEB-INF/jdbc.properties" />
        <!-- Defining the DataSource -->
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
                destroy-method="close" 
p:driverClassName="${jdbc.driverClassName}"
                p:url="${jdbc.url}" p:username="${jdbc.username}" 
p:password="${jdbc.password}" />
        
        <!-- Configuration for Hibernate -->
        <bean id="sessionFactory"
                
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
                <property name="dataSource" ref="dataSource" />
                <property name="configLocation">
                        <value>/WEB-INF/hibernate.cfg.xml</value>
                </property>
                <property name="configurationClass">
                        <value>org.hibernate.cfg.AnnotationConfiguration</value>
                </property>
                <property name="hibernateProperties">
                        <props>
                                <prop 
key="hibernate.dialect">${jdbc.dialect}</prop>
                                <prop key="hibernate.show_sql">true</prop>
                        </props>
                </property>
        </bean>
        
        <!-- transaction Manager -->
        <bean id="transactionManager" 
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
                <property name="sessionFactory" ref="sessionFactory" />
        </bean>
</beans>


My hibernate config is:


<?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>
        <mapping class="au.com.deccan.model.User" />
        </session-factory>
 </hibernate-configuration>



There are no erros or exceptions is the log. 
 Can, someone please let me know what may be causing this behavious. 
 
 Regrads 
 Adofo
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/609901#609901]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to