Interface SQLDatabase

XML Namespace

urn:icsy:venice:wsdl:data

XSD Data Types

basic:  http://www.v-grid.info/types/basic.xsd

domain:  http://www.v-grid.info/types/domain.xsd

faults:  http://www.v-grid.info/types/faults.xsd

sql:  http://www.v-grid.info/types/data/SQLDatabase.xsd

Operations

 basic:String createDatabase (domain:SSOInformation sso, basic:String name) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Creates a new data base with the associated name.

void dropDatabase (domain:SSOInformation sso, basic:String name) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Drops an existing database with the given name.

 basic:StringArray getDatabaseList (domain:SSOInformation sso) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Returns a list of all available data bases.

void setPermissions (domain:SSOInformation sso, sql:SQLPermissions perm) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Defines some permissions for data base access (i.e. manages the access control list).

 sql:SQLPermissions getPermissions (domain:SSOInformation sso, basic:String dbname) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Returns the currents effective access control list for a data base.

 sql:SQLValueSet query (domain:SSOInformation sso, sql:SQLQuery exec) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Performs an SQL query on a data base.

 sql:SQLExecuteResult execute (domain:SSOInformation sso, sql:SQLQuery exec) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Executes an SQL query on a data base.

 sql:SQLValueSet nextResultSet (domain:SSOInformation sso, xsd:long id) throws faults:AuthorizationFault, faults:SQLPermissionFault, faults:SQLFault
Returns the next result set if available.

 xsd:boolean tableExists (domain:SSOInformation sso, basic:String database, basic:String table) throws faults:AuthorizationFault, faults:SQLFault
Checks whether a table exists in a data base.

 xsd:boolean databaseExists (domain:SSOInformation sso, basic:String databaseName) throws faults:AuthorizationFault, faults:SQLFault
Checks whether a data base name already exists.

void commit (domain:SSOInformation sso, xsd:long persistentId) throws faults:AuthorizationFault, faults:SQLFault
Sends a commit to the data dase and persistently stores all changes of the transaction.

void rollback (domain:SSOInformation sso, xsd:long persitentId) throws faults:AuthorizationFault, faults:SQLFault
Sends a rollback to the data base and discards all changes of the transaction.