1 Reply Latest reply on Jan 27, 2007 2:34 AM by Elias Ross

    Flashrecriut problem

    Mohamed King Newbie

      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.