David, Ignore the previous code!!This is the right one:will this code make the difference?
catch(Exception exp) { theLog.error("Exception while getting a Datasource connection..Trying again..."); theLog.error(exp); int i=1; do{ try{ return ds.getConnection(); } catch(Exception e){ theLog.error("Try:"+i+"Exception while getting a Datasource connection..."); theLog.error(e); if(i==3) throw e; } i++ }while(i<=3) } Regards, Thangavel Sankaranarayanan Thangavel Sankaranarayanan/ India/[EMAIL PROTECTED] To "Tomcat Users List" 09/09/2008 12:16 <users@tomcat.apache.org> AM cc Subject Please respond to Re: Intermitant DB Problem in "Tomcat Users tomcat:java.sql.SQLException: Io List" exception: Connection reset by <[EMAIL PROTECTED] peer: JVM_recv in socket input che.org> stream read David,Actually Resource element is used when we want to map a datascr to a JNDI Resource and call from aoos.But in my case there is no JNDI naming of datasource or database!! all parameters are hard coded . In that case wat can i do!!! I have modified my code slightly to look like ths!!! will this be helpfull??? catch(Exception exp) { theLog.error("Exception while getting a Datasource connection..Trying again..."); theLog.error(exp); int i=1; do{ try{ return ds.getConnection(); } catch(Exception e){ theLog.error("Try:"+i+"Exception while getting a Datasource connection..."); theLog.error(e); if(i==3) throw e; } i++ }while(i<=3) } Regards, Thangavel Sankaranarayanan David Smith <[EMAIL PROTECTED] > To Tomcat Users List 09/08/2008 11:51 <users@tomcat.apache.org> PM cc Subject Please respond to Re: Intermitant DB Problem in "Tomcat Users tomcat:java.sql.SQLException: Io List" exception: Connection reset by <[EMAIL PROTECTED] peer: JVM_recv in socket input che.org> stream read Actually I believe tomcat 4.1 still predominantly used server.xml for context definitions. Take a look in there for a <ResourceParams ...> ... </ResourceParams> element under your webapp's <Context ...> ... </Context> element. I could be wrong about that -- it's been a *very* long time since I've done anything with that version. --David Thangavel Sankaranarayanan wrote: > Hi David, > > In my webapps directory ,i can find Conext.xml (nameof context.xml).in my > context.xml the following is defined.. > > where do i need to configure it ,David?? > > <Context path="/mpp" docBase="D:/projects/mpp/dealer/release071010" > debug="0" privileged="true"> > > <Realm className="au.com.workconsult.catalina.realm.NdsJNDIRealm" > debug="99" > connectionName="cn=Directory Manager" > connectionPassword="hadepyhkl" > connectionURL="ldap://vanja1234:389" > digest="SHA" > roleBase="ou=mpp,ou=Groups,dc=vodafone,dc=com,dc=au" > roleName="cn" > roleSearch="(uniquemember={0})" > roleSubtree="true" > userPassword="userPassword" > userPattern="uid={0},dc=abc,dc=com,dc=in" > /> > > </Context> > > > > Regards, > Thangavel Sankaranarayanan > > > > > > David Smith > <[EMAIL PROTECTED] > > To > Tomcat Users List > 09/08/2008 10:44 <users@tomcat.apache.org> > PM cc > > Subject > Please respond to Re: Intermitant DB Problem in > "Tomcat Users tomcat:java.sql.SQLException: Io > List" exception: Connection reset by > <[EMAIL PROTECTED] peer: JVM_recv in socket input > che.org> stream read > > > > > > > > > > > I think so. Tomcat 4.1.x relies on DBCP 1.0 whose docs aren't readily > available anymore. If you can find the source for DBCP 1.0, you could > take a look in the source code and get that answer. Or you could just > try it on your test system and see if it works. :-) > > The manner the validation query is added to tomat's config is different > though. You add it in the ResourceParams element the same way other > properties are defined in your version. > > --David > > Thangavel Sankaranarayanan wrote: > > >> Hi David, >> Thanks !!! >> >> Is the validationQuery applicable to tomacat 4.x. >> I am using tomcat 4.x in windows2000 >> >> >> Regards, >> Thangavel Sankaranarayanan >> >> >> >> >> >> > > >> David Smith >> > > >> <[EMAIL PROTECTED] >> > > >> > >> > To > >> Tomcat Users List >> > > >> 09/08/2008 09:19 <users@tomcat.apache.org> >> > > >> PM >> > cc > > > > Subject > >> Please respond to Re: Intermitant DB Problem in >> > > >> "Tomcat Users tomcat:java.sql.SQLException: Io >> > > >> List" exception: Connection reset by >> > > >> <[EMAIL PROTECTED] peer: JVM_recv in socket input >> > > >> che.org> stream read >> > > > > > > > > > > > > > > >> >> >> I've partially given it to you already. I'm assuming for the purposes >> of this thread you have tomcat 5.5.x or tomcat 6.0.x and are using the >> tomcat provided database pooling. Find the <Resource ... /> element in >> your webapp's context xml file where you defined your database pool and >> add an attribute named validationQuery with a value of "select 1". Then >> restart your webapp. >> >> --David >> >> Thangavel Sankaranarayanan wrote: >> >> >>> Please help me in setting up a Validation Querry!!! >>> I am not aware of it!! >>> >>> Regards, >>> Thangavel Sankaranarayanan >>> >>> >>> >>> >>> >>> >> >>> David Smith >>> >>> >> >>> <[EMAIL PROTECTED] >>> >>> >> >>> > >>> >>> >> To >> >> >>> Tomcat Users List >>> >>> >> >>> 09/08/2008 06:24 <users@tomcat.apache.org> >>> >>> >> >>> PM >>> >>> >> cc >> >> >> >> Subject >> >> >>> Please respond to Re: Intermitant DB Problem in >>> >>> >> >>> "Tomcat Users tomcat:java.sql.SQLException: Io >>> >>> >> >>> List" exception: Connection reset by >>> >>> >> >>> <[EMAIL PROTECTED] peer: JVM_recv in socket input >>> >>> >> >>> che.org> stream read >>> >>> >> >> >> >> >> >> >> >> >> >> >> >> >> >>> Two questions: >>> >>> 1. Is the db server on the same box as the tomcat server? If not, have >>> you ruled out network hardware issues between the db server and tomcat? >>> >>> 2. Does your db pool definition have the attribute >>> validationQuery="select 1"? That would pre-test your connections before >>> returning one on ds.getConnection(), regenerating them if they fail. >>> >>> --David >>> >>> Thangavel Sankaranarayanan wrote: >>> >>> >>> >>>> Hi , >>>> >>>> I am getting the following error when connecting to oracle database, >>>> >>>> Has any one seen this kind of errors before? is this the problem with >>>> tomcat in loosing the connections?? >>>> I am getting this error once in 5 hrs and i get a HTTPStatus500 error >>>> >>>> >>>> >>> and >>> >>> >>> >>>> when a user tries again it gets okay and it is working >>>> How can i resolve this Intermitant DB Problem in tomcat!!! >>>> >>>> java.sql.SQLException: Io exception: Connection reset by peer: JVM_recv >>>> >>>> >>>> >>> in >>> >>> >>> >>>> socket input stream read >>>> >>>> This is the Exception details in my application logs: >>>> DEBUG au.com.vodafone.mpp.bos.MPPFactory - Calling getConnection >>>> >>>> >>>> >>> method >>> >>> >>> >>>> of Datasrc Class:600991 >>>> DEBUG au.com.vodafone.mpp.da.DataSrc - Inside getConnection() >>>> > method > >>>> >>> of >>> >>> >>> >>>> DataScr >>>> DEBUG au.com.vodafone.mpp.da.DataSrc - About to get a Connection >>>> > from > >>>> SharedPoolDatasrc and return it back... >>>> ERROR au.com.vodafone.mpp.da.DataSrc - Exception while get a >>>> >>>> >>>> >>> Datasource >>> >>> >>> >>>> connection >>>> ERROR au.com.vodafone.mpp.da.DataSrc - java.sql.SQLException: Io >>>> exception: Connection reset by peer: JVM_recv in socket input stream >>>> >>>> >> read >> >> >>>> DEBUG au.com.vodafone.mpp.bos.MPPFactory - >>>> Exception:java.sql.SQLException: Io exception: Connection reset by >>>> > peer: > >>>> JVM_recv in socket input stream read >>>> WARN org.apache.struts.action.RequestProcessor - Unhandled >>>> > Exception > >>>> thrown: class java.sql.SQLException >>>> >>>> >>>> This is my code: >>>> >>>> static public Connection getConnection() throws Exception { >>>> theLog.debug("Inside getConnection() method of DataScr"); >>>> try >>>> { >>>> >>>> if (ds == null) >>>> { >>>> theLog.debug("SharedPoolDatasrc is NULL: >>>> > Serious > >>>> Error "); >>>> System.out.println("SERIOUS ERROR 99"); >>>> } >>>> theLog.debug("About to get a Connection from >>>> SharedPoolDatasrc and return it back..."); >>>> return ds.getConnection(); >>>> } >>>> catch(Exception exp) >>>> { >>>> theLog.error("Exception while get a Datasource >>>> connection"); >>>> theLog.error(exp); >>>> throw exp; >>>> } >>>> } >>>> >>>> >>>> >>>> Regards, >>>> Thangavel Sankaranarayanan >>>> >>>> >>>> --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]