Forum Discussion
Hello All,
1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear
2.I'm using the connection string as
jdbc:oracle:thin:UserName/Password@ServerName:1521:Sid
3.When i click on Test Connection Button it is not showing any pop up message as Connection successfully tested
4.However it shows in logs as The JDBC driver [oracle.jdbc.driver.OracleDriver] is already registered.
1.I'm able to connect my oracle db using my credentials through Toad Tool
2.My Java version is 1.8.0_172( I did research for this java version JDBC jar files-ojdbc6 and 7 are compatible
I have some thoughts but i'm driving at moment. Will respond in about an hour and a half.
Cheers
richie
- richie7 years agoCommunity HeroQuick question. What version of oracle are you trying to connect to? (Not your local oracle installation, but the remote database you are trying to connect to?)
- richie7 years agoCommunity HeroHi ,
Is it
12? Uses ojdbc6.jar and %7.jar
12.1.x.x? Uses ojdbc6.jar and %7.jar
12.2.x.? Uses ojdbc8.jar
12.c? Uses ojdbc8.jar
Just need to make sure youre using the correct version
In regards to testing your connection with toad....did you force it to connect via the thin driver? Toad uses tnsnames.ora file to connect by default, even though you might have thr thin driver setup as well. We need to determine IF the connection test is using the thin driver or tnsnames.ora file. With this in mind, rather than try and mess around disabling your tns connection in toad, can you navigate to the relevant directory and either rename the file (youll need elevated local admin privileges to edit this ifni remember correctly) so toad cant use the tnsnames.ora file OR comment out the connection setup in your tnsnames.ora file. Make sure toad is shut down whilst editing the file. Then relaunch toad and try and connect using the thin driver. That will confirm if its a soapui issue or not.
Finally. Did you confirm that your environment variables (classpath, path and java_home) are correct? (Remember there can be other jre instances packaged up with other installed software...so you need to run 'java -version' at command prompt to ensure its using the jre you want it to. Ok. Thats it for now,
Cheers
richie - richie7 years agoCommunity HeroAdded in error
- NK127 years agoOccasional Contributor
I'm able to succesfully establish the connection through my DBA team.
DBA team grant the access for me to get in through Read
Steps
Hello All,
1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear
2.I'm using the connection string as
jdbc: oracle:thin:UserName/Password@ServerName:1521:<SID Name>
- richie7 years agoCommunity HeroHi NK12,
I dont understand what you mean when you say "dba granted access through read".
Were you trying the wrong useraccount details? Or are you saying you are using a different useraccount with connect/read only access where the useraccount you were using had insert/update/read access, but for some reason it didnt work?
Can you explain what the actual issue was?
Cheers
richie
Related Content
- 5 years ago
Recent Discussions
- 15 hours ago
- 8 days ago