Re: Invalid SQL State

2005-10-30 Thread Michael J. Segel
On Sunday 30 October 2005 08:46, Chas douglass wrote: > I'm using Derby embedded 10.1.1.0 with Hibernate 3.0.5. I have one thread > running, iterating through a number of transactions. A second thread > starts up, performs 0 or more transactions, and then ends. At this point, > thread 1 gets: >

Re: [Fwd: Re: Are you happy with Derby?]

2005-10-28 Thread Michael J. Segel
On Thursday 27 October 2005 23:28, Daniel John Debrunner wrote: > Michael J. Segel wrote: > > On Thursday 27 October 2005 15:19, Daniel John Debrunner wrote: > > Sigh. > > > > Dan, you really need to pay more attention to what was written. > > > > With respec

Re: [Fwd: Re: Are you happy with Derby?]

2005-10-28 Thread Michael J. Segel
On Thursday 27 October 2005 23:04, Jean T. Anderson wrote: > Michael J. Segel wrote: > > ... > > Getting back to Apache, under Apache, the contributor pretty much puts > > his software out in the public eye and says have at it. > > > > Apache is great if your

Re: [Fwd: Re: Are you happy with Derby?]

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 15:19, Daniel John Debrunner wrote: Sigh. Dan, you really need to pay more attention to what was written. With respect to GPL I never talked about end users. Just those who license their code under GPL. GPL does allow a company to release the code under a different lic

Re: Unique constraints on multiple fields with one nullable

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 15:54, Daniel John Debrunner wrote: > > Sigh. > > Ok, so you want to play with cats? > > What is NULL? > > > > That was a rhetorical question. > > > > Here's a more practical approach and why its a bug. > > > > By the definition of a UNIQUE TABLE CONSTRAINT, I should ge

Re: Unique constraints on multiple fields with one nullable

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 13:44, Daniel John Debrunner wrote: > > But Dan's reply is an interesting one. > > > > What Sybase did was create a Schrodinger's Cat. > > (See http://whatis.techtarget.com/definition/0,,sid9_gci341236,00.html > > for a definition... ;-) > > > > This is actually a bug i

Re: [Fwd: Re: Are you happy with Derby?]

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 12:22, Daniel John Debrunner wrote: > Michael J. Segel wrote: > > I guess you could say that this is a good thing if you're looking at > > using Derby vs MySQL. Which is why MySQL can be released under multiple > > licensing types. GPL affo

Re: Unique constraints on multiple fields with one nullable

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 11:01, Rick Hillegas wrote: > Thanks, Michael. You are correct, Derby, like DB2, finesses this issue > by not allowing nullable columns in unique constraints. I have closed > this bug. > > Cheers, > -Rick > NP, But Dan's reply is an interesting one. What Sybase did was

Re: Unique constraints on multiple fields with one nullable

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 07:40, Dan Meany wrote: > The posted code does not provide a workaround as it > does not allow duplicate rows with nulls: > > INSERT INTO foo VALUES (6, NULL); > INSERT INTO foo VALUES (6, NULL); <-- this fails > > Error: org.apache.derby.client.am.SqlException: The > s

Re: [Fwd: Re: Are you happy with Derby?]

2005-10-27 Thread Michael J. Segel
On Thursday 27 October 2005 02:08, Craig L Russell wrote: > I am not a lawyer, but I believe that Michael's interpretation is way > off base. > Uhm, I suggest that you talk to a lawyer... ;-) >[SNIP] Cut out the history since we all know I made a mistake thinking GPL. Oh yeah. SOX RULE! > > Yeah,

Re: FW: [Fwd: Re: Are you happy with Derby?]

2005-10-26 Thread Michael J. Segel
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 encouragin

Re: Unique constraints on multiple fields with one nullable

2005-10-26 Thread Michael J. Segel
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

Re: FW: [Fwd: Re: Are you happy with Derby?]

2005-10-26 Thread Michael J. Segel
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

Re: Select and null problem

2005-10-26 Thread Michael J. Segel
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

Re: Select and null problem

2005-10-26 Thread Michael J. Segel
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

Re: Regular Expressions

2005-10-26 Thread Michael J. Segel
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

Re: Derby Development and IDEs?

2005-10-19 Thread Michael J. Segel
On Wednesday 19 October 2005 22:44, David W. Van Couvering wrote: > I used to work with Kava and I really liked it. Too bad they missed the > open source wave and instead got sucked into some big company -- I can't > remember who any more. It's nice that the two main IDEs for Java are > both fre

Derby Development and IDEs?

2005-10-19 Thread Michael J. Segel
Sorry if this is slightly off topic, but since the individuals on this list are doing actual development with Derby, thought I might be able to get a decent survey on what combinations seem to work best I've been "playing" around with the following java IDEs: NetBeans, Eclipse, and Webspher

Re: How to update cardinality statistics

2005-10-19 Thread Michael J. Segel
On Wednesday 19 October 2005 04:04, Øystein Grøvlen wrote: > > "MM" == Mike Matrigali <[EMAIL PROTECTED]> writes: > > MM> I 2nd Satheesh's query, it is useful to know why you care. Derby > MM> unlike most other database's automatically maintains histogram > MM> type information abo

Re: How to update cardinality statistics

2005-10-18 Thread Michael J. Segel
On Tuesday 18 October 2005 13:50, Mike Matrigali wrote: > I 2nd Satheesh's query, it is useful to know why you care. Derby > unlike most other database's automatically maintains histogram > type information about the tables (this does require indexes to > exist). This information is gathered dire

Re: DevX article comparing open-source databases

2005-10-17 Thread Michael J. Segel
On Monday 17 October 2005 09:56, Dan Scott wrote: > Hmm, anybody want to step up to the task of sending in corrections for > this "Open Source Database Feature Comparison Matrix": > http://www.devx.com/dbzone/Article/29480?trk=DXRSS_LATEST > > The authors of the matrix (creators of DaffodilDB) comp

Re: transient priviledgeException

2005-10-11 Thread Michael J. Segel
On Tuesday 11 October 2005 02:06, Xavier Vigouroux wrote: > Let's summarize > > 1/ I start the embedded server and wait ping is ok > 2/ I execute "ij" to boot the DB and create the schema (ij.database has > a create=true) > and I give an SQL file to execute. > > at the first line of the executi

Re: transient priviledgeException

2005-10-11 Thread Michael J. Segel
On Tuesday 11 October 2005 01:56, Xavier Vigouroux wrote: > Le 10 oct. 05, à 19:05, Kathey Marsden a écrit : > > Xavier Vigouroux wrote: > >> Hi, > >> > >> I have a transient priviledgeException when connection to the DB with > >> ij. > >> > >> here is the scenario: > >> > >> 1/ I start an embedde

Re: transient priviledgeException

2005-10-10 Thread Michael J. Segel
On Monday 10 October 2005 08:50, Øystein Grøvlen wrote: > > "XV" == Xavier Vigouroux <[EMAIL PROTECTED]> writes: > > XV> If I understand you, you propose to improve my call to ping > with a XV> loop on the creation (ie. url with create=true) of a *FAKE* > schema XV> until it succeed

Re: transient priviledgeException

2005-10-06 Thread Michael J. Segel
On Thursday 06 October 2005 04:41, Xavier Vigouroux wrote: [SNIP] > > > > You're doing this in a shell script? > > yes. > > > So when you start derby your command forks a seperate process, hence > > IJ gets > > started prior to the completion of the creation of the base database. > > no, IJ is crea

Re: transient priviledgeException

2005-10-05 Thread Michael J. Segel
On Wednesday 05 October 2005 10:44, Xavier Vigouroux wrote: > Le 4 oct. 05, à 23:27, Øystein Grøvlen a écrit : > >> "XV" == Xavier Vigouroux <[EMAIL PROTECTED]> > >> writes: > > > > XV> Hi, > > XV> I have a transient priviledgeException when connection to the > > DB with > > XV

Re: transient priviledgeException

2005-10-04 Thread Michael J. Segel
On Tuesday 04 October 2005 16:27, Øystein Grøvlen wrote: > > "XV" == Xavier Vigouroux <[EMAIL PROTECTED]> writes: > > XV> Hi, > XV> I have a transient priviledgeException when connection to the DB > with XV> ij. > > > XV> here is the scenario: > > XV> 1/ I start an embeddedSe

Re: derby to mysql?

2005-09-30 Thread Michael J. Segel
On Friday 30 September 2005 02:09, Liam wrote: > Hi List, > > This question may have come up before, but I've ben unable to find it on > the list or the web. > > I have a large derby database which has been used for a java application > and I now have a need to use it on the web. With the little co

Re: Distributed databases

2005-09-22 Thread Michael J. Segel
On Thursday 22 September 2005 04:07, Øystein Grøvlen wrote: > > "JAC" == James A Craig/O/VCU <[EMAIL PROTECTED]> writes: > > JAC> Hi, I'm fairly new to Derby but I was curious if its possible > JAC> to use it in a distributed setup. I currently have a small > JAC> cluster and want t

Re: Class loading deadlock

2005-09-15 Thread Michael J. Segel
On Thursday 15 September 2005 09:52, Andreas Fredriksson wrote: [SNIP] > The point I was trying to make is that if there are no locks involved at > all, and only a single write of a field (as appears to be the case > here), a reader might theoretically never see the written value, ever, > as the vi

Re: Are you happy with Derby?

2005-09-09 Thread Michael J. Segel
On Friday 09 September 2005 12:49, Raji Sridar wrote: First take what I say with a grain of Salt You're asking a Derby list so you're going to get a positive and biased response. The short answer is yes. > Hello Derby Users, > > I recently subscribed to this group. > We are evaluating a ope

Re: Does Derby support ALTER TABLE DROP COLUMN?

2005-09-09 Thread Michael J. Segel
On Friday 09 September 2005 09:22, Rick Hillegas wrote: > Derby does have a RENAME TABLE command. > > Cheers, > -Rick > Perfect. If you were to enhance the Alter Table to allow for a DROP COLUMN foo, then you'd rename the existing table to a temp name, rebuild the table with all of the columns e

Re: Does Derby support ALTER TABLE DROP COLUMN?

2005-09-08 Thread Michael J. Segel
On Thursday 08 September 2005 20:09, [EMAIL PROTECTED] wrote: > Hi Susan, > > Is there any other way we can drop columns > which are not objects you mentioned ? > or impossible ? > > thanks, > > Wolfgang You could always do a simple work around. I don't know if you can rename the table, you can al

Re: Running Derby as a Service

2005-09-06 Thread Michael J. Segel
On Tuesday 06 September 2005 09:17, Michael Oliver wrote: > Michael Oliver wrote: > >I did not find instructions in the guides about running Derby as a > > service. I can run the StartNetworkServer.bat file and I can put a > > shortcut to that batch file in the Startup directory...but I would pref

Re: BLOB : java.lang.OutOfMemoryError

2005-08-31 Thread Michael J. Segel
On Wednesday 31 August 2005 13:32, Grégoire Dubois wrote: > Perhaps it could help : the DBMS Mckoi ( http://mckoi.com/database/ ) > has got a JDBC driver that supports blob streaming over network. Code is > open. > > I tried with IBM DB2, and same as Derby, streaming isn't supported with > their JD

Re: BLOB : java.lang.OutOfMemoryError

2005-08-31 Thread Michael J. Segel
On Wednesday 31 August 2005 10:49, Satheesh Bandaram wrote: > Thanks for the offer.. It would really be great to have more developpers > working on Derby. Join the derby-dev alias to participate in the > development. > > Derby embedded driver already has the capability to stream blob/clob, > with

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-26 Thread Michael J. Segel
On Thursday 25 August 2005 16:00, Dan Scott wrote: > > Sorry, that was a slightly bogus example; the addition of the primary > key constraint failed because the column wasn't defined as null, not > because the column already contained null values. A better example is: > > [EMAIL PROTECTED] ~ $ db2

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-25 Thread Michael J. Segel
On Thursday 25 August 2005 09:25, Daniel John Debrunner wrote: > Michael J. Segel wrote: > > On Wednesday 24 August 2005 21:50, Jean T. Anderson wrote: > > *WARNING* > > This post may require the readers donning flame retardant clothing. ;-) > > It seems to me that Susan

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-25 Thread Michael J. Segel
On Wednesday 24 August 2005 21:50, Jean T. Anderson wrote: *WARNING* This post may require the readers donning flame retardant clothing. ;-) > Michael J. Segel wrote: > > On Wednesday 24 August 2005 18:33, Susan Cline wrote: > >>I just logged DERBY-539 as a documentation enhanc

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-24 Thread Michael J. Segel
; understand when first using the product. > > Susan > > "Michael J. Segel" <[EMAIL PROTECTED]> wrote: > On Tuesday 23 August 2005 13:20, Susan Cline wrote: > Sigh. How is this behavior any different from any other database? I think my frustration is that Derby/

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-23 Thread Michael J. Segel
have a unique index called SQL050822044536100 > > 3) Then I try to create another unique index called idx2 with this SQL: > > > CREATE UNIQUE INDEX "APP"."idx2" ON "APP"."TABLE2" ("COL1" ASC); > > and it fails. > > > S

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-23 Thread Michael J. Segel
traint. When you create a unique constraint on a table, why would you check to see if an index already exists? Hence her issue. Does this make sense? -G > Michael J. Segel wrote: > > On Monday 22 August 2005 15:33, Susan Cline wrote: > >>In the 'Create Index' sta

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-22 Thread Michael J. Segel
On Monday 22 August 2005 15:33, Susan Cline wrote: > In the 'Create Index' statement documentation of the 10.1 Reference Guide > this statement is made about creating unique indexes: > > Indexes and constraints > > Unique, primary key, and foreign key constraints generate indexes that > enforce or

Re: Ability to create a unique index on the same column, doc bug or "bug" bug?

2005-08-22 Thread Michael J. Segel
On Monday 22 August 2005 15:33, Susan Cline wrote: > In the 'Create Index' statement documentation of the 10.1 Reference Guide > this statement is made about creating unique indexes: > > Indexes and constraints > > Unique, primary key, and foreign key constraints generate indexes that > enforce or

Re: Quick question... on use with "Ram Drives" or FOBs...

2005-08-17 Thread Michael J. Segel
On Wednesday 17 August 2005 10:57, David Van Couvering wrote: > BTW, what kind of application do you have that doesn't require the data > to be persistent over a memory failure? > Thats a good question, there are several scenarios that this could be applied. (I'll give you an example shortly...) T

Quick question... on use with "Ram Drives" or FOBs...

2005-08-16 Thread Michael J. Segel
Hi, Quick question... Has anyone tried using Derby/Cloudscape with the data being written to one of those 512MB FOBs instead of a hard drive? Got in to a discussion over a beer last night regarding "in memory" databases vs solid state drives vs those FOBs that now have over a GB of storage. T

Re: platform support proposal

2005-08-03 Thread Michael J. Segel
On Wednesday 03 August 2005 13:54, Daniel John Debrunner wrote: > Michael J. Segel wrote: > > On Tuesday 02 August 2005 23:39, Daniel John Debrunner wrote: > >>Rick Hillegas wrote: > >>>Is this acceptable? If not, how would you like to see Derby handle the >

Re: platform support proposal

2005-08-03 Thread Michael J. Segel
On Tuesday 02 August 2005 23:39, Daniel John Debrunner wrote: > Rick Hillegas wrote: > > Hi Derby users, > > > > Sun will stop supporting jdk1.3 at the end of March, 2006 (see > > http://java.sun.com/j2se/1.3/index.jsp) and is encouraging customers to > > migrate their applications to supported pla