No data found? I saw an EOFException . Did the data in the tables load
up?
-----Original Message-----
From: Andy Akins [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 2:16 PM
To: [email protected]
Subject: Error thrown trying to create a blog...
I've got Roller set up, I believe correctly. Its running on Tomcat 5.5,
under JVM 1.5r6 under Red Hat ES3. Its talking to a mysql 5.0.17
database, which has a roller user with all privileges, and the tables
have been created.
However, when I try to create a blog, the following shows up in the
logs:
ERROR 2006-05-22 14:09:44,016 StandardWrapperValve:invoke -
Servlet.service() for servlet action threw exception
org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(E
rror
CodeConverter.java:92)
at
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.ja
va:8
0)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
java
:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:11
1)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:433)
at
org.roller.business.hibernate.HibernateUserManagerImpl.getWebsiteByHandl
e(Hi
bernateUserManagerImpl.java:167)
at
org.roller.business.UserManagerImpl.getWebsiteByHandle(UserManagerImpl.j
ava:
103)
at
org.roller.presentation.website.actions.CreateWebsiteAction.validate(Cre
ateW
ebsiteAction.java:201)
at
org.roller.presentation.website.actions.CreateWebsiteAction.save(CreateW
ebsi
teAction.java:114)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j
ava:
276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196
)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
oces
sor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.jav
a:79
)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilt
er.j
ava:77)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persis
tenc
eSessionFilter.java:43)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:292)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterS
ecur
ityInterceptor.java:116)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Filte
rSec
urityInterceptor.java:79)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTransl
atio
nFilter.java:143)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(Ano
nymousProcessingFilter.java:138)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilt
er(S
ecurityContextHolderAwareRequestFilter.java:50)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(Channel
Proc
essingFilter.java:168)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Reme
mber
MeProcessingFilter.java:174)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin
gFil
ter.java:246)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H
ttpS
essionContextIntegrationFilter.java:220)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1
73)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:120
)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeE
nfor
cementFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncoding
Filt
er.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.ja
va:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105
)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java
:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.j
ava:
833)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.proce
ss(H
ttp11AprProtocol.java:639)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState
ment
.java:1347)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta
teme
nt.java:958)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:170
5)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Del
egat
ingPreparedStatement.java:92)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120
)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade
r.ja
va:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:11
1)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:433)
at
org.roller.business.hibernate.HibernateUserManagerImpl.getWebsiteByHandl
e(Hi
bernateUserManagerImpl.java:167)
at
org.roller.business.UserManagerImpl.getWebsiteByHandle(UserManagerImpl.j
ava:
103)
at
org.roller.presentation.website.actions.CreateWebsiteAction.validate(Cre
ateW
ebsiteAction.java:201)
at
org.roller.presentation.website.actions.CreateWebsiteAction.save(CreateW
ebsi
teAction.java:114)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j
ava:
276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196
)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
oces
sor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.jav
a:79
)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilt
er.j
ava:77)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persis
tenc
eSessionFilter.java:43)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:292)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterS
ecur
ityInterceptor.java:116)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Filte
rSec
urityInterceptor.java:79)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTransl
atio
nFilter.java:143)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(Ano
nymousProcessingFilter.java:138)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilt
er(S
ecurityContextHolderAwareRequestFilter.java:50)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(Channel
Proc
essingFilter.java:168)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Reme
mber
MeProcessingFilter.java:174)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin
gFil
ter.java:246)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H
ttpS
essionContextIntegrationFilter.java:220)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erCh
ainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1
73)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:120
)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeE
nfor
cementFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncoding
Filt
er.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tion
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erCh
ain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.ja
va:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126
)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105
)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java
:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.j
ava:
833)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.proce
ss(H
ttp11AprProtocol.java:639)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState
ment
.java:1347)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta
teme
nt.java:958)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:170
5)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Del
egat
ingPreparedStatement.java:92)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120
)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade
r.ja
va:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 70 more
Any ideas? I'm fairly sure that the MySQL is functioning properly -
other apps use it as well, and have no problems.
Here's my context file, sans passwords:
<Context path="/blogs" docBase="/opt/roller/blogs" debug="0">
<Resource name="jdbc/rollerdb" auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://mdb.tnanytime.org:3306/roller?autoReconnect=true&u
seUn
icode=true&characterEncoding=utf-8&mysqlEncoding=utf8"
username="roller"
password="blahblah"
maxActive="20"
maxIdle="3"
removeAbandoned="true"
maxWait="3000" />
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"
mail.smtp.host="dns.tnanytime.org" /> </Context>
Thanks!
--
Andy Akins
Director of Development
TennesseeAnytime - A partnership with Tennessee.gov
Phone: 615.313.0305
Fax: 615.313.0301
Email: [EMAIL PROTECTED]
Visit www.Tennessee.gov the official Web site for the State of Tennessee
**********************************
CONFIDENTIALITY NOTICE:
This E-mail and any attachments are confidential. If you are not the
intended recipient, you do not have permission to disclose, copy,
distribute, or open any attachments. If you have received this E-mail in
error, please notify us immediately by returning it to the sender and
delete this copy from your system.
Thank you. TennesseeAnytime
**********************************
