Re: JDBC question...

Shane,

That's likely because you're not closing each prepared statement - you
should always make sure you close each statement, something such as:

PreparedStatement stmt = conn.prepareStatement ("SELECT * FROM ABC WHERE
XYZ = ?");
try
{
      .......
}
finally
{
      stmt.close ();
}

If you can't solve this maybe you could post the section of code for us to
look at?

HTH,

Nigel Gay,
Computer Patent Annuities.



|---------+------------------------------>
|         |           Shane_Cessna@xxxxxx|
|         |           m                  |
|         |           Sent by:           |
|         |           java400-l-bounces@m|
|         |           idrange.com        |
|         |                              |
|         |                              |
|         |           17/06/2005 12:00 PM|
|         |           Please respond to  |
|         |           Java Programming on|
|         |           and around the     |
|         |           iSeries / AS400    |
|         |                              |
|---------+------------------------------>
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                 |
  |       To:       Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>                  |
  |       cc:                                                                   
                                 |
  |       Subject:  Re: JDBC question...                                        
                                 |
  
>--------------------------------------------------------------------------------------------------------------|




Do I have to have a prepareStatement() method before I do a .setXXX on a
PreparedStatement object?

If so, how can I get around the error: Limit on number of statements
exceeded. ?

Shane Cessna
iSeries Programmer
iSeries WAS Administrator
North American Lighting, Inc.
(618) 662-4483 x2776
shane_cessna@xxxxxxxxx
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.








********************************************************************************
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee; access to this
email by anyone else is unauthorised.

If you are not the intended recipient: (1) you are kindly requested
to return a copy of this message to the sender indicating that you
have received it in error, and to destroy the received copy; and (2)
any disclosure or distribution of this message, as well as any action
taken or omitted to be taken in reliance on its content, is prohibited
and may be unlawful.
********************************************************************************