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:[EMAIL PROTECTED] tel. +46 8 7492952 / mob. +46 70 4103964 http://www.geocities.com/laghi2000 http://www.xmlBlaster.org
