Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 2.x
Mapping documents:
VotersVO.hbm.xml
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.acs.gs.eJuror.db.beans.VotersVO" table="voters">
<id name="partNumber" column="part_no" type="string">
<generator class="assigned"/>
</id>
<component name="personalInfo" class="com.acs.gs.eJuror.db.common.PersonalInfoBean">
<property name="lastName" column="lname" type="string" not-null="true"/>
<property name="firstName" column="fname" type="string" not-null="true"/>
<property name="address" column="address" type="string" not-null="true"/>
<property name="city" column="city" type="string" not-null="true"/>
<property name="state" column="state" type="string" not-null="true"/>
<property name="zip" column="zip" type="string" not-null="true"/>
<property name="birthDate" column="dob" type="date"/>
</component>
<property name="emailAddress" column="email_acct" type="string"/>
</class>
</hibernate-mapping>
0 WARN net.sf.hibernate.util.JDBCExceptionReporter | SQL Error: 904, SQLStat
e: 42000
0 ERROR net.sf.hibernate.util.JDBCExceptionReporter | ORA-00904: "VOTERSVO0_"
."EMAIL_ACCT": invalid identifier
11 WARN net.sf.hibernate.util.JDBCExceptionReporter | SQL Error: 904, SQLStat
e: 42000
11 ERROR net.sf.hibernate.util.JDBCExceptionReporter | ORA-00904: "VOTERSVO0_"
."EMAIL_ACCT": invalid identifier
21 ERROR net.sf.hibernate.util.JDBCExceptionReporter | could not load: [com.ac
s.gs.eJuror.db.beans.VotersVO#100012548]
java.sql.SQLException: ORA-00904: "VOTERSVO0_"."EMAIL_ACCT": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.
java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
dStatement.java:798)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1038)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
redStatement.java:838)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1131)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3284)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:3328)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
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.loadEntity(Loader.java:911)
at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:931)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:59)
at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:51)
at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:
419)
at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:2117)
at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1991
)
at net.sf.hibernate.impl.SessionImpl.get(SessionImpl.java:1927)
at org.springframework.orm.hibernate.HibernateTemplate$1.doInHibernate(H
ibernateTemplate.java:448)
at org.springframework.orm.hibernate.HibernateTemplate.execute(Hibernate
Template.java:363)
at org.springframework.orm.hibernate.HibernateTemplate.get(HibernateTemp
late.java:442)
at org.springframework.orm.hibernate.HibernateTemplate.get(HibernateTemp
late.java:436)
at com.acs.gs.eJuror.db.hibernate.dao.VotersDAOHibernate.findByPartNumbe
r(VotersDAOHibernate.java:53)
at com.acs.gs.eJuror.service.impl.DefaultSecurityService.getToken(Defaul
tSecurityService.java:90)
at com.acs.gs.eJuror.web.actions.LoginAction.execute(LoginAction.java:14
2)
at org.springframework.web.struts.DelegatingActionProxy.execute(Delegati
ngActionProxy.java:106)
at com.acs.gs.eJuror.web.struts.EJRequestProcessor.processActionPerform(
EJRequestProcessor.java:109)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:116
4)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at com.acs.gs.eJuror.web.servlet.SecurityFilter.doFilter(SecurityFilter.
java:85)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Thread.java:595)
Name and version of the database you are using:Oracle, 9.1 I think
The generated SQL (show_sql=true):This would be great! Where does this setting go. It might help me fix this problem.
OK, so I get this error on line 53 of this class:
Code:
/*
* Author : Vincent Fumo
* Created : Feb 10, 2005
* Modified :
*
* Copyright (c) ACS Government Systems, Inc. 2006. All rights reserved.
*
* CONFIDENTIAL BUSINESS INFORMATION
*
* THIS PROGRAM IS PROPRIETARY INFORMATION OF
* ACS GOVERNMENT SYSTEMS AND IS NOT TO BE COPIED,
* REPRODUCED, LENT OR DISPOSED OF, NOR USED FOR
* ANY PURPOSE OTHER THAN THAT FOR WHICH IT IS
* SPECIFICALLY PROVIDED WITHOUT THE WRITTEN
* PERMISSION OF ACS.
*/
package com.acs.gs.eJuror.db.hibernate.dao;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.acs.gs.eJuror.db.beans.VotersVO;
import com.acs.gs.eJuror.db.dao.VotersDAO;
/**
* @author Vincent Fumo
* @version 1.0
*/
public class VotersDAOHibernate extends HibernateDaoSupport implements VotersDAO {
private static VotersDAOHibernate MyInstance;
public static VotersDAOHibernate getInstance(){
while(MyInstance==null){
try{
Thread.sleep(1000);
}
catch (InterruptedException ie){
}
}
return MyInstance;
}
public VotersDAOHibernate(){
if(MyInstance==null){
MyInstance=this;
}
}
public VotersVO findByPartNumber(String partNumber) {
return (VotersVO)getHibernateTemplate().get(VotersVO.class, partNumber);
}
public void update(VotersVO vo) {
getHibernateTemplate().update(vo);
}
}
I don't think anything in this table changed since it last worked, but, of course, people with problems never do. EMAIL_ACCT exists in voters. Why am I getting an error on VOTERSVO0_ ??
Thanks.
Login
FAQ
Search