You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Roman Novak <r....@iqsoft.at> on 2004/10/15 13:09:45 UTC
Re: Slide Oracle Store: ORA-01461 <- resolved
Tx Oliver.
I did a complete checkout of all sources again and made a clean build from that.
The issue is resolved. Seems I must have had some inconsistency in a crucial place :(
I hope I wasted mostly only my time on this.
Roman
Am Mi 13.10.2004 21:32, Oliver Zeigermann <ol...@gmail.com> schrieb:
> I do not use the Oracle store, so I am of little help. However, the
> only change to classes that might be concerned with storing blobs
> since 31st August seems to be the calculation of the content length.
> This may be the problem you experience as the SQL error indicates a
> long is tried to be saved to a NUMBER(10) field.
>
> As the changes made there seem pretty reasonable could you try and
> revert *only* CommonRDBMSAdapter to version 1.6 (which will be the
> one checked out on 31st of August) and report back if this fixes your
> problem.
>
> From there we can go on then...
>
> Oliver
>
>
> On Wed, 13 Oct 2004 15:33:31 +0200 (CEST), Roman Novak
> <r....@iqsoft.at> wrote:
> > Additional Info:
> > my working build is from 31st of August.. luckily I found it.
> >
> > Am Mi 13.10.2004 15:06, Roman Novak <r....@iqsoft.at> schrieb:
> >
> > > Hi,
> > >
> > > I recently get an error with the Oracle store during file uploads (I run JBoss 3.23 and Oracle9i 9.2.0.4.0), which didn't occur before.
> > > - I have a store running with lots of items already in it.
> > > - I checked out the latest files.
> > >
> > > Interestingly I can't rebuild a working version with the beta from 10th August either. I did my working build somewhen around the 20th August.
> > >
> > > Has anyone the same problems with the Oracle store ?
> > >
> > > Roman
> > >
> > > The error looks like this:
> > > 14:54:08,703 ERROR [STDERR] at org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.impl.rdbms.JDBCStore@5d3ac0 access error : ORA-01461: can bind a LONG value only for insert into a LONG column
> > > 14:54:08,703 ERROR [STDERR] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(StandardRDBMSAdapter.java:1440)
> > > 14:54:08,703 ERROR [STDERR] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(StandardRDBMSAdapter.java:1086)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionContent(StandardRDBMSAdapter.java:1037)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevisionContent(AbstractRDBMSStore.java:823)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.store.AbstractStore.createRevisionContent(AbstractStore.java:1347)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.store.ExtendedStore.createRevisionContent(ExtendedStore.java:508)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.content.ContentImpl.create(ContentImpl.java:548)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java:392)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMethod.java:386)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:164)
> > > 14:54:08,718 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
> > > 14:54:08,718 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org