Dan,
I did not know of the JDBC escape functions. These work indeed with
Derby, however the MySQL JDBC driver does not seem to support them (we
need to run our queries on both Derby and MySQL).
I know that this is not the best place to ask, but does anyone happen to
know more about the
Donald,
Thanks for the code snippet. This is also what I tried to do. However, a
modification is required so that the timezone is explicitly set:
Calendar cal = Calendar.getInstance(TimeZone.getTimeZone(UTC));
Otherwhise the miliseconds will be those from your own timezone (which
most
Dan,
My timestamp computations were all local, but as mentioned in my
previous post I managed to solve the issue.
Regards,
Robert
Daniel John Debrunner wrote:
Robert Enyedi wrote:
This is exactly what I've been trying to do. The difficulty which I'm
unable to overcome yet is that the
Robert Enyedi wrote:
If I need to group the values returned by the MY_USER_FUNCTION, I simply
cannot do so because the following query is invalid in Derby:
SELECT MY_USER_FUNCTION(t1.field1) AS MY_VALUE
FROM T1
GROUP BY MY_VALUE
I have not tried this, but maybe something like this will
Thanks for the tip. I tried this, but it has the same problem with alias
referencing.
Regards,
Robert
Øystein Grøvlen wrote:
Robert Enyedi wrote:
If I need to group the values returned by the MY_USER_FUNCTION, I
simply cannot do so because the following query is invalid in Derby:
SELECT
Have you tried this?
SELECT my_value
FROM
(SELECT MY_USER_FUNCTION(t1.field1) AS my_value
FROM T1) AS UserFunction
GROUP BY my_value
Regards,
- Fernanda
Robert Enyedi wrote:
Thanks for the tip. I tried this, but it has the same problem with
alias referencing.
Regards,
Robert
Robert Enyedi wrote:
Thanks for the tip. I tried this, but it has the same problem with alias
referencing.
Sorry, I should have tried this first. Fernanda has given you the right
solution.
--
Øystein
Wow, this really works. Thanks a lot, Fernanda!
I just wonder why the alias propagation works well in this scenario and
with the obvious one it does not.
Regards,
Robert
Fernanda Pizzorno wrote:
Have you tried this?
SELECT my_value
FROM
(SELECT MY_USER_FUNCTION(t1.field1) AS my_value
No problem. Thanks anyway!
Regards,
Robert
Øystein Grøvlen wrote:
Robert Enyedi wrote:
Thanks for the tip. I tried this, but it has the same problem with
alias referencing.
Sorry, I should have tried this first. Fernanda has given you the
right solution.
--
Øystein
I need insert large text (over 100 KB) into column type CLOB (created as
max. available size - cca 2GB) using SQL command, but derby (latest
release) inserts only cca 32 KB. If text is larger, derby throws SQL
exception with description 'A string constant starting with ''inserted
text ... ' is
Radek Terber wrote on 18.09.2006 14:09:
I need insert large text (over 100 KB) into column type CLOB (created as
max. available size - cca 2GB) using SQL command, but derby (latest
release) inserts only cca 32 KB. If text is larger, derby throws SQL
exception with description 'A string
I use JuicyVPS. It's $10/month for a root account so you'll have to
set everything up. I've been using them for about a year with no
complaints. I've tried a few others and they are the best so far. I
run several Tapestry/Derby projects there.
MySQL does support JDBC escape functions in their JDBC driver.
Robert Enyedi wrote:
Dan,
I did not know of the JDBC escape functions. These work indeed with
Derby, however the MySQL JDBC driver does not seem to support them (we
need to run our queries on both Derby and MySQL).
I know that
Thanks for response, but i have NO acces to database over JDBC, but only
via text stream, thus i MUST use SQL commands (e.g. INSERT INTO
(...) VALUES (...) ).
I cannot call metgods of JDBC driver directly.
Thomas Kellerer wrote:
Radek Terber wrote on 18.09.2006 14:09:
I need insert
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 10:25 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Thanks for response, but i have NO acces to database over JDBC, but only
via text stream, thus i MUST use SQL
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 10:25 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Thanks for response, but i have NO acces to database over JDBC, but only
via text stream, thus i
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 10:56 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday,
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 10:56 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
Sent: Monday, September 18, 2006 11:21 AM
To: Derby Discussion
Subject: Re: Insert large using SQL
Michael Segel wrote:
-Original Message-
From: Radek Terber [mailto:[EMAIL PROTECTED]
ASF infra volunteers know about the problem. If you want to monitor
status, ajax is the machine to watch:
http://monitoring.apache.org/status/
-jean
Hi,
I would like to use Derby to store some web application meta-info, and
I think I'd like to have it embedded (only my web app's POJOs will
access it). It's gonna store simple text like menu urls and global
user preferences, which I was previously storing in XML files deployed
with my
21 matches
Mail list logo