viewFile -- VelocitySupport

[tmoes]

hi Isomorphic,

with this operationBinding (FETCH)

<operationBinding requiresAuthentication="true" operationType="fetch">  
		<orderClause>XMLORREPORTFILE_date_created DESC</orderClause>
		<whereClause>XMLUPLOAD.CLIENT = $session.client AND ($defaultWhereClause)</whereClause>  
</operationBinding>

i get this error message.

=== 2011-01-19 00:07:06,856 [0-11] INFO  SQLDriver - [builtinApplication.DSXmlUpload_viewFile, builtinApplication.null] Execute of select: SELECT XMLUPLOAD.IMPORTED_OK, XMLUPLOAD.USERDEFINEDFIELDS1, XMLUPLOAD.CLIENT, XMLUPLOAD.USAGERULES_OK, XMLUPLOAD.XMLORREPORTFILE, XMLUPLOAD.XMLORREPORTFILE_filesize, XMLUPLOAD.XMLORREPORTFILE_filename, XMLUPLOAD.CONTAINERTYP, XMLUPLOAD.XSDRECOGNITION_OK, XMLUPLOAD.CLEARINGTYPSELECTITEM, XMLUPLOAD.XSDCHECK_OK, XMLUPLOAD.XMLORREPORTFILE_date_created, XMLUPLOAD.REPORTMESSAGE, XMLUPLOAD.USERID, XMLUPLOAD.SESSIONID, XMLUPLOAD.pk FROM pay.XMLUPLOAD WHERE XMLUPLOAD.CLIENT = $session.client AND ((XMLUPLOAD.pk='111')) ORDER BY XMLORREPORTFILE_date_created DESC on db: 
mainDataBase threw exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid pseudocolumn "$session". - assuming stale connection and retrying query.

is there no VelocitySupport for viewFile? The same operationBuinding with Fetch is working fine.

Also an additional operation binding (viewFile) does not help, it is always called fetch.

<operationBinding requiresAuthentication="true" operationType="viewFile">  
		<orderClause>XMLORREPORTFILE_date_created DESC</orderClause>
</operationBinding>

The problem occurs under mysql and sqlserver.

i used:
GWT: 2.1
smartGWT: SC_SNAPSHOT-2011-01-18/PowerEdition Deployment

[Isomorphic]

We've just implemented a fix that should get you past this specific problem. We are also aware of the confusion with viewFile / fetch operations (it comes about because we spawn an additional fetch on the server-side for a viewFile request), and will be refining things in that area soon.

[tmoes]

now it works, thanks