Struts2 + Hibernate

[Ivar sol]

Hi i am using Hibernate to insert bulk records/ query bulk records at a time.

All works well but suddenly after some time error comes up saying that cannot open connection/TNS listener not listening in the middle of the application.
What does it mean?


Error i get is :

   

Row No.: 10
00289512
ADDEPALLI, SRI LAKSHMI DEEPTI
Hibernate: select this_.EKEY as EKEY163_0_, this_.EMPLOYEE_ID as EMPLOYEE2_163_0_, this_.EMPLOYEE_NAME as EMPLOYEE3_163_0_, this_.SKILL as SKILL163_0_, this_.SUPPORT as SUPPORT163_0_ from SCOTT.AMS_EMPLOYEE this_ where this_.EMPLOYEE_ID like ?
Hibernate: select this_.ASSIGN_ID as ASSIGN1_160_0_, this_.ASSIGNMENT as ASSIGNMENT160_0_, this_.GENERAL_RECEIVER as GENERAL3_160_0_, this_.ASSIGN_TEXT as ASSIGN4_160_0_, this_.ASSIGN_STATUS as ASSIGN5_160_0_, this_.TASK_COMPONENT as TASK6_160_0_, this_.AA_TYPE as AA7_160_0_, this_.HOURS as HOURS160_0_ from SCOTT.AMS_ASSIGNMENT this_ where this_.GENERAL_RECEIVER like ?
Tue Apr 13 00:00:00 IST 2010
2010-04-13
Hibernate: select this_.DATE_ID as DATE1_161_0_, this_.F_YEAR as F2_161_0_, this_.WEEK_P as WEEK3_161_0_, this_.WEEK_FY as WEEK4_161_0_, this_.DDATE as DDATE161_0_, this_.PERIOD as PERIOD161_0_, this_.BI_WEEK as BI7_161_0_ from SCOTT.AMS_CAL this_ where this_.DDATE=?
SYS10087-01-05-0000
new
Hibernate: select max(TRANS_KEY) from SCOTT.AMS_TRANS
Hibernate: insert into SCOTT.AMS_TRANS (CREATED_DATE, LAST_CHANGE, EMPLOYEE_ID, COST_CENTER, GENERAL_RECEIVER, DDATE, HOURS, TRANS_KEY) values (?, ?, ?, ?, ?, ?, ?, ?)
Row No.: 11
00289512
ADDEPALLI, SRI LAKSHMI DEEPTI
Hibernate: select this_.EKEY as EKEY183_0_, this_.EMPLOYEE_ID as EMPLOYEE2_183_0_, this_.EMPLOYEE_NAME as EMPLOYEE3_183_0_, this_.SKILL as SKILL183_0_, this_.SUPPORT as SUPPORT183_0_ from SCOTT.AMS_EMPLOYEE this_ where this_.EMPLOYEE_ID like ?
Hibernate: select this_.ASSIGN_ID as ASSIGN1_180_0_, this_.ASSIGNMENT as ASSIGNMENT180_0_, this_.GENERAL_RECEIVER as GENERAL3_180_0_, this_.ASSIGN_TEXT as ASSIGN4_180_0_, this_.ASSIGN_STATUS as ASSIGN5_180_0_, this_.TASK_COMPONENT as TASK6_180_0_, this_.AA_TYPE as AA7_180_0_, this_.HOURS as HOURS180_0_ from SCOTT.AMS_ASSIGNMENT this_ where this_.GENERAL_RECEIVER like ?
Mon Apr 12 00:00:00 IST 2010
2010-04-12
Hibernate: select this_.DATE_ID as DATE1_181_0_, this_.F_YEAR as F2_181_0_, this_.WEEK_P as WEEK3_181_0_, this_.WEEK_FY as WEEK4_181_0_, this_.DDATE as DDATE181_0_, this_.PERIOD as PERIOD181_0_, this_.BI_WEEK as BI7_181_0_ from SCOTT.AMS_CAL this_ where this_.DDATE=?
SYS10087-01-05-0000
org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
	at dte.dao.DaoPoi.insertTrans(DaoPoi.java:858)
	at dte.dao.DaoPoi.accessDao2(DaoPoi.java:402)
	at dte.service.ServicePoi.accessService(ServicePoi.java:26)
	at dte.action.dteAction.executePoi(dteAction.java:83)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:128)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
	at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:XE

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:280)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:154)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	... 72 more
Row No.: 12
00289512
 

My program is like this, this function is called in a loop more than 1000 times,however i get error at the 10th row if i use Oracle 10g XE,
and on around 100th row if i use Oracle 10g.
All previous take out coorect data/ insert data in database.but after some time this error creeps in

   


public String[] getConnection(String employeeId, String gen_Receiver, Date ddate, String task, String [] result) throws IOException
	{
		Session session = null;

		try
		{

			SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
			//session =sessionFactory.getCurrentSession();
			session =sessionFactory.openSession();
		//	Transaction tx = session.beginTransaction();
			String str1= "%"+employeeId+"%";
			Criteria crit1 = session.createCriteria(AMS_EMPLOYEE.class).add(Restrictions.like("EMPLOYEE_ID",str1));
			List list1 = crit1.list();
			Iterator it1 =  list1.iterator();
			AMS_EMPLOYEE emp = (AMS_EMPLOYEE)it1.next();
			result[0]=emp.getSKILL();
			result[1]=emp.getSUPPORT();
			
			String str2= "%"+gen_Receiver+"%";
			Criteria crit2 = session.createCriteria(AMS_ASSIGNMENT.class).add(Restrictions.like("GENERAL_RECEIVER",str2));
			List list2 = crit2.list();
			Iterator it2 =  list2.iterator();
			AMS_ASSIGNMENT assign = (AMS_ASSIGNMENT)it2.next();
			result[2]=assign.getASSIGNMENT();
			result[3]=assign.getASSIGN_STATUS();
			System.out.println(ddate);
			java.sql.Date date = new java.sql.Date(ddate.getTime());
	//		SimpleDateFormat fmt = new SimpleDateFormat("dd-MMM-yyyy");
	//        String todayStr = fmt.format(ddate);
	        System.out.println(date);
			//System.out.println(date);
			Criteria crit3 = session.createCriteria(AMS_CAL.class).add(Restrictions.eq("DDATE",ddate));
			List list3 = crit3.list();
			Iterator it3 =  list3.iterator();
			AMS_CAL cal = (AMS_CAL)it3.next();
			result[4]=cal.getF_YEAR();
			result[5]=cal.getPERIOD();
			result[6]=cal.getBI_WEEK();
			result[7]=cal.getWEEK_P();
			result[8]=cal.getWEEK_FY();
		

		}
		catch(Exception e)
		{
			e.printStackTrace();
			System.out.println("All Records not present in Database");
			System.out.println("Connection Failed");
		}
		finally{
			session.flush();
			session.close();
		}
		return result ;

	}

 

Please suggest what is going wrong.

[Ivar sol]

And i am using Tomcat 6 server