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]
