The first thing I would look into is logging some info about the ResultSet you are getting back. Is the ResultSet from execute query null? It probably is. Then pin point the problem to Statement.executeQuery. If this is the problem, then I think since the error you are receiving is in a JDBC method and this is a method in the Oracle driver you may want to try a different database (just make some simple tables and things for testing) make some simple pages and test the Oracle Driver and the other Database.
If the other driver works fine, and the Oracle Driver is the one having the problem; then you need to contact Oracle about the issue. Explain that with one users permissions you can do this .... Show them an example. Then, with this users this happens. Also, show them code using a different driver. Working with Oracle on issues is never fun, and it is never fast, and they always want someone else to front the cost...even if it is their fault. But, at the end of the day, the code in the JDBC driver is their responsibility. I would go that route. It will pin point you to the source of the problem with proof that X works and Y doesn't. Y happens to be Oracles thin db driver. Find out what it may be accessing in the file system or other things that could be causing this problem. Hope that helps you some. Wade -----Original Message----- From: Jose Euclides da Silva Junior - DATAPREVRJ [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 4:40 PM To: 'Tomcat Users List'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RES: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Dear Chuck and friends, here is all steps taken: 1 - disable old tomcat's service 2 - download new tomcat 4.1.17 3 - install it as a NT service 4 - process of app configuration ( server.xml, web.xml and adding folders ) AGAIN, the old big problem still alive: only the static pages are availables, so whenever my app tries to use ResultSet, I get that known error message: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.NullPointerException at BancoServlet.recuperaTopicoAssunto(BancoServlet.java:413) Really, what is wrong with this procedure? Let me remind you: since i have runned this fucking tcservcfg ( to turn tomcat a service), my app have never been running correctly anymore.Probably, some NT internal configuration was wrongly mismatched by tcservcfg. Any last hint? -----Mensagem original----- De: Goehring, Chuck Mr., RCI - San Diego [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 21 de outubro de 2003 16:00 Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Apache. Org (E-mail) Assunto: RES: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Jose, Yes. I'd rename the top level dir so you have your servlets, jsps and images saved. Otherwise, I'd zip it and copy it somewhere. Chuck -----Original Message----- From: Jose Euclides da Silva Junior - DATAPREVRJ [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:45 AM To: 'Tomcat Users List'; Goehring, Chuck Mr., RCI - San Diego Subject: RES: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Thank you, Chuck. I will do it! So, i should keep saved the existing server.xml and web.xml files before the new installation starts, i guess... Isnt it? Euclides -----Mensagem original----- De: Goehring, Chuck Mr., RCI - San Diego [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 21 de outubro de 2003 14:37 Para: Tomcat Users List Assunto: RE: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Jose, Uninstall Tomcat. Start the installer and one of the screens has a list of products (Tomcat, Source etc) if you scroll down, there is and unchecked item that says to install it as a service. You must check this one to get it installed. If you are re-installing you also need to make sure it installs in the same directory to prevent other problems. Once the installer completes you can run it as a service or disable the service and use the startup.bat in the bin directory to start it from a command prompt. Sometimes this is desirable when debugging things that go wrong at startup. Chuck -----Original Message----- From: Jose Euclides da Silva Junior - DATAPREVRJ [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:28 AM To: 'Tomcat Users List'; Goehring, Chuck Mr., RCI - San Diego Subject: RES: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Where is this checkbox? How can i reach there? I am talking about TomCat 4.1.18... -----Mensagem original----- De: Goehring, Chuck Mr., RCI - San Diego [mailto:[EMAIL PROTECTED] Enviada em: terça-feira, 21 de outubro de 2003 14:22 Para: Tomcat Users List Assunto: RE: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Jose, I spent a long time trying to manually setup Tomcat to run as a service. Finally ended up re-installing and checking the little checkbox that makes it usable as a service. It is unchecked by default. Once it is installed, you can change the account it executes as in the services thingy in control panel. Chuck -----Original Message----- From: Jose Euclides da Silva Junior - DATAPREVRJ [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 10:11 AM To: '[EMAIL PROTECTED]' Subject: Bugs and weakness when Tomcat works a NT Service (tcservcfg) Hi all, there have been a nightmare since i ve decided to make TomCat 4.1.18 be a Windows NT 4.0's Service.First of all, i ve the stuped idea of looking for a program which could make it for me. So, i found the nightmare main actor --> tcservcfg and the second one --> windows!!! Thus, i made the following steps: 1 - ...runned the main actor ( tcservcfg ) - OK! 2 - started up the service - OK! 3 - test the environment - FAILURE! NOW, THE NIGHTMARE begins 4 - Only the static pages are availables, so whenever my app tries to use Result Sets, I get this error message: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception java.lang.NullPointerException at BancoServlet.recuperaTopicoAssunto(BancoServlet.java:413) at BancoServlet.service(BancoServlet.java:249) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tion FilterChain.java:247) LINE 413 points to a resultset statement, see below: ring query = "Select * FROM DICAS WHERE ID_TOPICO = " + topico2; pstmt = con.prepareStatement(query); rs = pstmt.executeQuery(); if ( !rs.next() ) { // --> THIS IS LINE 413 <-- fechaconection( pstmt,rs,con); chamadevolta = getServletContext().getRequestDispatcher("/semconteudo.jsp"); chamadevolta.forward(request,response); } 5 - I ve tried to find something about permission but i didnt find anything. 6 - THE WORST: I stopped the service and tried to work as before --> starting TomCat by running startup.bat file. Unfortunatelly, TomCat doesnt starts up ANYMORE !!! 7- Then, i ve disabled all TomCat's services 8- Tried step 6 again - FAILURE AGAIN 9 - Finally, i ve removed the Registry key of TomCat service. 10 - Tried step 6 again - FAILURE AGAIN - it is a loop, isnt it... Really, any single help will be appreciated... Euclides. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
