[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
Is ORDERING so may cause problem? jboss-ql![CDATA[SELECT OBJECT(aa) FROM AccountAnal aa WHERE aa.account.id = ?1 order by aa.ordering]]/jboss-ql and error - generated query has starnge table-name after from SELECT t0_aa.id, t0_aa.ordering FROM TABLE-NAME = ACCOUNTANAL t0_aa, ACCOUNT t1_aa_account WHERE (t1_aa_account.id = ? AND t0_aa.account_id=t1_aa_account.id) ORDER BY t0_aa.ordering ASC View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845752#3845752 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845752 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
Version JBoss 3.2.5 View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845754#3845754 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845754 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
Thank you very much for your reply. As you said because of the order keyword it causes the problems. in my application order is an entity bean. but for the finder methods like @ejb.finder signature = java.util.Collection findByConsigneeDate(java.lang.String consigneeRef,java.util.Date orderDate) * query = SELECT OBJECT(o) FROM Order o WHERE o.consigneeReference = ?1 AND o.orderDate = ?2 the mentioned error is not coming. It deploys successfully. the major problem is i can not change name of that bean. could you pls make some suggesstions. thank you View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845556#3845556 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845556 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
You have change the abstract schema name to something else. The queries are compiled at deploy time (except for dynamic ones). So how does that deploy successfully? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845560#3845560 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845560 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
i am using xdoclet to generate ejb.jar and jboss.jar. i have define finder methods without using like as follows. @ejb.finder signature = java.util.Collection findByOrderStatus(java.lang.String orderStatus) * query = SELECT OBJECT(o) FROM Order o WHERE o.workflowStatus = ?1 it is working ok. when deploying it doesn't throw any exceptions. since i want to implement the wildcard search i have used like keyword and implement the query as i mentioned. then i got that error for order bean. but as u said when define find methods with like for country bean it works ok. so i have n't change the abstract shema. pls help me View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845580#3845580 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845580 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
i forget to add one thing. i get this error only when i use jboss.query with Like. if i use ejb finder without jboss.query not getting this error. is there anyway i could use order as bean jndi name and use above queries. you reply is very much appriciated. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845633#3845633 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845633 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: ABSTRACT_SCHEMA problem with ejb-ql
Order is a reserved word. Choose something different. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845460#3845460 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845460 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user