Re: Important parameter of MySQL Connector/J 3.0 for building connection between my StarOffice 6 and MySQL - Prabu Subroto - com.mysql.lists.java

14 messages in com.mysql.lists.javaRe: Important parameter of MySQL Conn...

From	Sent On	Attachments
Prabu Subroto	01 Apr 2003 04:00
JC	01 Apr 2003 04:14
Prabu Subroto	01 Apr 2003 05:16
JC	01 Apr 2003 05:32
Prabu Subroto	01 Apr 2003 05:36
Keith Hatton	01 Apr 2003 05:37
Prabu Subroto	01 Apr 2003 05:43
Prabu Subroto	01 Apr 2003 05:47
Prabu Subroto	01 Apr 2003 05:48
Russ Tennant	01 Apr 2003 08:37
Henrik Pedersen	01 Apr 2003 18:53
Hermann Kienlein	02 Apr 2003 09:28
Prabu Subroto	10 Apr 2003 04:42
Prabu Subroto	10 Apr 2003 05:38

Subject:	Re: Important parameter of MySQL Connector/J 3.0 for building connection between my StarOffice 6 and MySQL
From:	Prabu Subroto (prab...@yahoo.com)
Date:	04/01/2003 05:36:49 AM
List:	com.mysql.lists.java

Dear Lorent...

What is "$JAVA_HOME" ? Where is the directory located? And what is it for?

Thank you very much in advance. --- JC <jclo...@dsic.upv.es> wrote:

Is the java driver class in your classpath? You must include the jar file where the driver class is in your classpath. You can put the jar in the $JAVA_HOME/jre/lib/ext directory too.

Prabu Subroto wrote:

Dear Lorente...

Firstly, thank you very much for your help.

But I still have the problem. I have changed the URL into "jdbc:mysql://192.168.23.1:3306/bernstein" but it doesn't make any difference.

I got 2 error messages in its detail: " The specified driver could not be loaded. /com/mysql/jdbc ".

Please tell me my mistake furthermore.

Thank you very much. --- JC <jclo...@dsic.upv.es> wrote:

Maybe with the url: jdbc:mysql://192.168.23.1:3306/bernstein

Prabu Subroto wrote:

Dear my friends....

I want to build an office automation with Java at

office. The clients will use staroffice 6 and my database is MySQL3.23.* . The connection between

the

Star Office 6 and MySQL will be over JDBC (MySQL Connector/J 3.0 [resin]).

This is the first time for me to use jdbc and I am also new to implement Java.

I need your advices, please tell me the needed parameter that I should define for building the connection between StarOffice 6 (also as the

internet

browser) and MySQL through JDBC.

Here was my first try: 1. I located my JDBC driver under "/com/MySQL/jdbc" directory. 2. I created a database named "bernstein" and a

user

name "prabu" and password "mypassword". I've

checked

the account and its privilege with mysqlclient and everything runs properly (OK). 3. I define... - JDBC driver class: "/com/mysql/jdbc" - URL: "jdbc://192.168.23.1:3306/bernstein" - username: prabu - password: mypassword 4. I tried to connect my MySQL but I got an error message. The error message was: "No connection for URL jdbc://192.168.23.1:3306/bernstein" and the also an error message somewhat that I should check the username and the password.

Please help me... Give me a solution.

Thank you very much in advance.

note: I am using SuSE Linux 8.1 for all of my

servers

and 80% the workstation.

__________________________________________________

Do you Yahoo!? Yahoo! Tax Center - File online, calculators,

forms, and more

http://platinum.yahoo.com