[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[xmlblaster] About the Microsoft SQL Server --Modify char to varchar



the string=CHAR(128)  must be changed to string=VARCHAR(128) ,
otherwise it will report error when i test the HelloWorldPublish example

The testcase is as follows:
  First publish 10 message to xmlblaster with args as " -erase false"
  and then shutdown xmlblaster and restart it ,
  then publish again, it will report error, i find the reason is when 
retriving record form SQL Server, the jdbc api cannot trim the space of
the "type" field in record. 

 
 

JdbcDriver.mapping[MicrosoftSQLServer]=\
  string=VARCHAR(128),longint=numeric (19),boolean=char(1),
  blob=image,tables=pg_tables,tablename=tablename,connectionErrorCodes=1089:17002
    



=============================================================
ÅÌÖг¬¼¶Ó¯Àû¾¡ÔÚÕÆÎÕ ÏíÊÜÀ­ÉýµÄ¿ì¸Ð        http://list.163.com/mlist/pzjg/pzjg.htm
°Ù·Ö°ÙÅ®ÓÑ - ´º¼¾Ñ¡ÃÀ»î¶¯!                 http://love.163.com
¸öÈË¿Õ¼äÃâ·ÑÊÔÓà                           http://www.nease.net