0
I’m having trouble adding the oracle driver in the iReport Designer, I tried to follow some tutorials, but I was not successful.
So my question is, how do I add and perform the necessary settings for the Oracle driver?
Note: Try following these steps:
http://community.jaspersoft.com/wiki/connecting-ireport-oracle-datasource https://www.youtube.com/watch?v=aWePwTz1knI
Edit error:
1
I usually do like this:
- I’m going on option Tools in the menu bar;
- Then on the option Ireport and on the tab Classpath
- Then click add Jars, then you locate the oracle driver. Located and added, click ok
After that, when you try to add an oracle driver connection, it will be enabled.
Then you put the connection data
That’s what I do
I hope I’ve helped
Browser other questions tagged java oracle ireport
You are not signed in. Login or sign up in order to post.
could you show me the connection data as well ? I’m having the error: Exception Message: 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
– Gustavo Santos
Connection data varies from company to company: it is only you fill in according to your need, for example:
jdbc:oracle:thin:@ip-do-servidor:1521:nome-do-banco-ou-servicoIn the Server Address field (Server Address), you put the ip of your server, in Database, the name of the bank or service, and finally the login and password and click test or save– adventistaam
check also your tsname
– adventistaam
I tried to do as you suggested, still could not, I edited the question and added an image to illustrate the error, if you can look and give me a new "opinion" about.
– Gustavo Santos
I tried to simulate the error and managed to change something, for example, I changed the port and gave this same error, check with detail, the name of the bank, the port, the server, anyway.
– adventistaam
thank you, it worked !
– Gustavo Santos
Cool! , good that worked
– adventistaam