[DONE] oracle connection problems

Note: please leave bug reports and feature requests on

[DONE] oracle connection problems

Postby fallingdown » Fri Aug 10, 2012 3:22 pm

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)
fallingdown
 
Posts: 41
Joined: Fri Aug 10, 2012 2:43 pm

Re: oracle connection problems

Postby codebling » Fri Aug 10, 2012 6:12 pm

codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: oracle connection problems

Postby fallingdown » Fri Aug 10, 2012 7:00 pm

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
fallingdown
 
Posts: 41
Joined: Fri Aug 10, 2012 2:43 pm

Re: oracle connection problems

Postby Serge » Sat Aug 11, 2012 12:18 pm

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?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: oracle connection problems

Postby fallingdown » Mon Aug 13, 2012 6:55 pm

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.
fallingdown
 
Posts: 41
Joined: Fri Aug 10, 2012 2:43 pm

Re: oracle connection problems

Postby codebling » Mon Aug 13, 2012 8:19 pm

Hm. Can you try creating a new connection from scratch again with the same settings? Maybe the other bug was causing the issue?
codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: oracle connection problems

Postby Gazonk » Sat Sep 01, 2012 10:00 am

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.
Gazonk
 
Posts: 3
Joined: Sat Sep 01, 2012 9:48 am

Re: oracle connection problems

Postby Serge » Sat Sep 01, 2012 10:27 am

Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: oracle connection problems

Postby Gazonk » Sat Sep 01, 2012 12:13 pm

Gazonk
 
Posts: 3
Joined: Sat Sep 01, 2012 9:48 am

Re: oracle connection problems

Postby Serge » Sat Sep 01, 2012 1:57 pm

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!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Next

Return to Support



Who is online

Users browsing this forum: No registered users and 7 guests