Jboss Data Virtualization

jdv.adoc

Web Service SOAP

1. Selecionar o VBL > Modeling > Create Web Service

2. Adicionar no VBL

3. Gerar o .war > Click direito no .vdb > Modeling > Generate SOAP WAR

   • IP: 10.19.150.125

   • Location: /opt/redhat/eap-6.4.0/standalone/deployments

   • URL: http://IP:8080/VDB-NAME/LDAP_VBL_DC_ext?wsdl

     A partir desse momento ele pode ser visualizado em: http://10.19.150.125:9990/console/App.html#webservice-runtime

     Executar Web Service pelo Database Development

     EXEC LDAP_VBL_WS.LDAP_VBL_DC_ext.getDC_ext();

Web Service REST

Clique direito no VBL > New Child > Procedure

• Name: Users

• Check Enable REST for this procedure

• Rest Method: GET

• URI: getUsers

• Character set: UTF-8

• Transformation SQL:

  BEGIN
  	SELECT XMLELEMENT(NAME users, XMLAGG(XMLELEMENT(NAME Users_VBL.LDAP_Users, XMLFOREST(Users_VBL.LDAP_Users.name, Users_VBL.LDAP_Users.description)))) AS result FROM Users_VBL.LDAP_Users;
  END

Click direito VDB > Generate Rest WAR

• Context-name: globo-jdv-rest

• VDB JNDI NAME: java:jboss/datasources/Oracle

• Location: /opt/redhat/eap-6.4.0/standalone/deployments

Cache

Exemplo de cache para 10 segundos, cache é representado em ms.

/*+ cache(ttl:10000) */

Exemplo para 24h

/*+ cache(ttl:86400000) */

Dashboard

http://10.19.150.125:8080/dashboard

1. Configura uma external connection

   Name: vdb-name
   JNDI path: java:/vdb-name

   Test Query: select 1

2. Configura um Data provider

   SELECT * FROM Users_VBL.LDAP_Users;

3. Cria um workspace

4. Cria uma page