Ivar sol

Greenhorn

+ Follow

news 3 Posts 2 Threads

since Aug 18, 2009

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Ivar sol

struts2 type="stream"

Hi i am doing a file download page.

With this i can make it happen.

My doubt is i want that simultaneously user be forwarded to new page after this file download is done.
How to make it happen with struts "result"?

14 years ago

Struts

Struts2 + Hibernate

And i am using Tomcat 6 server

14 years ago

Object Relational Mapping

Struts2 + Hibernate

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.

14 years ago

Object Relational Mapping