I am new to flashrecruit and I am currently trying to deploy it for a customer. I have followed the instructions for deploying flash recruit on an already installed JBoss application server but I seem to be having a very strange database issue. Below is a breakdown of my system specs and what I have done to deploy the application. Any help with this will be greatly appreciated.
System Specifications JBoss 4.0.5 GA MySQL server 5.0.27 J2SE 5.0 apache-ant-1.7.0 flashrecruit 0.9.8.0 Configuration site.properties (actual username and passswords not included) database.hibernate.dialect=org.hibernate.dialect.MySQLDialect database.jdbc.driver=com.mysql.jdbc.Driver database.url=jdbc:mysql://localhost:3306/ database.url.complete=${database.url}${database.name} host=jobs.nationalanesthesia.com jboss.base.dir=/opt/jboss4 test.host.ip=${host} admin.first.name=Admin admin.last.name=User [EMAIL PROTECTED] admin.user.name=admin admin.user.password=password #----------------------------------------------------------------- ## Testing settings ant.dir=/opt/ant #----------------------------------------------------------------- ## RUNTIME SETTINGS ## # Look and Feel of Public Site #public.site.theme=patriot #public.site.theme=meadow #public.site.theme=rainforest public.site.theme=ocean calendar.module.enabled=true debug=off debuglevel=lines,vars,source # ---------------------------------------------------------------- # Status transition mapping # status.transition.mapping=post-appr # Posting needs approval from a recruiting manager. # # status.transition.mapping=simple # No approvals needed for posting/unposting # # status.transition.mapping=enterprise # # ---------------------------------------------------------------- status.transition.mapping=post-appr #Default location for new jobs job.default.location=60100 #----------------------------------------------------------------- # vectrics.data.dir - the directory where FlashRecruit will store # local configuration files, cached information and # documents. #----------------------------------------------------------------- vectrics.data.dir=/opt/flashrecruit/data/ #----------------------------------------------------------------- # FlashRecruit emailing configuration. #----------------------------------------------------------------- mailer.host=localhost mailer.user=job mailer.password= mailer.from.name=Jobs [EMAIL PROTECTED] #----------------------------------------------------------------- # FlashRecruit email configuration for received resumes and cover # letters. #----------------------------------------------------------------- resume.recipient.email.host=localhost [EMAIL PROTECTED] resume.recipient.email.password=passowrd #pop3 or imap resume.recipient.server.type=pop3 #true or false demostration.version=false debug.javascript=false #----------------------------------------------------------------- # Database information - used by Ant schema building tasks. database.name=flashrecruit database.admin.user=flash database.admin.password=password database.application.user=mydb database.application.password=mypasswd jboss.server.dir=${jboss.base.dir}/server/default j2ee.deploy.dir=${jboss.server.dir}/deploy j2ee.lib.dir=${jboss.server.dir}/lib j2ee.ext-lib.dir=${jboss.server.dir}/lib/ext j2ee.schema.dir=${jboss.base.dir}/schema sql.print=yes I get the exception below sometimes. Its like the database connection does not stay active and the application is not fully deployed. org.vectrics.SystemException: Exception comitting transaction org.vectrics.hibernate.ThreadProperties.commitTransaction(ThreadProperties.java:541) org.vectrics.hibernate.ThreadProperties.forcedCommitAndClose(ThreadProperties.java:380) org.vectrics.struts.VectricsServlet.service(VectricsServlet.java:201) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) Below is what the log is showing when I get this exception. 2007-01-24 07:46:35,026 DEBUG [org.hibernate.transaction.JDBCTransaction] commit 2007-01-24 07:46:35,026 DEBUG [org.vectrics.common.db.AuditInterceptor] beforeTransactionCompletion() called 2007-01-24 07:46:35,026 DEBUG [org.hibernate.transaction.JDBCTransaction] re-enabling autocommit 2007-01-24 07:46:35,027 ERROR [org.hibernate.transaction.JDBCTransaction] Could not toggle autocommit java.sql.SQLException: Connection handle has been closed and is unusable at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537) at org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:321) at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194) at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115) at org.vectrics.hibernate.ThreadProperties.commitTransaction(ThreadProperties.java:503) at org.vectrics.hibernate.ThreadProperties.forcedCommitAndClose(ThreadProperties.java:380) at org.vectrics.struts.VectricsServlet.service(VectricsServlet.java:201) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) 2007-01-24 07:46:35,028 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC commit failed java.sql.SQLException: Connection handle has been closed and is unusable at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524) at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:333) at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115) at org.vectrics.hibernate.ThreadProperties.commitTransaction(ThreadProperties.java:503) at org.vectrics.hibernate.ThreadProperties.forcedCommitAndClose(ThreadProperties.java:380) at org.vectrics.struts.VectricsServlet.service(VectricsServlet.java:201) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) 2007-01-24 07:46:35,119 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection 2007-01-24 07:46:35,119 DEBUG [org.hibernate.jdbc.ConnectionManager] closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 2007-01-24 07:46:35,119 DEBUG [org.vectrics.common.db.AuditInterceptor] afterTransactionCompletion() called 2007-01-24 07:46:35,119 ERROR [org.vectrics.hibernate.ThreadProperties] Exception committing transaction - thread: TP-Processor2 org.hibernate.TransactionException: JDBC commit failed at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:130) at org.vectrics.hibernate.ThreadProperties.commitTransaction(ThreadProperties.java:503) at org.vectrics.hibernate.ThreadProperties.forcedCommitAndClose(ThreadProperties.java:380) at org.vectrics.struts.VectricsServlet.service(VectricsServlet.java:201) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java System Constant ( only thing I changed here is the URL for Public Site Settings) http://jobs.nationalanesthesia.com/recruit/public/31100001/index.do may or may not get a exception. If you do get one after one or 2 refresh the application comes up fine but your next click you will probably get a exception again. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4005766#4005766 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4005766 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user