[Lee Harrington]

I’m trying to setup an Oracle driver in the DB Browser. I put in the settings that I’ve used in an non-eclipse/ant based java app — in terms of database url etc. — and I’m getting an error when I try to connect

oracle.jdbc.driver.OracleDriver

That’s it — no other information in the error. This connection information successfully works in another app on my machine — the database is up — I can connect via other tools.

I’m stuck.

Lee

[snpe]

You have to add ojdbc4.jar (jdbc jar file for oracle) when create new profile in db perspective – click new driver and add jar file in extra class path

regards

[Lee Harrington]

thanks — having trouble doing so. I see the “extra class” tab, but it’s asking for a Name, Example URL and Driver Class Name and I don’t know what to put in these values.

[Lee Harrington]

Ok…here’s my jdbc connection string that works in my app
jdbc:oracle:thin:user/password@server.mycompany.com:portNumber:mysid

obviously with the names changed

What values to I put in the URL etc. in my MyEclipse database profile. I’ve tried numerous variations. I’ve tried selecting the oracle and the oracle thin drivers, I’ve tried adding a new one. I’ve not been able to successfully add a new one, because I don’t know what to put in the Name, Example URL and Driver Class Name fields.

Lee

[Riyad Kalla]

Name: “Oracle Driver”
Example URL: jdbc:oracle:thin:user/password@server.mycompany.com:portNumber:mysid
Drive Class Name: <hit “List drivers” and select it from the dropdown>

The “example URL” is a template displayed for you when you go to make a new connection of this TYPE to the DB, then you go in and fill in the vars (like user name/pass) with valid values.

[snpe]

Driver class for orcal jdbc is :
oracle.jdbc.driver.OracleDriver
URL set like
jdbc:oracle:thin:@your_server:port:sid
in driver setting exists fields for username and password – default for oracle
is DBA admin systm/manager or simple scott/tiger

If You don’t know server try localhost, port is default 1521, as sid for default install is orcl or ORCL – for correct value ask DBA

regards

[Lee Harrington]

@support-rkalla wrote:

Name: “Oracle Driver”
Example URL: jdbc:oracle:thin:user/password@server.mycompany.com:portNumber:mysid
Drive Class Name: <hit “List drivers” and select it from the dropdown>

The “example URL” is a template displayed for you when you go to make a new connection of this TYPE to the DB, then you go in and fill in the vars (like user name/pass) with valid values.

That worked, thanks. One caveat, when I tried the drop down of drivers, there were no values. Then I clicked the list drivers button, which populated the drop down. But that wasn’t very intuitive.

Lee

[Riyad Kalla]

Lee,
Agreed, it would be nicer if it was automatic, I’ll ask the dev to see if that’s quick to add.

[support-jeff]

I have entered this as an enhancement request. I have never liked this dialog anyway – needs an overhaul.

[Author]

Posts