Tranql has been on svn for quite a while.
try
svn co https://svn.codehaus.org/tranql/tranql
You might need one more directory (https://svn.codehaus.org/tranql)
if building complains about missing tranql-parent.
The build is on maven 2 now also.
I thought these were published, they'd probably be in the codehaus m2
repo.
thanks
david jencks
On Oct 24, 2006, at 12:48 AM, Kaeto23 wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
> Hello, Gianny
>
> can you point me to where to grab the new jar? I tried the download at
> codehaus.org but the file date for the 1.4 snapshot is July 2006?? And
> funnily I can't access the cvs (Could not connect to
> :pserver:anonymous@cvs.tranql.codehaus.org:/home/projects/tranql/scm:
> I/O exception occurred: Connection refused: /home/projects/tranql/scm:
> no such repository
> ).
>
> Regards
>
> Dirk
>
> Gianny Damour schrieb:
>> Hi,
>>
>> Thanks for reporting these problems. They are now fixed in HEAD of
>> TranQL. Could you please download the latest TranQL-1.4-SNAPSHOT
>> artifact and confirm that these problems are now fixed? You can
>> simply
>> drop this artifact in your repository and Geronimo will pick it up
>> as it
>> is the latest available version (thanks David J. for the hint).
>>
>> The Apache JIRA infrastructure is down at the moment. I will open two
>> issues to track them when JIRA will become available.
>>
>> Thanks for your patience,
>> Gianny
>>
>> On 20/10/2006, at 10:18 PM, Kaeto23 wrote:
>>
>>> Hello,
>>>
>>> OK, I tried your way now and at least Geronimo keeps talking to
>>> me. The
>>> stacktrace now reads as follows:
>>>
>>> Caused by: org.tranql.ql.QueryException: Select [Select
>>> method=[ejbSelectForumPostsNum]; EJB-QL=[select distinct count(p.id)
>>> from Post as p where p.thread.forum.id=?1]] does not return a EJB
>>> and
>>> defines the prefetch group [Default].
>>> at
>>> org.tranql.builder.SQLQueryBuilder.buildSelects
>>> (SQLQueryBuilder.java:224)
>>> at
>>> org.openejb.deployment.CMPContainerBuilder.buildIt
>>> (CMPContainerBuilder.java:311)
>>>
>>> at
>>> org.openejb.deployment.AbstractContainerBuilder.createConfiguration(
>>> AbstractContainerBuilder.java:354)
>>>
>>> at
>>> org.openejb.deployment.CMPEntityBuilder.createBean
>>> (CMPEntityBuilder.java:213)
>>>
>>> ... 32 more
>>>
>>>
>>> It seems Geronimo wants a EJB in return. Counting is still a
>>> problem ;)
>>>
>>> I just consider to switch to JOnAS or JBoss ;)
>>>
>>> Milan: how did you count the EJBs? Do you also use the "Default"
>>> prefetch group (only the CMP fields are loaded instead of CMP+CMR)?
>>>
>>> Best regards
>>>
>>> Dirk
>>>
>>>
>>> Unger, Milan schrieb:
>>>> Hello,
>>>>
>>>> I faced similar problem, the trick to use following EJB QL:
>>>>
>>>> select distinct count(p.key) from Post as p where
>>>> p.thread.forum.id=?1
>>>>
>>>> notice count(p.key) - where key should be a property of CMP bean.
>>>> I'm not sure if such syntax is required by EJB spec or simply a
>>>> bug in
>>>> geronimo/open-ejb.
>>>>
>>>> Regards, Milan.
>>>>
>>>> -----Original Message-----
>>>> From: Kaeto23 [mailto:kaeto23@yahoo.de]
>>>> Sent: Thursday, October 19, 2006 6:55 PM
>>>> To: Geronimo ML
>>>> Subject: ejbSelect tutorial?
>>>>
>>>> Hello,
>>>>
>>>> today I started to work on a CMP that also provides a ejbSelect for
>>>> counting some contents from a database. Basically, a CMP named Post
>>>> which should count how much entries exist in the database.
>>>>
>>>> Nothing so hard ;)
>>>>
>>>> Anyway, Geronimo has some trouble to use the EJB so I'd like to
>>>> know
>>>> WHAT is the problem :/
>>>>
>>>> Here the code snippet that, when not commented out, makes the
>>>> trouble:
>>>>
>>>>
>>>>
>>>>
>>>> @XD5EjbSelectMethode(descr = "returns the number of entries",
>>>> ejbQL =
>>>> "select distinct count(p) from Post as p where
>>>> p.thread.forum.id=?1")
>>>> public abstract long ejbSelectForumPostsNum(long forumId) throws
>>>> FinderException;
>>>>
>>>>
>>>>
>>>> Now XD5 creates the following deployment descriptor entries:
>>>>
>>>> ejb-jar.xml:
>>>> ...
>>>> <query>
>>>> <description>returns the number of entries</description>
>>>> <query-method>
>>>> <method-name>ejbSelectForumPostsNum</method-name>
>>>> <method-params>
>>>> <method-param>long</method-param>
>>>> </method-params>
>>>> </query-method>
>>>> <ejb-ql>select distinct count(p) from Post as p where
>>>> p.thread.forum.id=?1</ejb-ql>
>>>> </query>
>>>> ...
>>>>
>>>> openejb-jar.xml
>>>> ...
>>>> <query>
>>>> <query-method>
>>>> <method-name>ejbSelectForumPostsNum</method-name>
>>>> <method-params>
>>>> <method-param>long</method-param>
>>>> </method-params>
>>>> </query-method>
>>>> <group-name>Default</group-name>
>>>> </query>
>>>> ...
>>>>
>>>> If these lines are present, Geronimo will crash with this
>>>> exception:
>>>>
>>>> Caused by: java.lang.ClassCastException:
>>>> org.tranql.ql.EntityReference
>>>> at
>>>> org.tranql.ejbqlcompiler.PathTransformer$Context.<init>
>>>> (PathTransformer.
>>>> java:401)
>>>> at
>>>> org.tranql.ejbqlcompiler.PathTransformer$Context.<init>
>>>> (PathTransformer.
>>>> java:380)
>>>> at
>>>> org.tranql.ejbqlcompiler.PathTransformer.visit
>>>> (PathTransformer.java:73)
>>>> at org.tranql.ql.Query.visit(Query.java:59)
>>>> at
>>>> org.tranql.ejbqlcompiler.InterRepresentationTransformer.transform
>>>> (InterR
>>>> epresentationTransformer.java:41)
>>>> at
>>>> org.tranql.ejbqlcompiler.DerbyEJBQLCompilerFactory
>>>> $DerbyEJBQLCompiler.tr
>>>> ansform(DerbyEJBQLCompilerFactory.java:69)
>>>> at
>>>> org.tranql.sql.EJBQLToPhysicalQuery.expandToSQLQuery
>>>> (EJBQLToPhysicalQuer
>>>> y.java:243)
>>>> at
>>>> org.tranql.sql.EJBQLToPhysicalQuery.buildSelect
>>>> (EJBQLToPhysicalQuery.jav
>>>> a:171)
>>>> at
>>>> org.tranql.sql.EJBQLToPhysicalQuery.buildSelects
>>>> (EJBQLToPhysicalQuery.ja
>>>> va:109)
>>>> at
>>>> org.tranql.builder.SQLQueryBuilder.buildSelects
>>>> (SQLQueryBuilder.java:204
>>>> )
>>>> at
>>>> org.openejb.deployment.CMPContainerBuilder.buildIt
>>>> (CMPContainerBuilder.j
>>>> ava:311)
>>>> at
>>>> org.openejb.deployment.AbstractContainerBuilder.createConfiguration
>>>> (Abst
>>>> ractContainerBuilder.java:354)
>>>> at
>>>> org.openejb.deployment.CMPEntityBuilder.createBean
>>>> (CMPEntityBuilder.java
>>>> :213)
>>>>
>>>>
>>>> So, basically, do you have some examples or tutorials that show the
>>>> usage of ejbSelects with Geronimo 1.1.1? Let me know :)
>>>>
>>>> Best regards
>>>>
>>>> Dirk
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ___________________________________________________________
>>>> Der frhe Vogel fngt den Wurm. Hier gelangen Sie zum neuen Yahoo!
>>>> Mail:
>>>> http://mail.yahoo.de
>>>>
>>>
>>> --Kaeto23
>>>
>>> HTTP: http://kaeto23.dnsalias.com (german!)
>>> Jabber: jabber://kaeto23@jabber.ds2/DS2
>>>
>>> Reclaim Your Inbox!
>>> http://www.mozilla.org/products/thunderbird/
>>>
>>>
>>>
>>>
>>>
>>> ___________________________________________________________
>>> Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo!
>>> Mail: http://mail.yahoo.de
>>
>>
>
> - --
> Kaeto23
>
> HTTP: http://kaeto23.dnsalias.com (german!)
> Jabber: jabber://kaeto23@jabber.ds2/DS2
>
> Reclaim Your Inbox!
> http://www.mozilla.org/products/thunderbird/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFFPcVRbiSTaBU+G6oRA+RLAJ4zLxd6ikvCyohbVLfBOeZeV8yrBwCeMGNc
> NU9jAurfYX1i2N10tQs+eMI=
> =tmtN
> -----END PGP SIGNATURE-----
>
>
>
>
>
> ___________________________________________________________
> Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo!
> Mail: http://mail.yahoo.de
|