Home » Modeling » EMF » [Teneo] Ordering collections in a one-to-many association throws exception
| [Teneo] Ordering collections in a one-to-many association throws exception [message #427742] |
Fri, 27 February 2009 22:28  |
 Rachna Bakhru
Messages: 45
Registered: July 2009 |
Member |
|
|
Reposting it with the Teneo prefix ..........................
I have finished the library example on the website.
Now I am trying to add more books for an existing writer.
I have a many-to-one relationship between book and writer
I have set cascade=persist, so that when i add a new book and save it, the
existing writer gets persisted.
<many-to-one name="author" entity-name="Writer" lazy="false"
cascade="persist,save-update,lock" foreign-key="book_author" insert="true"
update="true" not-null="false">
<column not-null="false" unique="false" name="`myauthor_id`"/>
</many-to-one>
There is a one-to-many relationship between writer and book. And the books
are ordered by book_title.
<bag name="books" order-by="book_title" inverse="true" lazy="true"
cascade="merge,persist,save-update,lock">
<key update="true">
<column name="`myauthor_id`" not-null="false" unique="false"/>
</key>
<one-to-many entity-name="Book"/>
</bag>
Query query = session.createQuery("FROM Library");
List libraries = query.list();
Library lib = (Library) libraries.get(0);
System.out.println(lib.getName());
// read a writer
query = session.createQuery("FROM Writer where name='JRR Tolkien'");
List<Writer> writers = query.list();
Writer writer = writers.get(0);
System.out.println(writer.getName());
// add new books
LibraryFactory libFactory = LibraryFactory.eINSTANCE;
Book book1 = libFactory.createBook();
(119) book1.setAuthor(writer);
book1.setPages(306);
book1.setTitle("HIJK");
book1.setCategory(BookCategory.MYSTERY);
lib.getBooks().add(book1);
Line 119
book1.setAuthor(writer);
throws the following exception. (complete stack trace is in hibernate.log)
Is it because books is a bag in the generated hibernate mapping and an Elist
in the WriterImpl.java
How do I resolve this problem?
Thanks
RJ
11:53:56,142 DEBUG JDBCExceptionReporter:108 - could not initialize a
collection: [Writer.books#5] [select books0_."myauthor_id" as myauthor6_1_,
books0_."id" as id1_1_, books0_."id" as id1_0_0_, books0_."writelock" as
writelock2_0_0_, books0_."book_title" as book3_0_0_, books0_."page_count" as
page4_0_0_, books0_."category" as category5_0_0_, books0_."myauthor_id" as
myauthor6_0_0_, books0_.econtainer_class as econtainer9_0_0_,
books0_.e_container as e10_0_0_, books0_.e_container_featureid as e11_0_0_,
books0_1_."level" as level2_3_0_, case when books0_1_."book_id" is not null
then 1 when books0_."id" is not null then 0 end as clazz_0_ from
"mybooktable" books0_ left outer join "schoolbook" books0_1_ on
books0_."id"=books0_1_."book_id" where books0_."myauthor_id"=? order by
books0_.book_title]
java.sql.SQLException: ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid identifier
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330 )
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287 )
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedS tatement.java:212)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T 4CPreparedStatement.java:795)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Orac leStatement.java:1030)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (T4CPreparedStatement.java:835)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:1123)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:3284)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:3328)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatc her.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle ctions(Loader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
at
org.hibernate.loader.collection.CollectionLoader.initialize( CollectionLoader.java:36)
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427744 is a reply to message #427742] |
Fri, 27 February 2009 23:23  |
Martin Taal
Messages: 5468
Registered: July 2009 |
Senior Member |
|
|
Hi RJ,
I have to tried to find a solution for this one but haven't found it. It seems to be a Hibernate problem (it should use
the alias of book_title in the order by I think). Can you post the example in their forum and see what answer you get?
gr. Martin
RJDAG wrote:
> Reposting it with the Teneo prefix ..........................
>
> I have finished the library example on the website.
> Now I am trying to add more books for an existing writer.
>
> I have a many-to-one relationship between book and writer
> I have set cascade=persist, so that when i add a new book and save it, the
> existing writer gets persisted.
>
> <many-to-one name="author" entity-name="Writer" lazy="false"
> cascade="persist,save-update,lock" foreign-key="book_author" insert="true"
> update="true" not-null="false">
> <column not-null="false" unique="false" name="`myauthor_id`"/>
> </many-to-one>
>
>
> There is a one-to-many relationship between writer and book. And the books
> are ordered by book_title.
> <bag name="books" order-by="book_title" inverse="true" lazy="true"
> cascade="merge,persist,save-update,lock">
> <key update="true">
> <column name="`myauthor_id`" not-null="false" unique="false"/>
> </key>
> <one-to-many entity-name="Book"/>
> </bag>
>
> Query query = session.createQuery("FROM Library");
> List libraries = query.list();
> Library lib = (Library) libraries.get(0);
>
> System.out.println(lib.getName());
> // read a writer
> query = session.createQuery("FROM Writer where name='JRR Tolkien'");
> List<Writer> writers = query.list();
> Writer writer = writers.get(0);
> System.out.println(writer.getName());
>
> // add new books
> LibraryFactory libFactory = LibraryFactory.eINSTANCE;
> Book book1 = libFactory.createBook();
> (119) book1.setAuthor(writer);
> book1.setPages(306);
> book1.setTitle("HIJK");
> book1.setCategory(BookCategory.MYSTERY);
> lib.getBooks().add(book1);
>
> Line 119
> book1.setAuthor(writer);
>
> throws the following exception. (complete stack trace is in hibernate.log)
> Is it because books is a bag in the generated hibernate mapping and an Elist
> in the WriterImpl.java
> How do I resolve this problem?
>
> Thanks
> RJ
>
> 11:53:56,142 DEBUG JDBCExceptionReporter:108 - could not initialize a
> collection: [Writer.books#5] [select books0_."myauthor_id" as myauthor6_1_,
> books0_."id" as id1_1_, books0_."id" as id1_0_0_, books0_."writelock" as
> writelock2_0_0_, books0_."book_title" as book3_0_0_, books0_."page_count" as
> page4_0_0_, books0_."category" as category5_0_0_, books0_."myauthor_id" as
> myauthor6_0_0_, books0_.econtainer_class as econtainer9_0_0_,
> books0_.e_container as e10_0_0_, books0_.e_container_featureid as e11_0_0_,
> books0_1_."level" as level2_3_0_, case when books0_1_."book_id" is not null
> then 1 when books0_."id" is not null then 0 end as clazz_0_ from
> "mybooktable" books0_ left outer join "schoolbook" books0_1_ on
> books0_."id"=books0_1_."book_id" where books0_."myauthor_id"=? order by
> books0_.book_title]
> java.sql.SQLException: ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid identifier
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:111)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330 )
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287 )
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedS tatement.java:212)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T 4CPreparedStatement.java:795)
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Orac leStatement.java:1030)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (T4CPreparedStatement.java:835)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:1123)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:3284)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:3328)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatc her.java:186)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle ctions(Loader.java:224)
> at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
> at
> org.hibernate.loader.collection.CollectionLoader.initialize( CollectionLoader.java:36)
>
>
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427745 is a reply to message #427742] |
Fri, 27 February 2009 23:42 |
Rachna Bakhru
Messages: 45
Registered: July 2009 |
Member |
|
|
The fist line of the Exception has a query
When I execute it in Toad I get the following error
SELECT books0_."myauthor_id" AS myauthor6_1_, books0_."id" AS id1_1_,
books0_."id" AS id1_0_0_, books0_."writelock" AS writelock2_0_0_,
books0_."book_title" AS book3_0_0_,
books0_."page_count" AS page4_0_0_,
books0_."category" AS category5_0_0_,
books0_."myauthor_id" AS myauthor6_0_0_,
books0_.econtainer_class AS econtainer9_0_0_,
books0_.e_container AS e10_0_0_,
books0_.e_container_featureid AS e11_0_0_
FROM "mybooktable" books0_
WHERE books0_."myauthor_id" = 5
ORDER BY books0_.book_title
"ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid identifier"
But when i put quotes around book_title it works
SELECT books0_."myauthor_id" AS myauthor6_1_, books0_."id" AS id1_1_,
books0_."id" AS id1_0_0_, books0_."writelock" AS writelock2_0_0_,
books0_."book_title" AS book3_0_0_,
books0_."page_count" AS page4_0_0_,
books0_."category" AS category5_0_0_,
books0_."myauthor_id" AS myauthor6_0_0_,
books0_.econtainer_class AS econtainer9_0_0_,
books0_.e_container AS e10_0_0_,
books0_.e_container_featureid AS e11_0_0_
FROM "mybooktable" books0_
WHERE books0_."myauthor_id" = 5
ORDER BY books0_."book_title"
why aren't quotes being put around book_title like all other columns, am I
missing something in my ecore file.
Thanks
RJ
"RJDAG" <rjotwani@dag.com> wrote in message
news:go9pgg$54u$1@build.eclipse.org...
> Reposting it with the Teneo prefix ..........................
>
> I have finished the library example on the website.
> Now I am trying to add more books for an existing writer.
>
> I have a many-to-one relationship between book and writer
> I have set cascade=persist, so that when i add a new book and save it, the
> existing writer gets persisted.
>
> <many-to-one name="author" entity-name="Writer" lazy="false"
> cascade="persist,save-update,lock" foreign-key="book_author" insert="true"
> update="true" not-null="false">
> <column not-null="false" unique="false" name="`myauthor_id`"/>
> </many-to-one>
>
>
> There is a one-to-many relationship between writer and book. And the books
> are ordered by book_title.
> <bag name="books" order-by="book_title" inverse="true" lazy="true"
> cascade="merge,persist,save-update,lock">
> <key update="true">
> <column name="`myauthor_id`" not-null="false" unique="false"/>
> </key>
> <one-to-many entity-name="Book"/>
> </bag>
>
> Query query = session.createQuery("FROM Library");
> List libraries = query.list();
> Library lib = (Library) libraries.get(0);
>
> System.out.println(lib.getName());
> // read a writer
> query = session.createQuery("FROM Writer where name='JRR Tolkien'");
> List<Writer> writers = query.list();
> Writer writer = writers.get(0);
> System.out.println(writer.getName());
>
> // add new books
> LibraryFactory libFactory = LibraryFactory.eINSTANCE;
> Book book1 = libFactory.createBook();
> (119) book1.setAuthor(writer);
> book1.setPages(306);
> book1.setTitle("HIJK");
> book1.setCategory(BookCategory.MYSTERY);
> lib.getBooks().add(book1);
>
> Line 119
> book1.setAuthor(writer);
>
> throws the following exception. (complete stack trace is in hibernate.log)
> Is it because books is a bag in the generated hibernate mapping and an
> Elist in the WriterImpl.java
> How do I resolve this problem?
>
> Thanks
> RJ
>
> 11:53:56,142 DEBUG JDBCExceptionReporter:108 - could not initialize a
> collection: [Writer.books#5] [select books0_."myauthor_id" as
> myauthor6_1_,
> books0_."id" as id1_1_, books0_."id" as id1_0_0_, books0_."writelock" as
> writelock2_0_0_, books0_."book_title" as book3_0_0_, books0_."page_count"
> as
> page4_0_0_, books0_."category" as category5_0_0_, books0_."myauthor_id" as
> myauthor6_0_0_, books0_.econtainer_class as econtainer9_0_0_,
> books0_.e_container as e10_0_0_, books0_.e_container_featureid as
> e11_0_0_,
> books0_1_."level" as level2_3_0_, case when books0_1_."book_id" is not
> null
> then 1 when books0_."id" is not null then 0 end as clazz_0_ from
> "mybooktable" books0_ left outer join "schoolbook" books0_1_ on
> books0_."id"=books0_1_."book_id" where books0_."myauthor_id"=? order by
> books0_.book_title]
> java.sql.SQLException: ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid
> identifier
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:111)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330 )
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287 )
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedS tatement.java:212)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T 4CPreparedStatement.java:795)
> at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Orac leStatement.java:1030)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (T4CPreparedStatement.java:835)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:1123)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:3284)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:3328)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatc her.java:186)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle ctions(Loader.java:224)
> at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
> at
> org.hibernate.loader.collection.CollectionLoader.initialize( CollectionLoader.java:36)
>
>
>
>
>
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427746 is a reply to message #427745] |
Sat, 28 February 2009 00:03 |
Martin Taal
Messages: 5468
Registered: July 2009 |
Senior Member |
|
|
Hi RJ,
A good point. In the mapping Teneo adds a backtick (`) to all the column/table names, except for order-by. So this maybe
the cause and solution for this issue.
Can you change the annotation of the order-by so that it contains backticks:`book_title`
(and then regenerate the java code after changing the annotation)?
If this is the solution then I will add this to the mapping generation.
gr. Martin
RJDAG wrote:
> The fist line of the Exception has a query
> When I execute it in Toad I get the following error
> SELECT books0_."myauthor_id" AS myauthor6_1_, books0_."id" AS id1_1_,
> books0_."id" AS id1_0_0_, books0_."writelock" AS writelock2_0_0_,
> books0_."book_title" AS book3_0_0_,
> books0_."page_count" AS page4_0_0_,
> books0_."category" AS category5_0_0_,
> books0_."myauthor_id" AS myauthor6_0_0_,
> books0_.econtainer_class AS econtainer9_0_0_,
> books0_.e_container AS e10_0_0_,
> books0_.e_container_featureid AS e11_0_0_
> FROM "mybooktable" books0_
> WHERE books0_."myauthor_id" = 5
> ORDER BY books0_.book_title
>
> "ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid identifier"
>
> But when i put quotes around book_title it works
> SELECT books0_."myauthor_id" AS myauthor6_1_, books0_."id" AS id1_1_,
> books0_."id" AS id1_0_0_, books0_."writelock" AS writelock2_0_0_,
> books0_."book_title" AS book3_0_0_,
> books0_."page_count" AS page4_0_0_,
> books0_."category" AS category5_0_0_,
> books0_."myauthor_id" AS myauthor6_0_0_,
> books0_.econtainer_class AS econtainer9_0_0_,
> books0_.e_container AS e10_0_0_,
> books0_.e_container_featureid AS e11_0_0_
> FROM "mybooktable" books0_
> WHERE books0_."myauthor_id" = 5
> ORDER BY books0_."book_title"
>
> why aren't quotes being put around book_title like all other columns, am I
> missing something in my ecore file.
>
> Thanks
> RJ
> "RJDAG" <rjotwani@dag.com> wrote in message
> news:go9pgg$54u$1@build.eclipse.org...
>> Reposting it with the Teneo prefix ..........................
>>
>> I have finished the library example on the website.
>> Now I am trying to add more books for an existing writer.
>>
>> I have a many-to-one relationship between book and writer
>> I have set cascade=persist, so that when i add a new book and save it, the
>> existing writer gets persisted.
>>
>> <many-to-one name="author" entity-name="Writer" lazy="false"
>> cascade="persist,save-update,lock" foreign-key="book_author" insert="true"
>> update="true" not-null="false">
>> <column not-null="false" unique="false" name="`myauthor_id`"/>
>> </many-to-one>
>>
>>
>> There is a one-to-many relationship between writer and book. And the books
>> are ordered by book_title.
>> <bag name="books" order-by="book_title" inverse="true" lazy="true"
>> cascade="merge,persist,save-update,lock">
>> <key update="true">
>> <column name="`myauthor_id`" not-null="false" unique="false"/>
>> </key>
>> <one-to-many entity-name="Book"/>
>> </bag>
>>
>> Query query = session.createQuery("FROM Library");
>> List libraries = query.list();
>> Library lib = (Library) libraries.get(0);
>>
>> System.out.println(lib.getName());
>> // read a writer
>> query = session.createQuery("FROM Writer where name='JRR Tolkien'");
>> List<Writer> writers = query.list();
>> Writer writer = writers.get(0);
>> System.out.println(writer.getName());
>>
>> // add new books
>> LibraryFactory libFactory = LibraryFactory.eINSTANCE;
>> Book book1 = libFactory.createBook();
>> (119) book1.setAuthor(writer);
>> book1.setPages(306);
>> book1.setTitle("HIJK");
>> book1.setCategory(BookCategory.MYSTERY);
>> lib.getBooks().add(book1);
>>
>> Line 119
>> book1.setAuthor(writer);
>>
>> throws the following exception. (complete stack trace is in hibernate.log)
>> Is it because books is a bag in the generated hibernate mapping and an
>> Elist in the WriterImpl.java
>> How do I resolve this problem?
>>
>> Thanks
>> RJ
>>
>> 11:53:56,142 DEBUG JDBCExceptionReporter:108 - could not initialize a
>> collection: [Writer.books#5] [select books0_."myauthor_id" as
>> myauthor6_1_,
>> books0_."id" as id1_1_, books0_."id" as id1_0_0_, books0_."writelock" as
>> writelock2_0_0_, books0_."book_title" as book3_0_0_, books0_."page_count"
>> as
>> page4_0_0_, books0_."category" as category5_0_0_, books0_."myauthor_id" as
>> myauthor6_0_0_, books0_.econtainer_class as econtainer9_0_0_,
>> books0_.e_container as e10_0_0_, books0_.e_container_featureid as
>> e11_0_0_,
>> books0_1_."level" as level2_3_0_, case when books0_1_."book_id" is not
>> null
>> then 1 when books0_."id" is not null then 0 end as clazz_0_ from
>> "mybooktable" books0_ left outer join "schoolbook" books0_1_ on
>> books0_."id"=books0_1_."book_id" where books0_."myauthor_id"=? order by
>> books0_.book_title]
>> java.sql.SQLException: ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid
>> identifier
>>
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:111)
>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330 )
>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287 )
>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedS tatement.java:212)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T 4CPreparedStatement.java:795)
>> at
>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Orac leStatement.java:1030)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (T4CPreparedStatement.java:835)
>> at
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:1123)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:3284)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:3328)
>> at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatc her.java:186)
>> at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
>> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
>> at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle ctions(Loader.java:224)
>> at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
>> at
>> org.hibernate.loader.collection.CollectionLoader.initialize( CollectionLoader.java:36)
>>
>>
>>
>>
>>
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427748 is a reply to message #427745] |
Sat, 28 February 2009 00:32 |
Rachna Bakhru
Messages: 45
Registered: July 2009 |
Member |
|
|
I have posted it on the hibernate forumn
http://forum.hibernate.org/viewtopic.php?p=2407353#2407353
"RJDAG" <rjotwani@dag.com> wrote in message
news:go9ts6$rk0$1@build.eclipse.org...
> The fist line of the Exception has a query
> When I execute it in Toad I get the following error
> SELECT books0_."myauthor_id" AS myauthor6_1_, books0_."id" AS id1_1_,
> books0_."id" AS id1_0_0_, books0_."writelock" AS writelock2_0_0_,
> books0_."book_title" AS book3_0_0_,
> books0_."page_count" AS page4_0_0_,
> books0_."category" AS category5_0_0_,
> books0_."myauthor_id" AS myauthor6_0_0_,
> books0_.econtainer_class AS econtainer9_0_0_,
> books0_.e_container AS e10_0_0_,
> books0_.e_container_featureid AS e11_0_0_
> FROM "mybooktable" books0_
> WHERE books0_."myauthor_id" = 5
> ORDER BY books0_.book_title
>
> "ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid identifier"
>
> But when i put quotes around book_title it works
> SELECT books0_."myauthor_id" AS myauthor6_1_, books0_."id" AS id1_1_,
> books0_."id" AS id1_0_0_, books0_."writelock" AS writelock2_0_0_,
> books0_."book_title" AS book3_0_0_,
> books0_."page_count" AS page4_0_0_,
> books0_."category" AS category5_0_0_,
> books0_."myauthor_id" AS myauthor6_0_0_,
> books0_.econtainer_class AS econtainer9_0_0_,
> books0_.e_container AS e10_0_0_,
> books0_.e_container_featureid AS e11_0_0_
> FROM "mybooktable" books0_
> WHERE books0_."myauthor_id" = 5
> ORDER BY books0_."book_title"
>
> why aren't quotes being put around book_title like all other columns, am I
> missing something in my ecore file.
>
> Thanks
> RJ
> "RJDAG" <rjotwani@dag.com> wrote in message
> news:go9pgg$54u$1@build.eclipse.org...
>> Reposting it with the Teneo prefix ..........................
>>
>> I have finished the library example on the website.
>> Now I am trying to add more books for an existing writer.
>>
>> I have a many-to-one relationship between book and writer
>> I have set cascade=persist, so that when i add a new book and save it,
>> the
>> existing writer gets persisted.
>>
>> <many-to-one name="author" entity-name="Writer" lazy="false"
>> cascade="persist,save-update,lock" foreign-key="book_author"
>> insert="true"
>> update="true" not-null="false">
>> <column not-null="false" unique="false" name="`myauthor_id`"/>
>> </many-to-one>
>>
>>
>> There is a one-to-many relationship between writer and book. And the
>> books
>> are ordered by book_title.
>> <bag name="books" order-by="book_title" inverse="true" lazy="true"
>> cascade="merge,persist,save-update,lock">
>> <key update="true">
>> <column name="`myauthor_id`" not-null="false" unique="false"/>
>> </key>
>> <one-to-many entity-name="Book"/>
>> </bag>
>>
>> Query query = session.createQuery("FROM Library");
>> List libraries = query.list();
>> Library lib = (Library) libraries.get(0);
>>
>> System.out.println(lib.getName());
>> // read a writer
>> query = session.createQuery("FROM Writer where name='JRR Tolkien'");
>> List<Writer> writers = query.list();
>> Writer writer = writers.get(0);
>> System.out.println(writer.getName());
>>
>> // add new books
>> LibraryFactory libFactory = LibraryFactory.eINSTANCE;
>> Book book1 = libFactory.createBook();
>> (119) book1.setAuthor(writer);
>> book1.setPages(306);
>> book1.setTitle("HIJK");
>> book1.setCategory(BookCategory.MYSTERY);
>> lib.getBooks().add(book1);
>>
>> Line 119
>> book1.setAuthor(writer);
>>
>> throws the following exception. (complete stack trace is in
>> hibernate.log)
>> Is it because books is a bag in the generated hibernate mapping and an
>> Elist in the WriterImpl.java
>> How do I resolve this problem?
>>
>> Thanks
>> RJ
>>
>> 11:53:56,142 DEBUG JDBCExceptionReporter:108 - could not initialize a
>> collection: [Writer.books#5] [select books0_."myauthor_id" as
>> myauthor6_1_,
>> books0_."id" as id1_1_, books0_."id" as id1_0_0_, books0_."writelock" as
>> writelock2_0_0_, books0_."book_title" as book3_0_0_, books0_."page_count"
>> as
>> page4_0_0_, books0_."category" as category5_0_0_, books0_."myauthor_id"
>> as
>> myauthor6_0_0_, books0_.econtainer_class as econtainer9_0_0_,
>> books0_.e_container as e10_0_0_, books0_.e_container_featureid as
>> e11_0_0_,
>> books0_1_."level" as level2_3_0_, case when books0_1_."book_id" is not
>> null
>> then 1 when books0_."id" is not null then 0 end as clazz_0_ from
>> "mybooktable" books0_ left outer join "schoolbook" books0_1_ on
>> books0_."id"=books0_1_."book_id" where books0_."myauthor_id"=? order by
>> books0_.book_title]
>> java.sql.SQLException: ORA-00904: "BOOKS0_"."BOOK_TITLE": invalid
>> identifier
>>
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:111)
>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330 )
>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287 )
>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedS tatement.java:212)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T 4CPreparedStatement.java:795)
>> at
>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Orac leStatement.java:1030)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (T4CPreparedStatement.java:835)
>> at
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac leStatement.java:1123)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O raclePreparedStatement.java:3284)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac lePreparedStatement.java:3328)
>> at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatc her.java:186)
>> at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
>> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
>> at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyColle ctions(Loader.java:224)
>> at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
>> at
>> org.hibernate.loader.collection.CollectionLoader.initialize( CollectionLoader.java:36)
>>
>>
>>
>>
>>
>
>
|
|
| |
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427757 is a reply to message #427749] |
Sat, 28 February 2009 07:28 |
Martin Taal
Messages: 5468
Registered: July 2009 |
Senior Member |
|
|
Hi RJ,
Okay so this is the direction were to find the solution (the backticks). I checked the log but it consisted only of
chinese characters. Can you post it again?
gr. Martin
RJDAG wrote:
> my ecore file had
> Class :Book
> Field: title @Column(name="book_title")
>
> Class Writer:
> Field: books @OrderBy("title ASC")
>
> So I deleted the the annotation for Field title
> (@Column(name="book_title") )
> and changed the order-by anotation to
> @OrderBy("`title` ASC")
> This makes the program get into an endless loop. The log is attached.
>
>
> So I changed the hibernate.hbm.xml to
> <bag name="books" order-by="`title`" inverse="true" lazy="true"
> cascade="merge,persist,save-update,lock">
> <key update="true">
> <column name="`myauthor_id`" not-null="false" unique="false"/>
> </key>
> <one-to-many entity-name="Book"/>
> </bag>
> and used props.setProperty(PersistenceOptions.USE_MAPPING_FILE,"true ");
>
> And that worked.
>
>
> "Martin Taal" <mtaal@elver.org> wrote in message
> news:go9v02$19v$1@build.eclipse.org...
>> Hi RJ,
>> A good point. In the mapping Teneo adds a backtick (`) to all the
>> column/table names, except for order-by. So this maybe
>> the cause and solution for this issue.
>> Can you change the annotation of the order-by so that it contains
>> backticks:`book_title`
>> (and then regenerate the java code after changing the annotation)?
>>
>> If this is the solution then I will add this to the mapping generation.
>>
>> gr. Martin
>>
>
>
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427764 is a reply to message #427757] |
Mon, 02 March 2009 06:12 |
Rachna Bakhru
Messages: 45
Registered: July 2009 |
Member |
|
|
"Martin Taal" <mtaal@elver.org> wrote in message
news:goap3l$80t$1@build.eclipse.org...
> Hi RJ,
> Okay so this is the direction were to find the solution (the backticks). I
> checked the log but it consisted only of
> chinese characters. Can you post it again?
>
> gr. Martin
>
> RJDAG wrote:
>> my ecore file had
>> Class :Book
>> Field: title @Column(name="book_title")
>>
>> Class Writer:
>> Field: books @OrderBy("title ASC")
>>
>> So I deleted the the annotation for Field title
>> (@Column(name="book_title") )
>> and changed the order-by anotation to
>> @OrderBy("`title` ASC")
>> This makes the program get into an endless loop. The log is attached.
>>
>>
>> So I changed the hibernate.hbm.xml to
>> <bag name="books" order-by="`title`" inverse="true" lazy="true"
>> cascade="merge,persist,save-update,lock">
>> <key update="true">
>> <column name="`myauthor_id`" not-null="false" unique="false"/>
>> </key>
>> <one-to-many entity-name="Book"/>
>> </bag>
>> and used props.setProperty(PersistenceOptions.USE_MAPPING_FILE,"true ");
>>
>> And that worked.
>>
>>
>> "Martin Taal" <mtaal@elver.org> wrote in message
>> news:go9v02$19v$1@build.eclipse.org...
>>> Hi RJ,
>>> A good point. In the mapping Teneo adds a backtick (`) to all the
>>> column/table names, except for order-by. So this maybe
>>> the cause and solution for this issue.
>>> Can you change the annotation of the order-by so that it contains
>>> backticks:`book_title`
>>> (and then regenerate the java code after changing the annotation)?
>>>
>>> If this is the solution then I will add this to the mapping generation.
>>>
>>> gr. Martin
>>>
>>
>>
>>
>>
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal@springsite.com - mtaal@elver.org
> Web: www.springsite.com - www.elver.org
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427818 is a reply to message #427764] |
Mon, 02 March 2009 12:26 |
Martin Taal
Messages: 5468
Registered: July 2009 |
Senior Member |
|
|
Hi RJ,
Clear now (my text editor shows chinese characters but vi works fine). Can you enter a bugzilla for this? Apparently the
annotation parser can not handle the backtick. Did you also see my question in the other bugzilla you entered (about the
list-key element being present).
gr. Martin
RJDAG wrote:
> "Martin Taal" <mtaal@elver.org> wrote in message
> news:goap3l$80t$1@build.eclipse.org...
>> Hi RJ,
>> Okay so this is the direction were to find the solution (the backticks). I
>> checked the log but it consisted only of
>> chinese characters. Can you post it again?
>>
>> gr. Martin
>>
>> RJDAG wrote:
>>> my ecore file had
>>> Class :Book
>>> Field: title @Column(name="book_title")
>>>
>>> Class Writer:
>>> Field: books @OrderBy("title ASC")
>>>
>>> So I deleted the the annotation for Field title
>>> (@Column(name="book_title") )
>>> and changed the order-by anotation to
>>> @OrderBy("`title` ASC")
>>> This makes the program get into an endless loop. The log is attached.
>>>
>>>
>>> So I changed the hibernate.hbm.xml to
>>> <bag name="books" order-by="`title`" inverse="true" lazy="true"
>>> cascade="merge,persist,save-update,lock">
>>> <key update="true">
>>> <column name="`myauthor_id`" not-null="false" unique="false"/>
>>> </key>
>>> <one-to-many entity-name="Book"/>
>>> </bag>
>>> and used props.setProperty(PersistenceOptions.USE_MAPPING_FILE,"true ");
>>>
>>> And that worked.
>>>
>>>
>>> "Martin Taal" <mtaal@elver.org> wrote in message
>>> news:go9v02$19v$1@build.eclipse.org...
>>>> Hi RJ,
>>>> A good point. In the mapping Teneo adds a backtick (`) to all the
>>>> column/table names, except for order-by. So this maybe
>>>> the cause and solution for this issue.
>>>> Can you change the annotation of the order-by so that it contains
>>>> backticks:`book_title`
>>>> (and then regenerate the java code after changing the annotation)?
>>>>
>>>> If this is the solution then I will add this to the mapping generation.
>>>>
>>>> gr. Martin
>>>>
>>>
>>>
>>>
>>
>> --
>>
>> With Regards, Martin Taal
>>
>> Springsite/Elver.org
>> Office: Hardwareweg 4, 3821 BV Amersfoort
>> Postal: Nassaulaan 7, 3941 EC Doorn
>> The Netherlands
>> Cell: +31 (0)6 288 48 943
>> Tel: +31 (0)84 420 2397
>> Fax: +31 (0)84 225 9307
>> Mail: mtaal@springsite.com - mtaal@elver.org
>> Web: www.springsite.com - www.elver.org
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427843 is a reply to message #427818] |
Mon, 02 March 2009 19:46 |
Rachna Bakhru
Messages: 45
Registered: July 2009 |
Member |
|
|
I just updated the comments on Bugzilla.
And I will create a bug for this issue too.
"Martin Taal" <mtaal@elver.org> wrote in message
news:gogja7$b67$1@build.eclipse.org...
> Hi RJ,
> Clear now (my text editor shows chinese characters but vi works fine). Can
> you enter a bugzilla for this? Apparently the annotation parser can not
> handle the backtick. Did you also see my question in the other bugzilla
> you entered (about the list-key element being present).
>
> gr. Martin
>
> RJDAG wrote:
>> "Martin Taal" <mtaal@elver.org> wrote in message
>> news:goap3l$80t$1@build.eclipse.org...
>>> Hi RJ,
>>> Okay so this is the direction were to find the solution (the backticks).
>>> I checked the log but it consisted only of
>>> chinese characters. Can you post it again?
>>>
>>> gr. Martin
>>>
>>> RJDAG wrote:
>>>> my ecore file had
>>>> Class :Book
>>>> Field: title @Column(name="book_title")
>>>>
>>>> Class Writer:
>>>> Field: books @OrderBy("title ASC")
>>>>
>>>> So I deleted the the annotation for Field title
>>>> (@Column(name="book_title") )
>>>> and changed the order-by anotation to
>>>> @OrderBy("`title` ASC")
>>>> This makes the program get into an endless loop. The log is attached.
>>>>
>>>>
>>>> So I changed the hibernate.hbm.xml to
>>>> <bag name="books" order-by="`title`" inverse="true" lazy="true"
>>>> cascade="merge,persist,save-update,lock">
>>>> <key update="true">
>>>> <column name="`myauthor_id`" not-null="false" unique="false"/>
>>>> </key>
>>>> <one-to-many entity-name="Book"/>
>>>> </bag>
>>>> and used props.setProperty(PersistenceOptions.USE_MAPPING_FILE,"true ");
>>>>
>>>> And that worked.
>>>>
>>>>
>>>> "Martin Taal" <mtaal@elver.org> wrote in message
>>>> news:go9v02$19v$1@build.eclipse.org...
>>>>> Hi RJ,
>>>>> A good point. In the mapping Teneo adds a backtick (`) to all the
>>>>> column/table names, except for order-by. So this maybe
>>>>> the cause and solution for this issue.
>>>>> Can you change the annotation of the order-by so that it contains
>>>>> backticks:`book_title`
>>>>> (and then regenerate the java code after changing the annotation)?
>>>>>
>>>>> If this is the solution then I will add this to the mapping
>>>>> generation.
>>>>>
>>>>> gr. Martin
>>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>>
>>> With Regards, Martin Taal
>>>
>>> Springsite/Elver.org
>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>> The Netherlands
>>> Cell: +31 (0)6 288 48 943
>>> Tel: +31 (0)84 420 2397
>>> Fax: +31 (0)84 225 9307
>>> Mail: mtaal@springsite.com - mtaal@elver.org
>>> Web: www.springsite.com - www.elver.org
>>
>>
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal@springsite.com - mtaal@elver.org
> Web: www.springsite.com - www.elver.org
|
|
|
| Re: [Teneo] Ordering collections in a one-to-many association throws exception [message #427844 is a reply to message #427843] |
Mon, 02 March 2009 19:59 |
Rachna Bakhru
Messages: 45
Registered: July 2009 |
Member |
|
|
https://bugs.eclipse.org/bugs/show_bug.cgi?id=266740
"RJDAG" <rjotwani@dag.com> wrote in message
news:gohd5e$hk$1@build.eclipse.org...
>I just updated the comments on Bugzilla.
>
> And I will create a bug for this issue too.
>
> "Martin Taal" <mtaal@elver.org> wrote in message
> news:gogja7$b67$1@build.eclipse.org...
>> Hi RJ,
>> Clear now (my text editor shows chinese characters but vi works fine).
>> Can you enter a bugzilla for this? Apparently the annotation parser can
>> not handle the backtick. Did you also see my question in the other
>> bugzilla you entered (about the list-key element being present).
>>
>> gr. Martin
>>
>> RJDAG wrote:
>>> "Martin Taal" <mtaal@elver.org> wrote in message
>>> news:goap3l$80t$1@build.eclipse.org...
>>>> Hi RJ,
>>>> Okay so this is the direction were to find the solution (the
>>>> backticks). I checked the log but it consisted only of
>>>> chinese characters. Can you post it again?
>>>>
>>>> gr. Martin
>>>>
>>>> RJDAG wrote:
>>>>> my ecore file had
>>>>> Class :Book
>>>>> Field: title @Column(name="book_title")
>>>>>
>>>>> Class Writer:
>>>>> Field: books @OrderBy("title ASC")
>>>>>
>>>>> So I deleted the the annotation for Field title
>>>>> (@Column(name="book_title") )
>>>>> and changed the order-by anotation to
>>>>> @OrderBy("`title` ASC")
>>>>> This makes the program get into an endless loop. The log is attached.
>>>>>
>>>>>
>>>>> So I changed the hibernate.hbm.xml to
>>>>> <bag name="books" order-by="`title`" inverse="true" lazy="true"
>>>>> cascade="merge,persist,save-update,lock">
>>>>> <key update="true">
>>>>> <column name="`myauthor_id`" not-null="false" unique="false"/>
>>>>> </key>
>>>>> <one-to-many entity-name="Book"/>
>>>>> </bag>
>>>>> and used
>>>>> props.setProperty(PersistenceOptions.USE_MAPPING_FILE,"true ");
>>>>>
>>>>> And that worked.
>>>>>
>>>>>
>>>>> "Martin Taal" <mtaal@elver.org> wrote in message
>>>>> news:go9v02$19v$1@build.eclipse.org...
>>>>>> Hi RJ,
>>>>>> A good point. In the mapping Teneo adds a backtick (`) to all the
>>>>>> column/table names, except for order-by. So this maybe
>>>>>> the cause and solution for this issue.
>>>>>> Can you change the annotation of the order-by so that it contains
>>>>>> backticks:`book_title`
>>>>>> (and then regenerate the java code after changing the annotation)?
>>>>>>
>>>>>> If this is the solution then I will add this to the mapping
>>>>>> generation.
>>>>>>
>>>>>> gr. Martin
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>>
>>>> With Regards, Martin Taal
>>>>
>>>> Springsite/Elver.org
>>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>>> The Netherlands
>>>> Cell: +31 (0)6 288 48 943
>>>> Tel: +31 (0)84 420 2397
>>>> Fax: +31 (0)84 225 9307
>>>> Mail: mtaal@springsite.com - mtaal@elver.org
>>>> Web: www.springsite.com - www.elver.org
>>>
>>>
>>
>>
>> --
>>
>> With Regards, Martin Taal
>>
>> Springsite/Elver.org
>> Office: Hardwareweg 4, 3821 BV Amersfoort
>> Postal: Nassaulaan 7, 3941 EC Doorn
>> The Netherlands
>> Cell: +31 (0)6 288 48 943
>> Tel: +31 (0)84 420 2397
>> Fax: +31 (0)84 225 9307
>> Mail: mtaal@springsite.com - mtaal@elver.org
>> Web: www.springsite.com - www.elver.org
>
>
|
|
|
Goto Forum:
Current Time: Sat Apr 27 01:25:28 GMT 2024
Powered by FUDForum. Page generated in 0.03088 seconds |
] 
Search
Help
Register
Login
Home
