MyEclipse Forums
This thread has been locked & this forum has been archived.
Please post new topics to Java EE Development (EJB, JSP, Struts, XDoclet, etc.)
View previous topic Printable version Log in to check your private messages View next topic
Author Message
janice
Post subject: JBoss 5.1.0 GA Closing a result set you left open! Please c  PostPosted: Apr 13, 2012 - 12:52 AM
Registered Member
Registered Member


Joined: Feb 15, 2005
Posts: 5

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`
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
support-swapna
Post subject:   PostPosted: Apr 13, 2012 - 09:49 AM



Joined: Nov 11, 2010
Posts: 2499

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

_________________
Swapna
MyEclipse Support
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits