Re: [Middlegen-user] Wow! Synonym

2005-04-04 Thread 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

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

2005-04-04 Thread 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: [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

2005-04-04 Thread 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.

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