Well, as you see in the trace, Turbine is using the MySQL drivers and not
the Oracle drivers.
Look at your TurbineResources.properties. Comment out the MySQL entries and
uncomment the Oracle section so it looks something like (The URL for your
setup may be different depending on the server location, the port, and the
database name):
#### ORACLE
database.default.driver=oracle.jdbc.driver.OracleDriver
database.default.url=jdbc:oracle:thin:@localhost:1521:ORCL
#### MySQL MM Driver
#database.default.driver=org.gjt.mm.mysql.Driver
#database.default.url=jdbc:mysql://localhost/Turbine
database.default.username=<your oracle userid goes here>
database.default.password=<your oracle password goes here>
...other stuff...
database.adaptor=DBOracle
database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver
^
This needs to be in your classpath.
HTH
Steve B.
----- Original Message -----
From: "Nacho" <[EMAIL PROTECTED]>
To: "'JetSpeed'" <[EMAIL PROTECTED]>
Sent: Wednesday, June 28, 2000 8:56 AM
Subject: RE: Jetspeed/Tomcat tarball - Win32 .BAT file
No, no, this is my bad english writing skills, i'm trying to use
Jetspeed with Oracle Database , using ORacle's JDBC Drivers, but i get
the stacktrace that says that JetSpeed ( no i ) need the MySql Drivers,
having done ( AFAIK ) the modifications in the files that look like the
conf files, to not use mysql and use Oracle.
Thanks at all.
Saludos ,
Ignacio J. Ortega
> -----Mensaje original-----
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]En nombre de sbelt
> Enviado el: mi�rcoles 28 de junio de 2000 17:42
> Para: JetSpeed
> Asunto: Re: Jetspeed/Tomcat tarball - Win32 .BAT file
>
>
> Sorry if I misunderstan your email, but are you trying to use
> MySQL drivers
> to connect to your Oracle database? That would be quite
> incorrect. The MySQL
> drivers will only connect you to your MySQL database. Note
> that, as far as I
> know, the MySQL jdbc drivers are not in the distribution. To use the
> Mysql-jdbc drivers to connect to your MySQL database, you will need to
> download the .jar file from the MySQL.org web site (Sorry, as
> their web site
> appears to be down I cannot give you the exact url. I believe
> it was under
> downloads->Windows software).
>
> To connect to your oracle server, you would need to tell the
> TrubineResources.properties to use the oracle jdbc driver
> instead. I have
> not set this up myself, so I do not know where you get this
> driver. IN any
> case, make sure your drivers are in your classpath. If your
> using Tomcat,
> look at the startup window: there is a section where it
> echoes the classpath
> it is using.
>
> Also remember that there are scripts in the /src/sql folder
> that you will
> need to run to setup your database. Your error message below
> looks like it
> connected to the database but did not find the table named
> 'Visitor' that it
> was looking for.
>
> I also have Jetspeed running on my home system on windows 2k
> (Tomcat 3.1,
> MySQL), so let me know if I can help. I have never used the Win32.bat
> distribution, however, so my expereince is all in the manual
> install method.
>
> Steve B.
>
> ----- Original Message -----
> From: "Nacho" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 28, 2000 6:51 AM
> Subject: RE: Jetspeed/Tomcat tarball - Win32 .BAT file
>
>
> > Hola a todos:
> >
> > I done my 7th try in run JetSpeed...using the last complete dist
> > SuperKevin has done..
> >
> > i use W2K FYI.
> >
> > Well , i have no luck..
> >
> > I tried to reconfigure JetSpeed to use my Oracle database,
> but as i say
> > no luck, i'm still seeing the StackTrace below , that
> states that it not
> > found the MySql jdbc drivers.
> >
> > I've edited the text files that found in jetspeed-system\conf....
> >
> > Any help will be great
> >
> > Saludos ,
> > Ignacio J. Ortega
> >
> >
> >
> > 8<----------------------------------------
> > Exception: java.lang.Error: Error in
> BasePeer.initTableSchema(Visitor):
> > org.gjt.mm.mysql.Driver
> > at
> >
> org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:218)
> > at
> >
> org.apache.turbine.om.user.peer.TurbineUserPeer.<clinit>(Turbi
> neUserPeer
> > .java)
> > at
> >
> org.apache.turbine.om.user.TurbineUser.setUserName(TurbineUser
> .java:502)
> > at
> >
> org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactor
> y.java:158
> > )
> > at
> >
> org.apache.jetspeed.turbine.actions.JetspeedSessionValidator.d
> oPerform(J
> > etspeedSessionValidator.java:94)
> > at org.apache.turbine.modules.Action.perform(Action.java:77)
> > at
> > org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:111)
> > at Turbine.doGet(Turbine.java:303)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > at
> >
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWra
> pper.java:
> > 503)
> > at
> >
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWra
> pper.java:
> > 597)
> > at
> >
> org.apache.tomcat.servlets.InvokerServlet.service(InvokerServl
> et.java:25
> > 7)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > at
> >
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWra
> pper.java:
> > 503)
> > at
> >
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> > at
> >
> org.apache.tomcat.service.http.HttpConnectionHandler.processCo
> nnection(H
> > ttpConnectionHandler.java:160)
> > at
> >
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEnd
> point.java
> > :338)
> > at java.lang.Thread.run(Thread.java:484)
> > 8<----------------------------------------
> >
> > > -----Mensaje original-----
> > > De: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]En nombre de burtonator
> > > Enviado el: lunes 26 de junio de 2000 19:25
> > > Para: JetSpeed
> > > Asunto: Re: Jetspeed/Tomcat tarball - Win32 .BAT file
> > >
> > >
> > > Christopher Michael Ward wrote:
> > > >
> > > > Folks,
> > > >
> > > > Here is the batch file I fixed up to run the Jetspeed
> > > tarball. The only
> > > > thing I found missing
> > > > was the MySQL JDBC driver. I am using the 1.2b version,
> > > and placed the
> > > > mysql_uncomp.jar file
> > > > in the ./jetspeed/lib directory.
> > > >
> > > > I am working from home with a very antiquated laptop, so I
> > > haven't had the
> > > > time to check everything out, but the home page does
> > > appear. If I have done
> > > > anything stupid, please fix it and share it with everyone.
> > > This is working
> > > > with JDK 1.3, YMMV.
> > >
> > > OK. I will commit the code. I want to trim down the
> > > ./start-jetspeed.sh file too.
> > >
> > > <snip>
> > >
> > > Kevin
> > >
> > > --
> > > Kevin A Burton (e-mail: [EMAIL PROTECTED], UIN: 73488596, ZKey:
> > > burtonator)
> > > http://relativity.yi.org
> > > Message to SUN: "Please Open Source Java!"
> > > To fight and conquer in all your battles is not supreme
> excellence;
> > > supreme
> > > excellence consists in breaking the enemy's resistance
> > > without fighting.
> > > - Sun Tzu, 300 B.C.
> > >
> > >
> > > --
> > > --------------------------------------------------------------
> > > Please read the FAQ! <http://java.apache.org/faq/>
> > > To subscribe: [EMAIL PROTECTED]
> > > To unsubscribe: [EMAIL PROTECTED]
> > > Archives and Other: <http://java.apache.org/main/mail.html>
> > > Problems?: [EMAIL PROTECTED]
> > >
> >
> >
> > --
> > --------------------------------------------------------------
> > Please read the FAQ! <http://java.apache.org/faq/>
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Archives and Other: <http://java.apache.org/main/mail.html>
> > Problems?: [EMAIL PROTECTED]
>
>
>
> --
> --------------------------------------------------------------
> Please read the FAQ! <http://java.apache.org/faq/>
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Archives and Other: <http://java.apache.org/main/mail.html>
> Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
