Flashrecriut problem
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
admin.email=admin@mydomain.com
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
mailer.from.address=job@mydomain.com
#-----------------------------------------------------------------
# FlashRecruit email configuration for received resumes and cover
# letters.
#-----------------------------------------------------------------
resume.recipient.email.host=localhost
resume.recipient.email.username=resumes@mydomain.com
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.
