Re: [xmlblaster] How to support SQL Server with XMLBlaster?

[Marcel Ruff <mr at marcelruff.info>]

zhang wrote:

> I want to support XMLblaster with SQL Server,
> how can I support it ?
>
> modify xmlblaster.property 
> and JDBCConnectionPool.java ??
>
> can anybody explain this to me??
>  
Hi,

you need to adapt the files in directory:

  xmlBlaster/src/java/org/xmlBlaster/util/queue/jdbc

Have a look especially into

JdbcManagerCommonTable.java

for the mapping.
You need to fumble aroun in those files until it runs with SQL Server.

Please read all requirements first:

 http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.html
 
http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.jdbc.commontable.html
 
http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.jdbc.oracle.html
 
http://www.xmlblaster.org/xmlBlaster/doc/requirements/queue.jdbc.postgres.html

To test if your port is OK you must use our extensive testsuite in directory

 xmlBlaster/testsuite/src/java/org/xmlBlaster/test/classtest/queue

try to invoke:

 java -Djava.compiler= junit.swingui.TestRunner -noloading 
org.xmlBlaster.test.classtest.queue.AllTests

If you donate your work back to xmlBlaster you are very welcome
this way others can benefit from your work same as you profit from the 
work of others :-)


enjoy,

Marcel