Re: Wow! Synonym
Mal <[email protected]> Mon, 04 Apr 2005 16:16:02 +0100
| Newsgroups | gmane.comp.java.ejb.middlegen.user |
|---|---|
| Message-ID | <opsoprc0ofrdedtm@uknotebook01186> |
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: [email protected] > 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=6595&alloc_id=14396&op=click