You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Ja...@uv.es on 2003/10/17 11:51:36 UTC
Problems with jdbc targuet
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
Re: Problems with jdbc target
Posted by pa...@fastwebnet.it.
i have made a mistake on file properties.
using the torque gen (i use the 3.1 version) i have configurated the build.properties
with this value
torque.project = myproject
torque.database = oracle
torque.database.createUrl = jdbc:oracle:thin:@myhostdb:1521:mysid
torque.database.buildUrl = jdbc:oracle:thin:@myhostdb:1521:mysid
torque.database.url = jdbc:oracle:thin:@myhostdb:1521:mysid
torque.database.driver = oracle.jdbc.driver.OracleDriver
torque.database.user = user
torque.database.password = pwd
torque.database.schema = SCHEMA
torque.database.host = myhostdb
with this option the jdbc target work (on my project).
sorry for my english.
bye
daniele
>-- Original Message --
>Reply-To: "Apache Torque Users List" <to...@db.apache.org>
>Date: Mon, 20 Oct 2003 07:28:48 +0200
>From: David Solbach <de...@gmx.de>
>To: "Apache Torque Users List" <to...@db.apache.org>
>Subject: Re: Problems with jdbc targuet
>
>
>What she means, is the jdbc target, not the init target. I think she's
trying to create the schema files out of an existing database, which
would be interesting for me, too. So, help her! ;)
David
> -----Original Message-----
> From: daniele [mailto:paguaro@fastwebnet.it]
> Sent: S
>nday, 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.Olci
>a@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
> >
>chema 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 th
>
> > 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
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Problems with jdbc targuet
Posted by David Solbach <de...@gmx.de>.
What she means, is the jdbc target, not the init target. I think she's
trying to create the schema files out of an existing database, which
would be interesting for me, too. So, help her! ;)
David
On Sun, 19 Oct 2003 09:30:51 -0400
Vinnie DiPrenda <vd...@optonline.net> wrote:
> 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
>
--
--
David Solbach
public key ID: 6372ED85
http://wwwkeys.pgp.net/
--
RE: Problems with jdbc targuet
Posted by Vinnie DiPrenda <vd...@optonline.net>.
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
Re: Problems with jdbc targuet
Posted by daniele <pa...@fastwebnet.it>.
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