thanks for using code, tags, and including the exception, but I don't think the line numbers in the exception match those in the code sample (as I have never seen a finally statement throw an sql exception before )
As a few lines could have thrown the exception, could you adjust the code samplt to accuratly match the real code. or make the real code match the sample
Have you done any reseach into this issue, other than posting here, as I found a few intersting issues, involving db setup with certain oracle version, reporting this error.
posted 7 years ago
Wendy Gibbons wrote:Have you done any research into this issue, other than posting here, as I found a few interesting issues, involving db setup with certain oracle version, reporting this error.
Ya i tried to find out , and one more thing i want to tell you , i unable to installed my oracle 18.104.22.168 in my computer so i installed it manually, but sq l is working.. nicely as well as oracle jdbc.odbc driver are also working nicely but problem with this only when i start to use oracle thin driver ... so i got this exception any idea ? then reply me soon....
Koen Aerts wrote:Did you look in the DBMS log file and see if there's any indication as to why the connection fails?
Where will be located this file?
If you're using a listener, then it's probably in listener.log in the $ORACLE_HOME/diag and/or $ORACLE_HOME/network/log directories, otherwise do a search for either alert.log or log.xml file. Since Oracle 11 there's also several new V$ views available to look at log data. Google for Oracle 11g ADR to find various log directories.
posted 7 years ago
Here my alert.log file. i unable to understand if you then tell me how can i correct it? i attached the portion from alert file after my compilation time.
Do you need to use oracle?
if you are only trying to practice jdbc or writing applications for your own use MySQL is a much friendlier database to start with. A
s you had trouble doing the install of oracle it is not going to be an easy DB to maintain.
so my end advice is unless you are using oracle as work demands it SWAP NOW.