Hello-
I have gotten JBoss to use a MSSQL database. I then realized I needed to write a PK
class because my table had multiple PK fields. Now that I'm using a PK class I'm
getting this error in my server.log:
2004-07-22 13:25:36,082 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Pricing#findByCompanyID] Executing SQL:
SELECT FROM PricingProfiles t0_p WHERE (t0_p.companyID = ?)
2004-07-22 13:25:36,180 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Pricing#findByCompanyID] Find
failedjava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Incorrect syntax near the keyword 'FROM'.
This is the finder I have in the ejb-ql.xml file:
<query-method>
<method-name>findByCompanyID</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>select object(p) from PricingBean AS p where p.companyID=?1</ejb-ql>
I can't figure out why the query is not working.
Any help is greatly appreciated.
Thanks-
Michael
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843023#3843023
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843023
-------------------------------------------------------
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=4721&alloc_id=10040&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
