Apache Derby users Recent threads

Threads	Replies	First post	Last post
limit on the number of columns By: Patrick Meyer This is a multipart message in MIME format. I am aware that Derby has a limit of 1,012 columns for each table, but many users of my application (it is a program for statistical analysis) have very large files that go well beyond this number of…	3	May 24 2012 06:27	May 25 2012 03:23
Re: best way to check for the exsitence of a table By: Rick Hillegas Hi Pavel, Querying the metadata as you suggest is a good approach. You will want to adjust the arguments to DatabaseMetaData.getTables() however. The arguments in your example may find false matches in other schemas and with tables created with…	0	May 22 2012 14:33	May 22 2012 14:33
Not able to run the derby server on Eclipse By: Mahesh Sitaram Patil11 Hello Team, I have configured the derby database for my Java application in Eclipse but I am not able to start the Derby server in eclipse. Please find the below screen shot of the consol error I am getting: [cid:image0### @01CD375A.0CB56050] …	1	May 21 2012 03:52	May 21 2012 07:19
Re: ERROR 40XL1: A lock could not be obtained within the time requested By: Libor Jelinek Hard to say without deeper analysis but I guess that it can be caused by two simultaneously running transaction in which first one is waiting to second one to get finished (to release a lock) but reserved timeout already passed (effectively it…	0	May 20 2012 14:52	May 20 2012 14:52
Activity 3: Run a JDBC program using the embedded driver By: Douglas Allen First off for a unix/linux type system I need > java -cp . WwdEmbedded or else I get Error: Could not find or load main class WwdEmbedded Now for > java -cp . WwdEmbedded I get ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver …	2	May 17 2012 02:53	May 18 2012 20:34
Cache Hit/Miss rates for Derby pageCache By: David Zanter Does anyone know, is there a way to get derby statistics from a running system regarding the hit/miss rates for the Derby Page Cache. i.e. Statistics that would help determine if the: derby.storage.pageCacheSize was being effective or needs to…	3	May 17 2012 12:08	May 18 2012 09:56
a few questions to Apache Derby Database By: Awad, Luay This is a multi-part message in MIME format. Dear All, I have the following questions to Apache Derby Database: 1. Does Derby have any limit on the database size? ( the size of our Database is about 3,1 GB ) 2. Dose Derby have any…	2	May 18 2012 05:33	May 18 2012 09:37
Speed up single INSERT INTO statement? By: TXVanguard I need to speed up a single INSERT statement in Derby. The statement has the form: INSERT INTO table (col1, col2) SELECT a, b FROM .... In my application, it take about 10 seconds to insert 3000 records. I have experimented with turning off…	4	May 9 2012 12:01	May 14 2012 09:31
Null values with conditions By: Biene_Majo Hi, i have a table with 4 columns: A1 A2 B1 B2 i now need something like this (in relation to null values): (A1 AND A2) OR (B1 AND B2) So that if A1 is not null A2 must not be null and the other way around (so if A2 is not null A1 is not…	3	May 7 2012 07:15	May 7 2012 09:50
Derby database By: Aristedes Maniatis Running Derby 10.8, a customer has managed to corrupt their database somehow (possibly by forcing the database to quit when it did not shut down fast enough to their liking). I see that when I connect to it with ij in embedded mode, I get the…	1	May 5 2012 05:14	May 7 2012 05:42
User authorisation By: Trejkaz Hi all. We are using a custom UserAuthenticator to integrate Derby into our own user database. At the moment, this custom UserAuthenticator is also doing the job of tracking who can open which database. So of course when we deny someone because…	12	Apr 15 2012 21:25	Apr 27 2012 09:13
Suitable test query for Derby? By: Martin Lichtin Hi Implementations of connection pooling typically use a "test query" to first check whether a connection is still valid before sending the actual query across. A test query looks like SELECT SYSDATE FROM DUAL (eg. PostgreSQL or Oracle) or …	4	Apr 13 2012 09:49	Apr 15 2012 18:34
get SQLState from ij.runScript By: Anna Krajewska 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…	2	Apr 12 2012 04:57	Apr 12 2012 10:31
Constraint already exists in Schema 'APP' By: John Steele I have three tables Person, Patient, and Employee. Both Patient and Employee have a Foreign Key to Person; however, when creating the constraint for the second time I get the following error: Constraint 'PERSON_FK' already exists in Schema…	3	Apr 4 2012 16:27	Apr 6 2012 16:50
Milisecond support? By: Libor Jelinek Hello all, does Derby TIMESTAMP data type support millisecond? In reference manual ( http://db.apache.org/derby/docs/10.8/ref/rrefsqlj27620.html) is stated: yyy-mm-dd hh:mm:ss[.nnnnnn] yyyy-mm-dd-hh.mm.ss[.nnnnnn] *The first of the two formats…	3	Apr 5 2012 08:18	Apr 5 2012 09:39
Random DRDA Error on IBM J9 JVM By: Brandon L. Duncan I was wondering if anyone came across this error before while attempting to establish a connection to Derby? The database seems to boot fine, but when a connection is attempted it just bombs out. It also is not always reproducible, as at times it…	9	Mar 19 2012 10:56	Apr 4 2012 18:19
Embedded derby fails to start By: cruise27 Hi, I have a Java based web UI with Derby database created and booted up using the embedded driver. It is all deployed to tomcat. When tomcat starts, the web app boots up derby db and starts writing records to it. This is all deployed on Unix…	2	Mar 22 2012 15:39	Apr 4 2012 14:26
Database shutdown not releasing file handles By: Trejkaz We have the occasional user reporting that after shutting down the database, they can see file handles still open. We're using ;shutdown=true (or at least the DataSource equivalent of it) to do this, and we were led to believe that this would be…	3	Apr 3 2012 22:24	Apr 4 2012 04:41
WS-Notification using Mule By: John Steele I have several Java GUI applications running that use the same networked database, and I need to update/refresh the GUI when changes occur in the database. I'm not using a fancy application server that provides built in functionality for this…	1	Apr 3 2012 14:53	Apr 3 2012 16:01
Create Before Insert Trigger By: v2cg4ss I'm trying to assign values automatically to a row prior to the row being inserted. I have no problem doing this with MySQL or Oracle, etc... However in Derby I was trying issued the following statement and the last_update_uid is populated with…	1	Mar 29 2012 19:42	Apr 3 2012 14:53