Thanx Luts and kar YEOW it worked when i passed the % with the parameter.
cheers Imran -----Original Message----- From: Lutz Hilken [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 2:46 PM To: 'Imran Bohoran'; Jboss-User (E-mail) Subject: RE: [JBoss-user] Finder problem The % is part of the data, that is queried. So, put it to the values, that are passed to the finder when it is called. Cheers, Lutz. -----Original Message----- From: Imran Bohoran [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 7:02 PM To: Jboss-User (E-mail) Subject: [JBoss-user] Finder problem Hi has any one out there used the LIKE condition when customizing the finders in JAWS. I have this finder: <finder> <name>findByFirstNameAny</name> <query> FIRST_NAME LIKE '%{0}%' </query> <order></order> </finder> But the SQL statement which JAWS interprets; [JAWS] findByFirstNameAny command executing: SELECT CONTRACTOR_USERS.USER_ID FROM CONTRACTOR_USERS where FIRST_NAME LIKE '%?%' [JAWS] Set parameter: idx=1, jdbcType=VARCHAR, value='dd' throws an Error which lookis like: [JAWS] java.sql.SQLException: Cannot convert class java.lang.String to SQL type requested [JAWS] at org.gjt.mm.mysql.PreparedStatement.setObject(PreparedStatement.java:930) [JAWS] at org.gjt.mm.mysql.PreparedStatement.setObject(PreparedStatement.java:936) [JAWS] at org.jboss.pool.jdbc.PreparedStatementInPool.setObject(PreparedStatementInPoo l.java:282) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:33 4) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCDefinedFinderCommand.setParameters(JDBCD efinedFinderCommand.java:259) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159 ) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand. java:87) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEnti tiesCommand.java:153) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten ceManager.java:144) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManag er.java:305) [JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:567) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine r.java:843) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync hronizationInterceptor.java:231) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt erceptor.java:154) [JAWS] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor .java:108) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:307) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav a:103) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai nerInvoker.java:437) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:23 7) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182) [JAWS] at $Proxy195.findByFirstNameAny(Unknown Source) [JAWS] at com.zeborg.labor.ejb.session.purchaseOrderManager.PurchaseOrderManagerSB.sea rchContractorProfile(PurchaseOrderManagerSB.java:1026) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulS essionContainer.java:650) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:12 8) [JAWS] at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSess ionInstanceInterceptor.java:243) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:247) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [JAWS] at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java: 341) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI nvoker.java:393) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:152) [JAWS] at java.security.AccessController.doPrivileged(Native Method) [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:148) [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465) [JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7 06) [JAWS] at java.lang.Thread.run(Thread.java:484) [JAWS] java.sql.SQLException: Cannot convert class java.lang.String to SQL type requested [JAWS] at org.gjt.mm.mysql.PreparedStatement.setObject(PreparedStatement.java:930) [JAWS] at org.gjt.mm.mysql.PreparedStatement.setObject(PreparedStatement.java:936) [JAWS] at org.jboss.pool.jdbc.PreparedStatementInPool.setObject(PreparedStatementInPoo l.java:282) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:33 4) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCDefinedFinderCommand.setParameters(JDBCD efinedFinderCommand.java:259) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159 ) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute(JDBCFinderCommand. java:87) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEnti tiesCommand.java:153) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities(JAWSPersisten ceManager.java:144) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManag er.java:305) [JAWS] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:567) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine r.java:843) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync hronizationInterceptor.java:231) [JAWS] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt erceptor.java:154) [JAWS] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor .java:108) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:307) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav a:103) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106) [JAWS] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:420) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai nerInvoker.java:437) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:23 7) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182) [JAWS] at $Proxy195.findByFirstNameAny(Unknown Source) [JAWS] at com.zeborg.labor.ejb.session.purchaseOrderManager.PurchaseOrderManagerSB.sea rchContractorProfile(PurchaseOrderManagerSB.java:1026) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulS essionContainer.java:650) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:12 8) [JAWS] at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSess ionInstanceInterceptor.java:243) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT. java:247) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [JAWS] at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java: 341) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI nvoker.java:393) [JAWS] at java.lang.reflect.Method.invoke(Native Method) [JAWS] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) [JAWS] at sun.rmi.transport.Transport$1.run(Transport.java:152) [JAWS] at java.security.AccessController.doPrivileged(Native Method) [JAWS] at sun.rmi.transport.Transport.serviceCall(Transport.java:148) [JAWS] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465) [JAWS] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7 06) [JAWS] at java.lang.Thread.run(Thread.java:484) Can any one let me know as to what i'm missing here. btw I'm using MySQL as the DB. TIA Imran _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
