db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vinnie DiPrenda <vdipre...@optonline.net>
Subject RE: Problems with jdbc targuet
Date Sun, 19 Oct 2003 13:30:51 GMT
I've had the same problem. If you're seeing the same thing as me, the tables
are getting created, but the id_table doesn't get populated. I don't know if
there's a setting for torque to do a "commit", but I haven't found it. What
I've been doing, is putting a "commit" at the end of the
bookstore-schema-idtable-init.sql file. It solves the problem.


-----Original Message-----
From: daniele [mailto:paguaro@fastwebnet.it]
Sent: Sunday, October 19, 2003 4:51 AM
To: Apache Torque Users List
Subject: Re: Problems with jdbc targuet

hi.
use uppercase when define the schema name into Torque.properties.

daniele


On Fri, 2003-10-17 at 11:51, Javier.Olcina@uv.es wrote:
> Hi all!
>
>    I am quite new user of Torque, I managed to make the bookstore
> example, that is in the Torque tutorial, work, but when I try to run
> the jdbc targuet to import my database schema to the Torque XML schema
> file, I do not get any content in the file even if all the messages
> seem to be correct.
>    Has anybody try this feature with Oracle? Please, would you have any
> idea why the proccess does not work properly? I enclosed you the Torque
> output and the xml file that I get.
>    I did some debugging and it seems to me that for some reason there
> is not Metadata available.
>
>
>    Thanks a lot.
>
> Javier Olcina
>
> ***************************** schema.xml *****************************
> <?xml version="1.0"?>
> <!DOCTYPE database
> SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
> <!-- Autogenerated by JDBCToXMLSchema! -->
> <database/>
> ***************************** Torque output **************************
> 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:@peloto.uv.es:1521:curidesa
> [torque-jdbc-transform] user : investi
> [torque-jdbc-transform] schema : investi
> [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: 3 seconds
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
--
Debian/Linux on Duron 700
ICQ UIN:142516098
AIM Screenname: pknauno

---------------------------------------------------------------------
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
View raw message