Jump to content
Changes to the Jaspersoft community edition download ×

Not able to connect to oracle database


Recommended Posts

Hi ,

I am trying to connect to oracle data base in jaspersoft studio 6. 6.0 using  "oracle.jdbc.driver.OracleDriver" . and i am giving below db details to connect to db :

jdbcurl : jdbc:oracle:thin:@ Service nameUsername : ABCPASS: ****[/code]

while testing i am getting below error :

Caused by: java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor[/code]

i am giving databse service name to access db .

Kindly help.



Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi Hozawa ,


Actaully you are right.I was using wrong syntax to call service name .

It is fixed now . But now i am getting one more error. I have already asked question in cummunity for that . Below is the link :


Can you please help me on that ?




Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...