Hi all,
Please help me to know
If i use ClassicQueryTranslatorFactory in my cfg.xml am getting below error
Am using Spring+hibernate +sunone application server 8.2
[#|2008-07-17T17:23:14.353+0800|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8080-0;|
Hibernate: select hostel1_.DEPT_C as DEPT2_3_, hostel1_.DEPT_T2 as DEPT4_3_, hostel1_.FAC_C as FAC3_3_, hostel1_.DEPT_C as col_0_0_, raposition0_.RA_POSTN_N as col_1_0_, raposition0_.APPL_ST_D as col_2_0_, raposition0_.APPL_END_D as col_3_0_, raposition0_.ACAD_Y as col_4_0_, raposition0_.SEM_C as col_5_0_, raposition0_.STDCAT_C as col_6_0_, raposition0_.POSTN_ST_D as col_7_0_, raposition0_.POSTN_END_D as col_8_0_, raposition0_.POSTN_STS_C as col_9_0_ from RA_APPL_CTRL raposition0_, DEPARTMENT hostel1_ where (raposition0_.APPL_ST_D<current_date())and(raposition0_.APPL_END_D>current_date())and(raposition0_.HSTL_C=hostel1_.DEPT_C )and(raposition0_.POSTN_STS_C='O' )and(raposition0_.STDCAT_C=? )|#]
[#|2008-07-17T17:23:14.369+0800|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8080-0;|
2008-07-17 17:23:14,369 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 907, SQLState: 42000>
|#]
[#|2008-07-17T17:23:14.369+0800|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8080-0;|2008-07-17 17:23:14,369 ERROR [org.hibernate.util.JDBCExceptionReporter] - <ORA-00907: missing right parenthesis
>
|#]
[#|2008-07-17T17:23:14.369+0800|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8080-0;|Exception rise..|#]
[#|2008-07-17T17:23:14.369+0800|SEVERE|sun-appserver9.1|javax.enterprise.system.container.web|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8080-0;_RequestID=7e774726-9b56-4a65-b320-f268158b6af0;|StandardWrapperValve[oraaps]: PWC1406: Servlet.service() for servlet oraaps threw exception
javax.servlet.ServletException: Form object returned by formBackingObject() must not be null
at org.springframework.web.servlet.mvc.AbstractFormController.getErrorsForNewForm(AbstractFormController.java:345)
at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:323)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:263)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:839)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:774)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:460)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:290)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
|#]
------------------------------------------------------------Can any one help me to know why am getting above error if I use below Query
Query query = getSession().createQuery("select new RAPosition(h, raPostion.positionId, raPostion.applicationStartDate, " +
"raPostion.applicationEndDate, raPostion.acadYear, raPostion.acadSem, " +
"raPostion.studType, raPostion.apptStartDate, raPostion.apptEndDate, " +
"raPostion.positionStatus) from RAPosition as raPostion, Hostel as h " +
"where raPostion.applicationStartDate < current_date() " +
"and raPostion.applicationEndDate > current_date() " +
"and raPostion.hostel.hostelId = h.hostelId " +
"and raPostion.positionStatus = 'O' " +
"and raPostion.studType = ?");
query.setParameter(0, studType);
----------------------------------cfg.xml have below deatils---------------------------------------
<?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:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="/WEB-INF/jdbc.properties"/>
</bean>
<!--
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<bean id="jndiTemplate" class="org.springframework.jndi.JndiTemplate">
<property name="environment">
<props>
<prop key="java.naming.factory.initial">org.springframework.jndi.JndiObjectFactoryBean</prop>
<prop key="java.naming.provider.url">java:comp/env/jdbc/oraaps</prop>
</props>
</property>
</bean>
-->
<!-- CustomDataSource :: by Lalitha -->
<bean id="customDataSource" class="oraaps.dataaccess.CustomDataSource"/>
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="customDataSource"/>
<property name="mappingResources" value="oraaps.hbm.xml"/>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.generate_statistics">true</prop>
<!-- <prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop> -->
<prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
</props>
</property>
<property name="eventListeners">
<map>
<entry key="merge">
<bean class="org.springframework.orm.hibernate3.support.IdTransferringMergeEventListener"/>
</entry>
</map>
</property>
</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" read-only="true"/>
<tx:method name="find*" read-only="true"/>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="transMethods" expression="execution(* oraaps.service.*.*(..))"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="transMethods"/>
</aop:config>
</beans>
------------------------------------ CustomDataSource.java --------------------
Connection con =null;
try{
InitialContext ic = new InitialContext();
DataSource ds = (DataSource)ic.lookup("jdbc/oraaps");
con = ds.getConnection();
}catch (Exception e)
{
}
finally{}
return con;
--------------- jdbc.property------------
jdbc.driverClassName=oracle.jdbc.OracleDriver
#local [not in use]
jdbc.url=jdbc:oracle:thin:@quest31.nus.edu.sg:1523:ADMT
#SIT or Prod [not in use]
#jdbc.url=oracle.jdbc.pool.OracleConnectionPoolDataSource
jdbc.username=""
jdbc.password=""
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect