Re: AW: PLEASE HELP ME: JNDI ERROR 1
Hi all, this morning I have discovered that my oracle version is 8.1.6. Then I have taken the jdbc classes12.zip for 8.1.6 but the result is the same: Errore = java.sql.SQLException: Eccezione IO: The Network Adapter could not establish the connection Eccezione IO: The Network Adapter could not establish the connection I'm without words: is there some JNDI problem for oracle 8.1.6? I have also seen network.log of oracle but it doesn't say anything (there is the connection of tomcat (my IP) but no error, I think). Can someone help me ? Please help Laura Alle 20:43, lunedì 15 aprile 2002, hai scritto: Thats a very good point. Also, look for any other old set of classes which Tomcat is picking up. Which may mean JNDI related classes too. I dont know if this would work but, change the time stamp's of all tomcat related .xml files by making a small change like adding a space, pressing enter etc and see if it makes any difference. regards hemant - Original Message - From: Angel Municio [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Monday, April 15, 2002 1:00 PM Subject: RE: AW: PLEASE HELP ME: JNDI ERROR 1 If the Oracle database that you are trying to connect to is a different version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this file, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
Hi all, tomorrow I'll try all your suggestions (today in Italy is the day of the big the strike for the defence of the workers ): I'll put the new version of classes12.jar and then I'll see the log of oracle server. But I have a question: Hemant said Which may mean JNDI related classes too. I dont know if this would work but, change the time stamp's of all tomcat related .xml files by making a small change like adding a space, pressing enter etc and see if it makes any difference. I don't understand: I 'm using Tomcat 4.0.2. Should I upgrade to Tomcat 4.0.3? Tomcat's JNDI is old? Why should I change all .xml Tomcat files? Thanks Laura Thats a very good point. Also, look for any other old set of classes which Tomcat is picking up . Which may mean JNDI related classes too. I dont know if this would wor k but, change the time stamp's of all tomcat related .xml files by making a s mall change like adding a space, pressing enter etc and see if it makes any difference. regards hemant - Original Message - From: Angel Municio [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Monday, April 15, 2002 1:00 PM Subject: RE: AW: PLEASE HELP ME: JNDI ERROR 1 If the Oracle database that you are trying to connect to is a differen t version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this fil e, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is , the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands: mailto:tomcat-user- [EMAIL PROTECTED] Troubles with the list: mailto:tomcat-user- [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
Where is nslistener network log ? This log file is on the server (where oracle is installed) or on the client? Can you explain me where it is and what I should have to find? Laura Alle 18:48, lunedì 15 aprile 2002, peter lin ha scritto: look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: AW: PLEASE HELP ME: JNDI ERROR 1
If the Oracle database that you are trying to connect to is a different version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this file, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
I use classes12.jar (classes12.zip): well, the database my examples was ok with, was 8i. My new database I don't know what version is: if it was 9i which driver I should use? Laura Alle 19:00, lunedì 15 aprile 2002, hai scritto: If the Oracle database that you are trying to connect to is a different version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this file, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
that's probably the cause. go to oracle's site and download the latest driver Laura wrote: I use classes12.jar (classes12.zip): well, the database my examples was ok with, was 8i. My new database I don't know what version is: if it was 9i which driver I should use? Laura Alle 19:00, lunedì 15 aprile 2002, hai scritto: If the Oracle database that you are trying to connect to is a different version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this file, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: AW: PLEASE HELP ME: JNDI ERROR 1
I think the big problem is that Oracle didn't put much thought on the naming convention for its jdbc drivers, so basically all versions are classes12.zip. There are a very big library of releases and there is not (or at least I haven't found a central repository). You have to unzip/unjar the file and see what it contains. If you see things like ocijdbc9_g.dll, it will work with 9i. I personally keep a directory structure where I put all releases of classes12.zip that I find, and with which versions, jdk, OS and connection type (thin/OCI) they work. Ex: NT/8.1.7/Thin/classes12.zip 1887KB NT/8.1.7.1/Thin/classes12.zip 1888KB NT/9.0.1/Thin/classes12.zip 1081KB There are sometimes patches with one or two classes, that you have to move to your all zip to make it work. Many times a jdbc may work with thin client but not with fat, or work in NT but not in Solaris. Personally I think Oracle has done a mess with this, the only solution is try until you find a good one. By the way, having the latest doesn't warranty it will work with your current setup. The are not backward compatible. angel -Original Message- From: Laura [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:06 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 I use classes12.jar (classes12.zip): well, the database my examples was ok with, was 8i. My new database I don't know what version is: if it was 9i which driver I should use? Laura Alle 19:00, lunedì 15 aprile 2002, hai scritto: If the Oracle database that you are trying to connect to is a different version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this file, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: AW: PLEASE HELP ME: JNDI ERROR 1
Thats a very good point. Also, look for any other old set of classes which Tomcat is picking up. Which may mean JNDI related classes too. I dont know if this would work but, change the time stamp's of all tomcat related .xml files by making a small change like adding a space, pressing enter etc and see if it makes any difference. regards hemant - Original Message - From: Angel Municio [EMAIL PROTECTED] To: 'Tomcat Users List' [EMAIL PROTECTED] Sent: Monday, April 15, 2002 1:00 PM Subject: RE: AW: PLEASE HELP ME: JNDI ERROR 1 If the Oracle database that you are trying to connect to is a different version than the old one, check for updated Oracle jdbc drivers (classes12.zip). I have found that there are many releases of this file, and newer releases are not always backwards compatible. For instance, classes12.zip that work well with 8i do not work well with 9i. angel -Original Message- From: peter lin [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:48 PM To: Tomcat Users List Subject: Re: AW: PLEASE HELP ME: JNDI ERROR 1 look in the tnslistener network log to see if tomcat is getting to the machine correctly. If not, it's most likely a typo someplace. If it is, the log will give you more data to debug the problem. peter lin Laura wrote: But I have controlled all. If I try to connect with sql plus, I connect to the db. Any suggestions? Laura Alle 18:30, lunedì 15 aprile 2002, hai scritto: You said that you changed user, password, and url. I would suspect, that you mistyped either the name of the server or the port or that your new database is using different parameters than your old one. -Ursprüngliche Nachricht- Von: Laura [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 15. April 2002 18:26 An: Tomcat Users List Betreff: PLEASE HELP ME: JNDI ERROR 1 -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]