Michael J. Segel wrote (2005-08-22 22:16:31):
Consider this... You create a table foo, with two columns, bar and retz.
bar is an integer, retz is a character string. You populate the table so it
looks like this:
Foo:
BAR RETZ
1 abc
2 def
3 NULL
4 jam
...
Now you
Hi,
How can I compute the duration of two timestamps?
Is there any built-in function that helps?
Are any alternative options?
Thank you in advance, Kostas
Kostas Karadamoglou wrote:
Hi,
How can I compute the duration of two timestamps?
Is there any built-in function that helps?
Are any alternative options?
This question was asked on this list not so long ago. You can find the
answer in the mailing list archives:
Hi Oyvind,
The link is broken can you send me the valid one.
Prior of my first post I searched my gmane mailing list using the
duration keyword but I didn't find anything
[EMAIL PROTECTED] wrote:
Kostas Karadamoglou wrote:
Hi,
How can I compute the duration of two timestamps?
Is there
PB == Piet Blok [EMAIL PROTECTED] writes:
PB Hi,
PB I noticed some different behaviour between Derby EmbeddedDriver and
ClientDriver. This was a disappointment, because I wanted to develop a Derby
application that may switch between the two drivers.
PB Differences I noticed are:
Thanks!
I found it
Thomas Lecavelier wrote:
The link is correct under my thunderbird 1.0.2
http://mail-archives.apache.org/mod_mbox/db-derby-user/200508.mbox/[EMAIL
PROTECTED]
If this don't work, search for the mail of Satheesh Bandaram:
Subject: Re: How to get a difference between two
Hi,
We use a derby server in an High Availability context. Thus, we need to
test if derby server is in a good shape or not. The result of this
repetitive question will imply a fail-over or not.
we thought about two solutions:
1/ create an agent to insert/select/delete an entry in a table
2/
OK David,
Jira issues Derby-530 (Properties ignored) and Derby-531 (resultset closed
after next() return false) have been filed.
Thanks for your help.
Piet Blok
- Original Message -
From: David Van Couvering [EMAIL PROTECTED]
To: Derby Discussion derby-user@db.apache.org
Sent:
Xavier Vigouroux wrote:
Hi,
We use a derby server in an High Availability context. Thus, we need to
test if derby server is in a good shape or not. The result of this
repetitive question will imply a fail-over or not.
we thought about two solutions:
1/ create an agent to
Hi Øystein
I filed a Jira issue (Derby-530) on the Properties issue. I included a code
fragment illustrating a workaround for the problem. I see no reason why the
ClientDriver cannot do the same internally.
However, there are some other issues: actually, I do not exactly understand
yet the
you might also check out C-JDBC from ObjectWeb. Emmanuel Cecchet did a
writeup for Derby that's available for download from here:
http://db.apache.org/derby/integrate/
-jean
Xavier Vigouroux wrote:
Hi,
We use a derby server in an High Availability context. Thus, we need to
test if derby
Thanks for the research... I think Derby has this optimization that
only catches the case of duplicate indexes one way. (Where
primary/unique constraint is created first) The second duplicate index
that may get created the other way doesn't cause any issues, other than
being redundent and
Is there any database system out there that ignores current data
when adding a constraint to the table? It seems almost all applications
which require a constraint to be added, will fail if some of the
data does not meet the constraint.
For Derby's implementation of uniqueness constaint this
On Tuesday 23 August 2005 13:20, Susan Cline wrote:
All,
Sorry to top post, but this is not a *bug* or a product defect.
I would also recommend not changing the language in the documentation.
Again, a simple general rule of thumb. When applying a constraint, it will
only effect the actions
Hi, I'm wondering if someone has run into this and can
help me understand what's happening.
I'm porting some JDBC code from Another Database to Derby;
I'm using Derby 10.1.1.0 on RedHat Linux.
My program contains a snippet of code something like:
PreparedStatement stmt =
Hello,
Not sure I can assist with more than my 2 cents. Since a blank
string is different than the absence of value (null), I would argue that
Derby is doing the correct thing, while the other DBMS is guessing at
the user's intentions. The root cause of this specific message is that
Hi Bryan,
Nice to see you on the list. It may be that the database which would
remain nameless is Oracle. Oracle treats 0-length strings as null. Note
that Oracle documentation confesses that this is a bad idea and darkly
hints that future versions of Oracle may conform to the standard
17 matches
Mail list logo