Re: Call Level Interface error

Fred, 

Do i set up the trace details you mentioned on As400
command line STRTCPSVR *HTTP HTTPSVR(DEFAULT) ....

OR


Is there a properties file that I need to meddle with
? 

Regards
Madhavan

--- kulack@us.ibm.com wrote:
> 
> Trust me. There is a reason... 8-)
> Whenever you get something like that, there are a
> couple of common
> things that you need to look at before you can do
> any debugging.
> 
> 1) See if you can get a call stack trace from the
> Java exception.
> 
> In Websphere: Sometimes if you enable websphere
> tracing, you'll
> get a call stack trace of the exception in the
> output trace file.
> 
> Alternatively, if you're using the native JDBC
> driver
> (com.ibm.db2.jdbc.app.DB2Driver),
> you can enable internal Jdbc trace at an error
> level, and you
> should get a JDBC trace of the call stack.
> On the websphere command line for your app server,
> add these
> properties:
> -Djdbc.db2.trace=1 and
> -Djdbc.db2.trace.config=file:///jdbc.%j.txt
> 
> 1 is error level trace, the levels can go up to 3,
> but 3 is very verbose
> and
> can give you trace files in the HUNDREDS of
> megabytes or even a
> 1G trace file. Stop your server after the error is
> recreated and
> remove the trace properties.
> If you like to see how things work internally, more
> verbose traces
> give you things you can follow through.
> Ensure that for the destination of the trace, you
> have 3 slashes.
> i.e. 2 for the file://, and one for the path of the
> file /jdbc.%j.txt.
> After getting your error, look at
> /jdbc.<full-jobname>.txt and
> you should see a call stack in there somewhere.
> 
> 2) Look in the joblog of the websphere application
> server.
> There should be joblog messages about what the
> actual
> error condition was.
> 
> Post back with more info.
> 
> 
> "Do you believe that my being stronger or faster has
> anything
>  to do with my muscles in this place?" ... "Free
> your mind."
> Laurence Fishburne as Morpheus in 'The Matrix'.
> 
> Fred A. Kulack  -  AS/400e  Java and Java DB2
> access, Jdbc, JTA, etc...
> IBM in Rochester, MN  (Phone: 507.253.5982   T/L
> 553-5982)
> mailto:kulack@us.ibm.com   Personal:
> mailto:kulack@bresnanlink.net
> AOL Instant Messenger: Home:FKulack  Work:FKulackWrk
> 
> 
> Madhavan <seawolf00@yahoo.com>@midrange.com on
> 09/22/2000 01:43:14 PM
> 
> Please respond to JAVA400-L@midrange.com
> 
> Sent by:  owner-java400-l@midrange.com
> 
> 
> To:   JAVA400-L@midrange.com
> cc:
> Subject:  Call Level Interface error
> 
> 
> 
> I am running a bunch of processes on AS400 V4R4
> WebSphere std edition. The process involves native
> JDBC access to create XML object. Suddenly during
> processing and for no reason, I get an error like "
> :com.ibm.db2.jdbc.app.DB2SQLException2: Error
> Occurred
> in SQL Call Level Interface " . Later on it starts
> running smoothly.. I am using IBM's Connnection pool
> manager /implementations to create pool of
> connections
> for my servlet.
> 
> Can somebody explain how to rectify this error since
> it misses a document object processing during that
> error.
> 
> AS400 -v4r4
> Websphere - 2.0 (std edition)
> Conn pool - Using IBM' implementation
> Process :
>   A thread job runs continously to poll a dataqueue
> and if any entry found, it calls an extraction job
> to
> do some sql fetches and creates xml object
> 
> Regards
> madhavan
> 
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo!
> Messenger.
> http://im.yahoo.com/
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to
> JAVA400-L@midrange.com.
> | To subscribe to this list send email to
> JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner:
> joe@zappie.net
> +---
> 
> 
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to
> JAVA400-L@midrange.com.
> | To subscribe to this list send email to
> JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner:
> joe@zappie.net
> +---


__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---