[DONE] oracle connection problems

[fallingdown]

I did a search on the forum and did not find anything on this...

I had a heck of time getting oracle connection to work. I was using the thin jdbc driver. On the connection settings screen, no matter what valid info i put (on the step where you input the connection settings and login info) I get the error when testing the connection:

Unexpected driver error occurred while connecting to database
NullPointerException

When i advance to the next screen (set connection name) and then test the connection, I get this error:

SQL Error [12514] [66000]: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

I know my settings are correct because they work with other products (SQL Developer, DBArtisan).

I eventually got it to work, but I had to use the advanced option and input the JDBC url using the TNS definition string.

It might be beneficial to be able to view the JDBC url connection string that DBeaver builds from the Basic settings.

My environment:
DBeaver 1.6.1 windows 32 bit
Windows 7 Enterprise (64 bit)
Oracle thin driver: ojdbc6.jar (downloaded via DBeaver site)

[codebling]

[fallingdown]

My initial settings:
Oracle Thin connection settings
Connection Type - Basic
Host: myhost
Port: 1521
SID/Service: mysid

Security
User name: myuser
Role: Normal
password: xxxxxx

Settings that work:
Connection Type - Custom
JDBC URL: jdbc:oracle:thin:@(description=(address=(host=myhost)(protocol=tcp)(port=1521))(connect_data=(sid=mysid)))

Security
User name: myuser
Role: Normal
password: xxxxxx

[Serge]

Hmm, it is pretty strange problem. It shouldn't occur when you specify host/port and use direct connect.

What Oracle server version do you use?

[fallingdown]

Oracle 11.1

I meant to follow up on this post some more, but I had to run out.

I played around with it some more. After successfully testing the connection with the custom JDBC url, I switched over to the Basic view again and saw the host and sid populated. I tested the connection again from Basic and it worked. Then I switched back over to the custom, deleted out the url, switched back to Basic and Test connection was successful again.

In the end, i have my connections set up and they work. Just seems like I had to 'jiggle' it a good bit before it started working.

[codebling]

Hm. Can you try creating a new connection from scratch again with the same settings? Maybe the other bug was causing the issue?

[Gazonk]

I have the same problem.
Can only get an oracle (11g) connection by entering the jdbc-url. I ended up creating my own driver for oracle which works fine.

[Serge]

[Gazonk]

[Serge]

Ah, I see. We use URL syntax for service name, not for SID.
It is a bug and it will be fixed in the next version.

Thanks!