Colin Rosenthal wrote:
On Tue, 2005-10-25 at 13:30, Knut Anders Hatlen wrote:
Colin Rosenthal [EMAIL PROTECTED] writes:
Hi all,
We have an application which uses derby in auto-commit=false mode.
For some reason a row in one of our tables cannot be updated from
our system. Attempting to do
Hi Frederic,
This looks like a bug. I have logged bug 649 to track this issue. Thanks
for the detailed test case.
Regards,
-Rick
Frederic MOREAU wrote:
Hello,
The optimizer does not take my indexes into account when I do a select
on a 'UNION ALL' type of view ; therefore, table scans
Hello,
Sorry to bother you with such a trivial question.
I am trying to create a table with one of the columns storing a java object.
The sql statement I have is:
CREATE TABLE StoreObject (objectID INT, object MyJavaObject);
And recieved this:
ERROR 42X01: Syntax error: Encountered at line
Hi
I m trying to do a pretty simple insert :
insert into foo (fields ) select value1, value2, , field3,
field5 from foo where id = x
Everything work until when a value is equal to NULL, i have this message :
error: Encountered null at line
Ok sql has seen a null well good
El mar, 25-10-2005 a las 13:56 +0200, Fernanda Pizzorno escribió:
Juan Ignacio Villa wrote:
[...]
Consulta =
DBConexion.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Rs = Consulta.executeQuery(sql);
[...]
Hello,
Scrollable sensitive result sets
Hi Michael,
Your opinion was very encouraging - I also built a
prototype based on Derby.
I am happy to say, that our management has almost
decided on Derby, subject to legal approval for the licensing
aspects.
We plan to use Derby as an embedded RDBMS in our
Network Management
On Wednesday 26 October 2005 15:06, Nicolas Dufour wrote:
Hi
I m trying to do a pretty simple insert :
insert into foo (fields ) select value1, value2, , field3,
field5 from foo where id = x
Everything work until when a value is equal to NULL, i have this message :
error:
Nicolas Dufour wrote:
Hi
I m trying to do a pretty simple insert :
insert into foo (fields ) select value1, value2, ,
field3, field5 from foo where id = x
Everything work until when a value is equal to NULL, i have this
message :
error: Encountered null at line
Ok sql
I noticed that in Derby a unique constraint on two
columns A and B, with B nullable, will prevent
inserting two identical records that contain NULL in
B.
This is different from some other databases such as
Sybase that do allow it (I assume where the null
records are not in stored as part of the
Raji Sridar wrote:
Hi Michael,
Your opinion was very encouraging - I also built a prototype based on Derby.
I am happy to say, that our management has almost decided on Derby,
subject to legal approval for the licensing aspects.
We plan to use Derby as an embedded RDBMS in our Network
Rick Hillegas wrote:
I recommend that you make your class implement java.io.Externalizable.
That way you can write your own deserialization logic to handle version
upgrades of your class. Don't rely on java.io.Serializable; it doesn't
handle versioning and isn't appropriate for persisting
Hi Dan,
I believe that the Sybase behavior is correct. I have logged bug 653 to
track this issue.
Regards,
-Rick
Dan Meany wrote:
I noticed that in Derby a unique constraint on two
columns A and B, with B nullable, will prevent
inserting two identical records that contain NULL in
B.
This
duschhaube wrote:
Hi!
Is it possible to use regular expressions in a select statement.
for example select * from test where name=a*b
ciao
I don't think you can do that way. Using the like operator, one can
do some pattern matching in Derby.
For Example:
create table t2(name char(30)
Hello all. I have run into some behaviour that looks like a memory
leak. I don't know if it's a bug or if I'm just missing something, but
it's causing my application to crash so I would greatly appreciate any
ideas.
Scenario: Using derby 10.1.1.0 in an embedded setup, I am inserting many
tens
Sorry for the crappy formatting of the code in my original mail. I hope
this one is better:
** InsertLots.java **
import java.util.*;
import java.sql.*;
import org.apache.derby.jdbc.EmbeddedDriver;
public class InsertLots {
static public void main(String args_[]) throws Exception {
new
Daniel Tripp wrote:
Hello all. I have run into some behaviour that looks like a memory
leak. I don't know if it's a bug or if I'm just missing something, but
it's causing my application to crash so I would greatly appreciate any
ideas.
Scenario: Using derby 10.1.1.0 in an embedded setup,
On Wednesday 26 October 2005 17:11, Nicolas Dufour wrote:
Ahh perhaps i didnt explain very well my problem :
I have an error with this query :
insert into foo (id, name, date, remark) select 1234, 'a_text', null,
remark from foo where id = 1234;
And right here derby is not happy by the null
On Wednesday 26 October 2005 17:44, Daniel John Debrunner wrote:
Raji Sridar wrote:
Hi Michael,
Your opinion was very encouraging - I also built a prototype based on
Derby. I am happy to say, that our management has almost decided on
Derby, subject to legal approval for the licensing
Michael J. Segel wrote:
The only drawback is that Derby is under GPL. So as long as you follow GPL's
rules, you're ok.
snip - lots of stuff about gpl
Derby is* not licensed *under GPL. See
http://db.apache.org/derby/license.html
Derby is available under the Apache License, Version 2.0
On Wednesday 26 October 2005 19:22, Rick Hillegas wrote:
Sorry to top post...
Sigh.
Seems that some are quick to pull the trigger and call everything they see a
bug!
This is not a bug. ;-)
Its a design issue.
I'm sure that this distinction is going to be lost on a couple of people, and
it
Thanks, Daniel!
-Original Message-
From: Daniel John Debrunner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 3:44 PM
To: Derby Discussion
Subject: Re: FW: [Fwd: Re: Are you happy with Derby?]
Raji Sridar wrote:
Hi Michael,
Your opinion was very encouraging - I also
On Thursday 27 October 2005 00:00, David W. Van Couvering wrote:
Michael J. Segel wrote:
On Wednesday 26 October 2005 17:44, Daniel John Debrunner wrote:
Raji Sridar wrote:
Hi Michael,
Your opinion was very encouraging - I also built a prototype based on
Derby. I am happy to say, that our
22 matches
Mail list logo