I found all my answers in the Derby 10.0 Developer's Guild.
At 09:57 AM 5/31/2005, you wrote:
I am using Class.forName("org.apache.derby.jdbc.EmbeddedDriver") to load
one embedded derby in my application. It works successfully. I want to be
able to control the path for the database instances,
Is there timezone support in Derby? timezone_hour and timezone_minute are
listed as SQL reserved words, but I could not find any other information
about them. I need to do an insert of timestamp in GMT. I use "CURRENT
TIMESTAMP - CURRENT TIMEZONE" in DB2 and "ALTER SESSION SET TIME_ZONE =
'-0:0'; a
Edson Carlos Ericksson Richter wrote:
So, for each page I execute 50 queries (open connection -> query by pk
-> Navigate resultSet -> close connection).
If you aren't doing so already, you can optimize Tomcat by loading the
Derby embedded driver at Tomcat startup and shutting Derby down when
Edson Carlos Ericksson Richter wrote:
I've run with derby.language.logQueryPlan=true and result is that I
have table scan for only one table, that has actually one record.
I am curious as to why a table scan is being picked. Does this table
have indexes that can be used for the query in que
Sunitha Kambhampati escreveu:
...I was just trying to find out if your app was using a lot of cpu or
if it was just waiting for disk i/o to happen. I guess your app sounds
like it is cpu bound.
Sunitha.
Oh, I'm getting 100% Cpu every time I open JSP page that make queries.
One interesting
I've run with derby.language.logQueryPlan=true and result is that I have
table scan for only one table, that has actually one record.
The most costing queries are sub-selects (cost 13525) inside a almost
large query, but everything is being run either using indexes (cost
between 13 and 25) or ha
Edson Carlos Ericksson Richter wrote:
Responses inline:
Sunitha Kambhampati escreveu:
Edson Carlos Ericksson Richter wrote:
Hi!
I'm trying to embed Derby into Tomcat web apps (using Embedded
driver). But I found it's very, very slow.
My tables are not so big (majority have 10 or 20 record
Responses inline:
Sunitha Kambhampati escreveu:
Edson Carlos Ericksson Richter wrote:
Hi!
I'm trying to embed Derby into Tomcat web apps (using Embedded
driver). But I found it's very, very slow.
My tables are not so big (majority have 10 or 20 records), and 2 have
many records (27000 in o
Edson Carlos Ericksson Richter wrote:
Hi!
I'm trying to embed Derby into Tomcat web apps (using Embedded
driver). But I found it's very, very slow.
My tables are not so big (majority have 10 or 20 records), and 2 have
many records (27000 in one, 436000 in other).
I have same database running
Hi!
I'm trying to embed Derby into Tomcat web apps (using Embedded driver).
But I found it's very, very slow.
My tables are not so big (majority have 10 or 20 records), and 2 have
many records (27000 in one, 436000 in other).
I have same database running at full speed using MaxDB (SapAG/MySQL
Thanks.
I made a fgrep -iR "server side" * in docs and found nothing about it.
a fgrep -iR "cursor" * found several docs, but none specific about
server side cursors.
Even a fgrep -iR "cursor" | egrep -i "server" reveal no doc about server
side cursor.
May be the terminoly I'm looking for i
While I can't help you with C-JDBC, I can suggest how to workaround
connecting to Cloudscape 10 database using Derby 10.1 beta. Check this
posting:
http://mail-archives.apache.org/mod_mbox/db-derby-dev/200504.mbox/[EMAIL PROTECTED]
Do keep a backup of your database before you try this. Derby
Derby certainly can. Data for cursors in Derby is fetched on demand.
Check Derby documentation for more info.
Satheesh
Edson Carlos Ericksson Richter wrote:
> Is derby able to delivery very large resultsets (really bigger than
> phisical memory of the db server) throught server side cursors?
>
>
Stephan Bardubitzki wrote:
> Hi,
>
> I'm using Cloudscape 10 for a while and switched now to derby. The jdbc
> driver for both a currently not supporting update able ResultSets.
> Version 10_1 beta made some progress in this case, but inserting rows is
> still not supported.
>
> I'm wondering wh
You can use your function in any expressions. The easiest way to invoke
a function is by using VALUES clause.
VALUES APPBUT_USER.TRIGGER_RESIZE(..);
You can also use the function in SELECT list, like SELECT
APPBUT_USER.TRIGGER_RESIZE(..) WHERE ...
Both these can be used in trigger body.
While running SYSCS_COMPRESS_TABLE on a particular table, no operations
can be done on that particular table or it's indexes. Operations on
other tables and indexes are not affected, so work can be done
concurrently by other threads on other tables.
Note that cloudscape automatically reuses space
I am using Class.forName("org.apache.derby.jdbc.EmbeddedDriver") to load
one embedded derby in my application. It works successfully. I want to be
able to control the path for the database instances, though. It seems to
always default to the present working directory. Each of my databases are
c
You may need to use it in a values clause in the
trigger body:
VALUES(APPBUT_USER.TRIGGER_RESIZE(schema,table))
Regards,
Ali
--- Peter Nabbefeld <[EMAIL PROTECTED]> wrote:
> Jean T. Anderson schrieb:
> > A trigger can't call a procedure, but it can call
> a user-defined sql
> > function.
> >
>
We are usimg the embedded variant of derby to handle various persistence
requirements. This means that we do a lot of insert and delete operations,
quickly growing the size of the on-disk files. I have been looking into using
the SYSCS_COMPRESS_TABLE procedure in order to compress the database,
19 matches
Mail list logo