| Anonymous | Login | Signup for a new account | 05-02-2024 16:36 PDT |
| Main | My View | View Issues | Change Log | Docs |
| Viewing Issue Advanced Details [ Jump to Notes ] | [ View Simple ] [ Issue History ] [ Print ] | ||||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||
| 0000393 | [Resin] | minor | always | 09-21-05 00:00 | 11-30-05 14:42 | ||||
| Reporter | user241 | View Status | public | ||||||
| Assigned To | |||||||||
| Priority | urgent | Resolution | fixed | Platform | |||||
| Status | closed | OS | |||||||
| Projection | none | OS Version | |||||||
| ETA | none | Fixed in Version | 3.0.15 | Product Version | 3.0.14 | ||||
| Product Build | 3.0.14 | ||||||||
| Summary | 0000393: can't traverse many-to-one paths in amber (resin 3) ejb-ql | ||||||||
| Description |
RSN-439 Given the following ejb-ql: SELECT a FROM schemaA a, IN (a.schemaB) b where b = ?1 if a has a many-to-one relationship with b then the query dies with the following error: com.caucho.amber.query.QueryParseException: collections in FROM may not be sub-collected. in "SELECT a FROM schemaA a, IN(a.schemaB) b WHERE b = ?1" at com.caucho.amber.query.QueryParser.error(QueryParser.java:1490) at com.caucho.amber.query.CollectionSchemaExpr.createField(CollectionSchemaExpr.java:65) at com.caucho.amber.query.QueryParser.parseSchema(QueryParser.java:671) at com.caucho.amber.query.QueryParser.parseFrom(QueryParser.java:518) at com.caucho.amber.query.QueryParser.parseSelect(QueryParser.java:264) at com.caucho.amber.query.QueryParser.parse(QueryParser.java:239) at com.caucho.amber.connection.AmberConnectionImpl.parseQuery(AmberConnectionImpl.java:963) at I have traced this through the source and this error ("collections in FROM may not be sub-collected") is hardcoded into CollectionSchemaExpr.java. It looks like the coding was simply never finished. So an ejb query can no longer traverse a many-to-one path anymore, which pretty much makes the IN clause of ejb-sql useless. In resin 2, the join was created easily and works. Can you get this completed and into 3.0.15??? cheers christian |
||||||||
| Steps To Reproduce | |||||||||
| Additional Information | resin 3.x pro. all platforms. | ||||||||
| Attached Files | |||||||||
|
|
|||||||||
 Relationships |
|
|
Notes |
|
|
(0000450) ferg 09-21-05 00:00 |
ejb/0h18 |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 09-21-05 00:00 | user241 | New Issue | |
| 11-30-05 00:00 | administrator | Fixed in Version | => 3.0.15 |
| 11-30-05 14:42 | ferg | Status | resolved => closed |
| Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
33 total queries executed. 27 unique queries executed. |  |
