Re: having a problem with not in

tyoup wrote: i'm having problems with the following query select a,b,c from ta where (b,c) not in (select bb,cc from tb where dd = 3) wich won't work in derby how can i work this around ? Hi Tyoup If I remember correctly, IN clauses can only take handle one attribute. I think you'll get

listing available databases

Hello, I'm looking for a way of displaying available databases, ideally something similar to show databases from MySQL. Thanks, -- Natalia

Re: backup size exploded

Fabian Merki wrote: hi all i encountered a very strange problem. today the backup of a small db was 7.4 gb and it filled up my disk. running du -s results in: 105194 backup/2007-10-14 03-09-31/ 105214 backup/2007-10-15 03-10-23/ 105250 backup/2007-10-16 03-09-40/ 105318

drop table does not delete .dat files

hi all i've just recognized that drop table does not delete .dat files. is this a feature or a bug? google did not help to answer this question ;-( i don't think that this issue has anything to do with my other problem i posted today... thanks fabian

backup size exploded

hi all i encountered a very strange problem. today the backup of a small db was 7.4 gb and it filled up my disk. running du -s results in: 105194 backup/2007-10-14 03-09-31/ 105214 backup/2007-10-15 03-10-23/ 105250 backup/2007-10-16 03-09-40/ 105318 backup/2007-10-17 03-09-29/ 202713

Error: Invalid cursor state - no current row

Hello, i have the database with two tables Opzioni, Preventivi. This is my code; public class DerbySample { public static void main(String args[]) { // esempio collegamento a derby con modifiche try { Class.forName(org.apache.derby.jdbc.EmbeddedDriver).newInstance();

Re: having a problem with not in

Jørgen Løland wrote: tyoup wrote: i'm having problems with the following query select a,b,c from ta where (b,c) not in (select bb,cc from tb where dd = 3) wich won't work in derby how can i work this around ? Hi Tyoup If I remember correctly, IN clauses can only take handle one

Re: Error: Invalid cursor state - no current row

Francesco Rosa [EMAIL PROTECTED] writes: Hello, i have the database with two tables Opzioni, Preventivi. This is my code; public class DerbySample { public static void main(String args[]) { // esempio collegamento a derby con modifiche try {

Re: drop table does not delete .dat files

Fabian Merki [EMAIL PROTECTED] writes: hi all i've just recognized that drop table does not delete .dat files. is this a feature or a bug? google did not help to answer this question ;-( Hi Fabian, Are the dat files still there after you have performed a shutdown of the database?

Re: Problem with valueSpecification() grammar rule

Øystein Grøvlen [EMAIL PROTECTED] writes: Dhananjay Muli wrote: Hello, I am facing problem with a query in postgresql having following condition in where clause bullyear=(acadyear-year+1) where acadyear, bullyear and year are columns of table. The existing sqlgrammar.jj file has a

Re: Problem with valueSpecification() grammar rule

Øystein Grøvlen wrote: Dhananjay Muli wrote: Hello, I am facing problem with a query in postgresql having following condition in where clause bullyear=(acadyear-year+1) where acadyear, bullyear and year are columns of table. The existing sqlgrammar.jj file has a problem parsing the

Re: Error: Invalid cursor state - no current row.

Bit Runner... [EMAIL PROTECTED] writes: Exact: I have put setAutoCommit(false) and all it works correctly!!! :- Thanks PS: an other question: but in AutoCommit true the every instruction sql is executed in one isolated transaction. And therefore why it gave error to me? In theory it

Memory Leak or Expected Behavior - BtreePostCommit

Hi, We have an application that is using embedded Derby (10.3), where we do a lot of adds and deletes. When we run this application under our stress scenarios, we see a memory leak in Derby. When we look at our heap dumps, what we see is an ever growing number of these classes:

Re: crate and drop databases.

Thanks Francois I didn't see that part. PJ 2007/10/26, Francois Orsini [EMAIL PROTECTED]: Hi Paulo, You'll find the information you need in the developers' guide, See 'Creating, Dropping, and Backing Up Databases' section:

Re: crate and drop databases.

2007/10/26, Stanley Bradbury [EMAIL PROTECTED]: Paulo Jesus wrote: I have two questions on create an drop databases. Do I have a command to drop a database? Or do I need to gently remove the directory of the database? I didn't find references to this. There is other way to create a

Re: Including a derby db within the same jar as the application

On 10/28/07, David Leader [EMAIL PROTECTED] wrote: A postscript to the solution to the problem: jdbc:derby:jar:(MyApp.jar)MyDB When I used exe4j to create a Windows .exe from MyApp.jar it worked fine without specifying any derby properties. When I created a Mac application bundle (can be

Re: listing available databases

I'm looking for a way of displaying available databases, ideally something similar to show databases from MySQL. Derby doesn't maintain a master catalog of databases, so you have to keep track of the databases yourself. Here's a few suggestions from the list archive from the last time this

Re: Memory Leak or Expected Behavior - BtreePostCommit

gregsmit wrote: Hi, We have an application that is using embedded Derby (10.3), where we do a lot of adds and deletes. When we run this application under our stress scenarios, we see a memory leak in Derby. When we look at our heap dumps, what we see is an ever growing number of these

Re: Memory Leak or Expected Behavior - BtreePostCommit

Hi Mike, OK, sounds like our stress test fits in one of those worst case for derby categories: Does your stress application happen to make the table average around 0 rows (ie. add rows and then delete them all, ...) Yes, this is exactly what our stress application does. It loops through 1)

Re: Memory Leak or Expected Behavior - BtreePostCommit

gregsmit wrote: Hi Mike, OK, sounds like our stress test fits in one of those worst case for derby categories: Does your stress application happen to make the table average around 0 rows (ie. add rows and then delete them all, ...) Yes, this is exactly what our stress application does. It

Re: Memory Leak or Expected Behavior - BtreePostCommit

Hi Mike, Sure -- be happy to help with this issue. The database and the queries are very simple. The reason is that we are not really testing a real app, but rather a web framework that we are building as a platform for other apps. So, our Demo App is the one that is being stress tested, so

Re: Memory Leak or Expected Behavior - BtreePostCommit

gregsmit wrote: Hi Mike, Sure -- be happy to help with this issue. The database and the queries are very simple. The reason is that we are not really testing a real app, but rather a web framework that we are building as a platform for other apps. So, our Demo App is the one that is being