project-jdbc (jdbc to xml) with SQL Server 7.x

[Chris McCann]

Greetings,

Has anyone successfully used project-jdbc with SQL Server, 7.x in 
particular?  

I've been trying to XML-ize the sample Northwind database as a proof of 
concept, using 3.1-b1, and all I get is an empty XML schema.  I've tried
the MS JDBC driver, the TWC driver, and the J-Connect driver -- all have
produced the same result.

Here is the output I get from the ant process:

    Buildfile: build.xml

    project-jdbc:
       [echo] JDBC transform
    [torque-jdbc] Torque - JDBCToXMLSchema starting
    [torque-jdbc]
    [torque-jdbc] Your DB settings are:
    [torque-jdbc] driver : com.microsoft.jdbc.sqlserver.SQLServerDriver
    [torque-jdbc] URL :
jdbc:microsoft:sqlserver://10.0.0.10:1433;DatabaseName=Northwind;
      SelectMethod=cursor
    [torque-jdbc] user : sa
    [torque-jdbc] password :
    [torque-jdbc] schema : ${databaseSchema}
    [torque-jdbc] DB driver sucessfuly instantiated
    [torque-jdbc] DB connection established
    [torque-jdbc] Getting table list...
    [torque-jdbc] Building column/table map...
    [torque-jdbc]
    [torque-jdbc] Torque - JDBCToXMLSchema finished

    BUILD SUCCESSFUL

    Total time: 1 second

And here is the content of the genereated schema.xml file:

    <?xml version="1.0"?>
    <!DOCTYPE app-data SYSTEM
"http://jakarta.apache.org/turbine/dtd/database.dtd";>
    <!-- Autogenerated by JDBCToXMLSchema! -->
    <app-data>
        <database/>
    </app-data>

Lastly, the database related properties in build.properties are:

 
databaseUrl=jdbc:microsoft:sqlserver://10.0.0.10:1433;DatabaseName=Northwind
;SelectMethod=cursor
    databaseDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
    databaseUser=sa
    databasePassword=
    databaseHost=10.10.10.3

----

Any info or advice would be greatly appreciated!  Thanks in advance.

-chris

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>