db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edwin Yearwood <Edwin.Yearw...@reuters.com>
Subject RE: Creating XML Database schema file from existing Database schema.
Date Thu, 29 Jan 2004 14:04:31 GMT
Thanks Sperlich,

That did the trick, whoo hoo!

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 13:51
To: Apache Torque Users List
Subject: AW: Creating XML Database schema file from existing Database schema.


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



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


Mime
View raw message