[teiid-users] Simple example (reading a CSV file) needed

[Torsten Schlabach]

Hi Ramesh!

Thanks for your hints, especially for the missing link to the video. This indeed helped me a lot.

I am not stuck with 2 problems, no idea if they are related or not:

1. Despite having a Connector connected to my model, I don't get this "Running man" icon enabled to try and see my data from my CSV file.
2. When I try and execute the VDB and try to make a SELECT * from from my virtual table which is a CSV file, I am stuck with this expection:

Caused by: org.teiid.connector.api.ConnectorException: Error trying to obtain connector metadata properties for sample.NewBaseTable. Group properties are not specified in the descriptor file.

What are those "group properties" mentioned there?

Regards,
Torsten

-------- Original-Nachricht --------
> Datum: Mon, 24 Aug 2009 12:23:43 -0500
> Von: Ramesh Reddy <rareddy at redhat.com>
> An: Torsten Schlabach <TSchlabach at gmx.net>
> CC: teiid-users at lists.jboss.org
> Betreff: Re: [teiid-users] Simple example (reading a CSV file) needed

> 
> On Mon, 2009-08-24 at 12:17 +0200, Torsten Schlabach wrote:
> > Where in the Designer would I have to create those two files? Looking at
> the examples in the designer, I cannot spot any files which look like
> that.
> These are simple text files, you can create them using any text editor
> either using eclipse or some other external editor.
> 
> 
> > > 3. Import the Derby database's "account" schema into a source model.
> > 
> > How would I do that???
> If go to File -> Import -> Import from JDBC
> once the wizard comes up follow it to define the connection and
> importing metadata
> http://docs.jboss.org/teiid/designer/6.0/user-guide/importers-chapter.html#jdbc-import-section
> 
> 
> > 
> > > 4. Manually create the source model for the "Text File". Create a
> Table 
> >      called "Price" with "stock" and "price" as column names
> > 
> > Again, how would I do that? I don't see anything called "Source Model"
> in my designer.
> > 
> see
> http://docs.jboss.org/teiid/designer/6.0/user-guide/newmodels-chapter.html#new-relational-source-model
> 
> > Also for the remaining steps, I just cannot find the elements in my
> designer which the steps talk about.
> > 
> > Any hints are welcome!
> > 
> There is video, for which a link is missing. Watch this
> http://docs.jboss.org/teiid/6.1/quick-start-guide/en-US/html/images/EmbeddedDesignerExampleVideo.swf
> 
> 
> Hope this helps.
> 
> Ramesh..
> 
> _______________________________________________
> teiid-users mailing list
> teiid-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-users