It have it working fine (now), but i have encountered 'issues'.

The main problem i had was that although you use "localhost" in the jdbc
connection url, mysql doesnt think it is localhost.

So if you try to use a user that is restricted to localhost it doesnt work.

Instead you have to use the fully qualified machine name in the Host column
in mysql/user table.

Another problem with OJB is the OJB tables are in all upper case.  In
windows you create them in uppercase but mysql converts them to lower case.
This works fine in windows (as it doesn't care about capitalisation).  If
you dump the database and import it in linux it dies :) so you have to
rename them (or use the origional script).

Daniel.

> -----Original Message-----
> From: J.Braeuchi [mailto:[EMAIL PROTECTED]
> Sent: 24 June 2004 14:14
> To: OJB Developers List; OJB Users List
> Subject: [OT] MySql and JDBC under Linux
>
>
> hi all,
>
> i know the subject is way off topic, but  i'm definitely lost . on my
> windows-machine mysql works perfectly and i can also access it from jdbc
> using the url jdbc:mysql://localhost:3306/ojb.
>
> under linux (suse 9.1) i installed mysql and i can used with mysqlcc but
> not with jdbc !?
> the only thing i get is a ConnectionException.
> i'm sure it must be a small detail but i can't find it :(
>
> jakob
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to