Re: [xmlblaster] Microsoft SQL Server

[Peter Bennett <bencom at bencom.co.nz>]

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