Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: <004401c47ab1$195ef4b0$6d1aa8c0@ascindia.com>
From: "Megha Audichya" <amegha@ascindia.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
References: <1091647151.2424b240saravkrish@uky.edu>
Subject: Re: Generating XML from JDBC connection
Date: Thu, 5 Aug 2004 11:27:32 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0041_01C47ADF.32BC8D90"

------=_NextPart_000_0041_01C47ADF.32BC8D90
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi All

I encountered the same problem too.=20
JDBC target requires various parameters to be passed out of which schema =
is the one that was the root cause of my problem.
TorqueJDBCTransformTask class internally looks for the table list based =
on the DataBaseMetaData.
The class calls
tableNames =3D dbMeta.getTables(null, dbSchema, "%", types);

Here dbschema (passed as a parameter) is the schemaPattern=20

schemaPattern - a schema name pattern; must match the schema name as it =
is stored in the database; "" retrieves those without a schema; null =
means that the schema name should not be used to narrow the search

If schema is not passed as a parameter in the jdbc target thereby =
passing schemapattern as null solves the problem.

Dont pass schema in the target and your problem should be solved.


Thanks
Megha Audichya


----- Original Message -----=20
From: "Saravana Krishnan Kannan" <saravkrish@uky.edu>
To: <torque-user@db.apache.org>
Sent: Thursday, August 05, 2004 12:49 AM
Subject: Re: Generating XML from JDBC connection


> Thats the way it works. It's limited in what it converts to xml =
schema. You will have to add a lot of additional properties/entities =
manually.
>=20
> -Sarav
>=20
>=20
> -----Original Message-----
> From: Derek Anderson <derek@kered.org>
> To: torque-user@db.apache.org
> Date: Wed, 04 Aug 2004 08:51:06 -0500
> Subject: Generating XML from JDBC connection
>=20
> Hey everyone,
>=20
> I'm trying to generate a schema off our existing oracle database using =
the=20
> torque generator.  The jdbc build target is completing successfully, =
yet the=20
> schema file is woefully incomplete.  Does anyone have a suggestion?
>=20
> Here is the ant output:
>=20
> C:\home\projects\EMS.torque\torque-gen-3.1>ant -f build-torque.xml =
jdbc
> Buildfile: build-torque.xml
>=20
> jdbc:
>       [echo] +-----------------------------------------------+
>       [echo] |                                               |
>       [echo] | Generating XML from JDBC connection !         |
>       [echo] |                                               |
>       [echo] +-----------------------------------------------+
> [torque-jdbc-transform] Torque - JDBCToXMLSchema starting
> [torque-jdbc-transform] Your DB settings are:
> [torque-jdbc-transform] driver : oracle.jdbc.driver.OracleDriver
> [torque-jdbc-transform] URL : =
jdbc:oracle:thin:@192.server.ip.1:1601:EMS920
> [torque-jdbc-transform] user : ems
> [torque-jdbc-transform] schema : EMS920
> [torque-jdbc-transform] DB driver sucessfuly instantiated
> [torque-jdbc-transform] DB connection established
> [torque-jdbc-transform] Getting table list...
> [torque-jdbc-transform] Building column/table map...
> [torque-jdbc-transform] ./schema/schema.xml
> [torque-jdbc-transform] Torque - JDBCToXMLSchema finished
>=20
> BUILD SUCCESSFUL
> Total time: 2 seconds
>=20
>=20
> And the resulting schema.xml:
>=20
> C:\home\projects\EMS.torque\torque-gen-3.1>cat schema\schema.xml
> <?xml version=3D"1.0"?>
> <!DOCTYPE database SYSTEM =
"http://db.apache.org/torque/dtd/database_3_1.dtd">
> <!-- Autogenerated by JDBCToXMLSchema! -->
> <database/>
>=20
>=20
> Thanks,
> --=20
> -- ----------------------------------------------- --
> ~   ____ ___  ___                Derek C. Anderson  ~
> ~  |  _ | _ \| __|  Computer Scientist / Tech Lead  ~
> ~  | | || __/||      Computer Sciences Corporation  ~
> ~  | |_||  \ ||_--   http://kered.org/professional  ~
> ~ (_)___|_|_\|___/                 derek@kered.org  ~
> -- ----------------------------------------------- --
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>=20
>=20
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>=20
>=20
> 
------=_NextPart_000_0041_01C47ADF.32BC8D90--