Text datatype and SQLQueryForEach question
Posted in 2004
Topics: Connectivity: ODBC / JDBC / .NET
I'm using the atg.droplet.sql.SQLQueryForEach droplet to get data out of a database but when I try to get iformation from a TEXT type field (in table if it makes any difference) I just get something like "[B@62bb72". I'm thinking that what I'm actually getting is an object reference but I don't know what to or how to access the actual contents of the field. I'd really appreciate any help on this as I've been thrown into the deep end a bit with zero training and noone else in the company knows any more than I do. The code looks something like this: <import bean="/atg/dynamo/droplet/SQLQueryForEach"> <droplet bean="SQLQueryForEach"> <param name="connectionURL" value="jdbc:atgpool:myconnection"> <param name="querySQL" value="SELECT * FROM mytable"> <oparam name="output"> <valueof param="element.longtext"></valueof> </oparam> </droplet> Thanks -- Paul