[JBoss-user] [Persistence CMP/JBoss] - EJB-QL - IS EMPTY
I'm not sure if the following EJB-QL with the IS EMPTY expression is translated correctly by JBoss 3.2.5. Wouldn't the generated SQL return an empty result no matter what? | ejb-ql |![CDATA[SELECT OBJECT(s) FROM Service s WHERE s.subscriptions IS EMPTY]] | /ejb-ql | | translated to... | | SELECT DISTINCT t0_s.service_id FROM service t0_s, subscription t1_s_subscriptions WHERE (t1_s_subscriptions.subs_id IS NULL AND t0_s.service_id=t1_s_subscriptions.service_id) | View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3845776#3845776 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3845776 --- 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] [Persistence CMP/JBoss] - Re: Primary Keys that are also Foreign Keys
I created the Student_Course EJB because I need fields other than student_id and course_id. For instance, I need another field that stores the date when the student registers for the course, etc. If I didn't create the Student_Course ejb, I wouldn't be able to store the additonal fields as the association table would only take the student_id and course_id. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3844534#3844534 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3844534 --- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: Primary Keys that are also Foreign Keys
That's exactly what I did. I'm using the compound PK (student_id, course_id) in the Student_Course EJB to ensure that no student registers for the same course more than once. Therein lies the problem. As you said earlier, a field can only be either CMP or CMR. But the student_id and course_id fields in the Student_Course tables are CMR fields. How do I then set these CMR fields? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3844540#3844540 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3844540 --- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Primary Keys that are also Foreign Keys
Hello, I have the following tables: Student - PK is student_id Course -PK is course_id Student_Course - PK is student_id and course_id I needed some additional fields in the association table, so I created an entity bean for Student_Course with student_id and course_id as CMR fields. As far as I know, PK is set in ejbCreate and CMR is set in ejbPostCreate. In this case, the PKs are also CMR fields...so how do I set them? I can't think of a way to set it in ejbCreate. I did try setting it in ejbPostCreate but I got the NULL Primary Key exception, as expected. I don't want to have to create a separate PK field in the association table. Many thanks. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3844509#3844509 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3844509 --- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: JNDI lookup
Thanks for your answer. It just seems a bit strange. I've seen ejb-ref and ejb-local-ref being configured for session beans but never entity beans. All the examples I've seen on the web never had to configure ejb-ref and ejb-local-ref for entity beans and still able to do a lookup with the ENC path. It's no big deal really. Just something that's worth knowing. Anyone with experience on app servers other than JBoss would like to share their experience? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3844388#3844388 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3844388 --- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: How to include two data-sources in jbosscmp-jdbc.xml fil
You need only to have one enterprise-beans/enterprise-beans tag. But within every tags, you can define the datasource that the particular entity bean uses. Check out the jbosscmp-jdbc.dtd (http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd). View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3844392#3844392 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3844392 --- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - JNDI lookup
I have an entity bean that calls another entity bean. I noticed that the following lookup doesn't work: XXXHome xxxHome = (XXXLocalHome) ctx.lookup(java:comp/env/ejb/XXXLocalHome); but if I remove java:comp/env, it works. Any idea why? What should I do if I want to use the full path? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3844262#3844262 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3844262 --- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: EJB-QL not equals to
Cheers, that worked. So the rule of thumb is that I need to include the CDATA bit if I'm using a comparison operator like or in my EJB-QL? Otherwise, I can ignore it? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3843360#3843360 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3843360 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721alloc_id=10040op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - EJB-QL not equals to
Can anyone help identify the problem with the EJB-QL statement below? I'm using JBoss 3.2.5. ejb-ql SELECT OBJECT(s) FROM Service s WHERE s.price 0 /ejb-ql org.jboss.deployment.DeploymentException: The content of elements must consist of well-formed character data or markup.; - nested throwable: (org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.) View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3843254#3843254 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3843254 --- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721alloc_id=10040op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
