Re: Need derby 10.0.2.1-bin.zip version

2012-10-01 Thread Kristian Waagan
On 28.09.2012 13:05, lakshmi Suresh wrote: Hi Team, I am unable to download Derby version 10.0.2.1-bin.zip says "URL not found". url : http://cvs.apache.org/dist/incubator/derby/10.0.2.1/incubating-derb

Re: Need derby 10.0.2.1-bin.zip version

2012-10-01 Thread Kristian Waagan
On 28.09.2012 15:17, lakshmi Suresh wrote: Dear Team , I am trying to set up a database for the CFEveryWhere environment. When i try to run the command "java org.apache.derby.drda.NetworkServerControl start" i am getting error as * "could not load main class org.apache.derby.drda.networkserv

Using Identity Colums with or without Sequences derby 10.8.1.2

2012-10-01 Thread Malte.Kempff
Hi, I'd like to use an identity-column And I am not quite sure how to receive the used number, if I used default. Actually I need the particular identity-value for the entries of other tables, since they are supposed to reference it. Am I forced to give those identities for my own like with a seq

Re: Using Identity Colums with or without Sequences derby 10.8.1.2

2012-10-01 Thread José Ventura
I believe this documentation page answers your question about how to retrieve the generated values: http://db.apache.org/derby/docs/10.7/ref/crefjavstateautogen.html In your case, the INSERT statement that creates a record in INPUTFILES will return a ResultSet which contains the generated value.

RE: Using Identity Columns with or without Sequences derby 10.8.1.2

2012-10-01 Thread John I. Moore, Jr.
Matt, I use generated IDs a lot in my applications. My implementation looks something like the following: create table X ( x_id int generated always as identity (start with 1000), ... constraint x_pk primary key (x_id) ); In order to get access to the generated ID, my code

AW: Using Identity Colums with or without Sequences derby 10.8.1.2

2012-10-01 Thread Malte.Kempff
Hi José, Thanks a lot for the hints, by the way are those identity-values cycled, so it does not come to crash if there a is a "roll over", unless there is a defined constrained that says not unique? Malte Von: José Ventura [mailto:st.ne...@gmail.com] Gesende

AW: Using Identity Columns with or without Sequences derby 10.8.1.2

2012-10-01 Thread Malte.Kempff
Hi John, Thanks a lot for your code example that helps me a lot saveing some time :-) Malte Von: John I. Moore, Jr. [mailto:softmo...@att.net] Gesendet: Montag, 1. Oktober 2012 15:54 An: 'Derby Discussion' Betreff: RE: Using Identity Columns with or without S