Encrypted db

2012-02-09 Thread jesusaplsoft
Is there any way to unencrypt a working encrypted db? -- View this message in context: http://old.nabble.com/Encrypted-db-tp33293118p33293118.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: About db file sizing

2012-02-09 Thread Rick Hillegas
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

RE: About db file sizing

2012-02-09 Thread Carlos de Luna Saenz
Great article the one about derby security... just what I needed to know, thanks. -Mensaje original- De: Rick Hillegas [mailto:rick.hille...@oracle.com] Enviado el: jueves, 09 de febrero de 2012 07:47 a.m. Para: derby-user@db.apache.org Asunto: Re: About db file sizing Hi Carlos, Some

How to drop two interrelated tables at the same time?

2012-02-09 Thread Libor Jelinek
Hello dear Derby community! Very stupid question but as I newcomer from MySQL (MyISAM) I am wondering how to delete table that has references to another table? Table *business_objects* refers to table* users*. Vice versa table* users*referes to *business_objects*. create table business_objects (

RE: How to drop two interrelated tables at the same time?

2012-02-09 Thread Bergquist, Brett
Use alter table business_objects drop constraint fk_created_by;; alter table users drop constraint fk_boid; drop table business objects; drop table users; Basically reverse what you did to create the tables. Brett From: Libor Jelinek

Re: How to drop two interrelated tables at the same time?

2012-02-09 Thread Libor Jelinek
No other way? Something like PostgreSQL's DROP TABLE yx CASCADE? But thanks a lot despite! Libor 2012/2/10 Bergquist, Brett bbergqu...@canoga.com Use alter table business_objects drop constraint fk_created_by;; alter table users drop constraint fk_boid; drop table business objects; drop