We are having problems when we are importing synonyms into VDB. It's not importing any column data for a synonym.

We will be able to get the column data with the following steps.

1. Get the actual table and owner schema of the table on which synonym is created from USER_SYNONYMS system table.
2. Call DataBaseMetaData.getColumns(null,<owner schema of the actual table>, <actual table>, "%");

I hope this will be useful.

Regards

Ram


> From: rareddy@redhat.com
> To: teiid-dev@lists.jboss.org; teiid-users@lists.jboss.org
> Date: Thu, 3 Sep 2009 09:29:55 -0500
> Subject: [teiid-dev] Teiid 6.2 M3
>
> Good morning,
>
> Teiid 6.2-M3 is now available for download at
>
> http://www.jboss.org/teiid/downloads.html
>
> all the major features slated for 6.2 are in this release, we will work
> few more bug fixes and integration issues and be ready for 6.2 stable
> release on September 14th.
>
> Please take for test drive and let us know if you see any issues. The
> documentation related to this release at
>
> https://www.jboss.org/community/wiki/TheTeiidProject
>
>
> Thank you.
>
> Ramesh..
>
> _______________________________________________
> teiid-dev mailing list
> teiid-dev@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/teiid-dev

---

Match ‘n’ Make new friends with the cool match-meter. Join the Planet with you Hotmail ID. Drag n’ drop