db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sperlich, Tino" <t.sperl...@hpc-hamburg.de>
Subject AW: Creating XML Database schema file from existing Database schema.
Date Thu, 29 Jan 2004 13:51:18 GMT
Hi Edwin,

you are right, it's build.properties

One thing strikes me here, 
use UPPERCASE for your schema name, e.g. IDEMP

here is my file for reference:

torque.addGetByNameMethod = true
torque.database.driver = oracle.jdbc.driver.OracleDriver
torque.database.host = <host-IP>
torque.project = pzp
torque.database.schema = PORTAL_PZP
torque.database.manualCreation = true
torque.database.user = portal_pzp
torque.database.url = jdbc:oracle:thin:@<host-IP>:1521:alias
torque.database.password = xxxx
torque.database = oracle
torque.database.name = pzp
torque.useManagers = false
torque.sameJavaName = false
torque.addTimeStamp = true
torque.basePrefix = Base
torque.complexObjectModel = true
torque.useClasspath = false
torque.targetPackage = de.xxxx
torque.java.dir = ../WEB-INF/src
torque.addIntakeRetrievable = false
torque.addSaveMethod = true


HTH,

Tino

-----Urspr√ľngliche Nachricht-----
Von: Edwin Yearwood [mailto:Edwin.Yearwood@reuters.com]
Gesendet: Donnerstag, 29. Januar 2004 14:47
An: Apache Torque Users List
Betreff: RE: Creating XML Database schema file from existing Database
schema.


Hi Sperlich,

Should I be using torque.properties or build.properties. I thought torque.properties was used
during execution and build.properties for class generation and other such build requirements.
Anyway the resulting schema file is empty, but the "ant -f build-torque.xml jdbc" completes
successfully, have you any idea why this would happen.

Here's an example of my build.properties.

torque.targetPackage = com.reuters.torque
torque.database.createUrl = jdbc:oracle:thin:@<host>:<port>:idem
torque.database.buildUrl = jdbc:oracle:thin:@<host>:<port>:idem
torque.database.url = jdbc:oracle:thin:@<host>:<port>:idem
torque.database.driver = oracle.jdbc.driver.OracleDriver
torque.database.user = idemp
torque.database.password = idemp
torque.database.host = <host>
torque.database = oracle
torque.sameJavaName = false
torque.database.default=idem
torque.database.schema = idemp
torque.database.idem.adapter=oracle
torque.project = idem

Thanks.

Edwin Yearwood
Developer
BTG
Reuters

Telephone		+44 (0)208 542 5818
Email			edwin.yearwood@reuters.com
Reuters Messaging 	edwin.yearwood.reuters.com@reuters.net

-----Original Message-----
From: Sperlich, Tino [mailto:t.sperlich@hpc-hamburg.de] 
Sent: 29 January 2004 12:00
To: Apache Torque Users List
Subject: AW: Creating XML Database schema file from existing Database schema.


Hi,

try setting up your Torque project as described in 
the user guide. (especially edit torque.properties to 
reflect your db-setting)

then run the build-torque.xml with ant using the task "jdbc" , 
that connects to your db and generates and xxx-schema.xml

On my machine it took a while for the task to complete (~10-15 min), 
but it was running stable...


HTH,

TIno


-----Urspr√ľngliche Nachricht-----
Von: Edwin Yearwood [mailto:Edwin.Yearwood@reuters.com]
Gesendet: Donnerstag, 29. Januar 2004 12:55
An: torque-user@db.apache.org
Betreff: Creating XML Database schema file from existing Database schema.


Hi,

Does anyone know whether torque can create the XML database schema file "myproject-schema.xml"
from an existing Database schema. If this question has been asked before can you direct me
to the answer in torque's mail archive.

Thanks.

Edwin Yearwood
Developer
BTG
Reuters

Telephone		+44 (0)208 542 5818
Email			edwin.yearwood@reuters.com
Reuters Messaging 	edwin.yearwood.reuters.com@reuters.net


-------------------------------------------------------------- --
        Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more information and to register,
visit http://www.reuters.com/messaging

Any views expressed in this message are those of  the  individual sender,  except  where 
the sender specifically states them to be the views of Reuters Ltd.


---------------------------------------------------------------------
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



--------------------------------------------------------------- -
        Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging

Any views expressed in this message are those of  the  individual
sender,  except  where  the sender specifically states them to be
the views of Reuters Ltd.


---------------------------------------------------------------------
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