Re: ERROR XSAI2: The conglomerate requested does not exist.

2007-05-11 Thread Stanley Bradbury
Daniel Noll wrote: It was while running this statement... CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE() That I got the following exception: ERROR XSAI2: The conglomerate (113) requested does not exist. at

Re: Exception getting columns from table

2007-05-11 Thread Stanley Bradbury
Andy Stewart wrote: Hi can anyone help? We were using derby 10.1 but have since upgraded to 10.2. Any databases created against version 10.1 work fine in our app against version 10.2. of derby. However when we try and connect to a database that has been created in 10.2 we get the following

Clarification needed about starting ij

2007-05-11 Thread Laura Stewart
In several of the Activities in Working With Derby, the instructions have the user type the following command to run ij java -jar %DERBY_HOME%\lib\derbyrun.jar ij If the user has set up the DERBY_HOME environment variable, why can't they just type ij to start the tool? The instructions in

Re: Exception getting columns from table

2007-05-11 Thread Mike Matrigali
As with all problem reports, could you say what exact version of Derby you are using. There were 2 different 10.2 releases, the latest was 10.2.2.0. Also just to verify, do you expect your database to be read only? There have been problems in the past with soft upgrade and stored prepared

RE: SQL Exception: Container xxx not found

2007-05-11 Thread Parker, Patricia \(LNG-CON\)
Hi Stanley, I disabled the cache and did more analysis of the actual timing of the events, and it appears that the problem is that the bulk load CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (?,?,?,?,?,?,?,?,?) is not entirely finishing before I try to query the table it is populating. I would expect to get

Re: SQL Exception: Container xxx not found

2007-05-11 Thread Bryan Pendleton
events, and it appears that the problem is that the bulk load CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (?,?,?,?,?,?,?,?,?) is not entirely finishing before I try to query the table it is populating. I would expect to get a locking exception, or something of that nature, but the I think I would expect

RE: SQL Exception: Container xxx not found

2007-05-11 Thread Parker, Patricia \(LNG-CON\)
Bryan, I've done just that. Thanks Patty -Original Message- From: Bryan Pendleton [mailto:[EMAIL PROTECTED] Sent: Friday, May 11, 2007 4:33 PM To: Derby Discussion Subject: Re: SQL Exception: Container xxx not found events, and it appears that the problem is that the bulk load CALL

Re: Clarification needed about starting ij

2007-05-11 Thread Laura Stewart
Thanks Kim, this really helps. I will clarify the text so that it doesn't confuse anyone else ! Laura On 5/11/07, Kim Haase [EMAIL PROTECTED] wrote: Laura Stewart wrote: In several of the Activities in Working With Derby, the instructions have the user type the following command to run ij

Re: SQL Exception: Container xxx not found

2007-05-11 Thread Mike Matrigali
Are the two threads sharing the same Connection object (and thus the same transaction)? If not I also would have expected a lock wait call. There may be a problem with dependency management. Are you using bulk load to load an empty table? /mikem Parker, Patricia (LNG-CON) wrote: Hi Stanley,