Update your jdbc driver to the newest version.
Or use http://jtds.sourceforge.net/.
Ｍａｙbe there are some advice about this in hibernate's doc.
2007/1/31, Himanshu Singh <[EMAIL PROTECTED]>:
Hi,
I'm trying to set up Roller using MS Sql Server 2K. Below are the
environment details:
Roller Version: 3.0
Application Server: Tomcat 5.0.28
Databse: MS SQL Server 2000
Java Version: 1.4.2
Operating System: MS Windows 2000 Server (SP4)
Browser: MS IE 6.0
I am using a jndi to connect to the SQL server database; and I have
uncommented the following node in the hibernate config file:
<property
name="dialect">org.hibernate.dialect.SQLServerDialect</property>
Roller server starts up fine and I was able to create the admin user. I
checked the 'rolleruser' table and found the record there.
However, when I try and create a new weblog, I am getting the following
error:
WARN 2007-01-31 10:35:17,080 JDBCExceptionReporter:logExceptions - SQL
Error: 0, SQLState: HY010
ERROR 2007-01-31 10:35:17,080 JDBCExceptionReporter:logExceptions -
[Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row
data for column 1.
WARN 2007-01-31 10:35:40,707 JDBCExceptionReporter:logExceptions - SQL
Error: 0, SQLState: HY010
ERROR 2007-01-31 10:35:40,707 JDBCExceptionReporter:logExceptions -
[Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row
data for column 1.
ERROR 2007-01-31 10:35:40,707 CreateWebsiteAction:save - ERROR in
createWebsite
org.apache.roller.RollerException
at
org.apache.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogCategoryAncestorAssocs
(HibernateWeblogManagerImpl.java:779)
at
org.apache.roller.pojos.WeblogCategoryData.getAncestorAssocs(
WeblogCategoryData.java:397)
at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.store(
HibernatePersistenceStrategy.java:292)
at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.addWeblogContents
(HibernateUserManagerImpl.java:271)
at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.addWebsite(
HibernateUserManagerImpl.java:247)
at
org.apache.roller.ui.core.struts.actions.CreateWebsiteAction.save(
CreateWebsiteAction.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(
DispatchAction.java:276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.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(
ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.RequestFilter.doFilter(
RequestFilter.java:83)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.rendering.filters.RequestMappingFilter.doFilter(
RequestMappingFilter.java:140)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.InitFilter.doFilter(InitFilter.java:71)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(
PersistenceSessionFilter.java:60)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(
FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(
FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(
ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(
AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter
(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(
ChannelProcessingFilter.java:138)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(
RememberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(
AbstractProcessingFilter.java:217)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(
HttpSessionContextIntegrationFilter.java:191)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java
:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:90)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(
SchemeEnforcementFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(
CharEncodingFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(
StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
--- ROOT CAUSE ---
org.hibernate.exception.GenericJDBCException: could not execute query
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
SQLStateConverter.java:91)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:79)
at
org.hibernate.exception.JDBCExceptionHelper.convert(
JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at
org.apache.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogCategoryAncestorAssocs
(HibernateWeblogManagerImpl.java:777)
at
org.apache.roller.pojos.WeblogCategoryData.getAncestorAssocs(
WeblogCategoryData.java:397)
at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.store(
HibernatePersistenceStrategy.java:292)
at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.addWeblogContents
(HibernateUserManagerImpl.java:271)
at
org.apache.roller.business.hibernate.HibernateUserManagerImpl.addWebsite(
HibernateUserManagerImpl.java:247)
at
org.apache.roller.ui.core.struts.actions.CreateWebsiteAction.save(
CreateWebsiteAction.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(
DispatchAction.java:276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.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(
ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.RequestFilter.doFilter(
RequestFilter.java:83)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.rendering.filters.RequestMappingFilter.doFilter(
RequestMappingFilter.java:140)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.InitFilter.doFilter(InitFilter.java:71)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(
PersistenceSessionFilter.java:60)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(
FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(
FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(
ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(
AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter
(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(
ChannelProcessingFilter.java:138)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(
RememberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(
AbstractProcessingFilter.java:217)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(
HttpSessionContextIntegrationFilter.java:191)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java
:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:90)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(
SchemeEnforcementFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(
CharEncodingFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(
StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(
StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java
:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]ResultSet can not re-read row data for column 1.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown
Source)
at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
at
org.apache.commons.dbcp.DelegatingResultSet.getString(
DelegatingResultSet.java:224)
at org.hibernate.type.StringType.get(StringType.java:18)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:554)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 87 more
Could you please help.
Regards,
Himanshu
**********************************************************************
***** IMPORTANT INFORMATION *****
This document should be read only by those persons to whom it is
addressed and its content is not intended for use by any other
persons. If you have received this message in error, please notify
us immediately. Please also destroy and delete the message from
your computer. Any unauthorised form of reproduction of this message
is strictly prohibited.
St George Bank Limited AFSL 240997, Advance Asset Management Limited
AFSL 240902, St George Life Limited AFSL 240900, ASGARD Capital
Management Limited
AFSL 240695 and Securitor Financial Group Limited AFSL 240687 is not
liable for
the proper and complete transmission of the information contained in
this communication, nor for any delay in its receipt.
**********************************************************************
