In order to use the edit feature of the AppDev Studio JDBC table components, the JDBC driver that is used must support direct updates through the ResultSet. SAS offers the following JDBC drivers, and the following describes in what situations direct update is available.

• MVADriver - connects to SAS workspace server. The MVADriver supports updatable ResultSets with the restriction that the query string be in the syntax of "select * from libname.dataset". The MVADriver will not allow concurrent updates to the data, unless the query is assigned to a libname that points to a SAS/Share server.
• Sharenet Driver - connects to SAS/Share server. The ShareNet driver does not support direct update of result sets. If you wish to use a SAS/Share table in an editable table, then the preferred method is to connect to an IOM workspace server with the MVADriver. In the IOM session, a libname to the share server can be defined, and used in the JDBC query. As long as the query is of the form select * from lib.table, the edit functionality will be enabled. This method will also allow concurrent update access to the table through the java application. The libname could be assigned in few different methods.
  • Preassigned library
  • Libname defined in workspace server autoexec
  • Assigned at runtime with java code. An example of how to submit SAS code to a workspace server, and then use it for a jdbc connection can be seen in Sample 33060

If you are using another vendor's JDBC driver, they may have different restrictions for obtaining updatable ResultSets.

Operating System and Release Information