Middlegen

Tracker: Bugs

5 Middlegen cannot deal with Synonyms in Oracle - ID: 1156698

Last Update: Comment added ( benlitchfield )

Details:

Running Middlegen against an older Oracle db, and it
drops this error regarding the synonyms in the schema.
$ ant
Buildfile: build.xml

init:

fail-if-no-xdoclet-1.2:

check-driver-present:

panic-if-driver-not-present:

middlegen:
[middlegen] Database
URL:jdbc:oracle:thin:@iddb02.lab.usi.net:1521:XPDWACD1
[middlegen] No <table> elements specified. Reading all
tables. This might take a while...

BUILD FAILED
C:\Documents and Settings\#taustin\Desktop\dev
downloads\middlegen-2.1\samples\b
uild.xml:228: middlegen.MiddlegenException: Wow!
Synonym CDCREDITREQUEST_SN not found. How can it happen?
Configured schema:IWDEV
Configured catalog:
Available schemas:
DBSNMP
IWDEV
OUTLN
PRODQUERY
SYS
SYSTEM
UPDATENOC
Available catalogs:

Submitted:

Tate Austin ( ravalox ) - 2005-03-04 14:40

Priority:

Status:

Closed

Resolution:

Fixed

Assigned:

Aslak Helles�y

Category:

database reading

Group:

None

Visibility:

Public

Comments ( 2 )

Date: 2005-03-26 22:38 Sender: benlitchfield Logged In: YES user_id=601708 This has been fixed in CVS. Please give it a try. Ben Litchfield
Date: 2005-03-18 16:18 Sender: kentsnow Logged In: YES user_id=1241982 Also see bug: 1084995 Class: MiddlegenPopulator.java version: 2.1 Line: 675 ps = getConnection().prepareStatement("select table_owner from sys.all_synonyms where table_name=? and owner=?"); The select statement is invalid...the method arg is: String synonymName so the prepared statement should read: ps = getConnection().prepareStatement("select table_owner from sys.all_synonyms where SYNONYM_NAME=? and owner=?");

Date: 2005-03-26 22:38
Sender: benlitchfield

Logged In: YES
user_id=601708

This has been fixed in CVS. Please give it a try.

Ben Litchfield

Date: 2005-03-18 16:18
Sender: kentsnow

Logged In: YES
user_id=1241982

Also see bug: 1084995

Class: MiddlegenPopulator.java
version: 2.1
Line: 675

ps = getConnection().prepareStatement("select table_owner
from sys.all_synonyms where table_name=? and owner=?");

The select statement is invalid...the method arg is: String
synonymName so the prepared statement should read:

ps = getConnection().prepareStatement("select table_owner
from sys.all_synonyms where SYNONYM_NAME=? and
owner=?");

Log in to comment.

Attached File

Changes ( 3 )

Field	Old Value	Date	By
status_id	Open	2005-03-26 22:38	benlitchfield
resolution_id	None	2005-03-26 22:38	benlitchfield
close_date	-	2005-03-26 22:38	benlitchfield

Middlegen

Tracker: Bugs

Comments ( 2 )

Log in to comment.

Attached File

No Files Currently Attached

Changes ( 3 )

About SourceForge

Find Software

Develop Software

Community

Help