[Stocolmo]

I need to make a webservice that connects to a mysql db… I followed the tutorial at myeclipse learning center but it uses oracle thin driver.

I use the MySQL Connector/J Driver and follow the same steps for Oracle thin driver. When I try connecting to the database I get the error “Error while trying to log to database: Illegal connection por value ‘3306>]'”

How do I fix the problem or is there another way to make this work.

thanks

[Riyad Kalla]

It looks like you might have an invalid connection String. Please paste your entire connection string here (it looks like you didn’t replace the default values)

[Stocolmo]

jdbc:mysql://(My hostname)[<:3306>]/hunden
this is the connection url.

[Stocolmo]

I now get a “null, message from server “Host ‘bernie’ is not allowed to connect to this MySQL server”

[Riyad Kalla]

yea that’s invalid, you need to make it:
jdbc:mysql://localhost:3306/hunden

where “localhost” would be whatever host you are connecting to. The [<>] stuff was just to mark optional content, that’s not how it actually has to look.

[Author]

Posts