RE: WARNING 02000 (was "Error 00200")

-Original Message- From: Stanley Bradbury [mailto:[EMAIL PROTECTED] Sent: 31 January 2008 16:04 To: Derby Discussion Subject: Re: WARNING 02000 (was "Error 00200") Hi Nick - Warnings messages should only be displayed when the derby.stream.error.logSeverityLevel property is set to zero, no

RE: distinct and order by

You can do it as long as the same column appears in both phrases. Allowed: select distinct project_id from projectproject order by project_id; Not allowed: select distinct project_id from projectproject order by name; (ERROR 42879: The ORDER BY clause may not contain column 'NAME', since the que

WARNING 02000 (was "Error 00200")

Sorry - typo in the thread title. Should have been "WARNING 02000". -Original Message----- From: Williamson, Nick Sent: 31 January 2008 11:50 To: 'Derby Discussion' Subject: Error 00200 Hi all, I'm running 10.3 and I get this message several times in the Derby

Error 00200

Hi all, I'm running 10.3 and I get this message several times in the Derby log file when my Java app deletes a row from a table that is the top table in a fairly extensive multi-level "ON DELETE CASCADE" foreign key hierarchy: "No row was found for FETCH, UPDATE or DELETE; or the result of a quer

RE: Trigger question

ssage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 January 2008 12:09 To: Derby Discussion Subject: Re: Trigger question Williamson, Nick wrote: > Sorry... it's obviously a create trigger in the example, although I > referred to an update trigger (I've been ex

RE: Trigger question

Sorry... it's obviously a create trigger in the example, although I referred to an update trigger (I've been experimenting with both insert and update triggers, and pasted the wrong one in to the mail...) -Original Message----- From: Williamson, Nick Sent: 10 January 2008 11:37

Trigger question

Hi all, I'm migrating an Oracle schema to Derby. I have a number of tables that are read and written by two different apps. Let's say that one such table has columns c1 and c2 and one application will only populate column c1, and the other will only populate column c2. In order to make records cr

Writing to BLOBs

Hi all, In Oracle, when you want to update a BLOB, you have to do this first: set my_blob_column=empty_blob(); ...which initializes it and opens it up for writing. Oracle has a concept of a "locator", which I guess is similar to a pointer or handle to the BLOB object, and it is required in or

RE: Hibernate comment in SQL - resolved

Hi all, I found a "sql_comments=" flag in Hibernate's config file. Setting it to false stopped the comments. Regards, Nick -Original Message- From: Williamson, Nick Sent: 24 October 2007 15:43 To: Derby Discussion Subject: Hibernate comment in SQL Hi all, I'

Hibernate comment in SQL

Hi all, I'm using Hibernate to hook my Java app up to a Derby 10.2 database for the first time and I'm finding that something - which I *think* is Hibernate - is embedding comments in the SQL that Derby can't handle: Failed Statement is: /* criteria query */ select this_.COLOR_ID as COLOR1_162_

Foreign key constraints

Hi all, I see that in Derby, foreign key constraints don't support the deferred / deferrable syntax that I'm used to using in Oracle, and - creating data in IJ by running a script - validation seems to take place straight away by default (in other words, Derby doesn't wait until the COMMIT). Now w

RE: Unraveling FK errors

OK, thanks - will do. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 September 2007 10:09 To: Derby Discussion Subject: Re: Unraveling FK errors You could log an enhancement request in Jira for this.

Unraveling FK errors

Hi all, If you get errors like these when you're creating a schema... "ERROR 42915: Foreign Key 'PIN_FK1' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would cause another table to be delete-connected to the same table through multiple paths with diff

RE: IJ out of memory

JIRA DERBY-3009 created. Regards, Nick -Original Message- From: Williamson, Nick Sent: 15 August 2007 09:53 To: Derby Discussion Subject: RE: IJ out of memory Thanks Kristian, I'll visit the site and create an issue, attaching the script. Thanks for doing the investig

RE: IJ out of memory

Thanks Kristian, I'll visit the site and create an issue, attaching the script. Thanks for doing the investigation. Regards, Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 August 2007 09:45 To: Derby Discussion Subject: Re: IJ out of memory Filin

RE: IJ out of memory

Thanks Bryan, Unfortunately, I'm working with an existing Oracle DDL script which has separate FK definitions so I can't easily include them in the table definition. I'm just running the Oracle DDL script through a reformatting routine that I wrote which removes tokens and statements that Derby do

RE: IJ out of memory

Thanks Kristian, ...and apologies for the lack of information. I knew as soon as I'd posted that I should have said more about the environment... My config is default AFAIK, with the exception that I have the error logging set to 0. That said, I still get the OOME if I set error logging back to t

IJ out of memory

Hi all, I'm experiencing java.lang.OutOfMemoryError when trying to create a large schema (500+ tables, lots of constraints). Is there anything I can do about it (perhaps by allocating more memory to IJ) or is it a bug? TIA Nick

Function-based indexes

Hi all, In Oracle, it's possible to have an index column that is the result of a function, for example: CREATE INDEX index_name ON table_name ( UPPER("column_name") ); It doesn't seem possible to do this in Derby. What would be the best way to mimic this behaviour? I guess I would need a

RE: Characters and bytes

> Derby's varchar(10) will store 10 Unicode (multi-byte) characters. > Are you saying you are getting an error when you attempt to do this? > I don't see an advantage to specifying bytes when all Derby data is > stored in a modified Unicode format. Hi Stanley, No, I'm not getting errors in D

Characters and bytes

Hi all, In Oracle, you can specify character columns widths in bytes (the default) or characters. The advantage of specifying column width in characters is that you can attempt to store - say - 10 multi-byte characters in a VARCHAR(10) column without getting an error. Derby doesn't seem to have a

Deferrable constraints

Hi all, I'm migrating an Oracle schema to the Derby environment. In Oracle, all my FK constraints are defined as INITIALLY DEFERRED DEFERRABLE, which means that the validation checking isn't performed until commit time. If I have parent table "A" and child table "B", I can create a row in table B

Newbie questions

Hi all, I'm brand new to Derby. Having been through the tutorial exercises, I've started on the joyous task of migrating my Oracle schema to Derby and I'm finding quite a few things in the DDL that it doesn't like. I've been able to re-phrase / remove most of them, but one in particular is causin