On 9/26/01 11:11 AM, "Fedor Karpelevitch" <[EMAIL PROTECTED]>
wrote:
> 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)
Do I need a dtd to simply insert data? All I want to do is take an xml file
that describes initial permission settings and insert them into a raw
system.
> 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]
--
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]
