[Middlegen-user] Wow! Synonym

[Jason]

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:

[Mal]

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

Post by Jason
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
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

[Jason]

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: middlegen-user-***@lists.sourceforge.net
[mailto:middlegen-user-***@lists.sourceforge.net] On Behalf Of Mal
Sent: Monday, April 04, 2005 3:05 AM
To: middlegen-***@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

Post by Jason
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
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

[Mal]

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.

Post by Jason
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-----
Sent: Monday, April 04, 2005 3:05 AM
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

Post by Jason
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
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