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
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.
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
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
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.)
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
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
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
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
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:
10 matches
Mail list logo