[Tricia]

Hi,

I’m trying to install some additional drivers in my workstation. I have followed the database connectivity documentation, but I’m not sure where to retrieve the jar files for the drivers. I’ve also checked some of the posts and some of the issues were the wrong URL’s for the specified drivers. Is there a place where the URL’s are documented? I tried downloading MySQL and Oracle drivers jars to my desktop but when I ran a test connection, it could not connect. I believe I used the url that was stated in the documentation for each. Also, the username and password, is that set when entered in the screen, or is there a generic one that we are to use?

I would like to install drivers for Oracle, MySQL

Download MySQL’s own JDBC driver from:
http://dev.mysql.com/downloads/connector/j/
URL-jdbc:mysql://localhost:3306/sai (where sai is your data base name)

Download Oracle’s own JDBC driver from: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
http://www.oracle.com/technology/products/database/oracle11g/index.html

One more question, since I already have the Derby database, and can connect to that, is it ok to create tables within there?

Looking forward to your response 🙂

Thanks

[support-shalini]

tricia0130,
When you select your data base under creating a new data base instance, a connection url is specified with dummy values
ex: jdbc:mysql://<hostname>[<:3306>]/<dbname>
in the above you can replace the host name and dbname according to your set up.
MySql provides two default testbases, mysql and test, that you can use. The username and password are the ones that you give when you set up mysql. Generally it defaults to root for both username and password
I have attached a screen shot for your reference.

One more question, since I already have the Derby database, and can connect to that, is it ok to create tables within there?

Yes, you can connect to the derby database and create tables.

I would recommend you to go through the following tutorials for further reference –
1. http://www.myeclipseide.com/documentation/quickstarts/dbtools/
2. http://www.myeclipseide.com/documentation/quickstarts/dbexplorer/index.html#4-1
Let me know if that helps

Attachments:

You must be logged in to view attached files.

[Tricia]

O.K. Shalini I will try it, thanks 🙂

[support-shalini]

Let us know if you have any issues

[Tricia]

Im still having issues. For the sql, I downloaded the sqljdbc2.jar file, and when I selected the jar, the drivers were automatically populated, but when I ran the test driver, it gave me the following error: Error while performing database login with the Oracle driver: The Network adaptor could not establish the connection

They mysql connectorj, it wouldn’t pick up the actual .jar file that I downloaded. I compressed/unzipped it, could that be the issue for that one?!! I got the websites for the dowloads from this site, maybe they didn’t have the most current versions?!!??!?! Not sure. Is there anyway you can send the websites to download the drivers for sqlserver and connectorj?

Thank

[support-shalini]

tricia0130,
For Oracle I have attached a screen shot for your reference. Please make sure that the oracle server is running and that the URL, username and password specified are correct.

For MySql, you can download the .zip version of the file from the link below – http://dev.mysql.com/downloads/connector/j/
Unzip the file and the .jar file should be available. Now point to the jar file when configuring the connector.

Let me know if that helps

Attachments:

You must be logged in to view attached files.

[Author]

Posts