[jboss-user] [Messaging, JMS & JBossMQ] - Flashrecriut problem

nayabingi do-not-reply at jboss.com
Wed Jan 24 07:57:04 EST 2007 

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 at 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 at mydomain.com

#-----------------------------------------------------------------
# FlashRecruit email configuration for received resumes and cover
#  letters.
#-----------------------------------------------------------------
resume.recipient.email.host=localhost
resume.recipient.email.username=resumes at 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. 
 



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

More information about the jboss-user mailing list