I just checked - it works (somewhat - see below).
The sequence to get it working is quite simple:
1) deploy torque (ant dist)
2) go to torque install ( bin/torque/torque )
3) edit build.properties and put your jdbc driver to lib/
4) do 'ant project-jdbc'
5) rename schema/schema.xml to yourprojectname-schema.xml
6) do 'ant project-datadtd' (produces src/yourprojectname-data.dtd)
7) do 'ant project-datadump' (produces
src/yourprojectname-default-all-data.xml)
8) copy src/yourprojectname-data.dtd to schema/ and
src/yourprojectname-default-all-data.xml to schema/yourprojectname-data.xml
9) do 'and project-datasql' (produces src/yourprojectname-data.sql)
problems:
1) only templates for mysql are present. you can copy
templates/sql/load/mysql dir to your db named dir.
2) datadump chokes on empty tables for some reason. apparently it fails to
detect end of recordset correctly. this may be driver-dependent.
3) out-of-memory on big DB. I guess this may be solved by adjusting vm args.
4) datadump templates do not do proper escaping so you will have trouble if
you have any 'bad' symbols in your data. It could have been easier to just
use DOM to generate xml... Same way datasql templates do not escape quotes,
so watch out.
To summarize, this is pretty raw code, but also there is not much of it -
three classes and a couple of templates all together containing only about
couple of dozens of code doing actual work, so it should be easy to grasp.
I, unfortunately, do not have time to work on it right now, but would be
happy to help if anybody else does.
fedor.
-------------------------------
Amicus Plato amicus Aristoteles magis amica veritas
> -----Original Message-----
> From: Jason van Zyl [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 7:07 AM
> To: [EMAIL PROTECTED]
> Subject: TorqueData task
>
>
> Hi Fedor,
>
> Do you have a little example kicking around that demonstrates
> the insertion
> of data with Torque?
>
> I would like to use the task to set the initial permissions
> for a turbine
> application so they can be stated generally in XML and
> integrated into the
> TDK process for initial application use and subsequent
> modification. And I
> only see mysql templates, is this the only RDB you've tried
> the task with?
>
> --
>
> jvz.
>
> Jason van Zyl
>
> http://tambora.zenplex.org
> http://jakarta.apache.org/turbine
> http://jakarta.apache.org/velocity
> http://jakarta.apache.org/alexandria
> http://jakarta.apache.org/commons
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
