HI,
you must specify your oracle schema name in your build.properties file:
databaseSchema = XXXX
ps: make sure the schema name must be in Capital !
Annie
----- Original Message -----
From: "Chris McCann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 11:11 AM
Subject: project-jdbc (jdbc to xml) with SQL Server 7.x
> 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]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
