Re: Performance degradation with Derby Embedded under Tomcat vs Jetty

2015-04-13 Thread Tim Watts
Have you put the app under a profiler to see what components are taking the most time in each container? Seems like the best way to get some facts on the table. On Sun, 2015-04-12 at 23:50 +0200, Øyvind Harboe wrote: Hi, I'm having problems with performance degrading dramatically when I

Re: seeking explanation of SQLException error message

2013-10-23 Thread Tim Watts
On Wed, 2013-10-23 at 10:48 -0700, Bob M wrote: hi I have the following code * // retrieve and output date and time of oldest record from the table rs = s.executeQuery(SELECT * FROM USD_JPY ORDER BY Date ASC, Time ASC FETCH FIRST ROW ONLY); rs.next(); String Date2 =

Re: AW: AW: AW: schema-questions

2012-07-19 Thread Tim Watts
in the absence of an actual performance issue is not going to be very productive. Malte -Ursprüngliche Nachricht- Von: Tim Watts [mailto:t...@cliftonfarm.org] Gesendet: Mittwoch, 18. Juli 2012 17:48 An: Derby Discussion Betreff: Re: AW: AW: schema-questions Hi Malte, On Wed

Re: AW: AW: schema-questions

2012-07-18 Thread Tim Watts
an embedded Derby engine. Just wanted to point that out so you and others aware of the possibilities. -Ursprüngliche Nachricht- Von: Tim Watts [mailto:t...@cliftonfarm.org] Gesendet: Dienstag, 17. Juli 2012 22:36 An: Derby Discussion Betreff: Re: AW: schema-questions On Tue, 2012

Re: derby.jar Classpath

2012-07-17 Thread Tim Watts
On Tue, 2012-07-17 at 05:56 -0700, Rick Hillegas wrote: On 7/17/12 3:23 AM, Peter Davis wrote: Hi I've been using derby db for a while now and have until now been willing to work around a problem with classpath. It appears that I have to explicitly place derby.jar on the class path

Re: schema-questions

2012-07-17 Thread Tim Watts
On Tue, 2012-07-17 at 16:44 +0200, malte.kem...@de.equens.com wrote: Another thing I am wondreing is, that it seems not to matter using a user or not using following derby.properties, though: derby.stream.error.logSeverityLevel=0 derby.database.fullAccessUsers=tech

Re: AW: schema-questions

2012-07-17 Thread Tim Watts
setting derby.system.home via JAVA_OPTS. (Derby 10.8.1.2) -Ursprüngliche Nachricht- Von: Tim Watts [mailto:t...@cliftonfarm.org] Gesendet: Dienstag, 17. Juli 2012 18:08 An: Derby Discussion Betreff: Re: schema-questions On Tue, 2012-07-17 at 16:44 +0200, malte.kem...@de.equens.com

Re: Strange OutOfMemory in unittest

2012-06-27 Thread Tim Watts
On Wed, 2012-06-27 at 06:15 -0700, mogoye wrote: Hello, I'm currently working on a some junit tests to validate My DB using Derby 1.8.1.2. My code is using JPA annotations and Eclipselink implementation. The purpose of this test is to evaluate the performances of my requests. My test is

Re: Correct Derby software ?

2012-06-21 Thread Tim Watts
On Thu, 2012-06-21 at 13:54 +0200, Isabelle DASTUGUE wrote: Hello, I have a Derby database that works when I start it from Eclipse, but when I try to run it from the. Jar of my application, it does not work. Here are two successive errors: java.sql.SQLException: Failed to start database

RE: Correct Derby software ?

2012-06-21 Thread Tim Watts
On Thu, 2012-06-21 at 15:10 +0200, Isabelle DASTUGUE wrote: My manifest : Manifest-Version: 1.0 Main-Class: Main Class-Path: SimulProg\lib\tinylaf.jar SimulProg\lib \swing-layout-1.0.3.jar SimulProg\lib\swt.jar SimulProg\lib \grouplayout.jar SimulProg\lib\resources.jar

Re: Correct Derby software ?

2012-06-21 Thread Tim Watts
On Thu, 2012-06-21 at 09:21 -0400, Tim Watts wrote: On Thu, 2012-06-21 at 13:54 +0200, Isabelle DASTUGUE wrote: Hello, I have a Derby database that works when I start it from Eclipse, but when I try to run it from the. Jar of my application, it does not work. Here are two

Re: Importing tables which have references to other tables

2012-06-15 Thread Tim Watts
On Thu, 2012-06-14 at 23:26 -0700, jaz1988 wrote: Hi, I have a table, TABLE1 which has a column which is GENERATED BY DEFAULT AS IDENTITY. I managed to export this table and import into an existing DB with the same table. The import is able to adjust the IDENTITY column accordingly with

Re: Importing tables which have references to other tables

2012-06-15 Thread Tim Watts
On Fri, 2012-06-15 at 08:18 -0400, Tim Watts wrote: On Thu, 2012-06-14 at 23:26 -0700, jaz1988 wrote: Hi, I have a table, TABLE1 which has a column which is GENERATED BY DEFAULT AS IDENTITY. I managed to export this table and import into an existing DB with the same table. The import

Re: Conglomerate could not be created?

2012-06-01 Thread Tim Watts
On Fri, 2012-06-01 at 15:19 +0300, John English wrote: I'm having trouble with the following error: Conglomerate could not be created. It happens when I do this: INSERT INTO resource_usage (resid,itemid,itemtype) (SELECT resid,?,? FROM resource_usage WHERE itemid=? AND

Re: ClientDriver class not found in derby.jar

2011-10-08 Thread Tim Watts
You need to put derbyclient.jar in your classpath. You probably don't need derby.jar if your class is just acting as a client. You would need that one if you're using Derby as an embedded database. On Sat, 2011-10-08 at 14:00 +0530, Pramod Talekar wrote: Hello, I'm using Derby-10.8.1.2 bin

Can't run SYSCS_IMPORT_TABLE

2011-10-03 Thread Tim Watts
Hello, Using Derby 10.8.1.2, I'm getting this exception: java.sql.SQLSyntaxErrorException: 'SYSCS_UTIL.SYSCS_IMPORT_TABLE' is not recognized as a function or procedure. whenever I try to execute this code: String statement = CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE

Re: Can't run SYSCS_IMPORT_TABLE

2011-10-03 Thread Tim Watts
On Mon, 2011-10-03 at 23:37 +0200, Dag H. Wanvik wrote: But I believe I'm passing the right number (9). The procedure does in fact exist according to ij's show procedures command. Any ideas what I'm doing wrong? No. This procedure has seven arguments. The one that has nine is