Altering identity field error

2006-07-10 Thread Lars Gramark
Hi, I'm trying out the new Derby alpha version 10.2.0.3-412239 and the new identity reset features. When I've altered an identity counter using the ALTER TABLE statement below, it seems as if the default identity behavior is lost. Consider the following statements: CREATE TABLE MYTABLE ( id

Can I encrypt a non encrypted database ?

2006-07-10 Thread Supal J Patel
Hi, If I have a database which is not encrypted and have some data in it , can I now encrypt that database ? In all the manuals they talk abt how to create a new encrypted database. Its no where mentioned that if you can or can not encrypt already existing database which is not encrypted.

RE: Altering identity field error

2006-07-10 Thread derby
Uhm, Just a hunch... when you alter the identity column and reset the CBV (Current Base Value), do you also have to redefine GENERATE BY DEFAULT ? It sounds that this could be the problem... -Original Message- From: Lars Gramark [mailto:[EMAIL PROTECTED] Sent: Monday, July 10, 2006

RE: Altering identity field error

2006-07-10 Thread Lars Gramark
Right, but according to the documentation this is not available. http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html And I cant find it in the JavaCC grammar either in the source code but I could be wrong. Do you have a suggestion of what I should write to get around the problem? /Lars

RE: Altering identity field error

2006-07-10 Thread Michael Segel
Ok, So if your problem can be duplicated, then it's a bug. From the cheap seats, it looks like when you reset the base value or next value, its losing the GENERATE BY DEFAULT and somehow the identity column is being reset to GENERATE ALWAYS. (Not sure which is the default constraint.)

Re: Can I encrypt a non encrypted database ?

2006-07-10 Thread Suresh Thalamati
Kristian Waagan wrote: Supal J Patel wrote: Hi, If I have a database which is not encrypted and have some data in it , can I now encrypt that database ? In all the manuals they talk abt how to create a new encrypted database. Its no where mentioned that if you can or can not encrypt

Re: Derby optimizer hints?

2006-07-10 Thread Ateesh_Verma
Hi Mamta, Thanks for the info. Here is the scenario: The query I am talking about is part of a repair mechanism when the application starts. So, if this query is invoked, it means that the application and hence the db connection was unexpectedly shutdown while the INSERTS/UPDATES were being

RE: Altering identity field error

2006-07-10 Thread Lars Gramark
A bug.. I filed a bug in the Jira. It sounds quite interesting but for me, beer and research usually ends up in a catastrophy ;) Thanks for your response. /Lars -- View this message in context: http://www.nabble.com/Altering-identity-field-error-tf1917526.html#a5259955 Sent from the Apache

Apache Derby with Hibernate3 (more specificly GRAILS)

2006-07-10 Thread Lance Shaw
Hello, I'm tring to use Derby with GRAILS which uses Hibernate3. When I try to start the application using 'grails run-app' I get the following error: org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect for

Re: Apache Derby with Hibernate3 (more specificly GRAILS)

2006-07-10 Thread Andrew McIntyre
On 7/10/06, Lance Shaw [EMAIL PROTECTED] wrote: Hello, I'm tring to use Derby with GRAILS which uses Hibernate3. When I try to start the application using 'grails run-app' I get the following error: