error when inserting xml into database - string literal too long

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nikki - 24 Jun 2006 21:23 GMT

That is correct (native xml support)

I used parameter markers and it did work. I inserted it as a string.
Is this the best way to do it? Or is there a better way.

Thank you for your help,

Nicole

Reply to this Message

Serge Rielau - 24 Jun 2006 22:10 GMT

> That is correct (native xml support)
>
> I used parameter markers and it did work. I inserted it as a string.
> Is this the best way to do it? Or is there a better way.

That's fine.

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Nikki - 26 Jun 2006 16:51 GMT

When I retrieve the xml using Rational Application Developer with my
java code I do something like...
String xml = resultSet.getString("XML");

The value is just a bunch of characters that make no sense. Do I need
to use a different get method on it? Which one?

Woud you suggest posting this somewhere else?

Thanks again for your help.

> > That is correct (native xml support)
> >
[quoted text clipped - 9 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message