-
15. Re: Uanble to import metadata from Oracle database
balaji.seshadri Oct 20, 2010 12:36 PM (in response to rareddy)No importing metadata still does not work,I was thanking for the proeprty tip you gave.
-
16. Re: Uanble to import metadata from Oracle database
jdoyle Oct 20, 2010 1:14 PM (in response to balaji.seshadri)Balaji,
I've been trying to think of ways that we can track this down. I have not seen this behavior in any of the Oracle DB's I've connected with, and I have not done anything special in regards to permissions with any of my databases.
Do you have any other oracle databases that you can test with to see if this is a issue for every oracle connection you make?
~jd
-
17. Re: Uanble to import metadata from Oracle database
balaji.seshadri Nov 3, 2010 6:32 PM (in response to jdoyle)Im not able to get things imported from any account in our oracle db.
Im seeing the tables from Squirrel Client and TOAD.Please help me to resolve this issue.
-
18. Re: Uanble to import metadata from Oracle database
balaji.seshadri Nov 3, 2010 6:39 PM (in response to balaji.seshadri)Please find data tools plugin details.If thats helpful.
-
datatools.jpg 206.4 KB
-
-
19. Re: Uanble to import metadata from Oracle database
jdoyle Nov 4, 2010 11:39 AM (in response to balaji.seshadri)Balaji,
I suggest you try debugging the Oracle driver when it's called by the JDBC Importer and comparing the log with what you see with debugging from Squirrel or TOAD.
I am following the directions for this from here: http://www.rgagnon.com/javadetails/java-0663.html.
I'm struggling a bit with getting the output from eclipse. If I run a debug version of Teiid Designer I get the output in my console, but if I launch normally the output is lost.
-
20. Re: Uanble to import metadata from Oracle database
rareddy Nov 4, 2010 12:04 PM (in response to balaji.seshadri)Balaji,
Lets take different course and try to use this source with Dynamic VDB. See if you see any tables.
Ramesh..