RE: com.ibm.db2.jdbc.app.DB2JDBCException: Function sequence error

Your connection is most likely closed or has too many open statements.  Try
calling isClosed() on the connection before prepareCall and see what it
returns.

Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
> Sent: Tuesday, January 13, 2004 10:45 AM
> To: java400-l@xxxxxxxxxxxx
> Subject: com.ibm.db2.jdbc.app.DB2JDBCException: Function 
> sequence error
> 
> 
> Hi
> I am getting following error when i try to create a 
> prepareStatement or callableStatement using native driver 
> from JTopen, 
> AS400 system V5R2
> full error description
> This was working 2 days ago, and no updates done on
> system
> any suggestions
> com.ibm.db2.jdbc.app.DB2JDBCException: Function
> sequence error.               
>  at java/lang/Throwable.<init>(Throwable.java:195)    
>                        
>  at java/lang/Exception.<init>(Exception.java:41)     
>                        
>  at java/sql/SQLException.<init>(SQLException.java:40)
>                        
>  at
> com/ibm/db2/jdbc/app/DB2Exception.<init>(DB2Exception.java:49)
>            
>  at
> com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j
> ava:2440)
>   
>  at
> com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j
> ava:2378)
>   
>  at
> com/ibm/db2/jdbc/app/DB2Connection.prepareCall(DB2Connection.j
> ava:2335)
>   
>  at
> com/pfizer/maps/data/purchase/POData.getChangeData(POData.java:106)
>       
>  at
> com/pfizer/maps/data/CreatePdfForPO.generatePDF(CreatePdfForPO
> .java:156)
>  
>  at
> com/pfizer/maps/data/PORPGToJava.createPDF(PORPGToJava.java:67)
>           
>  at
> com/pfizer/maps/data/PORPGToJava.pdfOnly(PORPGToJava.java:177)
>            
> 
> 
> =====
> A$HI$H
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes 
> http://hotjobs.sweepstakes.yahoo.com/signin> gbonus
> 
> _______________________________________________
> 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.
>