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
