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: '[email protected]'
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: [EMAIL PROTECTED]
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
