building connection between Star Office 6 and MySQL through MySQL Connector/J 3.0 (resin)
Dear my friends.... I want to build an office automation with Java at my 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! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
On Tuesday 01 April 2003 06:03, Prabu Subroto wrote:
Dear my friends....
I want to build an office automation with Java at my 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! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
I believe that you have a couple of things wrong here. Converting my postgreSQL jdbc stuff to MySQL would make the following more accurate. I haven't really done anything with it, I just set it up to play a little. I have been thinking about doing a couple of real things here at home with OpenOffice/PostgreSQL. At any rate, the driver should probably be : com.mysql.jdbc.Driver And the connection string should probably be: jdbc:mysql://192.168.23.1:3306/bernstein -- Kelly L. Fulks Home Account
participants (2)
-
Kelly L. Fulks -
Prabu Subroto