I finally managed to find the problem.I was using the oracle thin driver
(classes12.jar) but it seems to work fine with the ojdbc14.Don't know
why!Anyway, thanks a lot!> Date: Wed, 9 May 2007 12:40:28 -0700> From: [EMAIL
PROTECTED]> To: [email protected]> Subject: Re: Roller problems with
oracle> > Oracle works great, for the most part, but you need to use an up to
date > JDBC driver.> > Implicit handling of Clob data as strings is new in
10g.> >
http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/clob10g/handlingclobsinoraclejdbc10g.html>
> Dave wrote:> > On 5/9/07, Aggeliki Koukoutsaki <[EMAIL PROTECTED]> wrote:>
>> i'm using roller 3.1 and oracle 10g with tomcat.> >> The problem is that i
am not able to read any Clob values from the > >> database.> >> As i've
observed from the code the Clob columns are read as strings > >>
(resultset.getString()) and i believe that this causes the errors. I > >> think
the Clob values should be red as java.sql.Clob objects and then > >>
transformed into string. Am i right with this?> >> Is there a version that
works with oracle that i can use? Because it > >> is very difficult to change
all the necessary parts of the existing > >> code.> >> > None of the Roller
developers use Oracle (as far as I know), but we> > have heard reports that
Roller can work with Oracle -- and I don't> > believe they had to use
java.sql.Clob to make it work.> >> > You might want to check your
WEB-INF/classes/hibernate.cfg.xml file> > and make sure you are using the
Oracle dialect.> >> > Any Oracle users out there want to speak up?> >> > -
Dave>
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
