db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Megha Audichya" <ame...@ascindia.com>
Subject Re: Generating XML from JDBC connection
Date Thu, 05 Aug 2004 05:57:32 GMT
Hi All

I encountered the same problem too. 
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 = dbMeta.getTables(null, dbSchema, "%", types);

Here dbschema (passed as a parameter) is the schemaPattern 

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 ----- 
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.
> 
> -Sarav
> 
> 
> -----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
> 
> Hey everyone,
> 
> I'm trying to generate a schema off our existing oracle database using the 
> torque generator.  The jdbc build target is completing successfully, yet the 
> schema file is woefully incomplete.  Does anyone have a suggestion?
> 
> Here is the ant output:
> 
> C:\home\projects\EMS.torque\torque-gen-3.1>ant -f build-torque.xml jdbc
> Buildfile: build-torque.xml
> 
> 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
> 
> BUILD SUCCESSFUL
> Total time: 2 seconds
> 
> 
> And the resulting schema.xml:
> 
> C:\home\projects\EMS.torque\torque-gen-3.1>cat schema\schema.xml
> <?xml version="1.0"?>
> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
> <!-- Autogenerated by JDBCToXMLSchema! -->
> <database/>
> 
> 
> Thanks,
> -- 
> -- ----------------------------------------------- --
> ~   ____ ___  ___                Derek C. Anderson  ~
> ~  |  _ | _ \| __|  Computer Scientist / Tech Lead  ~
> ~  | | || __/||      Computer Sciences Corporation  ~
> ~  | |_||  \ ||_--   http://kered.org/professional  ~
> ~ (_)___|_|_\|___/                 derek@kered.org  ~
> -- ----------------------------------------------- --
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> 
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message