> -----Original Message-----
> From: Jason van Zyl [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 8:34 AM
> To: [EMAIL PROTECTED]
> Subject: Re: TorqueData task
>
>
> 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.
I would rather have the dtd, it very easy to generate - you only need the
schema xml file for that. Is there any problem?
>
> > 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
