Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v7.0
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT Word v1.0
  HXTT XML v3.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Excel
Getting Exception when trying to upload a file with hyperlink data in Unix AIX
S.P.L Srikanth
2013-02-11 18:19:41.0
I was trying to upload an XLS file which has an email address. I was trying to upload the file in my local and everything works fine for me. When I deploy the application in QA(Unix AIX). I am getting the error which is shown below.

Error:
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U 2013-02-11 10:42:21,743 [Servlet.Engine.Transports:5] ERROR com.comerica.forms.types.FileUploadController - SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)

[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U Error Code:393216
[2/11/13 10:42:21:743 EST] 7f17ba9c SystemOut U SQL State:60000

Uploaded File has test@email.com with hyper link in one of the cell. I will send the file in mail.

Please solve this ASAP.
Getting Exception when trying to upload a file with hyperlink data in Unix AIX
S.P.L Srikanth
2013-02-11 18:20:54.0
Data:
Test1
Test2
test@gmail.com(Hyperlink should be available).
Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX
HXTT Support
2013-02-11 18:59:09.0
Failed to recur your issue. Please send your sample file.
Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX
S.P.L Srikanth
2013-02-11 19:19:24.0
I have already sent the mail to webmaster@hxtt.net
Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX
S.P.L Srikanth
2013-02-11 19:23:28.0
Just now I have sent the mail to support@hxtt.com also. As I told, I cannot reproduce the issue in Windows but I can see issue when my app is deployed in UNIX AIX.
Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX
HXTT Support
2013-02-11 22:08:07.0
>java.lang.ArrayIndexOutOfBoundsException: 4090
Your sample is normal, but maybe your upload file contains invalid information. Please download the latest package, which will detect it.
Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX
S.P.L Srikanth
2013-02-12 14:46:36.0
I have downloaded Excel_Core_JDBC20.jar, HXTT_Common_JDBC20.jar and tried to reproduce the issue. I am getting the below error

Error:
[2/12/13 12:59:35:548 EST] 7f05e4d2 SystemOut U 2013-02-12 12:59:35,548 [Servlet.Engine.Transports:10] ERROR com.comerica.forms.types.FileUploadController - SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)

[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:154)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U Error Code:393216
[2/12/13 12:59:35:549 EST] 7f05e4d2 SystemOut U SQL State:60000
Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix AIX
HXTT Support
2013-02-12 17:04:30.0
>I have downloaded Excel_Core_JDBC20.jar, HXTT_Common_JDBC20.jar and tried to reproduce the issue. I am getting the below error
You should download Excel_JDBC20.jar or Excel_Embedded_JDBC20.jar, which is released on 2013-02-12. Older Excel_Core_JDBC20.jar and HXTT_Common_JDBC20.jar should be removed since it hasn't be refreshed this time.
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A
S.P.L Srikanth
2013-02-12 19:38:19.0
Hi have downloaded Excel_JDBC20.jar or Excel_Embedded_JDBC20.jar, removed the old Excel_Core_JDBC20.jar and HXTT_Common_JDBC20.jar and replaced with the downloaded jar files and tested. The belos is the error I got.

Error:
[2/12/13 22:32:54:132 EST] 74c8d0ae SystemOut U 2013-02-12 22:32:54,132 [Servlet.Engine.Transports:7] ERROR com.comerica.forms.types.FileUploadController - SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)

[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U SQL Exception due to java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U java.lang.ArrayIndexOutOfBoundsException: 4090
at com.hxtt.sql.excel.cy.do(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.av.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.if(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bw.a(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.j.(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.int(Unknown Source)(Inlined Compiled Code)
at com.hxtt.sql.excel.bk.new(Unknown Source)(Compiled Code)
at com.hxtt.sql.excel.bk.(Unknown Source)
at com.hxtt.sql.excel.c4.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bk.do(Unknown Source)
at com.hxtt.sql.excel.c2.a(Unknown Source)
at com.hxtt.concurrent.ax.a(Unknown Source)
at com.hxtt.sql.excel.bq.a(Unknown Source)
at com.hxtt.sql.excel.ah.a(Unknown Source)
at com.hxtt.sql.ee.if(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.w.a(Unknown Source)
at com.hxtt.sql.dv.a(Unknown Source)
at com.hxtt.sql.ee.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.a(Unknown Source)
at com.hxtt.sql.a4.executeQuery(Unknown Source)
at com.comerica.forms.types.FileUploadController.convertExcelToBean(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.readAndValidateFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FileUploadController.uploadFile(FileUploadController.java(Compiled Code))
at com.comerica.forms.types.FormLoaderServlet.doPost(FormLoaderServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U Error Code:393216
[2/12/13 22:32:54:133 EST] 74c8d0ae SystemOut U SQL State:60000
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A
HXTT Support
2013-02-12 20:40:08.0
1. How to know the detailed version information of HXTT Excel package?
1st way: "java com.hxtt.sql.excel.ExcelDriver" will print that information.
2nd way: check that MANIFEST.MF file in jar file.

It should be
Specification-Version: 4.1.108 on February 12, 2013
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A
S.P.L Srikanth
2013-02-14 21:30:57.0
When I cross checked
Excel_JDBC20.jar is updated on : 2013-02-10 11:08
Excel_Embedded_JDBC20.jar is updated on : 2013-02-11 09:35

Please check whether these are the updated ones and let me know which one I have to download and validate the issue
Re:Re:Re:Re:Re:Re:Re:Re:Getting Exception when trying to upload a file with hyperlink data in Unix A
HXTT Support
2013-02-14 23:41:34.0
The update date is 2013-02-12. Please login to download it.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap