Re: placement of derby.log

2013-06-10 Thread Jean-Yves Linet
Hi, I guess you are looking for : derby.stream.error.file Regards, 2013/6/10 Thomas thomas.k.h...@t-online.de Hi, is there any way to tell Derby where to store the derby.log file? (note: I am not referring to the database log file here, but to the file into which protocoll messages are

Re: Select multiple rows as one

2013-02-05 Thread Jean-Yves Linet
select newname from filedata union select altname from metadata select 'NEWFILE1' union select altname from metadata where newname='NEWFILE1' 2013/2/5 Danny Gallagher dannygallagh...@gmail.com Just can't seem to get this one right. Any help appreciated. I need a Query to return one row,

Re: Ideas for optimisation needed

2012-12-21 Thread Jean-Yves Linet
Do you have the same results if you exclude details field from your columns list ? 2012/12/21 John English john.fore...@gmail.com On 20/12/2012 14:12, Jean-Yves Linet wrote: Hi, May you could give more details about the structure of your table. The table looks like this: CREATE TABLE

Re: Ideas for optimisation needed

2012-12-20 Thread Jean-Yves Linet
Hi, May you could give more details about the structure of your table. Anyway the response delay you have seams to be very slow compare with what I have with Derby. I always read my resultset as forward only. Try to make a first request with select count(*) to have the number of rows. and then a

Re: Unique constraint, or something like it

2012-03-11 Thread Jean-Yves Linet
Can't you use 0 rather than 1 for null section. May be your code changes are not so important, as when an integer value is used in this context it is rare to use 0 as a significant value : 1- for insert just change default null by default 0 2- for select ResultSet.getInt return 0 for null value as

Re: Understanding an UPDATE

2012-03-05 Thread Jean-Yves Linet
You don't have where clause in your update, so all rows of t1 are updated. And as you have no row in t2 with id=1, the select return a null value. Le 6 mars 2012 02:19, TXVanguard brett.den...@lmco.com a écrit : When I run the following SQL statements in JavaDB:

Re: Sequence loses numbers: bug or feature?

2012-02-26 Thread Jean-Yves Linet
I guess answers to your questions are here : https://issues.apache.org/jira/browse/DERBY-5151 Le 26 février 2012 09:45, Karl Weber karl.webe...@googlemail.com a écrit : I have created a sequence using CREATE SEQUENCE GPS.SDSID AS INTEGER START WITH 1 INCREMENT BY 1

SQLChar.getCollationKey NPE in index-stat-thread

2011-12-11 Thread Jean-Yves Linet
(derby.storage.indexStats.auto). Can I set this property to false until the problem is solved without any side effect ? Thanks -- Jean-Yves LINET

Re: Float versus Double

2011-10-25 Thread Jean-Yves Linet
-tp32720294p32720294.html Sent from the Apache Derby Users mailing list archive at Nabble.com. -- Jean-Yves LINET

Re: Derby shutdown

2009-09-15 Thread Jean-Yves Linet
thank you for this precision. I have made more tests and have some more remarks. I replace the BUILTIN provider by a UserAuthenticator implementation class. I found that the example included in the documentation is not working if a system shutdown is done. In this case the authenticateUser