Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Pogs
Thanks! Maybe I'll just have to try it first... Jeff - Original Message From: Aristedes Maniatis <[EMAIL PROTECTED]> To: user@cayenne.apache.org Sent: Friday, February 16, 2007 6:35:40 PM Subject: Re: AUTO_PK_SUPPORT Error On 17/02/2007, at 1:17 AM, Pogs wrote: > Please advice on how

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Aristedes Maniatis
On 17/02/2007, at 1:17 AM, Pogs wrote: Please advice on how am I able to see the entire database. For Derby, one of the best tools to examine the structure and data we've found is Squirrel. It has JDBC adaptors for just about everything. I think you'll find it on Sourceforge somewhere.

SQLTemplate fetchLimit

2007-02-16 Thread Bryan Lewis
Just checking my understanding of something... Does it make any sense to call setFetchLimit() on a SQLTemplate? We're supplying the raw SQL so I would think we'd have to hand-craft the fetch limit as well, say with a 'rownum' or 'limit'.

Re: cayenne with jetty6

2007-02-16 Thread Andrus Adamchik
This is a problem on all versions of Cayenne. Here is a patch that explains the change. I will log it in Jira and apply to all versions. Andrus Index: cayenne-java/src/cayenne/java/org/objectstyle/cayenne/conf/ JNDIDataSourceFactory.java =

AW: AW: AW: AW: cayenne with jetty6

2007-02-16 Thread Peter Schröder
jey! kick ass! it works! what did you change? is it only a 1.2 problem? -Ursprüngliche Nachricht- Von: Andrus Adamchik [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. Februar 2007 16:02 An: user@cayenne.apache.org Betreff: Re: AW: AW: AW: cayenne with jetty6 On Feb 16, 2007, at 3:57

Re: AW: AW: AW: cayenne with jetty6

2007-02-16 Thread Andrus Adamchik
On Feb 16, 2007, at 3:57 AM, Peter Schröder wrote: 16 Feb 2007 09:55:03.928 [INFO] [main] [org.objectstyle.cayenne.conf.JNDIDataSourceFactory] - failed loading from local preferences java.lang.ClassCastException: org.objectstyle.cayenne.modeler.pref.PreferencesDataSourceFactory at org.o

Re: Cayenne and Daylight Savings Time Change?

2007-02-16 Thread Andrus Adamchik
I second that - Cayenne relies on the JDK, JDBC driver and the database to do the right thing. Those three can of course give you lots of headache... http://www.objectstyle.org/cayenne/lists/cayenne-user/2006/12/0107.html Andrus On Feb 15, 2007, at 11:14 PM, Michael Gentry wrote: I'm pret

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Tobias SCHOESSLER
hi, the sybase adapter used to created a stored procedure to retrieve the next PK from the AUTO_PK_SUPPORT tabel. I dont see this in your script, but I don't know if the derby adapter needs this at all. Tobias. Pogs <[EMAIL PROTECTED]> Friday, 16 February 2007 15:04 Please respond to

Re: What version of JGroups do people use?

2007-02-16 Thread Andrus Adamchik
I've been using 2.4CR2 for the last 4 months. Although I am using it in the context of Cayenne/OSCache combo, with targeted invalidation of named cache groups. It is not as transparent as full object sync provided by Cayenne, but it significantly reduces the cluster traffic. Not sure how we

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Pogs
Please advice on how am I able to see the entire database. Just have to start with the basics then I'll switch with MySql after I finish my test project. Mike Kienenberger <[EMAIL PROTECTED]> wrote: After you have executed the sql, did you verify that the database actually contains these tables?

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Pogs
Please advice on how am I able to see the entire database. Just have to start with the basics then I'll switch with MySql after I finish my test project. Mike Kienenberger <[EMAIL PROTECTED]> wrote: After you have executed the sql, did you verify that the database actually contains these tables?

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Mike Kienenberger
After you have executed the sql, did you verify that the database actually contains these tables? The sql you posted looks fine. On 2/16/07, Pogs <[EMAIL PROTECTED]> wrote: Here are the SQL Statements being generated. Thanks, Jeff CREATE TABLE GALLERY (GALLERY_ID INTEGER NOT NULL, GALLERY_NAM

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Pogs
Here are the SQL Statements being generated. Thanks, Jeff CREATE TABLE GALLERY (GALLERY_ID INTEGER NOT NULL, GALLERY_NAME VARCHAR (200), PRIMARY KEY (GALLERY_ID)) ; CREATE TABLE ARTIST (ARTIST_DATE_OF_BIRTH DATE, ARTIST_ID INTEGER NOT NULL, ARTIST_NAME VARCHAR (200), PRIMARY KEY (ARTIST_ID)) ;

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Pogs
Yes. It is also being created on the same schema. The modeler generated it automatically. Mike Kienenberger <[EMAIL PROTECTED]> wrote: I'm not sure if this is relevent in derby, but is your auto_pk_table being created in the same schema as your other tables? I know that this can be an issue wi

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Mike Kienenberger
I'm not sure if this is relevent in derby, but is your auto_pk_table being created in the same schema as your other tables? I know that this can be an issue with schemas in recent versions of hsqldb. On 2/16/07, Michael Gentry <[EMAIL PROTECTED]> wrote: Can you send us the SQL (when you choos

Re: AUTO_PK_SUPPORT Error

2007-02-16 Thread Michael Gentry
Can you send us the SQL (when you choose Generate Database Schema) it is showing so we can see the PK statements the modeler is generating for you? Thanks, /dev/mrg On 2/16/07, Pogs <[EMAIL PROTECTED]> wrote: The only options available are as follows: Drop Tables (unchecked) Drop Primary Key

AW: AW: AW: cayenne with jetty6

2007-02-16 Thread Peter Schröder
hi andrus, this is the debug-output. why does the loading of local preferences fail with the maven-plugin?! 16 Feb 2007 09:55:03.569 [DEBUG] [main] [org.objectstyle.cayenne.conf.DefaultConfiguration] - canInitialize started. 16 Feb 2007 09:55:03.569 [DEBUG] [main] [org.objectstyle.cayenne.conf