facebook
  1. MyEclipse Archived
    2.  > 
  2. Application Servers and Deployment

JBoss 5.1.0 GA Closing a result set you left open! Please c

  1. MyEclipse Archived
    2.  > 
  2. Application Servers and Deployment
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • April 12, 2012 at 6:52 pm #325202 Reply

    janice
    Member

    I am using myeclipse 9, jboss 5.10GS, jdk 5, jee 5, struts 2.1,and mysql 5.5.

    I have Result closed after Statements, and Connect closed last.
    My other queries run fine, it is just this select?

    Herer is the server.log information, below.

    2012-04-12 15:06:03,388 INFO [org.jboss.bootstrap.microcontainer.ServerImpl] (main) JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 3m:12s:727ms
    2012-04-12 15:07:55,964 INFO [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (HDScanner) deploy, ctxPath=/StrutsAction
    2012-04-12 15:07:57,787 INFO [com.opensymphony.xwork2.config.providers.XmlConfigurationProvider] (HDScanner) Parsing configuration file [struts-default.xml]
    2012-04-12 15:07:59,659 INFO [com.opensymphony.xwork2.config.providers.XmlConfigurationProvider] (HDScanner) Parsing configuration file [struts-plugin.xml]
    2012-04-12 15:07:59,795 INFO [com.opensymphony.xwork2.config.providers.XmlConfigurationProvider] (HDScanner) Parsing configuration file [struts.xml]
    2012-04-12 15:07:59,836 INFO [com.opensymphony.xwork2.config.impl.DefaultConfiguration] (HDScanner) Overriding property struts.i18n.reload – old value: false new value: true
    2012-04-12 15:07:59,837 INFO [com.opensymphony.xwork2.config.impl.DefaultConfiguration] (HDScanner) Overriding property struts.configuration.xml.reload – old value: false new value: true
    2012-04-12 15:10:29,586 ERROR [STDERR] (http-127.0.0.1-8080-1) java.sql.SQLException: Column ‘FirstName’ not found.
    2012-04-12 15:10:29,587 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2012-04-12 15:10:29,587 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2012-04-12 15:10:29,587 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2012-04-12 15:10:29,587 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2012-04-12 15:10:29,587 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
    2012-04-12 15:10:29,587 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5610)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getString(WrappedResultSet.java:888)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.java.QuickSearch.search(QuickSearch.java:774)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at java.lang.reflect.Method.invoke(Method.java:592)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
    2012-04-12 15:10:29,588 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    2012-04-12 15:10:29,589 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
    2012-04-12 15:10:29,590 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,591 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    2012-04-12 15:10:29,591 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,591 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    2012-04-12 15:10:29,591 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,591 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
    2012-04-12 15:10:29,592 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,592 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    2012-04-12 15:10:29,592 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,593 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,594 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
    2012-04-12 15:10:29,595 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,595 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
    2012-04-12 15:10:29,595 ERROR [STDERR] (http-127.0.0.1-8080-1) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    2012-04-12 15:10:29,595 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    2012-04-12 15:10:29,596 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
    2012-04-12 15:10:29,596 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    2012-04-12 15:10:29,597 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    2012-04-12 15:10:29,597 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2012-04-12 15:10:29,597 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2012-04-12 15:10:29,598 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    2012-04-12 15:10:29,598 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2012-04-12 15:10:29,598 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2012-04-12 15:10:29,598 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
    2012-04-12 15:10:29,598 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    2012-04-12 15:10:29,599 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
    2012-04-12 15:10:29,600 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
    2012-04-12 15:10:29,600 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
    2012-04-12 15:10:29,600 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    2012-04-12 15:10:29,601 ERROR [STDERR] (http-127.0.0.1-8080-1) at java.lang.Thread.run(Thread.java:595)
    2012-04-12 15:10:29,873 INFO [org.jboss.resource.connectionmanager.CachedConnectionManager] (http-127.0.0.1-8080-1) Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@1de1ed4
    java.lang.Throwable: STACKTRACE
    at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:278)
    at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:524)
    at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
    at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
    at com.java.QuickSearch.search(QuickSearch.java:627)
    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:592)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
    at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
    at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
    at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
    at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    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:235)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:595)
    2012-04-12 15:10:29,875 WARN [org.jboss.resource.adapter.jdbc.WrappedConnection] (http-127.0.0.1-8080-1) Closing a statement you left open, please do your own housekeeping
    java.lang.Throwable: STACKTRACE
    at org.jboss.resource.adapter.jdbc.WrappedConnection.registerStatement(WrappedConnection.java:894)

    Here is my Struts Action Class code:
    public String search(){

    DateConversion dt = new DateConversion();
    //calculate date range based on age

    if(this.age.equals(“30”)){
    // began = dt.getDate1(“1980”, “01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }else if(this.age.equals(“40”)){
    // began = dt.getDate1(“1972”, “01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }else if(this.age.equals(“50”)){
    // began = dt.getDate1(“1962”, “01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }else if(this.age.equals(“60”)){
    // began = dt.getDate1(“1952”, “01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }else if(this.age.equals(“70”)){
    // began = dt.getDate1(“1942”, “01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }else if(this.age.equals(“90”)){
    // began = dt.getDate1(“1932”, “01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }else if(this.age.equals(“110”)){
    // began = dt.getDate1(“1922″,”01”, “”);
    end = dt.getDate1(“2012”, “01”, “”);
    }

    try {
    try {
    ic = new InitialContext();
    ds = (DataSource)ic.lookup( “java:/MySqlDS” );
    } catch (NamingException e1) {
    // TODO Auto-generated catch block
    e1.printStackTrace();
    }

    con = ds.getConnection();

    con.setAutoCommit(false);
    pstmt = con.prepareStatement(“SELECT Start_Zipcode, 10_Miles,15_Miles,20_Miles,30_Miles,50_Miles,100_Miles,300_Miles,500_Miles from zipcodes where Major_Cities = ?” );

    String finalMajorCity = this.majorCity();
    pstmt.setString(1, finalMajorCity);

    rs = pstmt.executeQuery();
    if(rs.next()){
    zip_major = rs.getString(“Start_Zipcode”);
    zip1 = rs.getString(“10_Miles”);
    zip2 = rs.getString(“15_Miles”);
    zip3 = rs.getString(“20_Miles”);
    zip4 = rs.getString(“30_Miles”);
    zip5 = rs.getString(“50_Miles”);
    zip6 = rs.getString(“100_Miles”);
    zip7 = rs.getString(“300_Miles”);
    zip8 = rs.getString(“500_Miles”);

    }

    if(this.distance.equals(“10”)){
    finalzip2 = zip1;
    }else if(this.distance.equals(“15”)){
    finalzip2 = zip2;
    }else if(this.distance.equals(“20”)){
    finalzip2 = zip3;

    }else if(this.distance.equals(“30”)){
    finalzip2 = zip4;
    }else if(this.distance.equals(“50”)){
    finalzip2 = zip5;

    }else if(this.distance.equals(“100”)){
    finalzip2 = zip6;
    }else if(this.distance.equals(“300”)){
    finalzip2 = zip7;
    }else if(this.distance.equals(“500”)){
    finalzip2 = zip8;
    }

    servletContext2 = ServletActionContext.getServletContext();

    dataDir = servletContext2.getRealPath(“/content/”);

    File image = new File(dataDir);

    try {
    fos = new FileOutputStream(image);
    //your create the name of the file by test.jpg.
    // OutputStream out=new FileOutputStream(“C:\\photos\\test.jpg”);
    } catch (FileNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    /** try {
    // Call a procedure with one OUT parameter
    cs = con.prepareCall(“{call quickSearch(?,?,?,?,?,?,?,?,?)}”);

    // Set the value for the IN parameter
    cs.setString(1,zip_major);
    cs.setString(2,finalzip2);
    cs.setDate(3,end);
    cs.setString(4,this.gender);

    // Register the type of the OUT parameter
    cs.registerOutParameter(5, Types.VARCHAR);
    cs.registerOutParameter(6, Types.VARCHAR);
    cs.registerOutParameter(7, Types.VARCHAR);
    cs.registerOutParameter(8, Types.DATE);
    cs.registerOutParameter(9, Types.BLOB);

    // Execute the stored procedure and retrieve the OUT value
    boolean hadResult = cs.execute();

    while (hadResult) {
    rs2 = cs.getResultSet();

    firstName.put(y, rs2.getString(1)); // OUT parameter
    cityReturn.put(y, rs2.getString(2)); // OUT parameter
    stateReturn.put(y, rs2.getString(3)); // OUT parameter
    ageReturn.put(y, this.getYear(rs2.getDate(4))); // OUT parameter

    try {

    blob = rs2.getBlob(5); // OUT parameter
    InputStream is = blob.getBinaryStream();
    byte[] buffer = new byte[is.available()];
    while (is.read(buffer) > 0) {
    fos.write(buffer);
    fos.flush();
    }
    //fos.close();
    } catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    try {
    fos.close();
    } catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    y++;
    hadResult = cs.getMoreResults();
    } // end while loop
    } catch (SQLException e) {
    log.info(e.getMessage());
    }

    **/

    pstmt2 = con.prepareStatement(“SELECT c.FirstName, c.City, c.State,p.birthdate , p.photos “+
    “from customer c, profile p WHERE c.CustomerId = p.CustomerId AND “+
    ” c.Zipcode >= ? AND c.Zipcode <= ? AND p.birthdate <= CURDATE() AND p.birthdate >= ? AND p.gender = ?”, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
    // Set the values

    pstmt2.setString(1,zip_major);
    pstmt2.setString(2,finalzip2);
    pstmt2.setDate(3,end);
    pstmt2.setString(4,this.gender);
    //Insert the row
    rs = pstmt.executeQuery();

    int y =0; Blob blob;

    servletContext2 = ServletActionContext.getServletContext();

    dataDir = servletContext2.getRealPath(“/content/”);
    rs.beforeFirst();
    if(rs.next()){
    firstName.put(y, rs.getString(“FirstName”));
    cityReturn.put(y, rs.getString(“City”));
    stateReturn.put(y, rs.getString(“State”));
    ageReturn.put(y, this.getYear(rs.getDate(“birthdate”)));

    /*
    Blob test=rs.getBlob(“photos”);
    InputStream x=test.getBinaryStream();
    int size=x.available();
    OutputStream out=new FileOutputStream(“C:\\photos\\test.jpg”);
    byte b[]= new byte[size];
    x.read(b);
    out.write(b);
    } */
    try {
    fos = new FileOutputStream(image);
    } catch (FileNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    blob = rs.getBlob(“photos”);
    try {
    InputStream is = blob.getBinaryStream();
    byte[] buffer = new byte[is.available()];
    while (is.read(buffer) > 0) {
    fos.write(buffer);
    fos.flush();
    }
    fos.close();
    } catch (IOException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    y++;
    }

    con.commit();

    } catch (SQLException e) {
    e.printStackTrace();
    } finally {
    /** try {
    if (cs != null && !((Connection) cs).isClosed()) {
    cs.close();
    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    } */

    /* try {
    if (rs2 != null && !((Connection) rs2).isClosed()) {
    rs2.close();
    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    } */
    try {
    if (pstmt != null && !((Connection) pstmt).isClosed()) {
    pstmt.close();
    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    try {
    if (pstmt2 != null && !((Connection) pstmt2).isClosed()) {
    pstmt2.close();
    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    try {
    if (rs != null && !((Connection) rs).isClosed()) {
    rs.close();
    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    try {
    if (con != null && !con.isClosed()) {
    con.close();
    }
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }
    try {
    con.setAutoCommit(true);
    } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    }

    }//end finally

    //set images for display
    //set images for display

    uploadFiles();

    return “success”;

    }

    Here is my mysql-ds.xml file:

    <?xml version=”1.0″ encoding=”UTF-8″?>
    <!– See http://www.jboss.org/community/wiki/Multiple1PC for information about local-tx-datasource –>
    <!– $Id: mysql-ds.xml 88948 2009-05-15 14:09:08Z jesper.pedersen $ –>
    <!– Datasource config for MySQL using 3.0.9 available from:
    http://www.mysql.com/downloads/api-jdbc-stable.html
    –>
    <datasources>
    <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/datin</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>xxxxx</password>

    <!– <use-java-context>false</use-java-context> –>
    <min-pool-size>5</min-pool-size>
    <max-pool-size>100</max-pool-size>
    <track-statements>true</track-statements>
    <idle-timeout-minutes>2</idle-timeout-minutes>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <!– should only be used on drivers after 3.22.1 with “ping” support –>
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>

    <!– sql to call when connection is created
    <new-connection-sql>some arbitrary sql</new-connection-sql>
    –>
    <!– sql to call on an existing pooled connection when it is obtained from pool – MySQLValidConnectionChecker is preferred for newer drivers
    <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
    –>

    <!– corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) –>
    <metadata>
    <type-mapping>MySQL</type-mapping>
    </metadata>
    </local-tx-datasource>
    </datasources>

    Here are the tables:

    Customer Table-
    select
    `CustomerId`,
    `FirstName`,
    `MiddleName`,
    `LastName`,
    `Address1`,
    `Address2`,
    `City`,
    `State`,
    `Zipcode`,
    `Country`,
    `Email`,
    `Email2`,
    `PhoneNumber`,
    `Cell`
    from
    `datin`.`customer`

    Profile Table-
    select
    `ProfileId`,
    `CustomerId`,
    `birthdate`,
    `major_city`,
    `gender`,
    `marital_status`,
    `living_status`,
    `ethnicity`,
    `seeking`,
    `children`,
    `religion`,
    `sexual_openness`,
    `describe_looks`,
    `hair_color`,
    `eye_color`,
    `height`,
    `body_type`,
    `education`,
    `career`,
    `politics`,
    `income_level`,
    `smoking_habit`,
    `drug_habit`,
    `drinking_habit`,
    `about_me`,
    `attracted_to`,
    `likes`,
    `photos`,
    `photos1`,
    `photos2`,
    `photos3`,
    `photos4`,
    `photos5`
    from
    `datin`.`profile`

    April 13, 2012 at 3:49 am #325206 Reply

    support-swapna
    Moderator

    janice,

    Sorry that you are seeing this issue. This is more of a JBoss issue rather than a MyEclipse one.

    Do you see any issues when deploying this project to any other server apart from JBoss ?

    I suggest you cross post to JBoss communities for better support

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: JBoss 5.1.0 GA Closing a result set you left open! Please c

You must be logged in to post in the forum log in