I am an amateur with Jaspersoft studio and I want to create reports with as data source an Oracle database.

I added the .JAR file "ojdbc" in the Driver Classpath part
When I create the connection, when I run the test, it shows me this message:

ora-12505 tns listener does not currently know of sid given in connect descriptor.

And how import oracle database in jaspersoft studio

yoannelfriedayehui's picture
Joined: May 31 2018 - 1:33am
Last seen: 4 years 11 months ago

2 Answers:

Check this ref:

For import database in jasper, you need create a data adapter first, which connect to your databse. Then create your report with this adapter.

victorlizonglin's picture
Joined: May 23 2018 - 12:47pm
Last seen: 4 years 9 months ago

The message implies you don't have oracle sid that you've specified. Ask your database administrator to check if the ip address, port, SID, username, password is correct.

Jaspersoft Studio is just using jdbc connection to oracle database so the connection should be something like the following.

jdbc:oracle:thin:@ipaddress:1521:SID", "username", "password");


hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago