Spring + Hibernate ORA-00936: missing expression
Hi,
I 've got some problems when using spring with hibernate and Oracle.
I receceive this error when I execute a select on a single table.
My environment :Code:11:08:13,855 INFO [SQLErrorCodesFactory] SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase] 11:08:13,871 INFO [STDOUT] Hibernate: select from 11:08:13,887 WARN [JDBCExceptionReporter] SQL Error: 936, SQLState: 42000 11:08:13,887 ERROR [JDBCExceptionReporter] ORA-00936: missing expression 11:08:13,887 WARN [JDBCExceptionReporter] SQL Error: 936, SQLState: 42000 11:08:13,887 ERROR [JDBCExceptionReporter] ORA-00936: missing expression 11:08:13,887 ERROR [JDBCExceptionReporter] Could not execute query java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:1033) at net.sf.hibernate.loader.Loader.list(Loader.java:1024) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at org.springframework.orm.hibernate.HibernateTemplate$19.doInHibernate(HibernateTemplate.java:647) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:314) at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:633) at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:612) at be.brail.tutorial.dao.db.implementations.hibernate.EmployeeDAOImpl.listOfEmployees(EmployeeDAOImpl.java:25) at be.brail.tutorial.services.implementations.EmployeeServiceImpl.ListOfEmployee(EmployeeServiceImpl.java:31) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy65.ListOfEmployee(Unknown Source) at be.brail.tutorial.struts.actions.EmployeeListAction.execute(EmployeeListAction.java:44) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:147) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:53) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:743) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) 11:08:13,902 WARN [RequestProcessor] Unhandled Exception thrown: class org.springframework.jdbc.BadSqlGrammarException 11:08:13,902 ERROR [StandardWrapper[/Employee-tutorial:action]] Servlet.service() for servlet action threw exception org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00936: missing expression java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:1033) at net.sf.hibernate.loader.Loader.list(Loader.java:1024) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at org.springframework.orm.hibernate.HibernateTemplate$19.doInHibernate(HibernateTemplate.java:647) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:314) at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:633) at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:612) at be.brail.tutorial.dao.db.implementations.hibernate.EmployeeDAOImpl.listOfEmployees(EmployeeDAOImpl.java:25) at be.brail.tutorial.services.implementations.EmployeeServiceImpl.ListOfEmployee(EmployeeServiceImpl.java:31) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy65.ListOfEmployee(Unknown Source) at be.brail.tutorial.struts.actions.EmployeeListAction.execute(EmployeeListAction.java:44) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:147) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:53) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:743) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595)
Win XP
JBoss 4.0.2 RC1
Spring 1.2.1
Hibernate 2.1
Here is my configuration file:
The error occurs when I use the service employeeService and the method ListOfEmployee(). It's only at runtime that the problem occurs.Code:<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" singleton="true"> <property name="jndiName"> <value>java:jdbc/employee</value> </property> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean"> <property name="dataSource"> <ref bean="dataSource"/> </property> <property name="mappingResources"> <list> <value>be/brail/tutorial/model/Employee.hbm.xml</value> <value>be/brail/tutorial/model/Vehicle.hbm.xml</value> </list> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.statement_cache.size">25</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.query.substitutions">true 1,false 0,yes 'Y',no 'N'</prop> <prop key="hibernate.query.imports">net.sf.hibernate.test,net.sf.hibernate.eg</prop> <prop key="hibernate.proxool.pool_alias">pool1</prop> <prop key="hibernate.jdbc.user_streams_for_binary">true</prop> <prop key="hibernate.jdbc.batch_size">0</prop> <prop key="hibernate.dialect">net.sf.hibernate.dialect.Oracle9Dialect</prop> <prop key="hibernate.connection.pool_size">1</prop> <prop key="hibernate.cglib.user_reflection_optimizer">true</prop> <prop key="hibernate.use_outer_join">true</prop> <prop key="hibernate.cache.use_query_cache">false</prop> <prop key="hibernate.cache.provider_class">net.sf.ehcache.hibernate.Provider</prop> </props> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate.HibernateTransactionManager"> <property name="sessionFactory"> <ref bean="sessionFactory"/> </property> </bean> <!-- DAO SECTION --> <bean id="baseDAO" class="be.brail.tutorial.dao.db.implementations.hibernate.BaseDAOImpl"> <property name="sessionFactory"> <ref bean="sessionFactory"/> </property> </bean> <bean id="employeeDAO" class="be.brail.tutorial.dao.db.implementations.hibernate.EmployeeDAOImpl"> <property name="sessionFactory"> <ref bean="sessionFactory"/> </property> </bean> <bean id="vehicleDAO" class="be.brail.tutorial.dao.db.implementations.hibernate.VehicleDAOImpl"> <property name="sessionFactory"> <ref bean="sessionFactory"/> </property> </bean> <!-- SERVICE INITIALISATION --> <bean id="txProxyTemplate" lazy-init="true" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"> <property name="transactionManager"> <ref local="transactionManager"/> </property> <property name="transactionAttributes"> <props> <prop key="*">PROPAGATION_REQUIRED</prop> </props> </property> </bean> <bean id="employeeService" parent="txProxyTemplate"> <property name="target"> <bean class="be.brail.tutorial.services.implementations.EmployeeServiceImpl"> <property name="employeeDAO"> <ref bean="employeeDAO"/> </property> </bean> </property> </bean> <bean id="vehicleService" parent="txProxyTemplate"> <property name="target"> <bean class="be.brail.tutorial.services.implementations.VehicleServiceImpl"> <property name="vehicleDAO"> <ref bean="vehicleDAO"/> </property> </bean> </property> </bean> </beans>
When the server start and the project is loaded in the server all seems good.
The bean code:
Code:package be.brail.tutorial.model; import java.io.Serializable; import java.util.Date; import java.util.HashSet; import java.util.Set; /** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: SNCB/NMBS</p> * <p>Creation time : 06-Jun-2005 - 16:46:30</p> * @author Geraerts François * @version 1.0 * * @hibernate.class table = "TUT_EMPLOYEE" * * Represents a Employee. */ public class Employee implements Serializable { private String employeeId; private String name; private String firstName; private String sex; private Date birthDate; private String dept; private Set vehicles = new HashSet(); /** * @hibernate.property column = "BirthDate" type = "string" * @return Returns the birthDate. */ public Date getBirthDate() { return birthDate; } /** * @param birthDate The birthDate to set. */ public void setBirthDate(Date birthDate) { this.birthDate = birthDate; } /** * @hibernate.property column = "Dept" type = "date" * @return Returns the dept. */ public String getDept() { return dept; } /** * @param dept The dept to set. */ public void setDept(String dept) { this.dept = dept; } /** * @hibernate.id generator-class = "assigned" column = "EMPLOYEE_ID" * @return Returns the employeeId. */ public String getEmployeeId() { return employeeId; } /** * @param employeeId The employeeId to set. */ public void setEmployeeId(String employeeId) { this.employeeId = employeeId; } /** * @hibernate.property column = "FirstName" type = "string" * @return Returns the firstName. */ public String getFirstName() { return firstName; } /** * @param firstName The firstName to set. */ public void setFirstName(String firstName) { this.firstName = firstName; } /** * @hibernate.property column = "Name" type = "string" * @return Returns the name. */ public String getName() { return name; } /** * @param name The name to set. */ public void setName(String name) { this.name = name; } /** * @hibernate.property column = "Sex" type = "string" * @return Returns the sex. */ public String getSex() { return sex; } /** * @param sex The sex to set. */ public void setSex(String sex) { this.sex = sex; } /** * @hibernate.set table = "TUT_VEHICLE" cascade = "none" * @hibernate.collection-key column = "EMPLOYEE_ID" * @hibernate.collection-one-to-many class = "be.brail.tutorial.model.Vehicle" * @return Returns the vehicles. */ public Set getVehicles() { return vehicles; } /** * @param vehicles The vehicles to set. */ public void setVehicles(Set vehicles) { this.vehicles = vehicles; } }
The dao implementation code :
and the base dao code :Code:package be.brail.tutorial.dao.db.implementations.hibernate; import java.util.List; import org.springframework.orm.ObjectRetrievalFailureException; import be.brail.tutorial.dao.db.interfaces.EmployeeDAO; import be.brail.tutorial.model.Employee; /** * @author Geraerts François * Creation Date : 09-juin-2005 * * EmployeeDAOImpl.java */ public class EmployeeDAOImpl extends BaseDAOImpl implements EmployeeDAO { /* (non-Javadoc) * @see be.brail.tutorial.dao.db.interfaces.EmployeeDAO#listOfEmployees() */ public List listOfEmployees() { log.warn("listOfEmployees"); List result = getHibernateTemplate().find("FROM TUT_EMPLOYEE"); if (result.isEmpty()) { throw new ObjectRetrievalFailureException(Employee.class,null); } else { return result; } } /* (non-Javadoc) * @see be.brail.tutorial.dao.db.interfaces.EmployeeDAO#findAnEmployee(java.lang.String) */ public Employee findAnEmployee(String employeeId) { List result = getHibernateTemplate().find("FROM TUT_EMPLOYEE WHERE EMPLOYEE_ID = ?",employeeId); if (result.isEmpty()) { throw new ObjectRetrievalFailureException(Employee.class,employeeId); } else { return (Employee)result.get(0); } } }
When i look at the error, it's seems that the hibernate definition is "not load" or is not in the context. The corresponding sql generate is "Code:package be.brail.tutorial.dao.db.implementations.hibernate; import java.io.Serializable; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.springframework.orm.ObjectRetrievalFailureException; import org.springframework.orm.hibernate.support.HibernateDaoSupport; import be.brail.tutorial.dao.db.interfaces.BaseDAO; /** * This class serves as the Base class for all other DAOs - namely to hold * common methods that they might all use. Can be used for standard CRUD * operations.</p> * * */ public class BaseDAOImpl extends HibernateDaoSupport implements BaseDAO { protected final Log log = LogFactory.getLog(getClass()); /** * @see be.brail.a629.dao.db.interfaces.BaseDAO#saveObject(java.lang.Object) */ public void saveObject(Object o) { getHibernateTemplate().saveOrUpdate(o); } /** * @see be.brail.a629.dao.db.interfaces.BaseDAO#getObject(java.lang.Class, java.io.Serializable) */ public Object getObject(Class clazz, Serializable id) { Object o = getHibernateTemplate().get(clazz, id); if (o == null) { throw new ObjectRetrievalFailureException(clazz, id); } return o; } /** * @see be.brail.a629.dao.db.interfaces.BaseDAO#getObjects(java.lang.Class) */ public List getObjects(Class clazz) { return getHibernateTemplate().loadAll(clazz); } /** * @see be.brail.a629.dao.db.interfaces.BaseDAO#removeObject(java.lang.Class, java.io.Serializable) */ public void removeObject(Class clazz, Serializable id) { getHibernateTemplate().delete(getObject(clazz, id)); } }
select from. But when I look in the start of the server the context seems well initalised. It 's seem to be an configuration error but i don't have any idea.
To be complete the hibernate config file and the startup of the server:
and the startup:Code:<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> <hibernate-mapping > <class name="be.brail.tutorial.model.Employee" table="TUT_EMPLOYEE" > <id name="employeeId" column="EMPLOYEE_ID" type="java.lang.String" > <generator class="assigned"> <!-- To add non XDoclet generator parameters, create a file named hibernate-generator-params-Employee.xml containing the additional parameters and place it in your merge dir. --> </generator> </id> <property name="birthDate" type="string" update="true" insert="true" column="BirthDate" /> <property name="dept" type="date" update="true" insert="true" column="Dept" /> <property name="firstName" type="string" update="true" insert="true" column="FirstName" /> <property name="name" type="string" update="true" insert="true" column="Name" /> <property name="sex" type="string" update="true" insert="true" column="Sex" /> <set name="vehicles" table="TUT_VEHICLE" lazy="false" cascade="none" sort="unsorted" > <key column="EMPLOYEE_ID" > </key> <one-to-many class="be.brail.tutorial.model.Vehicle" /> </set> <!-- To add non XDoclet property mappings, create a file named hibernate-properties-Employee.xml containing the additional properties and place it in your merge dir. --> </class> </hibernate-mapping>
Thanks for advice or any suggestion about this problem.Code:13:52:02,366 INFO [TomcatDeployer] undeploy, ctxPath=/Employee-tutorial, warUrl=file:/C:/jboss-4.0.2RC1/server/default/tmp/deploy/tmp2754Employee-ear.ear-contents/Employee-war-exp.war/ 13:52:02,553 INFO [[/Employee-tutorial]] Closing WebApplicationContext of Struts ActionServlet 'action', module '' 13:52:02,553 INFO [XmlWebApplicationContext] Closing application context [WebApplicationContext for namespace 'action-servlet'] 13:52:03,054 INFO [DefaultListableBeanFactory] Destroying singletons in factory {org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,transactionManager,baseDAO,employeeDAO,vehicleDAO,txProxyTemplate,employeeService,vehicleService]; root of BeanFactory hierarchy} 13:52:03,054 INFO [LocalSessionFactoryBean] Closing Hibernate SessionFactory 13:52:03,054 INFO [SessionFactoryImpl] closing 13:52:04,475 WARN [DeploymentInfo] Could not delete file:/C:/jboss-4.0.2RC1/server/default/tmp/deploy/tmp2754Employee-ear.ear-contents/Employee-war-exp.war/ restart will delete it 13:52:04,475 INFO [EARDeployer] Undeploying J2EE application, destroy step: file:/C:/jboss-4.0.2RC1/server/default/deploy/Employee-ear.ear 13:52:04,522 WARN [DeploymentInfo] Could not delete file:/C:/jboss-4.0.2RC1/server/default/tmp/deploy/tmp2754Employee-ear.ear restart will delete it 13:52:04,647 INFO [EARDeployer] Init J2EE application: file:/C:/jboss-4.0.2RC1/server/default/deploy/Employee-ear.ear 13:52:06,491 INFO [TomcatDeployer] deploy, ctxPath=/Employee-tutorial, warUrl=file:/C:/jboss-4.0.2RC1/server/default/tmp/deploy/tmp2755Employee-ear.ear-contents/Employee-war-exp.war/ 13:52:11,507 INFO [PropertyMessageResources] Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true 13:52:11,507 INFO [PropertyMessageResources] Initializing, config='org.apache.struts.action.ActionResources', returnNull=true 13:52:12,335 INFO [PropertyMessageResources] Initializing, config='be.brail.tutorial.struts.ApplicationResources', returnNull=true 13:52:12,476 INFO [ContextLoaderPlugIn] ContextLoaderPlugIn for Struts ActionServlet 'action, module '': initialization started 13:52:12,476 INFO [[/Employee-tutorial]] Initializing WebApplicationContext for Struts ActionServlet 'action', module '' 13:52:12,741 INFO [XmlBeanDefinitionReader] Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml] 13:52:13,179 INFO [XmlWebApplicationContext] Bean factory for application context [WebApplicationContext for namespace 'action-servlet']: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,transactionManager,baseDAO,employeeDAO,vehicleDAO,txProxyTemplate,employeeService,vehicleService]; root of BeanFactory hierarchy 13:52:13,226 INFO [XmlWebApplicationContext] 9 beans defined in application context [WebApplicationContext for namespace 'action-servlet'] 13:52:13,257 INFO [CollectionFactory] JDK 1.4+ collections available 13:52:13,288 INFO [CollectionFactory] Commons Collections 3.x available 13:52:13,304 INFO [XmlWebApplicationContext] Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@1e5d207] 13:52:13,304 INFO [XmlWebApplicationContext] Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@13fe849] 13:52:13,320 INFO [UiApplicationContextUtils] No ThemeSource found for [WebApplicationContext for namespace 'action-servlet']: using ResourceBundleThemeSource 13:52:13,335 INFO [DefaultListableBeanFactory] Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,transactionManager,baseDAO,employeeDAO,vehicleDAO,txProxyTemplate,employeeService,vehicleService]; root of BeanFactory hierarchy] 13:52:13,335 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'dataSource' 13:52:13,507 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'sessionFactory' 13:52:13,648 INFO [Binder] Mapping class: be.brail.tutorial.model.Employee -> TUT_EMPLOYEE 13:52:13,679 INFO [Binder] Mapping class: be.brail.tutorial.model.Vehicle -> TUT_VEHICLE 13:52:13,679 INFO [LocalSessionFactoryBean] Building new Hibernate SessionFactory 13:52:13,679 INFO [Configuration] processing one-to-many association mappings 13:52:13,679 INFO [Binder] Mapping collection: be.brail.tutorial.model.Employee.vehicles -> TUT_VEHICLE 13:52:13,679 INFO [Configuration] processing one-to-one association property references 13:52:13,679 INFO [Configuration] processing foreign key constraints 13:52:13,679 INFO [Dialect] Using dialect: net.sf.hibernate.dialect.Oracle9Dialect 13:52:13,679 INFO [SettingsFactory] Use outer join fetching: true 13:52:13,679 INFO [ConnectionProviderFactory] Initializing connection provider: org.springframework.orm.hibernate.LocalDataSourceConnectionProvider 13:52:13,679 INFO [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended) 13:52:13,960 INFO [SettingsFactory] Use scrollable result sets: true 13:52:13,960 INFO [SettingsFactory] Use JDBC3 getGeneratedKeys(): false 13:52:13,960 INFO [SettingsFactory] Optimize cache for minimal puts: false 13:52:13,960 INFO [SettingsFactory] echoing all SQL to stdout 13:52:13,960 INFO [SettingsFactory] Query language substitutions: {no='N', true=1, yes='Y', false=0} 13:52:13,960 INFO [SettingsFactory] cache provider: net.sf.ehcache.hibernate.Provider 13:52:13,960 INFO [Configuration] instantiating and configuring caches 13:52:13,960 INFO [SessionFactoryImpl] building session factory 13:52:14,117 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured 13:52:14,117 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'transactionManager' 13:52:14,195 INFO [HibernateTransactionManager] Using DataSource [org.jboss.resource.adapter.jdbc.WrapperDataSource@f04dae] of Hibernate SessionFactory for HibernateTransactionManager 13:52:14,210 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'baseDAO' 13:52:14,242 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'employeeDAO' 13:52:14,257 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'vehicleDAO' 13:52:14,257 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'employeeService' 13:52:14,273 INFO [DefaultAopProxyFactory] CGLIB2 available: proxyTargetClass feature enabled 13:52:14,554 INFO [DefaultListableBeanFactory] Creating shared instance of singleton bean 'vehicleService' 13:52:14,585 INFO [ContextLoaderPlugIn] Using context class 'org.springframework.web.context.support.XmlWebApplicationContext' for servlet 'action' 13:52:14,585 INFO [ContextLoaderPlugIn] ContextLoaderPlugIn for Struts ActionServlet 'action', module '': initialization completed in 2109 ms 13:52:14,710 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-4.0.2RC1/server/default/deploy/Employee-ear.ear
Hugh.
Reply With Quote