| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| |
| maker
| |
| Title
| |
| isDescribedUsing
| |
| has creator
| |
| content
| - %VOSWARNING%
%META:TOPICINFO{author="TimHaynes" date="1144084447" format="1.1" version="1.1"}%
%VOSNAV%
---++ Hosting Java and .NET
Virtuoso allows extending server side logic using either Java or .net bound languages. Complex algorithms may be more
easily expressedin Java or C# than in SQL, while Virtuoso's SQL procedure language remains the most effective means of
implementing purely database-oriented server-side logic. Also using Java or .NET languages provides access to a vast
library of ready-made functionality.
---+++ Mapping Object Classes to SQL
Java or .NET logic is imported into the server by declaring a set of SQL classes (user defined types) to have an external
implementation. More conveniently, a .jar or .NET assembly can be imported as a unit. This causes the whole class-hierarchy
of the imported unit to be mapped into a corresponding hierarchy of SQL UDTs. All data members become members of the SQL
UDTs and all methods become methods of the UDT.
Once this is done, making a new instance of the user-defined type from SQL will make the corresponding Java or .NET instance
in the virtual machine. Calling any method of the instance will likewise call the corresponding method inside the Java or
.NET virtual machine.
Such hosted objects can be passed without restriction between SQL procedures and methods and hosted Java or .NET code. All
scalar data types are automatically converted to the closest equivalent when passing between SQL and Java or .NET.
---+++ Storing Objects
A column of a table can be declared to be of a hosted type. To do this, simply specify the SQL name of the Java or .NET
class as the column type. Instances of said class or subclasses thereof will be acceptable values as long as they are
serializable. All serialization and deserialization is transparent. If the serialization is expected to be long, the UDT
column may be declared long, meaning that a LOB is used for storing the content if the content does not fit on the row.
---+++ Invoking Methods
A method defined in a hosted language can be called identically to a native SQL method.
---+++ Security
The degree of "sandbox" enforced on hosted Java and .NET code is configurable at class-import time. Generally, operations in hosted languages should not start new threads, should not access the calling database except via a special in-process client and should return in a relatively short time.
%VOSCOPY%
CategoryWebSite CategoryVirtuoso CategoryOpenSource
|
| id
| - d52b345be86d400df65723081250df57
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| |
| links to
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is links to
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)