On Jul 3, 6:56 pm, Karl & Betty Schendel <schen...@[EMAIL PROTECTED]
>
wrote:
> On Jul 3, 2008, at 10:36 AM, ram...@[EMAIL PROTECTED]
wrote:
>
>
>
> > This is exactly what I am doing:
>
> > In the application, I am calling a method first to connect to the
> > database and retrieve some information. This works fine. The second
> > time I am calling another method with connection to the same database
> > passed as a parameter (as follows) and this is where the error takes
> > place. This application is kicked off every night and the only
> > puzzling thing is it was running OK for quite some time and the last
> > couple of days the error started showing up.
>
> The message about "DB procedure" is probably coming from some code
> somewhere that is shared between prepared statements and DB procs.
> Looking at your code snippet, it's probably running the select as a
> prepared statement and getting snarfled up somehow.
>
> I couldn't tell you what, though. Obviously something has changed
> somewhere along the pipeline.
>
>
>
> > private String getLastSuccessDate(DBConnection con, String x, String
> > y, String z){
> > String lastSuccessDate="";
>
> > try{
> > String sql2 = "SELECT max(date(field_value))
> > "+
> > "FROM additional_info
> > "+
> > "WHERE text_info_1 =
> > "+x+" AND "+
> > "text_info_2 = '"+y+"'
> > AND "+
> > "text_info_3 = '"+z+"'
> > ";
>
> > ResultSet result = con.runSelect(sql2);
> > while (result.next()){
>
> > lastSuccessDate=getValue(result.getString(1));
> > }//end while
>
> > } catch(Exception ex1){
> > EventLog.write(appName, "getLastSuccessDate
> > "+ex1.toString(), logFile); //Error is caught here
> > }
>
> > EventLog.write(appName, "last success date is
> > "+lastSuccessDate, logFile);
> > return lastSuccessDate;
> > }
I've seen the exact errors when trying switching sessions or when
reverting back to my current session with exec sql SET_SQL ( session
= :session_id) from inside my esql error handler. After some initial
error messages ('Attempt to switch to a non-existent session.
(E_LQ00BE) ' error. ) you eventually get the messages you describe.
For further details when that occurred you might want to check my post
<a href="http://groups.google.com/group/comp.databases.ingres/
browse_thread/thread/98a78263f9ae4aa0?hl=en#"> Real time decision
making based on QEP results </a>
So I assume that this is somehow related to connecting or to switching
to a session.
If that is so and you find out more I really would like to know as
well
|
