why my vdb 'state is alwarys loading

[uuliver]

<?xml version="1.0" ?>

<vdb name="ln622" version="1">

<description>VDB for: ln622, Version: 1</description>

<connection-type>BY_VERSION</connection-type>

<property name="{http://teiid.org/rest}auto-generate" value="true"></property>

<model name="bln" type="PHYSICAL" visible="true">

<property name="importer.tableTypes" value="TABLE"></property>

<source name="test" translator-name="oracle" connection-jndi-name="java:/OracleGeol"></source>

</model>

</vdb>

Deployed Virtual Databases list show the state is loading ,

exception is

TEIID11010 java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@55daac3a

[rareddy]

Did you create the datasource for the JNDI name "java:/OracleGeol"? The exception is saying there is an issue with the datasource. I can't really say what that is because you only posted part of the exception.

[uuliver]

i am sure i have create the datasoruce for the jndi name "java:/OracleGeol" ,i posted my code tommorow thank you for help,

[uuliver]

[uuliver]

TEIID500029 what means

[rareddy]

Also set the "schemaPattern" on the importer properties.

[uuliver]

set the "schemaPattern" on the importer properties. also is loading

<?xml version="1.0" ?>

<vdb name="ln628" version="1">

<description>VDB for: ln628, Version: 1</description>

<connection-type>BY_VERSION</connection-type>

<model name="Geol" type="PHYSICAL" visible="true">

<source name="Geol" translator-name="oracle" connection-jndi-name="java:/OracleGeol"></source></model>

<model name="Epbank" type="PHYSICAL" visible="true">

<source name="Epbank" translator-name="oracle" connection-jndi-name="java:/Epbank"></source></model>

<model name="myViewModel" type="VIRTUAL" visible="true"><metadata type="DDL"><![CDATA[create view bookInfo (TITLE string(255),SUBTITLE string(255)) as select Epbank.A1_DASHBOARD.menu_name,Geol.A1_GEOL_DESIGN.well_common_name from Epbank.A1_DASHBOARD,Geol.A1_GEOL_DESIGN;]]></metadata></model>

</vdb>

this deploy string ,the model geol and epbank ,is always loading ,

[uuliver]

after several Minute the epbank model state change failed ,

TEIID50029 VDB ln628.1 model "Epbank" metadata is currently being loaded. Start Time: 17-6-26 下午4:43

TEIID60011 No column found on table Epbank.MDSYS.SYS_NTj4Pd6KReXlTgQOUKi4pslA== with name NESTED_TABLE_ID

[uuliver]

set the "schemaPattern" on the importer properties.

<?xml version="1.0" ?><vdb name="ln626" version="1"><description>VDB for: ln626, Version: 1</description><connection-type>BY_VERSION</connection-type>

<model name="test" type="PHYSICAL" visible="true">

<property name="importer.tableTypes" value="TABLE,VIEW"></property>

<property name="importer.schemaPattern" value="PRODUCTS"></property>

<source name="test" translator-name="oracle" connection-jndi-name="java:/OracleGeol"></source>

</model></vdb>

and vdb is deploy failed

TEIID31070 Empty model;There are no tables, procedures or functions defined in this model test

[rareddy]

That means you do not have a schema called "PRODUCTS" in your Oracle database, or there are no tables in that schema.

[uuliver]

and what about this means

TEIID50029 VDB ln628.1 model "Epbank" metadata is currently being loaded. Start Time: 17-6-26 下午4:43

TEIID60011 No column found on table Epbank.MDSYS.SYS_NTj4Pd6KReXlTgQOUKi4pslA== with name NESTED_TABLE_ID

[rareddy]

Try "importer.importApproximateIndexes" to false as another property?

[uuliver]

if a model dont set property like this

<model name="bln" type="PHYSICAL" visible="true">

<source name="test" translator-name="oracle" connection-jndi-name="java:/OracleGeol"></source>

</model>

what about the default property

[rareddy]

When you leave like that, Oracle has side effect to download metadata about all the databases in your Oracle database.

[uuliver]

set"importer.importApproximateIndexes" to false as another property still has error