Forum:

Object Relational Mapping

org.hibernate.exception.GenericJDBCException: could not insert:

Ranch Hand

Posts: 48

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i am getting the following error

the application is running locally is fine, but whenever i put into server i got the following error

Error stack trace

[#|2010-06-18T18:55:15.601+0530|INFO|oracle-glassfish3.0.1|com.mchange.v2.resourcepool.BasicResourcePool|_ThreadID=20;_ThreadName=Thread-1;|Logging the stack trace by which the overdue resource was checked-out.
java.lang.Exception: DEBUG ONLY: Overdue resource check-out stack trace.
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:506)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
	at tcplistener.Alldatabase.Database(Alldatabase.java:252)
	at tcplistener.ModuleHandler.run(ModuleHandler.java:181)
	at java.lang.Thread.run(Thread.java:619)
|#]

[#|2010-06-18T18:55:18.079+0530|SEVERE|oracle-glassfish3.0.1|tcplistener.Alldatabase|_ThreadID=21;_ThreadName=Thread-1;|The log message is null.
org.hibernate.exception.GenericJDBCException: could not insert: [pip.Xydata]
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
	at tcplistener.Alldatabase.Database(Alldatabase.java:155)
	at tcplistener.ModuleHandler.run(ModuleHandler.java:181)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: You can't operate on a closed connection!!!
	at com.mchange.v2.c3p0.impl.C3P0PooledConnection$ProxyConnectionInvocationHandler.invoke(C3P0PooledConnection.java:952)
	at com.mchange.v2.c3p0.impl.$Proxy112.prepareStatement(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.hibernate.util.GetGeneratedKeysHelper.prepareStatement(GetGeneratedKeysHelper.java:49)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:495)
	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.prepare(IdentityGenerator.java:69)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:30)
	... 18 more
|#]

o am not getting the exactly where the error is coming

AllDatabase.java file

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package tcplistener;

import java.sql.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import parser.DecimalNumber;
import java.util.Date;
import java.util.Iterator;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import pip.Allalerts;
import pip.ClientKML;
import pip.Fm4features;
import test.HibernateUtil;
import pip.Highspeed;
import pip.Objtable;
import test.Speedemaill;
import pip.Xydata;
import test.Objectinfo;

/**
 *
 * @author sachin
 */
public class Alldatabase
{
private static String city = "N/A";
private static String location = "N/A";
private static String state = "N/A";
private static String distance = "0";
private ClientKML clientKML;
public String oid = "", cid = "", display="",email1 = "",Device="";
public int clientId = 0,objectId = 0;
public static Alldatabase instance = null;

/**
  *
  * @param imei
  *
  */

public int checkimei(String imei) throws SQLException
{

// PreparedStatement preparedStatement = null;
   // ResultSet rs = null;
    String checkImei = "";
    Session sess=null;
    int checkIm = 0;
    sess = HibernateUtil.getSessionFactory().openSession();
    try
    {

Transaction tr = sess.beginTransaction();

Query query = sess.createQuery("from Objectinfo as obj where obj.IMEI ='"+imei+"'");
     ArrayList list = (ArrayList) query.list();
     Iterator it = list.iterator();
     while(it.hasNext())
     {
         Objectinfo obj = (Objectinfo)it.next();
         checkImei = obj.getIMEI();
         objectId = (int) obj.getObjectId();
         clientId = obj.getClientId();
         display = obj.getDisplayName();
         email1 = obj.getEmail1();
         Device = obj.getDevice();

}

if (checkImei.equals(imei))
     {

checkIm = 1;

}else
     {
         checkIm = 0;
     }

}catch(Exception ex)
    {
         Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, ex);
    }
    finally
    {
        //preparedStatement.close();
        //sess.close();
        //rs.close();
    }
    return checkIm;
}

public Session getSession()
{

Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        if (s == null)
        {

s = HibernateUtil.getSessionFactory().openSession(); /// i chnged open to current
        }
      //  return s;
   // final Session sess = HibernateUtil.getSessionFactory().getCurrentSession();
    return s;
}
public void Database(int x, int y, short altitude, short angle, byte satellites, short speed,int ObjectId, int ClientId,long times,int[] obj, int[] obja) throws SQLException
{
      int cSpeed = 0;
     Session fmsess = null;
     Session sess = null,sess1 = null,sess2 = null;
    //PreparedStatement preparedStatement = null;
    DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    DecimalNumber xx ;
    DecimalNumber yy ;

//final Session sess = null;
     //Fm4features fm4 = null;
    String GpsTime = null,dn = "";
      try
        {
           Date resultdate = new Date(times);
           xx = new DecimalNumber(x,7);
           yy = new DecimalNumber(y,7);

sess = HibernateUtil.getSessionFactory().getCurrentSession();
        Transaction tr = sess.beginTransaction();
        Xydata xy = new Xydata();
        xy.setLongi(xx+"");
        xy.setLat(yy+"");
        xy.setAltitude(Integer.valueOf(altitude));
        xy.setAngle(Integer.valueOf(angle));
        xy.setSatellite(Integer.valueOf(satellites));
        xy.setSpeed(Integer.valueOf(speed));
        xy.setObjectId(objectId);
        xy.setClientId(clientId);
        xy.setGpsTime(sdf.format(resultdate));
        xy.setLocation("N/A");
        xy.setCity("N/A");
        xy.setState("N/A");
        xy.setDistance("0");
        sess.save(xy);
        int xyid = 0;

Fm4features fm4features = new Fm4features(xy.getId());
       for (int i = 0; i < obj.length && obj[i] != 0; i++)
          {
               fmsess = HibernateUtil.getSessionFactory().getCurrentSession();
               tr = fmsess.beginTransaction();
               int all = obj[i] - 1;
               fm4features.setDataId(all);
               fm4features.setValue(obja[i]);
               fmsess.save(fm4features);
               tr.commit();
               System.out.println(all + " ::: " + obja[i]);
               xyid = xy.getId();

}
        sess1 = getSession();
        Transaction trr = sess1.beginTransaction();
        Query query = sess1.createQuery("from Objtable where ObjectId='"+objectId+"'");
        ArrayList list = (ArrayList) query.list();
        Iterator it = list.iterator();
        while(it.hasNext())
        {
          Objtable log = (Objtable)it.next();
          GpsTime = log.getGpsTime();

}
        System.out.println("GpsTime is " + GpsTime + " sdf.format(resultdate) " + sdf.format(resultdate));

if (GpsTime != null)
           {
                System.out.println("GpsTime is not null " + GpsTime);
                DateFormat df = new SimpleDateFormat(sdf.format(resultdate));
                Date today = df.parse(sdf.format(resultdate));
                Timestamp d = new Timestamp(today.getTime());

java.util.Date parsedDate = sdf.parse(GpsTime);
                java.sql.Timestamp timestamp = new java.sql.Timestamp(parsedDate.getTime());

if (timestamp.before(d.valueOf(sdf.format(resultdate))))
           {
               clientKML = new ClientKML();
               clientKML.CreateKml(display, ClientId, ObjectId,x, y, speed,sdf.format(resultdate));
              sess = getSession();
               Transaction  tr1 = sess.beginTransaction();
               String hql = "update Objtable set ID = :ID,  Longi =:Longi,  Lat =:Lat,  Altitude=:Altitude, Angle=:Angle, Satellite =:Satellite,  Speed=:Speed, GpsTime=:GpsTime, Location =:Location, City =:City, State =:State, Distance =:Distance where ObjectId =:ObjectId and ClientId =:ClientId";
               Query query1 = sess.createQuery(hql);
               query1.setParameter("ObjectId", ObjectId);
               query1.setParameter("ClientId", ClientId);
               query1.setParameter("ID", xyid);
               query1.setParameter("Longi", xx+"");
               query1.setParameter("Lat", yy+"");
               query1.setParameter("Altitude", Integer.valueOf(altitude));
               query1.setParameter("Angle", Integer.valueOf(angle));
               query1.setParameter("Satellite", Integer.valueOf(satellites));
               query1.setParameter("Speed", Integer.valueOf(speed));
               query1.setParameter("GpsTime", sdf.format(resultdate));
               query1.setParameter("Location", location);
               query1.setParameter("City", city);
               query1.setParameter("State", state);
               query1.setParameter("Distance", distance);
               int rowCount = query1.executeUpdate();
               System.out.println("rowCount " + rowCount + " ID " + xy.getId() + " xyid " + xyid);
               tr1.commit();

}

}
        
           if (GpsTime == null || GpsTime == "")
           {
                System.out.println("GpsTime is null " + GpsTime);
                Objtable objtable = new Objtable();
                sess = getSession();
                Transaction tr1 = sess.beginTransaction();
                objtable.setID(xy.getId());
                objtable.setLongi(xx+"");
                objtable.setLat(yy+"");
                objtable.setAltitude(Integer.valueOf(altitude));
                objtable.setAngle(Integer.valueOf(angle));
                objtable.setSatellite(Integer.valueOf(satellites));
                objtable.setSpeed(Integer.valueOf(speed));
                objtable.setObjectId(objectId);
                objtable.setClientId(clientId);
                objtable.setGpsTime(sdf.format(resultdate));
                objtable.setLocation("N/A");
                objtable.setCity("N/A");
                objtable.setState("N/A");
                objtable.setDistance("0");
                sess.save(objtable);
                tr1.commit();

}
        
               sess = getSession();
               Transaction tr2  = sess.beginTransaction();
               Query highQuery = sess.createQuery("from Highspeed high where high.objectId='"+ObjectId+"'");
               ArrayList highlist = (ArrayList) highQuery.list();
               Iterator highit = highlist.iterator();
               while(highit.hasNext())
              {
                    Highspeed log = (Highspeed)highit.next();
                    dn = log.getDisplayName();
                    cSpeed = log.getSpeed();

}
                if (cSpeed != 0 )
                {

if (speed > cSpeed)
                    {

Allalerts alerts = new Allalerts();
                           sess = getSession();
                            Transaction tr1 = sess.beginTransaction();
                            alerts.setHeader("Speed Alerts");
                            alerts.setClientId(ClientId);
                            alerts.setObjectId(objectId);
                            alerts.setDisplay(dn);
                            alerts.setValue(""+speed);
                            alerts.setLongi(xx+"");
                            alerts.setLat(yy+"");
                            alerts.setComments("Overspeeding");
                            alerts.setGpsTime(sdf.format(resultdate));
                            sess.save(alerts);
                            tr1.commit();

Speedemaill speede = new Speedemaill();
                             sess = getSession();
                            Transaction tr3 = sess.beginTransaction();
                            speede.setHeader("Speed Alerts");
                            speede.setClientId(ClientId);
                            speede.setObjectId(ObjectId);
                            speede.setDisplay(dn);
                            speede.setValue(""+speed);
                            speede.setLongi(xx+"");
                            speede.setLat(yy+"");
                            speede.setComments("Overspeeding");
                            speede.setGpsTime(sdf.format(resultdate));
                            sess.save(speede);
                            tr3.commit();

//                       preparedStatement = conn.prepareStatement("insert into allalerts (Header,ClientId,ObjectId,Display,Value,Longi,Lat,Comments,GpsTime) values ('Speed Alert','"+ClientId+"','"+ObjectId+"','"+dn+"','"+speed+"','"+xx+"','"+yy+"','Overspeeding','"+sdf.format(resultdate)+"')");
//                       preparedStatement.addBatch();
//                       preparedStatement = conn.prepareStatement("insert into speedemail (Header,ClientId,ObjectId,Display,Value,Longi,Lat,Comments,GpsTime) values ('Speed Alert','"+ClientId+"','"+ObjectId+"','"+dn+"','"+speed+"','"+xx+"','"+yy+"','Overspeeding','"+sdf.format(resultdate)+"')");
//                       preparedStatement.addBatch();
//                       preparedStatement.executeBatch();

}

}catch(Exception exx)
        {

Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, exx);

}finally
        {

}
}

public void duplicateDatabase(int x, int y, short altitude, short angle, byte satellites, short speed,int ObjectId, int ClientId,long times,Connection conn,String display)
{
    PreparedStatement preparedStatement = null;
    ResultSet rs = null;
    Timestamp GpsTime = null ;
    DecimalNumber xx ;
    DecimalNumber yy ;
    DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      try
        {
           Date resultdate = new Date(times);

xx = new DecimalNumber(x,7);
           yy = new DecimalNumber(y,7);
           preparedStatement = conn.prepareStatement("select GpsTime from objtable where ObjectId='"+ObjectId+"' AND ClientId='"+ClientId+"'");
           rs = preparedStatement.executeQuery();
           if (rs.next())
           {
               GpsTime = rs.getTimestamp("GpsTime");
           }
           if (GpsTime != null)
           {
           DateFormat df = new SimpleDateFormat(sdf.format(resultdate));
           Date today = df.parse(sdf.format(resultdate));
           Timestamp d = new Timestamp(today.getTime());

if (GpsTime.before(d.valueOf(sdf.format(resultdate))))
           {

preparedStatement = conn.prepareStatement("update objtable set ID=LAST_INSERT_ID(), Longi = '"+xx+"',Lat = '"+yy+"',Altitude = '"+altitude+"',Angle = '"+angle+"',Satellite = '"+satellites+"',Speed='"+speed+"',GpsTime = '"+sdf.format(resultdate)+"',Location='"+location+"',City='"+city+"',State='"+state+"',Distance='"+distance+"' where ObjectId ='"+ObjectId+"' and ClientId='"+ClientId+"'");
               preparedStatement.executeUpdate();
               clientKML.CreateKml(display, ClientId, ObjectId,x, y, speed,sdf.format(resultdate));
           }

}
           if (GpsTime == null)
           {
             preparedStatement = conn.prepareStatement("insert into objtable (ID,Longi,Lat,Altitude,Angle,Satellite,Speed,ObjectId,ClientId,GpsTime,Location,City,State,Distance) Values (LAST_INSERT_ID(),'"+xx+"','"+yy+"','"+altitude+"','"+angle+"','"+satellites+"','"+speed+"','"+ObjectId+"','"+ClientId+"','"+sdf.format(resultdate)+"','"+location+"','"+city+"','"+state+"','"+distance+"')");
             preparedStatement.executeUpdate();
           }
    }catch(Throwable ex)
    {
        Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, ex);
    }
    finally
    {
      try{
         preparedStatement.close();
      }catch(Throwable e)
      {
          Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, e);
      }
      }
}

public void CheckSpeedAlert(int ObjectId,int ClientId, int speed, int x, int y, long gpsTime) throws SQLException
     {

Session sess1=null;
         Transaction trans=null;
         int cSpeed = 0;
         String dn = "";
         DecimalNumber xx ;
         DecimalNumber yy ;
         DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      try
      {
         Date resultdate = new Date(gpsTime);
         sess1 = HibernateUtil.getSessionFactory().openSession();
         trans = sess1.beginTransaction();
         Iterator query = sess1.createQuery("from Highspeed as h where h.objectId='"+objectId+"' and h.status = 'false' ").list().iterator();
         while(query.hasNext()){
         Highspeed h = (Highspeed)query.next();
         cSpeed = h.getSpeed();
         dn = h.getDisplayName();
          }
         System.out.println("cSpeed" +cSpeed);
         System.out.println("Display" +dn);
        if (cSpeed != 0 )
           {
                xx = new DecimalNumber(x,7);
                yy = new DecimalNumber(y,7);

if (speed > cSpeed)
            {
              System.out.println("Inserting Allalertss");
              Allalerts al=new Allalerts();
              al.setHeader("Speed Alert");
              al.setClientId(clientId);
              al.setObjectId(objectId);
              al.setDisplay(dn+"");
              al.setValue(speed+"");
              al.setLongi(xx+"");
              al.setLat(yy+"");
              al.setComments("Overspeeding");
              al.setGpsTime(sdf.format(resultdate));
              sess1.save(al);
              sess1.flush();
              System.out.println("Object Id" +al.getObjectId());
              System.out.println("Inserting speedmail");
              Speedemaill se=new Speedemaill();
              se.setHeader("Speed Alert");
              se.setClientId(clientId);
              se.setObjectId(objectId);
              se.setDisplay(dn+"");
              se.setValue(speed+"");
              se.setLongi(xx+"");
              se.setLat(yy+"");
              se.setComments("Overspeeding");
              se.setGpsTime(sdf.format(resultdate));
              sess1.save(se);
              sess1.flush();
           }

}
         trans.commit();
         }catch(Throwable th)
         {
           Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, th);
         }finally
         {
             if(sess1!=null)
             {
             sess1.close();
             }
         }

}

please help to solve the problem

thanks in advance

Regards
Bakthavachalam E

David Newton

Author

Posts: 12617

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm guessing something's funky with the connection pool manager, handler, or connection pool management. The code is a little difficult to follow; at the very least delete the commented-out lines--they're just noise. Some refactoring would clean things up too.

Baktha Elumalai

Ranch Hand

Posts: 48

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

package tcplistener;

public class Alldatabase
{
private static String city = "N/A";
private static String location = "N/A";
private static String state = "N/A";
private static String distance = "0";
private ClientKML clientKML;
public String oid = "", cid = "", display="",email1 = "",Device="";
public int clientId = 0,objectId = 0;
public static Alldatabase instance = null;

public int checkimei(String imei) throws SQLException
{

String checkImei = "";
    Session sess=null;
    int checkIm = 0;
    sess = HibernateUtil.getSessionFactory().openSession();
    try
    {

Transaction tr = sess.beginTransaction();

}

if (checkImei.equals(imei))
     {

checkIm = 1;

}else
     {
         checkIm = 0;
     }

}catch(Exception ex)
    {
         Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, ex);
    }
    finally
    {
       
    }
    return checkIm;
}

public Session getSession()
{

Session s = HibernateUtil.getSessionFactory().getCurrentSession();
        if (s == null)
        {

s = HibernateUtil.getSessionFactory().openSession(); /// i chnged open to current
        }
  
    return s;
}
public void Database(int x, int y, short altitude, short angle, byte satellites, short speed,int ObjectId, int ClientId,long times,int[] obj, int[] obja) throws SQLException
{
      int cSpeed = 0;
     Session fmsess = null;
     Session sess = null,sess1 = null,sess2 = null;
    //PreparedStatement preparedStatement = null;
    DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    DecimalNumber xx ;
    DecimalNumber yy ;

}
        System.out.println("GpsTime is " + GpsTime + " sdf.format(resultdate) " + sdf.format(resultdate));

java.util.Date parsedDate = sdf.parse(GpsTime);
                java.sql.Timestamp timestamp = new java.sql.Timestamp(parsedDate.getTime());

}

}
                if (cSpeed != 0 )
                {

if (speed > cSpeed)
                    {

}

}catch(Exception exx)
        {

Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, exx);

}finally
        {

}
}

if (GpsTime.before(d.valueOf(sdf.format(resultdate))))
           {

public void CheckSpeedAlert(int ObjectId,int ClientId, int speed, int x, int y, long gpsTime) throws SQLException
     {

}

Regards
Bakthavachalam E

Don't get me started about those stupid light bulbs.