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

Hi
thanx , some where in program the connection was
getting closed, thanx i got it working

Ashish
--- Gary L Peskin <garyp@xxxxxxxxxxxx> wrote:
> 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.
> > 
> 
> _______________________________________________
> 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.
> 


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus