Re: [xmlblaster] Microsoft SQL Server

[Michele Laghi <laghi at swissinfo.org>]

Yes,
in fact it would be nice if you could also try out mySql with the new 
code on cvs. You have of course to add the configuration in the 
xmlBlaster.properties file for mySQL the same way as for Oracle and 
postgres. The name you have to use is the one which the space-stripped
Connection.getMetaData().getDatabaseProductName();
returns.

Michele


Peter Bennett wrote:
> 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


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