Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate 3.0


error help plz

public static ICategory getInstanceById(String categoryid)
throws CategoryNotFoundException
{
System.out.println("Inside the getInstance");
System.out.println("The id is-->" + categoryid);
Category catObj = new Category();


try
{
HibernateUtil.beginTransaction();
String queryString = "select cat,metadata from Category as cat ,Metadata as metadata"
+ " where cat.id=:catid and cat.metadataId = metadata.id ";
Query query = HibernateUtil.getSession().createQuery(queryString);
query.setParameter("catid", categoryid, Hibernate.STRING);
List catList = query.list();
if (catList == null)
{
throw new CategoryNotFoundException("No Category Found for the Id");
}else
{
Object objs[] = (Object[])catList.get(0);
if(objs[0] instanceof Category )
{
catObj = (Category)objs[0];
}
if(objs[1] instanceof Metadata )
{
Metadata metObj = (Metadata)objs[1];
catObj.setMetadata(metObj);
}

}
}catch(Exception e)
{ System.out.println("heere is the error");ar
// e.printStackTrace();
}finally
{
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
}

return catObj;
}

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

org.hibernate.HibernateException: Session is closed
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:94)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.ja
va:134)
at com.transversalnet.hibernate.HibernateUtil.rollbackTransaction(Hibern
ateUtil.java:201)
at com.transversalnet.hibernate.HibernateUtil.commitTransaction(Hibernat
eUtil.java:186)
at com.transversalnet.docmanager.category.CategoryManager.getInstanceByI
d(CategoryManager.java:468)
at org.apache.jsp.docmanager.admin.categorydetails_jsp._jspService(categ
orydetails_jsp.java:168)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
92)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
0)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP