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

Re: [xmlblaster] Microsoft SQL Server



Greetings

Will this fix make it easier to use MySql as well?

Regards


Michele Laghi wrote:
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