db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Armin Waibel" <armin.wai...@code-au-lait.de>
Subject Re: cvs commit: db-ojb/src/test/org/apache/ojb repository_junit.xml
Date Thu, 10 Apr 2003 15:18:55 GMT
Hi,

by the way, is there a special reason for using
'id' attributes? Thought this is not necessary in
current version?

<field-descriptor id="2" name="date" column="DATE" jdbc-type="VARCHAR"/>

regards,
Armin

> Problems after check in of 'extent Aware Path Expressions'
>
> Think you shouldn't use DATE as column name (reserved word),
> ID as column name (reserved word in Postgres I think)
>
> regards,
> Armin
>
> project-insert-sql:
> [torque-insert-sql] Our new url -> jdbc:sapdb://localhost/OJB_1
> [torque-insert-sql] Executing file:
> E:\open_src\db-ojb\db-ojb\target\src\sql\ojbtest-schema.sql
> [torque-insert-sql] Failed to execute: CREATE TABLE PAPER ( ID INTEGER
> NOT NULL, DATE VARCHAR (50), AUTHOR VARCHAR (50) )
> [torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> [-7006] (at 43): Reserved identifier not allowed
> [torque-insert-sql] Failed to execute: ALTER TABLE PAPER ADD PRIMARY
KEY
> (ID)
> [torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> [-4004] (at 13): Unknown table name:PAPER
> [torque-insert-sql] Executing file:
> E:\open_src\db-ojb\db-ojb\target\src\sql\ojbcore-schema.sql
> [torque-insert-sql] Executing file:
> E:\open_src\db-ojb\db-ojb\target\src\sql\ojbtest-data.sql
> [torque-insert-sql] Failed to execute: INSERT INTO PAPER
> (ID,DATE,AUTHOR) VALUES (10,'today','NONE')
> [torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> [-4004] (at 13): Unknown table name:PAPER
> [torque-insert-sql] Failed to execute: INSERT INTO PAPER
> (ID,DATE,AUTHOR) VALUES (11,'yesterday','SALES MAN')
> [torque-insert-sql] com.sap.dbtech.jdbc.exceptions.DatabaseException:
> [-4004] (at 13): Unknown table name:PAPER
> [torque-insert-sql] 424 of 428 SQL statements executed successfully
>
> regards,
> Armin
>
> ----- Original Message -----
> From: "Leandro Rodrigo Saad Cruz" <leandro@ibnetwork.com.br>
> To: "OJB Developers List" <ojb-dev@db.apache.org>
> Sent: Thursday, April 10, 2003 2:40 PM
> Subject: Re: cvs commit: db-ojb/src/test/org/apache/ojb
> repository_junit.xml
>
>
> > Ooops.. it is on my machine.. sorry !
> >
> > On Wed, 2003-04-09 at 17:45, brj@apache.org wrote:
> > > brj         2003/04/09 13:45:20
> > >
> > >   Modified:    src/test/org/apache/ojb repository_junit.xml
> > >   Log:
> > >   fix description of NEWS and PAPER : collection-descriptor is not
> inherited
> > >
> > >   Revision  Changes    Path
> > >   1.58      +17 -9
> db-ojb/src/test/org/apache/ojb/repository_junit.xml
> > >
> > >   Index: repository_junit.xml
> > >
> ===================================================================
> > >   RCS file:
> /home/cvs/db-ojb/src/test/org/apache/ojb/repository_junit.xml,v
> > >   retrieving revision 1.57
> > >   retrieving revision 1.58
> > >   diff -u -r1.57 -r1.58
> > >   --- repository_junit.xml 9 Apr 2003 13:33:31 -0000 1.57
> > >   +++ repository_junit.xml 9 Apr 2003 20:45:20 -0000 1.58
> > >   @@ -124,7 +124,7 @@
> > >          />
> > >          <collection-descriptor
> > >             name="allArticlesInGroup"
> > >   -         element-class-ref="org.apache.ojb.broker.Article"
> > >   +
> element-class-ref="org.apache.ojb.broker.AbstractArticle"
> > >             auto-retrieve="true"
> > >             auto-update="true"
> > >             auto-delete="false"
> > >   @@ -3522,7 +3522,11 @@
> > >    <class-descriptor
class="org.apache.ojb.broker.BaseContentImpl">
> > >    <extent-class class-ref="org.apache.ojb.broker.News"/>
> > >    <extent-class class-ref="org.apache.ojb.broker.Paper"/>
> > >   - <field-descriptor id="1" name="id" column="ID"
> jdbc-type="INTEGER" primarykey="true"/>
> > >   + </class-descriptor>
> > >   +
> > >   + <class-descriptor class="org.apache.ojb.broker.News"
> table="NEWS">
> > >   + <field-descriptor id="1" name="id" column="ID"
> jdbc-type="INTEGER" primarykey="true"/>
> > >   + <field-descriptor id="2" name="headline" column="HEADLINE"
> jdbc-type="VARCHAR"/>
> > >        <collection-descriptor name="qualifiers"
> > >
> element-class-ref="org.apache.ojb.broker.Qualifier"
> > >                               auto-retrieve="true"
> > >   @@ -3534,15 +3538,19 @@
> > >        </collection-descriptor>
> > >    </class-descriptor>
> > >
> > >   - <class-descriptor class="org.apache.ojb.broker.News"
> table="NEWS">
> > >   - <field-descriptor id="1" name="id" column="ID"
> jdbc-type="INTEGER" primarykey="true"/>
> > >   - <field-descriptor id="2" name="headline" column="HEADLINE"
> jdbc-type="VARCHAR"/>
> > >   - </class-descriptor>
> > >   -
> > >    <class-descriptor class="org.apache.ojb.broker.Paper"
> table="PAPER">
> > >    <field-descriptor id="1" name="id" column="ID"
> jdbc-type="INTEGER" primarykey="true"/>
> > >    <field-descriptor id="2" name="date" column="DATE"
> jdbc-type="VARCHAR"/>
> > >   - <field-descriptor id="3" name="author" column="author"
> jdbc-type="VARCHAR"/>
> > >   + <field-descriptor id="3" name="author" column="author"
> jdbc-type="VARCHAR"/>
> > >   +    <collection-descriptor name="qualifiers"
> > >   +
> element-class-ref="org.apache.ojb.broker.Qualifier"
> > >   +                           auto-retrieve="true"
> > >   +                           auto-update="false"
> > >   +                           auto-delete="false"
> > >   +
indirection-table="CONTENT_QUALIFIER">
> > >   + <fk-pointing-to-this-class column="CONTENT_ID"/>
> > >   +         <fk-pointing-to-element-class column="QUALIFIER_ID"/>
> > >   +    </collection-descriptor>
> > >    </class-descriptor>
> > >
> > >    <class-descriptor class="org.apache.ojb.broker.Qualifier">
> > >   @@ -3755,4 +3763,4 @@
> > >            </reference-descriptor>
> > >        </class-descriptor>
> > >
> > >   -<!-- Mapping of classes used in junit tests and tutorials ends
> here -->
> > >   +<!-- Mapping of classes used in junit tests and tutorials ends
> here -->
> > >   \ No newline at end of file
> > >
> > >
> > >
> > >
> >
>
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> > > For additional commands, e-mail: ojb-dev-help@db.apache.org
> > >
> > >
> > --
> > Leandro Rodrigo Saad Cruz
> > IT - Inter Business Tecnologia e Servicos (IB)
> > http://www.ibnetwork.com.br
> > http://jakarta.apache.org/ojb
> >
> >
>
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-dev-help@db.apache.org
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>
>
>


Mime
View raw message