Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Development Tools >> Java Tools

query criteria invalid parameter binding problem

Dear,

I'm creating a simple insert update delete page from your JSC2u1 resource with ms sqlserver 2005. If I ever checked to add criteria to the foreign attribute on SQL editor (or edit it in sessionbean rowset). JSC will give me the invalid parameter binding error. It's my fourth re-installation on JSC2u1.

How do I know where the problem lies?

regards & TIA

[394 byte] By [banbei] at [2007-11-26 9:26:49]

«« Access Manager and Directory Proxy Server for DS Issues
»» Solaris installation - booting problems.

# 1

you add criteria as values or parameter?

lucylucy at 2007-7-7 0:05:54 >

top of Java-index,Development Tools,Java Tools...

# 2

It is a reported bug.

lucylucy at 2007-7-7 0:05:54 >

# 3

Thank you very much for your kind response

1. I add the criteria as a parameter

2. If it's a report bug, how do I fix it? I have installed all patches(?) via update center

2.1 How come some of my colleague's server does not behave like this?

3. For the record, I bypassed it by directly filter the rowset via rowset.setCommand(sql) instead where I copied the attributes from sessionbean (for consistency) then append the criteria to the sql String

banbei at 2007-7-7 0:05:54 >

# 4

you can reference http://developers.sun.com/prodtech/javatools/jscreator/learning/tutorials/2/ins erts_updates_deletes.html

lucylucy at 2007-7-7 0:05:54 >

# 5

I should have asked a clearer question.Where can I find information about the bug? (hopefully, there is a patch for it.) i.e. what do I need to do such that my system would behave like expected. regards,

banbei at 2007-7-7 0:05:54 >

# 6

Hi,

Thank you for your feedback.

There is a bug in the Query Editor when testing the query by executing the

Run Query menuitem.

However, this doesn't affect the application execution or binding.

Is the error you're seeing when binding components or at runtime?

Either way, please paste the exception and provide more info as to what

you're trying to do

Thank you

John

jawbe at 2007-7-7 0:05:54 >

# 7

Dear,

Thank you too for your response. What I want to do was to create a master detail page where I select a personId (his name shown) from a dropdownbox then display records from another table which has a foreign key to the personId. I'm running JSC2 on XP (SP2). I have SQLSERVER2000 on Windows Server2003. I also have a SQLSERVER express (XP version?) on XP.

I'll post two reply. This one is from app log. (The other is from the browser).

regards,

at com.sun.data.provider.impl.CachedRowSetDataProvider.cursorFirst(CachedRowSetDat aProvider.java:351)

at com.sun.data.provider.impl.CachedRowSetDataProvider.setCachedRowSet(CachedRowSe tDataProvider.java:182)

at com.sun.data.provider.impl.CachedRowSetDataProvider.close(CachedRowSetDataProvi der.java:209)

at webapplication2.boardPage.destroy(boardPage.java:404)

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java: 580)

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.ja va:316)

at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87 )

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)

at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

at com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 263)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:225)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 173)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 2)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:189)

at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess(ProcessorTask. java:604)

at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:475)

at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:371)

at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:264)

at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:281)

at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:83)

|#]

Reader executing query ps=0 SELECT ALL dbo.Board.BoardID,

dbo.Board.BoardCode,

dbo.Board.PersonID,

dbo.Board.RowStatus,

dbo.Board.UserID

FROM dbo.Board

WHERE dbo.Board.PersonID = ?

No Params|#]

java.sql.SQLException: [sunm][SQLServer JDBC Driver]Invalid parameter binding(s).

at com.sun.sql.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.sun.sql.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sun.sql.jdbc.base.BasePreparedStatement.validateParameters(Unknown Source)

at com.sun.sql.jdbc.base.BasePreparedStatement.preImplExecute(Unknown Source)

at com.sun.sql.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.sun.sql.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.sun.sql.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at com.sun.sql.rowset.internal.CachedRowSetXReader.readData(CachedRowSetXReader.ja va:193)

at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:950)

at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:1410)

at com.sun.data.provider.impl.CachedRowSetDataProvider.checkExecute(CachedRowSetDa taProvider.java:1219)

at com.sun.data.provider.impl.CachedRowSetDataProvider.setCursorRow(CachedRowSetDa taProvider.java:329)

at com.sun.data.provider.impl.CachedRowSetDataProvider.setCursorIndex(CachedRowSet DataProvider.java:300)

at com.sun.data.provider.impl.CachedRowSetDataProvider.getRowKeys(CachedRowSetData Provider.java:245)