[opencms-dev] Does this work with Oracle or NOT?

[Bryan Cantwell]

I think I am past that now... but I have another issue... during what looks like a pretty successful setup, I get this log output (Notice the dom4j class not found) dom4j jar is definately in , but for some reason isn't seem correctly...

java.lang.NoClassDefFoundError: org/dom4j/Element



-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org]On Behalf Of Frans Postma
Sent: Friday, April 08, 2005 6:10 PM
To: 'The OpenCms mailing list'
Subject: RE: [opencms-dev] Does this work with Oracle or NOT?


Bryan,
 
The "for update wait 10" construct was introduced in Oracle 9i. 
 
Are you *sure* there are no OLD classes*/ojdbc* files getting in the way and thus giving you a 8.1.7. command set ?? The
blob/abstract error also seems to indicate you have the wrong class, it's been some time I used it.
 
The filenames are by the way NOT related to oracle-versions. They are related to the JDK/JRE you want to use. 
  
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html
 
Hunt down and find anything called classes*.zip, odbc* or classes*.jar and rename them except one (you know; "there can be only
one" ;-) I'm not sure if you need OCI to handle blobs, I think not (in ora9 at least). 
 
Oh look, you can query the jdbc/driver version:

import java.sql.*;
import oracle.jdbc.driver.*;

class JDBCVersion
{
   public static void main (String args[]) throws SQLException {
      // Load the Oracle JDBC driver
      DriverManager.registerDriver
              (new oracle.jdbc.driver.OracleDriver());
      Connection conn = DriverManager.getConnection
              ("jdbc:oracle:thin:@host:port:sid","scott","tiger");

      // Create Oracle DatabaseMetaData object
      DatabaseMetaData meta = conn.getMetaData();

      // gets driver info:
      System.out.println("JDBC driver version is " + meta.getDriverVersion());
   }
}
====================================================

Well, have fun... I'm of to sleeeeeeeeeeeeeeeeeeeeeeep.

Frans
 

___