- This topic has 5 replies, 3 voices, and was last updated 17 years, 8 months ago by Frank Lawlor.
-
AuthorPosts
-
Frank LawlorParticipantI configured a mySQL driver (MySQL Connector/J) per the help directions and gave it the libs in the MYSQL install (tools/Java/lib).
I then tried to create a DB browser but it says it cannot connect, check the URL.
I gave it the same connect information as my application uses and my app can connect just fine, so I don’t understand what the DB browser doesn’t like.
The URL is jdbc:mysql:///mydb
I tried adding localhost:3306 and that didn’t help
I tried both the root and DB userid/password.
Any suggestions?
Brian FernandesModeratorHi,
The URL is of the following format:
jdbc:mysql://<hostname>[<:3306>]/<dbname>which would translate to something like this:
jdbc:mysql://localhost:3306/mydb
Hope this helps.
Frank LawlorParticipantIf you will read my post, that is what I tried.
My application connects fine, but MyEclipse DB Browser doesn’t.
Any suggestions?
Haris PecoMemberflawlor,
What you set for dirver class name and can you send error log (Help>About Eclipse SDK>Configuration Details>View Error Log), please.
Thanks,
Brian FernandesModerator1) What MyEclipse version are you using?
2) What MySQL version are you attempting to connect to?
3) What are the name(s) of the driver JAR you added to the driver connection and what is the FQN of the driver class? Usually there is just a single JAR file called mysql-connector-java-[version].jar, but you mentioned adding several files.
4) Please state the exact string you used in the DB profile, and the string you are able to successfully use in your Java program.
5) Could you please check your error log for relevant errors and post them here?More instructions here: Posting Guidelines
Thanks.
Frank LawlorParticipantBrian & Peco,
Thanks for the quick resonses.
When I added the jars it wasn’t clear from the directions what it needed so I gave it all the jars in the MySQL java/lib (as I did for my app). When I removed all the jars except the ql-connector-java-5.0.4-binjar, I was now able to connect.Thanks for the help,
— Frank -
AuthorPosts