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 13:06:51 GMT
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
>
>
>


Mime
View raw message