Derby eating up disk space + how to trigger ReclaimSpace elegantly

Hi, We're working on a java webapp and using a derby database (v10.5) in embedded mode. The first version of the application went live about 2 months ago. The application gets used for making invoices and we also store the XML of an invoice document in the derby DB (input data for generating a

Derby eating up disk space + how to trigger ReclaimSpace elegantly

Hi, We're working on a java webapp and using a derby database (v10.5) in embedded mode. The first version of the application went live about 2 months ago. The application is used to make invoices and we also store the XML of an invoice document (input data for generating a PDF against a

Re: ClassNotFoundException when deploying with apache tomcat = where to put the jar?

Am 07.08.2011 22:25, schrieb Spezifikum: Hi i am using apache derby with netbeans succesfully. Local applications run as excpeted, but when i try to create a servlet i always get the error that the driver could not be loaded together with a ClassNotFoundException, which afaik means that the

Re: Derby eating up disk space + how to trigger ReclaimSpace elegantly

Hi, For what it's worth, I had an approximately similar experience with approximately similar volumes of data on a desktop app using Derby embedded. I introduced a daily compress of all tables using the following command (for each table): call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('MYSCHEMA',

Re: Can't Load Embedded Driver

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

Re: Derby eating up disk space + how to trigger ReclaimSpace elegantly

On 05.08.2011 16:35, De Meyer Tim wrote: Hi, We're working on a java webapp and using a derby database (v10.5) in embedded mode. The first version of the application went live about 2 months ago. The application is used to make invoices and we also store the XML of an invoice document

Re: Can't Load Embedded Driver

Rick, Thank you very much for offering your help.  Apparently my CLASSPATH is good.  I typed in java org.apache.derby.jdbc.EmbeddedDriver and did indeed get exactly the expected Exception in thread main java.lang.NoSuchMethodError: main error message.  What else could be causing  my

Re: Can't Load Embedded Driver

On 07.08.2011 18:54, 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

Re: Can't Load Embedded Driver

I have some experience using Apache Derby. I can't remember exactly what was the issue I found in my project. It worked on DEV but not in PRD. I fixed it using derby.properties file. Do some research and take a look a derby.properties file:

Re: Table exists in same JVM after Derby is shutdown

Thank you, Dag. It looks like in order to get this to work, I had to make two calls to DriverManager.getConnection. Combining shutdown=true;drop=true didn't work. So, is this the correct implementation (if in-line image doesn't work, please see attachment): From: dag.wan...@oracle.com

Re: Can't Load Embedded Driver

I do not know what an fqcn is.  I am running the latest Derby release, 10.8.1.2.  The code pasted in below works great  in the dev environment (IntelliJ Idea), but the same code packaged in a jar cannot find the driver with CLASSPATH set correctly.    public static Connection

Re: Can't Load Embedded Driver

Hi Roy, The fqcn, is the fully qualified class name of the driver. So in your code you're using the driver manager to grab a connection; however I don't see a reference to loading the driver: http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html#embedded_driver

Re: Can't Load Embedded Driver

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?

Re: Can't Load Embedded Driver

Using jdk1.6.0_20. - Original Message - From: Rick Hillegas rick.hille...@oracle.com To: Derby Discussion derby-user@db.apache.org Sent: Monday, August 8, 2011 3:24:09 PM Subject: Re: Can't Load Embedded Driver Hi Roy, Thanks for including the code snippet. As Raymond points out,

Re: Can't Load Embedded Driver

That bottom level plumbing has been working perfectly for two years in dev.  I remember thinking it was pretty cool and developer-friendly.  I had essentially NO trouble getting it all up and working.  I have now added the code to explicitly load the driver.  It works fine in dev, but not

Re: Can't Load Embedded Driver

Thanks for the suggestion, Myrna.  However, it's NOT Intellij Idea that is having a problem; everything has been working perfectly in dev.  It's when I build a jar and just run under Windows that the problem occurs.  I'm getting desperate, though, so I'll try  PROGRA~1 and/or  moving the jars

Re: Table exists in same JVM after Derby is shutdown

On 08.08.11 16:41, Pavel Bortnovskiy wrote: Thank you, Dag. It looks like in order to get this to work, I had to make two calls to DriverManager.getConnection. Combining /shutdown=true;drop=true/ didn't work. So, is this the correct implementation (if in-line image doesn't work, please see