SQL Power Software Forum

Hi All,
I am very new to DQGuru. My ultimate aim is to load a oracle table and do some cleansing on it. For this i am trying to create a connection.

I am getting the following error when i am trying to Test the connection.

"java.sql.SQLException: Couldn't connect to database "Ram_Test":
JDBC Driver org.postgresql.Driver
does not accept the URL jdbc:oracle:thin:@172.24.252.7:1521:orcl"

The values i have given are:
Con Name - Ram_Test
db type - oracle 10g
jdbc url - jdbc:oracle:thin:@172.24.252.7:1521:orcl
uname - abc
pwd - abc
Repository Qualifier - NULL

I have downloaded the jar file and added it in the "JDBC Drivers" tab of DQGuru.

Please help me in resolving this.

Thanks in Advance,
Ram Mohan T

Hi,

it seems like you are using the wrong connection settings to connect to Oracle, you are using a Postgres JDBC driver instead of an Oracle one:

JDBC Driver org.postgresql.Driver

Make sure you have the Oracle JDBC driver available on your computer, it is not included in the DQGuru download. You'll have to point to the Oracle driver in the JDBC settings of DQGuru.

Then you'll be able to create a connection to connect to Oracle.

Benjamin

Hi Benjamin,

Thanks a lot for your valuble inputs. Now its working fine...

Regards,
Ram Mohan T