Hi , by chance ,does any one of you have an idea
of how I can from an xml file create a table in my derby database .
I need some code to do this . thanks in advance.
Thanks for this excellent feedback, Michelle. Sorry for the delay --
I've been out of town. I'll look at this tomorrow along with Dan
Debrunner feedback I didn't have time to close the loop on before
leaving town.
thanks,
-jean
On Mon, 03 Apr 2006, Michelle Caisse wrote:
> Hi Jean,
>
> I just
Hi,
I am wondering if it is related to the issue -
http://issues.apache.org/jira/browse/DERBY-649
If you have an older version (than 10.1.2.3), is it possible to re-run
you scenario
using the newer snapshot jars posted at:
http://db.apache.org/derby/derby_downloads.html#Snapshot+Jars
Pleas
Hi All,
This is the exact trigger I am trying to create:
CREATE TRIGGER TEST AFTER INSERT ON PLAN_NAME_TABLE REFERENCING NEW AS
NEWROW FOR EACH ROW MODE DB2SQL INSERT INTO PLAN_NUTRIENT_TABLE (PLAN,
NUTRIENT, NUTRIENT_TYPE, UNITS) VALUES (NEWROW.PLAN, 'Total Fat', 'Fat',
'g'),(NEWROW.PLAN, 'T
Make that a StackOverflow, as per DERBY-759.
-- Michelle
Michelle Caisse wrote:
Well, Peter said the trigger was "like" the one he showed, so the
actual one may be more complex. In any case, if these bugs are
relevant, there should be an OutOfMemoryException in the log. If not,
they
Well, Peter said the trigger was "like" the one he showed, so the
actual one may be more complex. In any case, if these bugs are
relevant, there should be an OutOfMemoryException in the log. If not,
they are not relevant.
-- Michelle
Daniel John Debrunner wrote:
Michelle Caisse wrote:
Hi,
We are porting a commercial application from DB2 to Derby and have run into
a performance issue. Our application has a very complex data model and uses
four levels of views for some reports. We are facing a performance problem
in joining views at the second level.
To illustrate an example, VI
Michelle Caisse wrote:
> See http://issues.apache.org/jira/browse/DERBY-443 and
> http://issues.apache.org/jira/browse/DERBY-759. There is an issue
> handling OutOfMemoryExceptions that can result in this error.
Not sure I see the connection with those bugs. I don't see how this
trigger would l
See http://issues.apache.org/jira/browse/DERBY-443 and
http://issues.apache.org/jira/browse/DERBY-759. There is an issue
handling OutOfMemoryExceptions that can result in this error.
-- Michelle
Peter Bowman wrote:
Hi Dan,
Thanks for your input. Since I first posted I tried the solution yo
Hi Dan,
Thanks for your input. Since I first posted I tried the solution you
suggested but I always got:
"ERROR 40XT0: An internal error was identified by RawStore module."
I've checked everything ove many times to ensure that my statement is
correct and I believe it is, so is there any othe
McColley, William S wrote:
Anyone experienced this before?
table definition is:
ij> create table INDIGO.ATTRIBUTE
(ATTRIBUTE_ID SMALLINT NOT NULL ,
ATTRIBUTE_PARENT_ENTITY_ID SMALLINT NOT NULL,
ATTRIBUTE_INTERNAL_NAME VARCHAR(50),
ATTRIBUTE_EXTERNAL_NAME VARCHAR(50),
ATTRIBUTE_MAX_WIDT
Anyone experienced this before?
table definition is:
ij> create table INDIGO.ATTRIBUTE
(ATTRIBUTE_ID SMALLINT NOT NULL ,
ATTRIBUTE_PARENT_ENTITY_ID SMALLINT NOT NULL,
ATTRIBUTE_INTERNAL_NAME VARCHAR(50),
ATTRIBUTE_EXTERNAL_NAME VARCHAR(50),
ATTRIBUTE_MAX_WIDTH SMALLINT,
ATTRIBUTE
Peter Bowman wrote:
> Hi All,
>
> I have a trigger like:
>
> DROP TRIGGER RULE_10A;
>
> CREATE TRIGGER RULE_10A
> AFTER INSERT ON PLAN_NAME_TABLE
> REFERENCING NEW AS NEWROW
> FOR EACH ROW MODE DB2SQL
> INSERT INTO PLAN_NUTRIENT_TABLE (PLAN, NUTRIENT, NUTRIENT_TYPE,
> UNITS) VAL
That solved the problem. Thank you,
Wynne
Wynne Crisman wrote (2006-04-09 17:25:17):
> Is it possible to assign a null value to a VARCHAR FOR BIT DATA column? I
> am getting the following exception from the derby driver:
>
> SQL Exception: An attempt was made to get a data value of type 'VARCHAR ()
> FOR BIT DATA' from a data
15 matches
Mail list logo