Using HTML in a JDBC SQL Insert Statement
Hi all,
I'm attempting to execute a SQL INSERT statement through a rule and am running into a problem. One of the fields in the SQL Server 2000 database is a text field and is used to house html for use in a user interface. I am running into the following error:
XPRESS <invoke> exception:
com.waveset.util.WavesetException: Can't call method sql on class com.waveset.util.JdbcUtil
==> com.waveset.util.WavesetException:
==> java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
The code that I am using is as follows:
<invoke name='sql' class='com.waveset.util.JdbcUtil'>
<map>
<s>type</s>
<s>sqlserver</s>
<s>driverClass</s>
<s>com.microsoft.jdbc.sqlserver.SQLServerDriver</s>
<s>driverPrefix</s>
<s>jdbc:sqlserver</s>
<s>url</s>
<s>jdbc:sqlserver://%h:%p;DatabaseName=%d</s>
<s>host</s>
<s>HOSTNAME</s>
<s>port</s>
<s>1</s>
<s>database</s>
<s>DATABASENAME</s>
<s>user</s>
<s>USERNAME</s>
<s>password</s>
<s>PASSWORD</s>
<s>sql</s>
<s>insert into RQST_TBL (RQST_TXT) values ('<b>hello</b>')</s>
</map>
</invoke>
The code works fine without the html bold tags (<b>) in the statement. Does anyone have any ideas (escape characters, etc.) on how to get the tags to work?
Thanks!
