Hey Tom, When I said your thread was off-topic I didn't mean to imply you couldn't post your question! Sorry if that's how it came across. Just thought you should mark it [OT] as Yoav pointed out. It appears I was wrong anyways; I missed the part about it working in Resin and not in Tomcat.
As for your question, what is it exactly that goes wrong with your app now that its running under Tomcat and not Resin? Trouble getting the data to your jsp? Is it not starting up? The code you posted doesn't actually DO anything so I'm guessing that's just an example you put together to illustrate what you're trying to do? Could you post the parts of your Context regarding the jndi resource you are configuring? Adrian ----- Original Message ----- From: "Tom K" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 9:41 AM Subject: RE: Question on debuggin JNDI/prepared statement in a bean Harry, Yes the ClassifiedAd and UniqueDateId are two parameters taken from an html form, the values of ClassifiedAd and UniqueDateId are used in a prepared statement for substitution of ? and ? the results are then forwarded to a results jsp, which used the getXXX() to retrieve the values from the bean. I have this code working in another form as a Servlet using JNDI and prepared statements. In the servlet the JNDI connection is made in the init(blah, blah) and calls the super.init(config) which I super.init(config) is implicit from reading the Tomcat docs. The bottom line on this, is how do you set up a JNDI connection in a bean, use a prepared statement (in a bean), retrieve a resultset and forward the result for the results jsp to retrieve the value from the bean. Finally, I apologize to those who feel this is off topic. I have similar code working in Resin but for the life of me, I can't get it working with Tomcat 5 :-( I searched all the archives and can't find a good example for doing this. TIA Tom K. -----Original Message----- From: Harry Mantheakis [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 2:29 AM To: Tomcat Users List Subject: Re: Question on debuggin JNDI/prepared statement in a bean Hello > pstmt.setString(1,ClassifiedAd); > pstmt.setString(2,UniqueDateId); Are those two parameters - 'ClassifiedAd' and 'UniqueDateId' - variables? They should be, and if so, where do you declare and initialise them? They do not appear in the method you posted. Harry > I am frustrated trying to debug a prepared statement within a bean; what > am I doing wrong?; ANY clues appreciatedŠ > It is not throwing any exceptions yet I methodically went over the code; > granted this is the first time I used beans versus servlets. > > Can anyone point me to a good example (JNDI, JSP, JavaBean, Resultset) > > Code within bean: > > private void prepareStatement(){ > try{ > > Context env = (Context) new > InitialContext().lookup("java:comp/env"); > pool = (DataSource) env.lookup("jdbc/myDB"); > > if (pool == null) > throw new NamingException("`jdbc/ myDB ' is an > unknown DataSource"); > > > > //dbConnection = null; > dbConnection = pool.getConnection(); > > > String SQLCmd = > "select * from AdInfoView where Classification = ? > " > + "and UniqueDateId < ? order by UniqueDateId > desc"; > > pstmt = dbConnection.prepareStatement(SQLCmd); > // TEST Exception thrown here. > // pstmt.setString(1,searchWord); > pstmt.setString(1,ClassifiedAd); > pstmt.setString(2,UniqueDateId); > > }catch(Exception e){ > System.err.println("Problem preparing statement " + > e.getMessage() + e.getCause()); > } > } > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 --------------------------------------------------------------------- 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]
