Attachment 846122 Details for Bug 1022586 – Tested Teiid artifact #1

Tested Teiid artifact #1

infinispancache-vdb.xml (text/xml), 2.78 KB, created by Stefan Bunciak on 2014-01-06 14:28:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Stefan Bunciak

Created: 2014-01-06 14:28:59 UTC

Size: 2.78 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8" standalone="yes"?>
><vdb name="SmallAs" version="1">
>
>    <description>Shows how to call an Infinispan local cache</description>
>    
>    <property name="UseConnectorMetadata" value="cached" />
>    <model name="SmallAs" visible="false">
>        <source name="objsource" translator-name="infinispan1" connection-jndi-name="java:/infinispanTest" />
>        <metadata type="DDL"><![CDATA[
>            CREATE FOREIGN TABLE SmallAs (SmallAObject Object OPTIONS (NAMEINSOURCE 'this', SEARCHABLE 'Unsearchable')) OPTIONS (NAMEINSOURCE 'local-quickstart-cache') ;
>         ]]> </metadata>
>    </model>
>    <model name="BQT1" type="VIRTUAL">
>        <metadata type="DDL"><![CDATA[
>            CREATE VIEW SmallA (
>		intKey integer PRIMARY KEY,
>		dateValue date,
>		stringKey string,
>		intNum integer,
>		stringNum string,
>		floatNum float,
>		doubleNum double,
>		longNum long,
>		byteNum byte,
>		timeValue time,
>		timestampValue timestamp,
>		booleanValue boolean,
>		charValue char,
>		shortValue short,
>		bigIntegerValue biginteger,
>		bigDecimalValue bigdecimal,
>		objectValue Object
>            )
>            AS
>            SELECT o.intKey,
>	    o.dateValue, 
>	    o.stringKey, 
>	    o.intNum, 
>	    o.stringNum, 
>	    o.floatNum, 
>	    o.doubleNum,
>	    o.longNum,
>	    o.byteNum, 
>	    o.timeValue, 
>	    o.timestampValue, 
>	    o.booleanValue, 
>	    o.charValue, 
>	    o.shortValue, 
>	    o.bigIntegerValue, 
>	    o.bigDecimalValue, 
>	    o.objectValue FROM SmallAs as T, OBJECTTABLE( 'x' PASSING T.SmallAObject AS x COLUMNS intKey integer 'teiid_row.intKey',
>	    dateValue date 'teiid_row.dateValue', 
>	    stringKey string 'teiid_row.stringKey',
>	    intNum integer 'teiid_row.intNum',
>	    stringNum string 'teiid_row.stringNum', 
>	    floatNum float 'teiid_row.floatNum', 
>	    longNum long 'teiid_row.longNum', 
>	    doubleNum double 'teiid_row.doubleNum', 
>	    byteNum byte 'teiid_row.byteNum', 
>	    timeValue time 'teiid_row.timeValue', 
>	    timestampValue timestamp 'teiid_row.timeStampValue', 
>	    booleanValue boolean 'teiid_row.booleanValue', 
>	    charValue char 'teiid_row.charValue', 
>	    shortValue short 'teiid_row.shortValue', 
>            bigIntegerValue biginteger 'teiid_row.bigIntegerValue',
>	    bigDecimalValue bigdecimal 'teiid_row.bigDecimalValue', 
>	    objectValue Object 'teiid_row.objectValue'
>	    ) as o;
>            
>        ]]> </metadata>
>    </model>
>    <translator name="infinispan1" type="infinispan-cache">
>        
>        <property name="SupportsLuceneSearching" value="false"/>
>        
>        
>        
>
>    </translator>
></vdb>

Actions: View

Attachments on bug 1022586: 846122 | 846124