Hi,
I have configured oracle datasource in WSAD5.1, i am trying to write to database using hibernate framework from a web application. i have copied all the required jar files into WEB-INF/lib folder, and created hibernate.cfg.xml, Person.hbm.xml ,and a TestServlet.java, following is the code listing for each file
hibernate.cfg.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.datasource">
jdbc/OraDS
</property>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<mapping resource="com/siva/seminar/hibernate/Person.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Person.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.siva.seminar.hibernate">
<class name="Person" table="person">
<id name="id" column="id" type="long">
<generator class="native"/>
</id>
<property name="lastName" column="lastname" type="string"/>
<property name="firstName" column="firstname" type="string"/>
<property name="address" column="address" type="string"/>
</class>
</hibernate-mapping>
TestServlet.java
package com.siva.seminar.web.controller;
import java.io.IOException;
import java.io.PrintWriter;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import com.siva.seminar.hibernate.Person;
public class TestServlet extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
DataSource ds = null;
InitialContext ctx = null;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try {
Configuration cfg = new Configuration();
SessionFactory factory = cfg.configure().buildSessionFactory();
Person person = new Person();
person.setAddress("2418 Independence");
person.setFirstName("Siva");
person.setLastName("Madala");
Session session = factory.openSession();
session.beginTransaction();
session.save(person);
session.flush();
out.print("success");
}
catch(Exception ex){
ex.printStackTrace();
out.print("Failure");
}
}
}
When i hit the servlet, the following is the exception thrown, and the object is not written into the data base, i am able to write into database using JDBC code though, its only the problem hibernate, any help is greatly appreciated
[2/25/06 22:23:50:531 CST] 6bb511bb LocalTranCoor E WLTC0033E: Resource jdbc/OraDS rolled back in cleanup of unresolved LocalTransactionContainment.
[2/25/06 22:23:50:531 CST] 6bb511bb LocalTranCoor E WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback.
[2/25/06 22:23:50:547 CST] 6bb511bb WebAppTransac E WTRN0043I: LocalTransaction rolled-back due to setRollbackOnly.
[2/25/06 22:23:50:578 CST] 6bb511bb WebGroup E SRVE0026E: [Servlet Error]-[LocalTransaction rolled-back due to setRollbackOnly]: com.ibm.ws.LocalTransaction.RolledbackException
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1073)
at com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvoke(WebAppTransactionCollaborator.java:249)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:708)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
Login
FAQ
Search
