[JBoss-user] [Persistence & CMP/JBoss] - Re: Sql not generating properly
My mistake in earlier post, I was little confused as all other CMPs in my project does not have getter and those still works!! Anyway I tried putting getter methods in PK class but still getting same error. The query jboss is generating is missing FROM a expression before FROM. It is generating a query as follow: SELECT FROM SMPPAGENTPROFILE t0_s WHERE (t0_s.smppAgentProfileId > 0) Log: | 2005-05-30 10:31:10,197 DEBUG [] Executing SQL: SELECT FROM SMPPAGENTPROFILE t0_s WHERE (t0_s.smppAgentProfileId > 0) | 2005-05-30 10:31:10,213 DEBUG [] Find failed | java.sql.SQLException: ORA-00936: missing expression | | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) | at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) | at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) | at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451) | at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651) | at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117) | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331) | at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422) | at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:314) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:198) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:117) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:38) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:587) | at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:285) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:322) | at org.jboss.ejb.EntityContainer.find(EntityContainer.java:670) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:585) | at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1061) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) | at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:204) | at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) | at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) | at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90) | at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) | at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) Any pointers? Let me know if you need more details on my CMP bean. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3879407#3879407 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3879407 --- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: Sql not generating properly
Hi, can you please tell me what did you mean by getters on PK class?
I'm getting the same problem and not able to find what is wrong in my query or
PK class. Thanks.
PK class is as follow:
public class SMPPAgentProfileParmsPK implements Serializable {
| //
| //-- Instance Attributes
| //
|
| public Integer smppAgentProfileId;
|
| //
| //-- Constructors
| //
|
| public SMPPAgentProfileParmsPK(){}
| public SMPPAgentProfileParmsPK( Integer smppAgentProfileId){
| this.smppAgentProfileId = smppAgentProfileId;
| }
|
| //
| //-- Overridden methods
| //
|
| public boolean equals( Object obj ) {
| if ( obj == null || !(obj instanceof SMPPAgentProfileParmsPK) ) {
| return false;
| }
| else if (
!((SMPPAgentProfileParmsPK)obj).smppAgentProfileId.equals(smppAgentProfileId) )
{
| return false;
| }
| else
| return true;
| }
|
| public int hashCode() {
| return smppAgentProfileId.intValue();
| }
|
| public String toString() {
| return smppAgentProfileId.toString();
| }
| }
|
finder method is as follow:
|
| findAllAgentProfiles
|
|
| [CDATA[ Select OBJECT(s) FROM
SMPPAgentProfileParmsBean AS s WHERE s.smppAgentProfileID > 0]]
|
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3879405#3879405
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3879405
---
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: EJbspec violation error while deploying entity bean - pl
These methods are not abstract in home interface. But when I decompile the class I see that these methods are abstract. And I'm not getting this error for just findByPrimaryKey(), it is for all the methods in home interface which returns remote interface. I tried many things but now running out of ideas . HELP PLEASE View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853824#3853824 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853824 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [HTTPD, Servlets & JSP] - Re: How do I set 3 context for one web module?
Nope, this does not work. Any other pointer? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853821#3853821 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853821 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: EJbspec violation error while deploying entity bean - pl
YES, PK class implements Serializable. Any other pointers? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853712#3853712 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853712 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - EJbspec violation error while deploying entity bean - please
Hi All, I'm trying to resolve this error from past 5 days and so far no luck. Error is as folllow: 14:04:51,176 WARN [verifier] EJB spec violation: Bean : telParms Method : public abstract TelParms findByPrimaryKey(TelParmsPK) throws RemoteExce ption, FinderException Section: 12.2.9 Warning: The method return types defined in an Entity beans home interface MUST be legal types for RMI/IIOP. I get this error in all the method of this bean which returns the remote interface. Check and double check the remote class and it extends "EJBObject" only. Did any of you have face the similar problems? Please help... -Ami View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853698#3853698 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853698 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [HTTPD, Servlets & JSP] - How do I set 3 context for one web module?
How can we set 3 context for one web module in Jboss 3.2.5? In standalone tomcat I was able to do it by adding a 'Context ' element in server.xml of Tomcat. If we do the same changes in server.xml of integrated Jboss-Tomcat, it is not picking up contexts. Any idea, how can we do the same in Jboss 3.2.5-Tomcat? Appreciate any kind of help. Thanks, -Ami View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853581#3853581 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853581 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
