[Middlegen-user] Using Middlegen with oracle 9i

Discussion:

Indra Adnyana

2003-02-26 09:00:06 UTC

Hi there,

Are there anyone here who already tried middlegen with Oracle 9.0.1?
I tried today with no success. Please help.

I downloaded Middlegen 2.0b1 in binary form.

This is the output:

C:\DevTools\middlegen\samples>ant
Buildfile: build.xml

check-driver-present:

panic-if-driver-not-present:

middlegen:
[middlegen] Database URL:jdbc:oracle:thin:@10.1.0.3:1521:srengsng
[middlegen] No <table> elements specified. Reading all tables. This
might take a
while...

BUILD FAILED
file:C:/DevTools/middlegen/samples/build.xml:95:
middlegen.MiddlegenException: M
iddlegen successfully connected to the database, but couldn't find any
tables. P
erhaps the specified schema or catalog is wrong? -Or maybe there aren't
any tabl
es in the database at all?

This is the oracle.xml:

<property name="database.script.file"
value="${src.dir}/sql/${name}-oracle.sql"/>
<property name="database.driver.file"
value="C:\oracle\ora90\jdbc\lib\classes12.jar"/>
<property name="database.driver.classpath"
value="${database.driver.file}"/>
<property name="database.driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url"
value="jdbc:oracle:thin:@10.1.0.3:1521:srengsng"/>
<property name="database.userid" value="system"/>
<property name="database.password" value="manager"/>
<property name="database.schema" value=""/>
<property name="database.catalog" value=""/>

build.xml stayed intact, except in the DOCTYPE section.

<!DOCTYPE project [
<!ENTITY database SYSTEM "file:./config/database/oracle.xml">
<!ENTITY ejb SYSTEM "file:./config/ejb/weblogic.xml">
]>

Thanks in advance

Indra Adnyana
***@sadikungroup.com

Eivind Waaler

2003-02-26 09:40:01 UTC

Permalink

Hi, sounds like you need to set the schema attribute of the jdbc
connection. Make sure it's set in both the jdbc xml file and the
<middlegen> taks. Check the following mail:

http://sourceforge.net/mailarchive/message.php?msg_id=3571915

.eivind

Post by Indra Adnyana
Hi there,
Are there anyone here who already tried middlegen with Oracle 9.0.1?
I tried today with no success. Please help.
I downloaded Middlegen 2.0b1 in binary form.
C:\DevTools\middlegen\samples>ant
Buildfile: build.xml
[middlegen] No <table> elements specified. Reading all tables. This
might take a
while...
BUILD FAILED
middlegen.MiddlegenException: M
iddlegen successfully connected to the database, but couldn't find any
tables. P
erhaps the specified schema or catalog is wrong? -Or maybe there aren't
any tabl
es in the database at all?
<property name="database.script.file"
value="${src.dir}/sql/${name}-oracle.sql"/>
<property name="database.driver.file"
value="C:\oracle\ora90\jdbc\lib\classes12.jar"/>
<property name="database.driver.classpath"
value="${database.driver.file}"/>
<property name="database.driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url"
<property name="database.userid" value="system"/>
<property name="database.password" value="manager"/>
<property name="database.schema" value=""/>
<property name="database.catalog" value=""/>
build.xml stayed intact, except in the DOCTYPE section.
<!DOCTYPE project [
<!ENTITY database SYSTEM "file:./config/database/oracle.xml">
<!ENTITY ejb SYSTEM "file:./config/ejb/weblogic.xml">
]>
Thanks in advance
Indra Adnyana

a***@netcom.no

2003-02-26 09:51:04 UTC

Permalink

You must specify schema and/or catalog.

Aslak

----- Original Message -----
From: "Indra Adnyana" <***@sadikungroup.com>
Date: Wednesday, February 26, 2003 10:54 am
Subject: [Middlegen-user] Using Middlegen with oracle 9i

Post by Indra Adnyana
Hi there,
Are there anyone here who already tried middlegen with Oracle
9.0.1?
I tried today with no success. Please help.
I downloaded Middlegen 2.0b1 in binary form.
C:\DevTools\middlegen\samples>ant
Buildfile: build.xml
[middlegen] No <table> elements specified. Reading all tables. This
might take a
while...
BUILD FAILED
middlegen.MiddlegenException: M
iddlegen successfully connected to the database, but couldn't find any
tables. P
erhaps the specified schema or catalog is wrong? -Or maybe there
aren'tany tabl
es in the database at all?
<property name="database.script.file"
value="${src.dir}/sql/${name}-oracle.sql"/>
<property name="database.driver.file"
value="C:\oracle\ora90\jdbc\lib\classes12.jar"/>
<property name="database.driver.classpath"
value="${database.driver.file}"/>
<property name="database.driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url"
<property name="database.userid" value="system"/>
<property name="database.password" value="manager"/>
<property name="database.schema" value=""/>
<property name="database.catalog" value=""/>
build.xml stayed intact, except in the DOCTYPE section.
<!DOCTYPE project [
<!ENTITY database SYSTEM "file:./config/database/oracle.xml">
<!ENTITY ejb SYSTEM "file:./config/ejb/weblogic.xml">
]>
Thanks in advance
Indra Adnyana

Indra Adnyana

2003-02-28 02:09:15 UTC

Permalink

Well, thanks so much. That trick did it all. Surely that one is a very
common problem. :) I put the username into ${database.schema} and passed
its value into middlegen task, and bump! There goes the tables..

Thank you guys, you really did save my neck. :)

cheers,
Indra Adnyana

-----Original Message-----
From: middlegen-user-***@lists.sourceforge.net
[mailto:middlegen-user-***@lists.sourceforge.net] On Behalf Of Eivind
Waaler
Sent: 26 Februari 2003 18:39
To: middlegen-***@lists.sourceforge.net
Subject: Re: [Middlegen-user] Using Middlegen with oracle 9i

Hi, sounds like you need to set the schema attribute of the jdbc
connection. Make sure it's set in both the jdbc xml file and the
<middlegen> taks. Check the following mail:

http://sourceforge.net/mailarchive/message.php?msg_id=3571915

.eivind

aren't

Post by Indra Adnyana
any tabl
es in the database at all?
<property name="database.script.file"
value="${src.dir}/sql/${name}-oracle.sql"/>
<property name="database.driver.file"
value="C:\oracle\ora90\jdbc\lib\classes12.jar"/>
<property name="database.driver.classpath"
value="${database.driver.file}"/>
<property name="database.driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url"
<property name="database.userid" value="system"/>
<property name="database.password" value="manager"/>
<property name="database.schema" value=""/>
<property name="database.catalog" value=""/>
build.xml stayed intact, except in the DOCTYPE section.
<!DOCTYPE project [
<!ENTITY database SYSTEM "file:./config/database/oracle.xml">
<!ENTITY ejb SYSTEM "file:./config/ejb/weblogic.xml">
]>
Thanks in advance
Indra Adnyana

-------------------------------------------------------
This SF.net email is sponsored by: Scholarships for Techies!
Can't afford IT training? All 2003 ictp students receive scholarships.
Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more.
www.ictp.com/training/sourceforge.asp