( I can't do that, Dave., Z );
}
}
Hope this helps,
-Rick
On 4/26/12 10:09 PM, Trejkaz wrote:
On Mon, Apr 23, 2012 at 10:50 PM, Rick Hillegas
rick.hille...@oracle.com wrote:
UserAuthenticator.authenticateUser() can throw a SQLException which explains
that the user doesn't have access
On 4/24/12 6:49 PM, Tomcat Programmer wrote:
That is a very good question... there is no error message at all.
However, what I did see was a startup message, like when the database
initially starts. Except, I never restarted it! And the machine did
not reboot... are there ever conditions
On 4/20/12 4:41 PM, Trejkaz wrote:
On Sat, Apr 21, 2012 at 1:50 AM, Rick Hillegasrick.hille...@oracle.com wrote:
3) ...or something else?
Possibly something else.
Specifically, the only thing that doesn't really work with the way
we're doing it now is that if you provide valid credentials
Hi Trejkaz,
I do not see any responses to your email yet. I did not respond
immediately because I was not sure what help you wanted from the
community. Maybe other people were confused too.
It sounds as though you have written your own custom authenticator
backed by a database which
On 4/12/12 2:56 AM, Anna Krajewska wrote:
Hi
Is there an elegant way in which I can get sqlState of the exception
occured while running ij.runScript? I get an output which looks like
command line history, the sqlState is present there but I can only get
it by parsing the string (finding the
Hi Libor,
The reference manual needs to be corrected. Derby supports 9 nanosecond
digits. See the following script output:
ij connect 'jdbc:derby:memory:db;create=true';
ij create table t( a timestamp );
0 rows inserted/updated/deleted
ij insert into t( a ) values ( timestamp( '2012-04-05
There's an existing doc issue for this problem:
https://issues.apache.org/jira/browse/DERBY-5596
Regards,
-Rick
On 4/5/12 7:28 AM, Rick Hillegas wrote:
Hi Libor,
The reference manual needs to be corrected. Derby supports 9
nanosecond digits. See the following script output:
ij connect
On 2/12/12 9:10 AM, anthonyri wrote:
I have a table with and index and yet the optimiser chooses a full table scan
instead of using it - why does this happen? Can I force it to use the index?
create table test(id smallint, seq smallint, type smallint);
select id, seq, type from test where type
Hi Carlos,
Some responses inline...
On 2/8/12 3:00 PM, Carlos de Luna Saenz wrote:
I really don't know if this is a good couple questions or not...
We are developing an embedded DB app that has a 1.74GB of files for the
database
I wonder if there is something like a shrink or compact command
On 2/6/12 2:29 PM, TXVanguard wrote:
Rick Hillegas-3 wrote:
Hope this helps,
-Rick
Rick, thanks for all your help. The SELECT DISTINCT syntax seems to work.
Here's one more wrinkle I discovered:
I have several lines that look like this:
UPDATE T1 INNER JOIN T2 ON (T1.A= T2.A) SET T2.B
Hi John,
This is one of many areas where Derby's dependency tracking could be
improved. I think that Derby is over-aggressive in dropping views when
you drop a column in the underlying table. As I read the SQL Standard
(part 2, section 11.19 drop column definition), a RESTRICTed column
drop
On 2/7/12 8:09 AM, TXVanguard wrote:
Rick,
I've discovered a few more wrinkles in some of the UPDATE/INNER JOIN states
I have to port. Here's an example:
UPDATE T1 INNER JOIN (T2a INNER JOIN T2b ON T2a.B = T2b.B) ON T1.B = T2b.B
SET T2a.D = true WHERE (T2b.E=true AND NOT (T1.F=2 AND (T2b.G=2
Hi Ram,
Thanks for including the Derby log file. There are lots of errors in
this log. This error looks particularly suspicious:
java.io.IOException: No space left on device at
sun.nio.ch.FileDispatcher.pwrite0(Native Method) at
sun.nio.ch.FileDispatcher.pwrite(FileDispatcher.java:45)
Try
On 2/6/12 7:43 AM, TXVanguard wrote:
Bryan Pendleton-3 wrote:
Perhaps something like:
update t2 set b = (select b from t1 where t1.a = t2.a)
I tried your suggestion, but now I get the error message:
Scalar subquery is only allowed to return a single row.
Any other suggestions?
On 2/6/12 10:22 AM, TXVanguard wrote:
Rick Hillegas-3 wrote:
This means that more than 1 row is returned by the subquery. That, in
turn, suggests that the query, which succeeds for you on another
database, may not be behaving in a predictable way there. Since more
than one row qualifies
On 2/6/12 12:36 PM, TXVanguard wrote:
Rick Hillegas-3 wrote:
The Access update could change the target row twice. No one will notice
if both matching rows from T1 have the same value in column B. Or...not
many people will notice if the rows from the join always come back in
the same order so
On 2/6/12 12:48 PM, Rick Hillegas wrote:
On 2/6/12 12:36 PM, TXVanguard wrote:
Rick Hillegas-3 wrote:
The Access update could change the target row twice. No one will notice
if both matching rows from T1 have the same value in column B. Or...not
many people will notice if the rows from
Hi Simon,
Glad to hear that regenerating the statistics fixed your problem. More
inline...
On 2/1/12 4:07 AM, Simon Chatelain wrote:
...
But one small question remains, do you think that it is enough to run
SYSCS_UPDATE_STATIS
TICS only once, or should I plan to run this procedure at
Hi Simon,
I am not an expert in how the optimizer chooses query plans. Hopefully,
other people will be able to provide more insight.
From the second plan, it is clear that the optimizer understands that
the timestamp restriction will qualify only 97 rows. But the optimizer
is unable to use
On 1/27/12 6:47 AM, Mojo Nixon wrote:
I recently received a database from a user. They said they were viewing a
record in the application, and went back to open it a bit later and the
record was gone. In the database the record is indeed gone, but when I look
at the table .dat file in a binary
On 1/24/12 12:09 AM, squidy78 wrote:
hello, actually we use oracle and would like to use derby as the
embedded db for our junit testing.
now we have a problem with sequences and I haven't found a solution
yet, maybe we use it the wrong way?! I hope somebody can help...
we have the following
On 1/24/12 7:42 AM, squidy78 wrote:
Thanks for your reply, your solution is an option we could use, but we
would like to use a sql script only and not java code.
Do you have a sql-only-solution?
If your application is single-threaded (which would support
nextval/currval usage), then the insert
On 1/12/12 1:34 AM, Udhayakumar wrote:
Hi,
I want to download the source code of derby.jar version
10.0.201 but I'm not able to find the release for the same version
in apache derby site. Where can I find the source code for that and
also I wanted to know whether the
On 12/29/11 5:27 PM, 鲍少明 wrote:
I think this could be an improvement.
Can we extend the existing SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure
to support bulking-loading multiple same format csv files in one call?
I think it will not be difficult to use something like
SequenceInputStream to
will increase its chances of being implemented.
Hope this helps,
-Rick
Thanks again,
Julio
Are there any plans to
Rick Hillegas-3 wrote:
Hi Julio,
I haven't looked into the details of what the Derby optimizer does in
the case of multiple SET clauses, each driven by its own subselect
On 12/19/11 9:10 AM, newboid123 wrote:
I have a very simple (conceptually, at least) problem that I need help with.
I want to put jpg images in a server database, which can then be accessed
via a client Java program. I realize that the images need to be store as
blob data, but how does one do
On 12/16/11 1:42 PM, JulioSerje wrote:
Is there any way to implement an update using a JOIN? The reference manual
only allows for one table to be updated:
UPDATE table-Name [[AS] correlation-Name]
SET column-Name = Value
[ , column-Name = Value} ]*
[WHERE clause]
We have an
On 12/19/11 12:24 PM, JulioSerje wrote:
Rick Hillegas-3 wrote:
On 12/16/11 1:42 PM, JulioSerje wrote:
Is there any way to implement an update using a JOIN? The reference
manual
only allows for one table to be updated:
UPDATE table-Name [[AS] correlation-Name]
SET column-Name = Value
On 12/10/11 1:36 PM, Sandeep Dixit wrote:
Here is the scenario: I have everything working on my local machine. I
used online backup to create a backup - then tried shutdown and
restart and everything works fine on my local machine. I zipped it and
then copied it to my server - however when I try
On 12/8/11 7:16 AM, Bryan Pendleton wrote:
ResultSet rs = s.executeQuery(values upper('Straße'));
So it seems the value is returned correctly, but the meta-data is wrong
(STRASSE is 7 characters long, not 6). ij uses the meta-data to
determine how much space each column should have.
6
On 12/6/11 7:45 AM, Danny Gallagher wrote:
SELECT * FROM TABLE WHERE NAME = 'LKFSASP'
Hi Danny,
I can't reproduce this problem (see the script below, which runs
correctly for me). Are you using a special collation in this database?
connect 'jdbc:derby:memory:db;create=true';
create table
of characters.
Thanks,
Danny
-Original Message-
From: Rick Hillegas [mailto:rick.hille...@oracle.com]
Sent: Tuesday, December 06, 2011 11:11 AM
To: derby-user@db.apache.org
Subject: Re: dash in a varchar column - effect on select statement
On 12/6/11 7:45 AM, Danny Gallagher wrote
On 11/30/11 1:58 AM, Emanuel Chiavegato wrote:
Hi Rick,
Thanks for your reply.
Yes, the problem was related to have the table name in uppercase. Once i
fixed it another error came out and i was hoping you could help. The error
mesage is extremely long but starts like: Column
On 11/30/11 5:46 AM, mane_uk wrote:
And i have also tried using the IMPORT_DATA instead of IMPORT_TABLE but
then it gives the following error message:
Exception in thread main java.sql.SQLException: Import error on line 1 of
file C:\dev\workspace\test\TRADEMANAGERXLHEAD_TRADELEG.csv:
On 11/25/11 2:07 AM, Emanuel Chiavegato wrote:
Hi all,
I hav been given the task of exchanging our xls files with data used for
test for a better tool and I believe derby is the ideal db for this task.
I am using eclipse to handle this change, as the data needed for test is
handled
On 11/22/11 11:21 PM, gopi krishna wrote:
Hi
This is Krishna , i need to edit an existing stored procedure from
one of the client. So i need to get script of that stored
procudure.How can i get that.
Please can you help me here
Thanks
Krishna
Hi Krishna,
Derby stored procedures are just
On 11/12/11 2:36 AM, Karl Weber wrote:
Am Mittwoch, 9. November 2011, 11:51:43 schrieb Knut Anders Hatlen:
Karl Weberkarl.webe...@googlemail.com writes:
Hi,
Derby does support UDTs. One can use any java.io.Serializable java class
as a UDT.
On the other hand, derby does not support SQL ARRAY
On 11/12/11 2:36 AM, Karl Weber wrote:
Am Mittwoch, 9. November 2011, 11:51:43 schrieb Knut Anders Hatlen:
Karl Weberkarl.webe...@googlemail.com writes:
Hi,
Derby does support UDTs. One can use any java.io.Serializable java class
as a UDT.
On the other hand, derby does not support SQL ARRAY
On 11/13/11 2:14 PM, dag.wan...@oracle.com wrote:
Karl Weberkarl.webe...@googlemail.com writes:
Is there a way to use an R-Tree with derby db? (Or a GiST?)
In [1] R-Trees are mentioned on page 55. Is it possible to add one's own
implementation on top of derby, if it is not added to derby?
On 11/11/11 4:39 AM, Jonas Pettersson wrote:
DECLARE GLOBAL TEMPORARY TABLE SESSION.memtable (id int, name
varchar(10)) NOT LOGGED
Hi Jonas,
It's likely that you are running with autocommit turned on (this is the
default). Your temporary table was declared in a way which causes it to
throw
Hi Pavel,
I don't see a builtin function which does what you want. You might be
able to cobble together what you need using the LOCATE and SUBSTR
functions, but the statement would probably look ugly. Alternatively,
you can register your own user defined formatting function using the
CREATE
On 10/17/11 5:56 AM, Paul Nichols wrote:
The documentation is still (in 10.8) glossed with warnings against
production use of the BUILTIN authentication mechanism, can anyone tell me
what is wrong with it? The only reference to any problems I can find is
CVE-2009-4269 (DERBY-4483) which was
On 9/29/11 4:47 AM, gbattinelli wrote:
Dear all,
I'm newbie of derby but there is something not clear for me.
I use derby database through Netbeans.
I've an application in java that can use two dbs, mysql and derby, both
through hibernate.
For correct working of application some default data
On 9/24/11 6:09 PM, Michael Ma wrote:
Hello sir,
I have a question using derby in a web app,that is where is the
path of the database when I start derby using
org.apache.derby.drda.NetServlet .
Thanks.
--
Best Regards.
Michael
Hi Michael,
Directory names (if they are relative file
On 9/19/11 2:54 PM, Mike Matrigali wrote:
Rick Hillegas wrote:
Hi Mike,
Some comments inline...
On 9/19/11 10:38 AM, Mike Matrigali wrote:
I am not sure how it applies to all of these points, but I am
wondering if secure by default should be implemented on a per
database basis rather than
On 9/19/11 5:28 PM, Kathey Marsden wrote:
On 9/19/2011 1:20 PM, José Ventura wrote:
I'm not sure whether making the default value on will actually
improve security as a whole. If a developer hasn't given thought to
security, there are plenty of other pitfalls that may compromise an
On 9/20/11 8:41 AM, Mamta Satoor wrote:
Hi Rick,
Does this mean that a pre-existing database will always be run with
the knob off after hard-upgrade to 11.x release(or whatever the
release number which will have the security features)?
Hi Mamta,
I think that we will minimize upgrade problems
The Derby developers are considering introducing a single master
security property. Turning this property on will enable most Derby
security mechanisms:
1) Authentication - Will be on, requiring username/password credentials
at connection time. Derby will supply a default authentication
be best. It will make it easier to
reason about Derby's behavior and simplify our user guides.
Thanks,
-Rick
Rick Hillegas wrote:
The Derby developers are considering introducing a single master
security property. Turning this property on will enable most Derby
security mechanisms:
1
Hello,
ON UPDATE CASCADE is not supported for REFERENCES clauses. If you follow
these links in the Reference Guide...
CREATE TABLE - column-definition - Column-level-constraint -
REFERENCES clause
...you will find the following syntax description:
REFERENCES table-Name [ (
as
Rick says
it should. So, WTF am I doing wrong? In Unix, I would have
double-checked
rwx permissions (maybe Intellij Idea is running as root), but I'm not as
familiar with this stuff in Windows.
From: Rick Hillegas rick.hille...@oracle.com
To: Derby
On 8/9/11 7:50 AM, Bryan Pendleton wrote:
C:\WINDOWS\SYSTEM32\java.exe -splash:EMsplash.jpg -jar C:\Program
Files\ElectionManager\EMServer.jar
Not sure if this is the problem, but I believe that if you use '-jar' on
your command line, then CLASSPATH is ignored, and ALL the classes have to
come
On 8/7/11 9:54 AM, roy.mi...@comcast.net wrote:
I have been happily using Derby for two years within IntelliJ Idea,
but have now hit a wall trying to deploy the application I developed.
I have tried setting the path to derby.jar on the command line and/or
in the CLASSPATH environment
Hi Roy,
Thanks for including the code snippet. As Raymond points out, you are
not loading the driver explicitly. This should not be necessary if you
are using Java 6 or 7. However, driver autoloading does not happen in
Java 5 and earlier versions of Java. What version of Java are you using?
On 8/3/11 2:41 AM, Mukesh Modi wrote:
Please let us know the Apache *Derby *release which is completely OPEN
SOURCE in PRODUCTION environment.
We are planning to migrate from Oracle to Apache *Derby*. Woluld like
to know its oracle compatibilty so as to reduce the amount of rework.
Regards,
On 7/30/11 2:36 PM, Patrick wrote:
I have an application that creates tables in a derby database. Some of
the tables contain specific variables (i.e. predetermined column
names) and, therefore, are of a certain type. Some functions in the
application only work with some types of tables. Is
On 8/2/11 11:12 AM, Carlos de Luna Saenz wrote:
I used the following lines at my main() method, I hope this is the
right way to do it:
System.out.println(Iniciando variables del programa);
System.setProperty(derby.storage.tempDirectory,System.getProperty(java.io.tmpdir));
Thanks again
and the documentation says that the property
is static, it works fine but don't know if is the proper way to do
it...
Thanks
-Mensaje original-
De: Rick Hillegas [mailto:rick.hille...@oracle.com]
Enviado el: martes, 02 de agosto de 2011 01:33 p.m.
Para: Derby Discussion
Asunto: Re
Hi Ryan,
I don't know whether you have considered identity columns. Identity
columns may give you what you need. See the Derby Reference Guide topics
CREATE TABLE statement - column-definition -
generated-column-spec. Right now, identity columns provide less
concurrency than sequences do.
On 7/7/11 5:20 AM, Remya Thomas wrote:
Hi Team,
We are using derby-10.4.1.3 in our application. Recently, we faced an
issue in using this derby database with an exception
java.sql.SQLTransactionRollbackException: A lock could not be obtained
within the time requested
I would like to know
Hi Nicolas,
Might be a corrupt primary key. Can you try dropping and redeclaring the
primary key on the outage table? Do you have a script which reliably
recreates this problem? That would help us track down the original
corruption.
Thanks,
-Rick
On 7/5/11 7:56 AM, Nicolas Nobelis wrote:
On 6/28/11 4:45 AM, IkeAbalogu wrote:
I am trying to find websites with tutorial on derby stored procedures.i find
the reference manual article confusing.
Thanks
There is also some material in the Developer's Guide:
http://db.apache.org/derby/docs/10.8/devguide/devguide-single.html#cdevspecial
look at.
I responded to the stored procedure tutorial help thread. Hope that
helps...
-Rick
Thanks again.
Rick Hillegas-3 wrote:
Instead of declaring a trigger which fires an update statement, you
might want to consider declaring a trigger which fires a database
procedure--the procedure would
Hi Andy,
I believe that you see this behavior because the unique constraint does
not give rise to a unique index. The index forbids duplicates if all of
the key values are non-null. However, if any of the key values are null,
then duplicates are allowed. If you need an index which forbids
Thanks for raising this topic, David and Thomas. Feel free to vote for
this new enhancement request:
https://issues.apache.org/jira/browse/DERBY-5298 I have worked around
this problem by using the helper functions attached to
https://issues.apache.org/jira/browse/DERBY-5242
Thanks,
-Rick
On
Can you share your schema and the error message you are seeing? That
will help people advise you.
Thanks,
-Rick
On 6/27/11 5:20 AM, IkeAbalogu wrote:
CREATE TRIGGER NEWBALANCE
AFTER INSERT ON APP.PRODUCTQUANTMONITOR
REFERENCING NEW AS NEWROW
FOR EACH ROW
UPDATE NEWROW SET PREVIOUS_BALANCE =
productsupply(supplyid) ON DELETE RESTRICT ON UPDATE RESTRICT;
Rick Hillegas-3 wrote:
Can you share your schema and the error message you are seeing? That
will help people advise you.
Thanks,
-Rick
On 6/27/11 5:20 AM, IkeAbalogu wrote:
CREATE TRIGGER NEWBALANCE
AFTER INSERT
The 1.4 JVM has not been supported as a free platform for some time
(although I believe you can buy a support contract for 1.4 if you need
to). Does anyone plan to run Derby 10.9 on this platform? Does anyone
plan to run Derby 10.9 on the related small device CDC/FP 1.1 platform?
For the next
TABLE productquantmonitor ADD CONSTRAINT
fk1_productquantmonitor_to_productsupply FOREIGN KEY(fk1_supplyid)
REFERENCES productsupply(supplyid) ON DELETE RESTRICT ON UPDATE RESTRICT;
Thanks.
Rick Hillegas-3 wrote:
When I run these commands, I get
.
Rick Hillegas-3 wrote:
After running the database creation script, I see the reported 42X05
error when creating the problem trigger:
CREATE TRIGGER NEWBALANCE
AFTER INSERT ON APP.PRODUCTQUANTMONITOR
REFERENCING NEW AS NEWROW
FOR EACH ROW
UPDATE NEWROW SET PREVIOUS_BALANCE =
CASE
WHEN (SELECT COUNT
On 6/21/11 8:23 AM, Matt Pouttu-Clarke wrote:
...
iCrossing Privileged and Confidential Information
This email message is for the sole use of the intended recipient(s) and may
contain confidential and privileged information of iCrossing. Any unauthorized
review, use, disclosure or
Hi Manjesh,
I would expect that Oracle would outperform Derby, especially on heavy
workloads (terabytes of data and thousands of concurrent users).
Hope this helps,
-Rick
On 6/19/11 10:00 PM, manjesh wrote:
Hi I am j2ee developer ,i have worked with Oracle and MySQL, I liked
Derby and have
Hi Rob,
Because of the difference between hard and soft-upgrade, there are two
version numbers which might be interesting:
1) The version number of the Derby code in the Derby jar files.
2) The version number of the data stored in a particular database.
You can get the answer to (1) by
On 6/15/11 3:16 AM, Ivan Kelly wrote:
The Derby charter[1] states that there is ODBC support in derby. Is
this still the case or has it fallen out of use? Searching gives an
IBM article from 2004 and not much else. Does anyone use Derby with
ODBC in production?
Regards
Ivan
Hi Masood,
Some comments inline...
On 6/13/11 7:30 PM, Masood Mortazavi wrote:
On Mon, Jun 13, 2011 at 7:18 PM, Masood Mortazavi
masoodmortaz...@gmail.com mailto:masoodmortaz...@gmail.com wrote:
On Mon, Jun 13, 2011 at 6:39 PM, Masood Mortazavi
masoodmortaz...@gmail.com
Resending this message under another subject line. If no-one volunteers
to build and host these plugins, they will not be available after
release 10.8.2.
Regards,
-Rick
On 5/26/11 7:40 AM, Rick Hillegas wrote:
Dear Eclipse users,
For the past six years, Derby releases have included two
Hi Laran,
I can't say how the layers above Derby got into the situation of
requesting a character stream on an integer column. Derby does not
support that conversion. ResultSet.getCharacterStream() on an INTEGER
column is not supported, according to Appendix B (table B-6) of the JDBC
3.0
Dear Eclipse users,
For the past six years, Derby releases have included two Eclipse
plugins: a core plugin and a ui/doc plugin. The Derby developers have
come to the conclusion that these plugin artifacts fall outside the
scope of our charter, which explictly excludes IDE and GUI work:
On 5/22/11 1:43 AM, Hubert jun. Hölzl wrote:
Hi,
I've found a misstake in your documentation at
http://db.apache.org/derby/docs/10.2/ref/rrefsqlj57522.html
There you say
A LEFT OUTER JOIN B is equivalent to B RIGHT OUTER JOIN A, with the columns in
a different order
I think that the
There seem to a number of mis-statements on this page:
o The performance claim.
o The claim that Derby doesn't have an Explain plan feature.
o The claim that Derby doesn't support user-defined datatypes.
o The claim that Derby doesn't support sequences.
o The claim that Derby doesn't support
On 5/19/11 11:36 AM, Lukas Eder wrote:
Hello,
I was wondering about this for a while, as Derby seems to be the only
RDBMS I know that does not support the simple syntax for CASE
clauses:
CASE [expression]
WHEN [expression] THEN [expression]
WHEN [expression] THEN [expression]
...
See
On 5/14/11 6:39 AM, Lukas Eder wrote:
Hello,
I have found a lot of references on Google concerning this topic.
Mostly, this is leading to the same JIRA tickets and to this wiki
page:
http://wiki.apache.org/db-derby/OLAPOperations
From what I understand, Derby's long-term goal is to support
Hi Tim,
One comment below:
On 5/13/11 6:49 AM, Tim Dudgeon wrote:
Hi Rick,
Thanks for quick response.
Thoughts below.
Tim
On 13/05/2011 14:22, Rick Hillegas wrote:
Thanks for the comments on Restriction, Tim. Some responses inline..
On 5/13/11 3:22 AM, Tim Dudgeon wrote:
Hi, I
Thanks for the comments on Restriction, Tim. Some responses inline..
On 5/13/11 3:22 AM, Tim Dudgeon wrote:
Hi, I was looking at writing restricted table functions to retrieve
data from a foreign database, and think I have identified some
limitations of the org.apache.derby.vti.Restriction
I'm trying to write a restricted table function that retrieves data
from a different database and needing some clarification on how the
narrowing of the data is supposed to work. The docs mentions that
initScan() is called like this:
initScan( new String[] { ID, null, null, FIRSTNAME,
Hi Libor,
If you committed the transaction which created the tables, then the
tables should be visible to DatabaseMetaData.getTables() and getColumns().
Thanks,
-Rick
On 5/5/11 9:21 AM, Libor Jelinek wrote:
Hello all once more,
this time I would like to ask you how to flush newly created
On 5/4/11 10:38 AM, dag.wan...@oracle.com wrote:
Rick Hillegasrick.hille...@oracle.com writes:
I don't see an existing JIRA for this issue. Feel free to log one.
Rick, do you know if there is a standard way of doing this (beyond the
JDBC escape function)? I didn't find anything in the
On 5/3/11 4:52 AM, Lukas Eder wrote:
Derby supports the JDBC escape function TIMESTAMPADD, documented here:
http://db.apache.org/derby/docs/10.8/ref/rrefjdbc88908.html
Example:
ij values {fn timestampadd(SQL_TSI_DAY, 1, timestamp('2010-12-31 23:59:59'))};
Are there any plans to make this
The Apache Derby project is pleased to announce feature release 10.8.1.2.
Apache Derby is a subproject of the Apache DB project. Derby is a pure
Java relational database engine which conforms to the ISO/ANSI SQL and
JDBC standards. Derby aims to be easy for developers and end-users to
work
Hi Luis,
Derby does not support a GROUP_CONCAT aggregate function. However, it
would be trivial to write if we implemented DERBY-672, user-defined
aggregates. By voting for that feature, you can boost its chances of
being implemented in our next feature release.
Many performance-enhancing
Thanks for everyone's work on coding, documenting, and testing 10.8.1.2.
The polls have closed. The community has approved 10.8.1.2 as an
official Derby release:
+1:
Kim Haase (pmc)
Tiago Espinha
Bryan Pendleton (pmc)
Lily Wei (pmc)
Rick Hillegas (pmc)
Knut Anders Hatlen (pmc)
Dag Wanvik (pmc
Hi Brett,
Some comments inline...
On 4/12/11 6:21 PM, Brett Wooldridge wrote:
I have perhaps a misunderstanding/mis-expectation of a database
created with collation TERRITORY_BASED:PRIMARY.
From the manual:
Territory based with collation strength PRIMARY. Specify this value
to make Derby
Hi Clark,
Derby does not expose this information through a public api. After
statement triggers may help you here.
Regards,
-Rick
On 3/31/11 5:23 PM, 鲍少明 wrote:
Thanks for Myrna's answer. But I am asking another function.
Currently, I am using Derby in the memory mode.
I need to know the
Hi Clark,
It would help if you could give us more information about the problem
you are seeing:
1) What are your table definitions, including primary/unique and foreign
keys.
2) What is the sequence of statements which results in the failure you
are seeing.
Thanks,
-Rick
On 4/1/11 6:17
On 3/29/11 12:01 AM, Sergio Medina wrote:
Hi
Is there something in Derby that emulates a Queue?
Thanks
Hi Sergio,
Derby doesn't provide a wrapper api to make queue management simple. But
probably lots of people use Derby tables to model queues. Maybe someone
can share their wrapper
On 3/28/11 9:04 PM, wrote:
Hi All,
I am using derby not long. I want to use lpad/rpad function like in
oracle. I think there is one in derby but I can't find it. Is there
this kind of functions in derby? Thanks a lot!
Regards,
jolt
Hi Jolt,
Derby provides builtin functions to
The Apache Derby project is pleased to announce feature release 10.7.1.1.
Apache Derby is a subproject of the Apache DB project. Derby is a pure
Java relational database engine which conforms to the ISO/ANSI SQL and
JDBC standards. Derby aims to be easy for developers and end-users to
work
Hi Mamatha,
I'm not sure that I understand what the trigger is supposed to do, but
here is a sample script which may do something close. Along the way I
rephrased myTable.size as a generated column because your example
suggested it was being used that way:
create table myTable
(
myTableID
The Apache Derby project is pleased to announce release 10.6.1.0. In
addition to introducing many new features, this release fixes a security
flaw. Please see below for more details.
Apache Derby is a subproject of the Apache DB project. Derby is a pure
Java relational database engine which
---BeginMessage---
Hi PMC's
Please distribute this notice to your user and dev lists:
The Travel Assistance Committee is now taking in applications for those
wanting to attend ApacheCon North America (NA) 2010, which is taking place
between the 1st and 5th November in Atlanta.
The Travel
401 - 500 of 927 matches
Mail list logo