Michael J. Segel wrote:
On Wednesday 26 October 2005 09:20, duschhaube wrote:
Hi!
Is it possible to use regular expressions in a select statement.
for example select * from test where name="a*b"
ciao
Maybe its just your example, but what you're asking for is for all rows where
th
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 h
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 als
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 goe
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
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 management has almost decided on
Derby, subject to legal approval
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 li
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
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 s
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 E
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 of
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)
It's clear from list traffic that some things work with Derby and
Hibernate and some things don't. Please add your experience to this Wiki
page:
http://wiki.apache.org/db-derby/HibernateHelp
When you cite a problem, please be sure to note the versions of
Hibernate and Derby involved.
Anyone
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 i
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 persistin
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 Ne
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 un
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 value.
The same if a do this :
select 'test', null from foo;
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 sq
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 :
> e
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 Applicatio
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 se
Hi Islay,
It is true that old versions of Cloudscape let you declare a column to
be a Serializable type. This functionality was removed from Derby
because the syntax was non-standard. Most of the machinery to support
this useful feature, however, still exists. I have logged enhancement
reques
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 goo
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
On Wednesday 26 October 2005 09:20, duschhaube wrote:
> Hi!
>
>
> Is it possible to use regular expressions in a select statement.
>
> for example select * from test where name="a*b"
>
> ciao
Maybe its just your example, but what you're asking for is for all rows where
the field name matches the
Hi!
Is it possible to use regular expressions in a select statement.
for example select * from test where name="a*b"
ciao
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 are
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 are done and performances are bad.
Note : my indexes are taken into account
if I try equivalent selects on tables (instead of views).
Please find below a sample i
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
30 matches
Mail list logo
