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
