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 project.
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
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]
Se
> -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]
> >> Sen
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]
Sent:
> -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 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
> -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
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 lar
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
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.
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 constant
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
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
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
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
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
Øystein
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 MY
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 work
Given the variant nature of user functions it seems perfectly justified
to not use nor allow them in the GROUP BY clause. However, I needed this
because first of all aliases cannot be referenced in the GROUP BY clause.
For instance, let's consider this query:
SELECT MY_USER_FUNCTION(t1.field1)
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 ti
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 prob
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 statu
23 matches
Mail list logo