Hi
Already my application in Struts using JDBC.At present my application is implemented in Struts with hibernate
So i am not changing the SQL queries converting to the like this
String sql4="select max(sed.Subexpe nseId) from hiber.Subexpens eDet sed";
List query1 = session.createS QLQuery(sql4).a ddEntity(Subexp enseDet.class). list();
Iterator it1 = query1.iterator ();
it1.hasNext();
SubexpenseDet set1 = (SubexpenseDet) it1.next();
subexpenseid=se t1.getSubexpens eId();
at the retriving time i got the Exception like this
Hibernate: select max(sed.Subexpe nseId) from hiber.Subexpens eDet sed
org.hibernate.e xception.SQLGra mmarException: could not execute query
at org.hibernate.e xception.SQLSta teConverter.con vert(SQLStateCo nverte
ava:67)
at org.hibernate.e xception.JDBCEx ceptionHelper.c onvert(JDBCExce ptionH
er.java:43)
at org.hibernate.l oader.Loader.do List(Loader.jav a:2148)
at org.hibernate.l oader.Loader.li stIgnoreQueryCa che(Loader.java :2029)
at org.hibernate.l oader.Loader.li st(Loader.java: 2024)
at org.hibernate.l oader.custom.Cu stomLoader.list (CustomLoader.j ava:11
at org.hibernate.i mpl.SessionImpl .listCustomQuer y(SessionImpl.j ava:16
at org.hibernate.i mpl.AbstractSes sionImpl.list(A bstractSessionI mpl.ja
142)
at org.hibernate.i mpl.SQLQueryImp l.list(SQLQuery Impl.java:164)
at food.FoodDAO.in sertBreakFastDa ta(FoodDAO.java :111)
at food.FoodAction .execute(FoodAc tion.java:57)
at org.apache.stru ts.action.Reque stProcessor.pro cessActionPerfo rm(Req
tProcessor.java :431)
at org.apache.stru ts.action.Reque stProcessor.pro cess(RequestPro cessor
va:236)
at org.apache.stru ts.action.Actio nServlet.proces s(ActionServlet .java:
6)
at org.apache.stru ts.action.Actio nServlet.doPost (ActionServlet. java:4
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:709)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:802)
at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(A
icationFilterCh ain.java:252)
at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licati
ilterChain.java :173)
at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapp
alve.java:213)
at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dConte
alve.java:178)
at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValv
ava:126)
at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValv
ava:105)
at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard Engine
ve.java:107)
at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.
a:148)
at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.j
:856)
at org.apache.coyo te.http11.Http1 1Protocol$Http1 1ConnectionHand ler.pr
ssConnection(Ht tp11Protocol.ja va:744)
at org.apache.tomc at.util.net.Poo lTcpEndpoint.pr ocessSocket(Poo lTcpEn
int.java:527)
at org.apache.tomc at.util.net.Lea derFollowerWork erThread.runIt( Leader
lowerWorkerThre ad.java:80)
at org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(Thre
ool.java:684)
at java.lang.Threa d.run(Unknown Source)
Caused by: com.mysql.jdbc. exceptions.MySQ LSyntaxErrorExc eption: Table 'hiber.
expensedet' doesn't exist
at com.mysql.jdbc. SQLError.create SQLException(SQ LError.java:936 )
at com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:2870)
at com.mysql.jdbc. MysqlIO.sendCom mand(MysqlIO.ja va:1573)
at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:1665)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:3176)
at com.mysql.jdbc. PreparedStateme nt.executeInter nal(PreparedSta tement
va:1153)
at com.mysql.jdbc. PreparedStateme nt.executeQuery (PreparedStatem ent.ja
1266)
at org.hibernate.j dbc.AbstractBat cher.getResultS et(AbstractBatc her.ja
139)
at org.hibernate.l oader.Loader.ge tResultSet(Load er.java:1669)
at org.hibernate.l oader.Loader.do Query(Loader.ja va:662)
at org.hibernate.l oader.Loader.do QueryAndInitial izeNonLazyColle ctions
ader.java:224)
at org.hibernate.l oader.Loader.do List(Loader.jav a:2145)
... 28 more
what is the problem in my sql query and the code
please help me
thank u