Development and Deployment is not a problem. The problem occurs just is production environment.
mgainty wrote: > > > develop and deploy on your own machine to control environmental issues > such as 403 > > Viel Gluck! > Martin > ______________________________________________ > Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality > note > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte > Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht > dient lediglich dem Austausch von Informationen und entfaltet keine > rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von > E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > This message is confidential and may be privileged. If you are not the > intended recipient, we kindly ask you to please inform the sender. Any > unauthorised dissemination or copying hereof is prohibited. This message > serves for information purposes only and shall not have any legally > binding effect. Given that e-mails can easily be subject to manipulation, > we can not accept any liability for the content provided. > > > > > > >> Date: Tue, 24 Mar 2009 07:03:57 -0700 >> From: rjrferre...@gmail.com >> To: users@tomcat.apache.org >> Subject: Re: Tomcat and Database Problem >> >> >> Hi David, >> >> >> Yes I know that a 403 doesn't seem to have anything with this situation, >> but >> it's the only error :) >> >> Strange...Strange... I don't know what to do... >> >> >> If I raise de connection timeout in the firewall I solve the problem. The >> problem here, is that i don't have permissions to do anything in others >> firewalls (like in a production scenario) >> >> >> One workaround for this, is stimulate the application/databases >> connections >> and prevent this kind of problems! I don't know if this is a good >> approach >> but I don't remember nothing else... >> >> Solution... keep trying... >> >> tnks for all! >> >> >> >> >> David Smith-2 wrote: >> > >> > Are you sure the validation query is active in the connection pool? >> > There aren't any other <Context ... /> elements in other xml fragments >> > superseding the one below? Seems a litle strange that your firewall >> > would should down a connection in the tiny (microseconds) sliver of >> time >> > between the validation query and using the connection. >> > >> > Oh, and a 403 error in http land if that's what you are referring to is >> > "Forbidden" .. the client doesn't have permission to view the requested >> > resource. Your browser provided credentials and they are validated, >> but >> > those credentials are not authorized to view the resource. This >> doesn't >> > seem to have anything to do with the database problem. >> > >> > --David >> > >> > >> > CutKiller wrote: >> >> If helps, the connection state is "connection reset" >> >> >> >> >> >> >> >> CutKiller wrote: >> >> >> >>> No errors... :( >> >>> >> >>> For example when i sign in on the App, appears one error on tomcat >> >>> log... >> >>> A 403 something... >> >>> >> >>> >> >>> >> >>> >> >>> David Smith-2 wrote: >> >>> >> >>>> Any indication in the logs of what's happening around the time you >> get >> >>>> a >> >>>> bad connection? Seems weird to me that the validation query isn't >> >>>> working. >> >>>> >> >>>> --David >> >>>> >> >>>> CutKiller wrote: >> >>>> >> >>>>> Tnks David. >> >>>>> >> >>>>> >> >>>>> But the validationQuery was set at the Resources Tags. >> >>>>> >> >>>>> <Context path="/testAdmin" docBase="testAdmin" >> >>>>> debug="0" reloadable="true" crossContext="true"> >> >>>>> <Resource name="jdbc/sp360_main_v2" auth="Container" >> >>>>> type="javax.sql.DataSource" maxActive="100" maxIdle="30" >> >>>>> maxWait="10000" removeAbandoned="true" >> removeAbandonedTimeout="1800" >> >>>>> logAbandoned="true" username="mqa" password="1nspector" >> >>>>> driverClassName="oracle.jdbc.OracleDriver" >> >>>>> url="jdbc:oracle:thin:xxx/xxxxx@//00.00.00.00:1521/orcl" >> >>>>> validationQuery="select 1 from dual" >> >>>>> testWhileIdle="true" >> >>>>> timeBetweenEvictionRunsMillis="60000"/> >> >>>>> </Context> >> >>>>> >> >>>>> >> >>>>> >> >>>>> >> >>>>> >> >>>>> David Smith-2 wrote: >> >>>>> >> >>>>> >> >>>>>> CutKiller wrote: >> >>>>>> >> >>>>>> >> >>>>>>> If I raise the timeout value in the firewall parameters the >> >>>>>>> connection >> >>>>>>> problem was solved.... but i don't have permissions to do that in >> >>>>>>> real >> >>>>>>> environment. >> >>>>>>> >> >>>>>>> The connections are dead, but this connections stays in tomcat >> pool >> >>>>>>> with >> >>>>>>> no >> >>>>>>> problems. Tomcat, in a perfect scenario, should recognize the >> loss >> >>>>>>> of >> >>>>>>> connection, and create a new one. >> >>>>>>> >> >>>>>>> I need this connections anytime. >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>> Right and it would recognize dead connections if validationQuery >> is >> >>>>>> provided on the connection pool. The pool will execute the >> >>>>>> validation >> >>>>>> query before handing your webapp the connection, dropping and >> >>>>>> creating >> >>>>>> a >> >>>>>> new connection as necessary. Your problem smells like you are >> >>>>>> getting >> >>>>>> a connection from the pool and keeping around a long time without >> >>>>>> returning it to the pool. Doing that effectively circumvents the >> >>>>>> pool's >> >>>>>> ability to validate connections. >> >>>>>> >> >>>>>> Posting details of your setup would be helpful including the >> >>>>>> <Resource >> >>>>>> ... /> tag that configures your pool and relevant code where >> things >> >>>>>> are >> >>>>>> breaking. >> >>>>>> >> >>>>>> --David >> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>>> David Smith-2 wrote: >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>>> CutKiller wrote: >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> >> >>>>>>>>> Hi all I have this scenario: >> >>>>>>>>> >> >>>>>>>>> |Tomcat| -> |Firewall| -> |Database| >> >>>>>>>>> >> >>>>>>>>> Sometimes the connection to the database is lost. The cause of >> >>>>>>>>> this >> >>>>>>>>> fact >> >>>>>>>>> maybe lives in the Firewall. But, the major problem, resides in >> >>>>>>>>> Tomcat. >> >>>>>>>>> He >> >>>>>>>>> doesn't recognize the connection break. What can i do, for >> Tomcat >> >>>>>>>>> knows >> >>>>>>>>> when >> >>>>>>>>> the connections break? >> >>>>>>>>> >> >>>>>>>>> Best Regards, >> >>>>>>>>> Rodrigo >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>> Can you provide a bit more context for when/how you use >> connections >> >>>>>>>> and >> >>>>>>>> how you expect tomcat to recognize when connections break? In >> >>>>>>>> general >> >>>>>>>> webapp code retrieves a connection, does it's business and then >> >>>>>>>> closes >> >>>>>>>> the connection to return it to the pool in the smallest >> reasonable >> >>>>>>>> space >> >>>>>>>> .. the whole cycle done and over with by the time your webapp is >> >>>>>>>> finished with the current request if not sooner. >> >>>>>>>> >> >>>>>>>> --David >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> >> > >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> > For additional commands, e-mail: users-h...@tomcat.apache.org >> > >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Tomcat-and-Database-Problem-tp22658620p22681114.html >> Sent from the Tomcat - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> > > _________________________________________________________________ > Internet Explorer 8 – Now Available. Faster, safer, easier. > http://clk.atdmt.com/MRT/go/141323790/direct/01/ > -- View this message in context: http://www.nabble.com/Tomcat-and-Database-Problem-tp22658620p22684901.html Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org