Skip to Main Content
  • Questions

  • Connection between Mysql and SQL Developer Datamodeler

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Romina.

Asked: September 26, 2016 - 3:43 am UTC

Last updated: September 28, 2016 - 7:18 am UTC

Version: SQL Developer 4.1.5

Viewed 1000+ times

You Asked

Hi Tom,
Im trying to connect Oracle SQL Developer Datamodeler with Mysql but nothing work. I can connect Oracle SQL Developer with Mysql with an J Connector, but when I do the same steps on SQL Datamodeler (add an extension in the Third Party JDBC) it doesnt work.
Another thing I was trying is to get the dtabase I already charge on the SQL Developer and import in the Datamodeler but it doesnt work either.

Thanks.

Regards,
Romina Cruz

and Connor said...

"it doesn't work" isnt a great deal of evidence for us to work with.

I just tried this and it worked:

- data modeller 4.1.3
- driver mysql-connector-java-5.1.39-bin.jar
- tools => preferences => 3rd party drivers in the normal

For the connection I did:

jdbc url = jdbc:mysql://localhost:3306/mysql
driver class = com.mysql.jdbc.Driver

See how you go

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thaaanks but I have an other issue

Romina, September 27, 2016 - 4:25 am UTC

Helps me a lot, I really appreciated.
Otherwise, I'm trying to connected to Mysql in other virtual machine and I think that my JDBC Url it's wrong : jdbc:mysql:\\192.168.0.113:3306/mysql.
Because it appears a failure: Verify the URL format.
I would like to know what I'm doing wrong to correct it and finally do the connection.
Thanks
Connor McDonald
September 28, 2016 - 7:18 am UTC


jdbc:mysql:\\192.168.0.113:3306/mysql

should be

jdbc:mysql://192.168.0.113:3306/mysql
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.