Cannot Preview Data

Problem: In some cases, Unwired WorkSpace cannot extract the metadata that is required for a preview through the JDBC driver. In these cases, Unwired WorkSpace either executes the mobile business object's SQL statement to extract the metadata from the preview results, or executes a remote procedure call to get the results.

Solution: In UnwiredWorkSpace.bat, set the autocommitPreviewTransaction property to true:
  1. Shut down Unwired WorkSpace.
  2. Go to the Unwired WorkSpace Eclipse subdirectory; for example: C:\Sybase\UnwiredPlatform-1_2\Eclipse.
  3. Use a text editor to open UnwiredWorkSpace.bat, and add this line, following -vmargs:
    -D "autocommitPreviewTransaction=true"
    For example:
    start "Sybase Unwired WorkSpace" "%ECLIPSE_ROOT%\eclipse.exe" 
    %ADDITIONAL_ARGS% -vm "%JAVA_HOME%\bin\javaw.exe" -vmargs 
    -D "autocommitPreviewTransaction=true"
    -D"java.endorsed.dirs=%ECLIPSE_ROOT%\endorsed" -Xmx512M -DSampleObject=true 
    -DPureJava=PureJava -Declipse.product=com.sybase.sup.SUPproduct 
    ...
    goto 
    EXIT
  4. Restart Unwired WorkSpace.