Re: [Middlegen-user] Wow! Synonym
Jason, It is possible that A might be left over from a table deletion and is still in your Oracle recycle bin, I've been caught out by left over tables before. I'm using 10G and classes12.jar quite happily with middlegenIDE On Sun, 3 Apr 2005 23:08:12 -0500, Jason [EMAIL PROTECTED] wrote: Using Oracle 10g and ojdbc14.jar (which is Oracles 1.4 jdbc driver). Receiving the message below outside of middlegenide, but I notice when running through middlegenide that A was listed as a table but A is not a table according Oracle EM. Any ideas? middlegen.MiddlegenException: Wow! Synonym A no t found. How can it happen? Configured schema:PPDM37 Configured catalog:null Available schemas: ANONYMOUS BI CTXSYS DBSNMP DIP DMSYS EXFSYS HR IX MDDATA MDSYS MGMT_VIEW OE OLAPSYS ORDPLUGINS ORDSYS OUTLN PM PPDM37 SCOTT SH SI_INFORMTN_SCHEMA SYS SYSMAN SYSTEM WKPROXY WKSYS WK_TEST WMSYS XDB Available catalogs: -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ middlegen-user mailing list middlegen-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/middlegen-user
RE: [Middlegen-user] Wow! Synonym
That was good info, it lead me to look at the schema itself. What I found was that A is synonym for table Area. How come middlegen is trying to load synonyms? Thought it was only supposed to read tables? J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mal Sent: Monday, April 04, 2005 3:05 AM To: middlegen-user@lists.sourceforge.net Subject: Re: [Middlegen-user] Wow! Synonym Jason, It is possible that A might be left over from a table deletion and is still in your Oracle recycle bin, I've been caught out by left over tables before. I'm using 10G and classes12.jar quite happily with middlegenIDE On Sun, 3 Apr 2005 23:08:12 -0500, Jason [EMAIL PROTECTED] wrote: Using Oracle 10g and ojdbc14.jar (which is Oracles 1.4 jdbc driver). Receiving the message below outside of middlegenide, but I notice when running through middlegenide that A was listed as a table but A is not a table according Oracle EM. Any ideas? middlegen.MiddlegenException: Wow! Synonym A no t found. How can it happen? Configured schema:PPDM37 Configured catalog:null Available schemas: ANONYMOUS BI CTXSYS DBSNMP DIP DMSYS EXFSYS HR IX MDDATA MDSYS MGMT_VIEW OE OLAPSYS ORDPLUGINS ORDSYS OUTLN PM PPDM37 SCOTT SH SI_INFORMTN_SCHEMA SYS SYSMAN SYSTEM WKPROXY WKSYS WK_TEST WMSYS XDB Available catalogs: -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ middlegen-user mailing list middlegen-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/middlegen-user --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ middlegen-user mailing list middlegen-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/middlegen-user
Re: [Middlegen-user] Wow! Synonym
I'd guess the distinction isn't made in MiddleGenIDE between tables and synonyms even though it does recognise views. I'd think there is a distinguisher in the use of the jdbc api to narrow down object types during selection. On Mon, 4 Apr 2005 10:05:17 -0500, Jason [EMAIL PROTECTED] wrote: That was good info, it lead me to look at the schema itself. What I found was that A is synonym for table Area. How come middlegen is trying to load synonyms? Thought it was only supposed to read tables? J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mal Sent: Monday, April 04, 2005 3:05 AM To: middlegen-user@lists.sourceforge.net Subject: Re: [Middlegen-user] Wow! Synonym Jason, It is possible that A might be left over from a table deletion and is still in your Oracle recycle bin, I've been caught out by left over tables before. I'm using 10G and classes12.jar quite happily with middlegenIDE On Sun, 3 Apr 2005 23:08:12 -0500, Jason [EMAIL PROTECTED] wrote: Using Oracle 10g and ojdbc14.jar (which is Oracles 1.4 jdbc driver). Receiving the message below outside of middlegenide, but I notice when running through middlegenide that A was listed as a table but A is not a table according Oracle EM. Any ideas? middlegen.MiddlegenException: Wow! Synonym A no t found. How can it happen? Configured schema:PPDM37 Configured catalog:null Available schemas: ANONYMOUS BI CTXSYS DBSNMP DIP DMSYS EXFSYS HR IX MDDATA MDSYS MGMT_VIEW OE OLAPSYS ORDPLUGINS ORDSYS OUTLN PM PPDM37 SCOTT SH SI_INFORMTN_SCHEMA SYS SYSMAN SYSTEM WKPROXY WKSYS WK_TEST WMSYS XDB Available catalogs: -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ middlegen-user mailing list middlegen-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/middlegen-user