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

Re: [xmlblaster] Microsoft SQL Server



Hi Zhang,
I made some modifications to the JdbcManagerCommonTable class. The manual creation of the pg_table view is not needed anymore since the information about the tables is gained via the MetaData information. I tested the code with oracle and postgres but I don't have any Microsoft SQL server running. Could you please check out the latest code and make sure it still works for Microsoft SQL Server (with no pg_table view!) ?


If that works I would then change the requirements and clean up the code.

Regards
Michele


zhang wrote:
I have use the following command to test the Microsoft SQL Server:
  java -Djava.compiler= junit.swingui.TestRunner -noloading  org.xmlBlaster.test.classtest.AllTests

the test results ok.


but I think the xmlBlaster.properties.template file has small bugs


1: it seems that you omit the oracle , just postgres and MicrosoftSQLServer
#QueuePlugin[JDBC][1.0]=${JdbcStorage[postgres]}
QueuePlugin[JDBC][1.0]=${JdbcStorage[MicrosoftSQLServer]}
2: the Microsoft SQL Server driver class need to be added


JdbcDriver.drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver



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




--
Michele Laghi
mailto:laghi at swissinfo.org
tel. +46 8 7492952 / mob. +46 70 4103964
http://www.geocities.com/laghi2000
http://www.xmlBlaster.org