Anderson dos Santos wrote:
> Hi,
>
> i have a problem with database connection using mySQL, with HyperSonic works
> fine, see my turbine resource properties:
>
> # D A T A B A S E S E T T I N G S
>
> #Works fine
> #database.default.driver=org.hsql.jdbcDriver
> #database.default.url=jdbc:HypersonicSQL:${webapp.dir}/WEB-INF/db/jetspeed
> #database.default.username=sa
> #database.default.password=
>
> #No work, return Database type org.gjt.mm.mysql.Driver not implemented
> #database.default.driver=org.gjt.mm.mysql.Driver
> #database.default.url=jdbc:mysql://localhost/turbine
> #database.default.username=jetspeed
> #database.default.password=1234
>
> #No work, return an error
> database.driver=org.gjt.mm.mysql.Driver
> database.url=jdbc:mysql://localhost/turbine
> #database.username=root
> database.username=jetspeed
> database.password=1234
>
> Error
> Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER):
> null
>
> My enviroment:
> .WIN NT 2000 SP1
> .JDK 1.2.2
> .Apache Jetspeed 1.3a1
> .Tomcat Version 3.2.1
> .Apache/1.3.14 Server at localhost Port 8000
> .mySQL drive: mm.mysql-2.0.3.jar
> .Jetspeed and Tomcat libs leave original in dist
> .MySQL 3.23.31 running on localhost
>
> []'s
> Anderson
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/[email protected]/>
> List Help?: [EMAIL PROTECTED]
A good place to start is by downloading and browsing
through Turbine. If you are just getting started- you can also
download an prebuilt version- the TDK.
Turbine includes some example scripts to create
and use mysql tables. ( for example - the torque peer model is
powerful once you get the hang of it)
Since Jetspeed uses Hypersonic by default, the DB file
has been preloaded with the tables. To use mysql- you have
to create the tables yourself.
There are some previous emails in the archive about using
mysql- do a search of the list archives. A good example is:
http://www.mail-archive.com/[email protected]/msg02992.html
You can also use the version of mm mysql JDBC library
that comes with Turbine. When you are testing- keep your
eye on the Jetspeed logs and the tomcat logs for any error
messages. Common problems include not being able to find the mm
JDBC jar in the CLASSPATH, permissions, etc.
To troubleshoot- also make sure that your mysql environment
is working independently of Jetspeed. There are some samples
that come with mysql that do a simple JDBC connect and query.
Make sure that you can run simple JSPs/ servlets with JDBC under
tomcat before including Jetspeed. There are also some
good examples in the Village distribution.
Initially when I was setting up the JDBC connection, I found
that I had to tweak some of the user permissions on the mysql
database to allow the connection.
Jetspeed runs nicely with mysql once you get everything set
up. The nice advantage to mysql is that you can use all of the
existing tools that support mysql (ie like admin tools, backup tools, etc)
with your Jetspeed tables as well...
-bill
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/[email protected]/>
List Help?: [EMAIL PROTECTED]
