Hi,
I've been trying to get this working myself. I saw the steps you listed in
your footnote as an example of a basic working test.
[2]
1. Master: connect
'jdbc:derby:enctest2;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=test;create=true';
2. Master: CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()
Rick,
Ok, lets see if I got the math straight...
X, 1.04%X, (1.04*1.04)%X, (1.04*1.04*1.05)%X
So the last version is roughly 13.568% larger than X.
I don't know how much growth is acceptable, and you're right. Moore's law
and systems' capacities have increased at a larger rate. But that doesn't
m
Here's the growth of the embedded engine, derby.jar, over the last few
feature releases:
10.4.1.3 2440097 +4%
10.3.1.4 2338649 +4%
10.2.1.6 2253277 +5%
10.1.3.1 2141382
This seems like modest growth to me and well behind the corresponding
growth in the size of storage devices over the same per
Hey!
Not to be a 'Debbie Downer' but I have some reservations.
Knut points out that there is a viable work around. (Wrap the query)
Currently Derby/JavaDB doesn't have any way of creating a scalable foot
print.
As more and more features/enhancements are added to Derby/JavaDB, you're
going to see
Hi Kim and Knut,
Some comments inline...
Knut Anders Hatlen wrote:
Kim Moore writes:
I am working on a query that uses a user defined function in a group
by clause.
select myfunction (datecolumn)
,count(*)
fromtable
group by myfunction (datecolumn)
Executing the query gives
Kim Moore writes:
> I am working on a query that uses a user defined function in a group
> by clause.
>
> select myfunction (datecolumn)
> ,count(*)
> fromtable
> group by myfunction (datecolumn)
>
> Executing the query gives the error "The SELECT list of a group query
> contains at
