You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by "Lihn, Steve" <ho...@merck.com> on 2006/11/16 20:32:37 UTC
ORA-00932: inconsistent datatypes: expected - got CLOB
I am getting another Oracle error. It seems to come up quite regularly.
Any idea what could've caused it?
--
ERROR 2006-11-16 00:00:00,596 HibernateRefererManagerImpl:clearReferrers
- EXCEPTION resetting referers
org.hibernate.exception.SQLGrammarException: could not execute update
query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:65)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
java:43)
at
org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:84)
at
org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorI
mpl.java:334)
at
org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPla
n.java:209)
at
org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at
org.apache.roller.business.hibernate.HibernateRefererManagerImpl.clearRe
ferrers(HibernateRefererManagerImpl.java:114)
at
org.apache.roller.ui.core.tasks.TurnoverReferersTask.run(TurnoverReferer
sTask.java:60)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes:
expected - got CLOB
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
1)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
a:215)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
ent.java:954)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1167)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
dStatement.java:3315)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:3399)
at
org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
... 8 more
-----Original Message-----
From: Lihn, Steve
Sent: Wednesday, November 15, 2006 4:46 PM
To: 'roller-user@incubator.apache.org'
Subject: ORA-01400: cannot insert NULL into
("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
Did anybody encounter the above error in Roller 3.0 (RC1)?
My users have a hard time posting entries and comments due to this
error. I went into Oracle database and change WEBLOGENTRY.TEXT to
NULLable (instead of NOT NULL). The error went away and the system is
functioning correctly again.
A section of the log is attached below.
Steve Lihn
--
INFO 2006-11-15 14:49:37,346 RendererManager:<clinit> - Renderer
Manager Initialized.
INFO 2006-11-15 14:49:37,355 RollerVelocity:<clinit> - Initializing
Velocity Rendering Engine
WARN 2006-11-15 14:53:39,262 JDBCExceptionReporter:logExceptions - SQL
Error: 1400, SQLState: 23000
ERROR 2006-11-15 14:53:39,264 JDBCExceptionReporter:logExceptions -
ORA-01400: cannot insert NULL into ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
WARN 2006-11-15 14:53:39,267 JDBCExceptionReporter:logExceptions - SQL
Error: 1400, SQLState: 23000
ERROR 2006-11-15 14:53:39,269 JDBCExceptionReporter:logExceptions -
ORA-01400: cannot insert NULL into ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
ERROR 2006-11-15 14:53:39,277
AbstractFlushingEventListener:performExecutions - Could not synchronize
database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute
JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:69)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
java:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202
)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java:296)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv
entListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:10
6)
at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush(
HibernatePersistenceStrategy.java:93)
at
org.apache.roller.business.hibernate.HibernateRollerImpl.flush(Hibernate
RollerImpl.java:92)
at
org.apache.roller.ui.authoring.struts.actions.WeblogEntryFormAction.save
(WeblogEntryFormAction.java:321)
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
ocessor.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
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.roller.ui.core.filters.RequestFilter.doFilter(RequestFilter.j
ava:83)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.roller.ui.rendering.filters.RequestMappingFilter.doFilter(Req
uestMappingFilter.java:140)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.roller.ui.core.filters.InitFilter.doFilter(InitFilter.java:71
)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(Pers
istenceSessionFilter.java:60)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterS
ecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Filte
rSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTransl
ationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilt
er(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(Channel
ProcessingFilter.java:138)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Reme
mberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin
gFilter.java:217)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H
ttpSessionContextIntegrationFilter.java:191)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
erChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1
48)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
:90)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(Schem
eEnforcementFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(CharEncodi
ngFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java: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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
678)
at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL
into ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError
.java:342)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedSt
atement.java:10698)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5
8)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195
)
... 77 more
INFO 2006-11-15 14:53:39,746 WriteToIndexOperation:run - Starting
search index operation
INFO 2006-11-15 14:53:40,440 WriteToIndexOperation:run - Search index
operation complete
------------------------------------------------------------------------------
Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates (which may be known
outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD
and in Japan, as Banyu - direct contact information for affiliates is
available at http://www.merck.com/contact/contacts.html) that may be
confidential, proprietary copyrighted and/or legally privileged. It is
intended solely for the use of the individual or entity named on this
message. If you are not the intended recipient, and have received this
message in error, please notify us immediately by reply e-mail and then
delete it from your system.
------------------------------------------------------------------------------
Re: ORA-00932: inconsistent datatypes: expected - got CLOB
Posted by Ben Avery <be...@youthnet.org>.
yeah, I get that one too, on a blog I'm running on 2.1 that I haven't
had time to upgrade to 3, or investigate. I have another one running 3.0
that seems immune to this.
Lihn, Steve wrote:
> I am getting another Oracle error. It seems to come up quite regularly.
> Any idea what could've caused it?
> --
> ERROR 2006-11-16 00:00:00,596 HibernateRefererManagerImpl:clearReferrers
> - EXCEPTION resetting referers
> org.hibernate.exception.SQLGrammarException: could not execute update
> query
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
> :65)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
> java:43)
> at
> org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:84)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorI
> mpl.java:334)
> at
> org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPla
> n.java:209)
> at
> org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1148)
> at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
> at
> org.apache.roller.business.hibernate.HibernateRefererManagerImpl.clearRe
> ferrers(HibernateRefererManagerImpl.java:114)
> at
> org.apache.roller.ui.core.tasks.TurnoverReferersTask.run(TurnoverReferer
> sTask.java:60)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> Caused by: java.sql.SQLException: ORA-00932: inconsistent datatypes:
> expected - got CLOB
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
> 1)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
> a:215)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatem
> ent.java:954)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
> java:1167)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
> dStatement.java:3315)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
> tatement.java:3399)
> at
> org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
> ... 8 more
>
> -----Original Message-----
> From: Lihn, Steve
> Sent: Wednesday, November 15, 2006 4:46 PM
> To: 'roller-user@incubator.apache.org'
> Subject: ORA-01400: cannot insert NULL into
> ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
>
> Did anybody encounter the above error in Roller 3.0 (RC1)?
>
> My users have a hard time posting entries and comments due to this
> error. I went into Oracle database and change WEBLOGENTRY.TEXT to
> NULLable (instead of NOT NULL). The error went away and the system is
> functioning correctly again.
>
> A section of the log is attached below.
>
> Steve Lihn
>
> --
> INFO 2006-11-15 14:49:37,346 RendererManager:<clinit> - Renderer
> Manager Initialized.
> INFO 2006-11-15 14:49:37,355 RollerVelocity:<clinit> - Initializing
> Velocity Rendering Engine
> WARN 2006-11-15 14:53:39,262 JDBCExceptionReporter:logExceptions - SQL
> Error: 1400, SQLState: 23000
> ERROR 2006-11-15 14:53:39,264 JDBCExceptionReporter:logExceptions -
> ORA-01400: cannot insert NULL into ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
>
> WARN 2006-11-15 14:53:39,267 JDBCExceptionReporter:logExceptions - SQL
> Error: 1400, SQLState: 23000
> ERROR 2006-11-15 14:53:39,269 JDBCExceptionReporter:logExceptions -
> ORA-01400: cannot insert NULL into ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
>
> ERROR 2006-11-15 14:53:39,277
> AbstractFlushingEventListener:performExecutions - Could not synchronize
> database state with session
> org.hibernate.exception.ConstraintViolationException: Could not execute
> JDBC batch update
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
> :69)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
> java:43)
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202
> )
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
> AbstractFlushingEventListener.java:296)
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEv
> entListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
> at
> org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:10
> 6)
> at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush(
> HibernatePersistenceStrategy.java:93)
> at
> org.apache.roller.business.hibernate.HibernateRollerImpl.flush(Hibernate
> RollerImpl.java:92)
> at
> org.apache.roller.ui.authoring.struts.actions.WeblogEntryFormAction.save
> (WeblogEntryFormAction.java:321)
> 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
> ocessor.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
> tionFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.roller.ui.core.filters.RequestFilter.doFilter(RequestFilter.j
> ava:83)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.roller.ui.rendering.filters.RequestMappingFilter.doFilter(Req
> uestMappingFilter.java:140)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.roller.ui.core.filters.InitFilter.doFilter(InitFilter.java:71
> )
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(Pers
> istenceSessionFilter.java:60)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:264)
> at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterS
> ecurityInterceptor.java:107)
> at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Filte
> rSecurityInterceptor.java:72)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTransl
> ationFilter.java:110)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter
> (AnonymousProcessingFilter.java:125)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilt
> er(SecurityContextHolderAwareRequestFilter.java:81)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(Channel
> ProcessingFilter.java:138)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Reme
> mberMeProcessingFilter.java:142)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin
> gFilter.java:217)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H
> ttpSessionContextIntegrationFilter.java:191)
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt
> erChainProxy.java:274)
> at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1
> 48)
> at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java
> :90)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(Schem
> eEnforcementFilter.java:121)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(CharEncodi
> ngFilter.java:104)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java: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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
> at
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
> at
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
> at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
> 678)
> at
> org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
> .java:684)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL
> into ("BLOG_ROLLER"."WEBLOGENTRY"."TEXT")
>
> at
> oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError
> .java:342)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedSt
> atement.java:10698)
> at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5
> 8)
> at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195
> )
> ... 77 more
> INFO 2006-11-15 14:53:39,746 WriteToIndexOperation:run - Starting
> search index operation
> INFO 2006-11-15 14:53:40,440 WriteToIndexOperation:run - Search index
> operation complete
>
>
> ------------------------------------------------------------------------------
> Notice: This e-mail message, together with any attachments, contains
> information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
> New Jersey, USA 08889), and/or its affiliates (which may be known
> outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD
> and in Japan, as Banyu - direct contact information for affiliates is
> available at http://www.merck.com/contact/contacts.html) that may be
> confidential, proprietary copyrighted and/or legally privileged. It is
> intended solely for the use of the individual or entity named on this
> message. If you are not the intended recipient, and have received this
> message in error, please notify us immediately by reply e-mail and then
> delete it from your system.
>
> ------------------------------------------------------------------------------
--
Ben Avery
Software Developer
Youthnet UK
email: ben.avery@youthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ