Dear all,
I am using derby version 10.2.2.0 .
One of my clients ( the one with the largest database, around 70 MB )
has the following problem :
- tries to add something into the application, the application does the
job in about 5-10 minutes. It is a very simple task and should take less
Valentin Cozma wrote:
Dear all,
I am using derby version 10.2.2.0 .
One of my clients ( the one with the largest database, around 70 MB )
has the following problem :
- tries to add something into the application, the application does the
job in about 5-10 minutes. It is a very simple task
Jean T. Anderson wrote:
ResultSet rs = s.executeQuery(
SELECT num, addr FROM derbyDB --derby-properties index=IDX1 \r
order by num);
Is there any feedback on using the \r ? In the back of my mind I'm
thinking that won't be portable between Windows and Unix.
\n is the unicode newline
Daniel John Debrunner wrote:
Jean T. Anderson wrote:
ResultSet rs = s.executeQuery(
SELECT num, addr FROM derbyDB --derby-properties index=IDX1 \r
order by num);
Is there any feedback on using the \r ? In the back of my mind I'm
thinking that won't be portable between Windows and Unix.
Hi all,
I'm wondering if anyone knows if it's possible to configure Derby so that
searches on CHAR/VARCHAR fields are case insensitive by default?
I'm guessing that if the answer is no, the solution is to just do a LOWER()
or similar on the field and compare it that way. I'm guessing if you
Hi,
I've been looking through the archives, and JIRA, but I can't seem to
find an answer. Basically, will Derby network server be enabled to
run as a daemon? I understand the next version of JAMES has been
modified to use commons-daemon, and wondered if there were plans for
Derby to
I've been looking through the archives, and JIRA, but I can't seem to
find an answer. Basically, will Derby network server be enabled to
run as a daemon? I understand the next version of JAMES has been
modified to use commons-daemon, and wondered if there were plans for
Derby to follow.
After I set DERBY_HOME and add Derby to my PATH, do I need to reboot
my Windows machine? Because when I run sysinfo from a command line
prompt, it isn't recognized...
--
Laura Stewart
Hi Jon,
Currently, you can't configure Derby to do case insensitive searches on
CHAR/VARCHAR. Using LOWER() function is a possible solution but as you
suspected, this will have a performance hit because Derby does not support
functional indexes. So, eventhough you might have an index on the