db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henning P. Schmiedehausen" <...@intermeta.de>
Subject Problem with SQL load task - ideas?
Date Mon, 04 Aug 2003 13:19:09 GMT

I have the following problem: 

I have a table (PostgreSQL). This table has multiple colums, one is a 
CLOB (PostgreSQL text) column. This column should get a text which is
generated by another application. The problem is, that this text might
look like this:

"foo bar
This bugger is --->              <---- that thick.
point 1
point 2
point 3

Which means, that I can contain multiple whitespaces and/or line feeds.

This is find in our source represenatation which is generated by an XML
transformation tool. I get stuff like this:

<table description="..... lots of stuff">

This XML file should be fed to the torque:insert-sql task to be put in
the database. However, the Torque task uses Texen, which in turn uses
Velocity, which "gobbles up excessive whitespace". Duh! There goes my text
formatting and/or linefeeds.

Can I turn this "excessive whitespace gobbling" off? If yes, how? If
not, is Texen still the right tool for us, because it simply changes
the value of database columns to be inserted?


Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
hps@intermeta.de        +49 9131 50 654 0   http://www.intermeta.de/

Java, perl, Solaris, Linux, xSP Consulting, Web Services 
freelance consultant -- Jakarta Turbine Development  -- hero for hire

"You are being far too rational for this discussion."  
       --- Scott Robert Ladd in <3F1874B0.6030507@coyotegulch.com>

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message