Patches for schema.sql : INTEGER - CHAR(1)

2005-08-02 Thread Andy Jefferson
Attached are patches for datastore and application identity schemas to fix issues with incorrect schemas for table ALLTYPES, and PCPOINTSINGLEFIELDCHAR. -- Andy Index: /home/andy/work/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql

Re: JIRA JDO-68

2005-08-02 Thread Michael Watzek
Hi Michelle, Andy, sorry I did not reply earlier. I talked to Craig about this issue yesterday. We agreed on leaving tables FIELDSOFCHARACTER, FIELDSOFPRIMITIVECHAR, and PCPointSingleFieldChar as they are keeping the INTEGER columns. The rationale is that pc class instances mapped to those

Re: JIRA JDO-68

2005-08-02 Thread Michelle Caisse
Hi again Michael, To further clarify, I agree that we want to leave the fld_char and fld_Character fields of AllTypes as INTEGER and change the orm to specify the jdbc-type. However, I think that Andy was correct in saying that the tables FIELDSOFCHARACTER and FIELDSOFPRIMITIVECHAR should

Re: JIRA JDO-68

2005-08-02 Thread Michael Watzek
Hi Andy, I changed the column types of table FIELDSOFCHARACTER back to INTEGER. I also changed the ORM metadata for class FieldsOfCharacter, e.g. class name=FieldsOfPrimitivechar table=FIELDSOFPRIMITIVECHAR ... field name=char0 column name=CHAR0

Re: JIRA JDO-68

2005-08-02 Thread Michael Watzek
Hi Michelle, please have a look at test TestFieldsOfCharacter. It uses java.lang.Charcater.MAX_VALUE and java.lang.Character.MIN_VALUE. Concerning test TestFieldsOfPrimitivechar I am wrong. This test initializes character fields using real characters like 'a'. For this reason, I agree to

Re: JIRA JDO-68

2005-08-02 Thread Andy Jefferson
I changed the column types of table FIELDSOFCHARACTER back to INTEGER. I also changed the ORM metadata for class FieldsOfCharacter, e.g. I'm using JPOX nightly build 2005-08-01. Can you please check and verify if JPOX calls PrepraredStatement.setString for the case above? Hi Michael, It's

Re: How to get started on JDO

2005-08-02 Thread Craig Russell
Hi Karan,On Jul 31, 2005, at 11:33 AM, Karan Malhi wrote:Can anybody give me a starting point to start contributing ? I think that the best thing for you to do is to look at the wiki pages and get a feel for the project activities. Right now, we are building spec-compliance tests for

Additional fields for FieldsOfSimpleInterface, FieldsOfSimpleClass, FieldsOfObject

2005-08-02 Thread Michelle Caisse
Hi, We would like to recognize three ways of mapping PC object types as fields: 1. Serialized in the primary table (field serialized=true) 2. Embedded in the primary table (field embedded=true) 3. Referenced in a table of their own (field embedded=false or embedded not specified) The

Re: Additional fields for FieldsOfSimpleInterface, FieldsOfSimpleClass, FieldsOfObject

2005-08-02 Thread Craig Russell
Hi Michelle,On Aug 2, 2005, at 1:02 PM, Michelle Caisse wrote:Hi,We would like to recognize three ways of mapping PC object types as fields:1. Serialized in the primary table (field serialized="true")2. Embedded in the primary table (field embedded="true")3. Referenced in a table of their own

Re: Additional fields for FieldsOfSimpleInterface, FieldsOfSimpleClass, FieldsOfObject

2005-08-02 Thread Craig Russell
One last thing.On Aug 2, 2005, at 4:21 PM, Craig Russell wrote:CREATE TABLE FIELDSOFSIMPLEINTERFACE(   IDENTIFIER INTEGER NOT NULL,References SIMPLECLASSCraig   INTFIELD1 INTEGER, STRINGFIELD1 VARCHAR(1024),   SIMPLEINTERFACE102 BIGINT REFERENCES SIMPLE_CLASS,   SIMPLEINTERFACE144 LONG VARCHAR FOR