Annie,
You were correct. After picking through the Torque for a while and
duplicating some of the logic, I found that:
databaseSchema=dbo
did the trick. Perhaps the MSSQL howto could include this?
Thanks!
-chris
> Annie,
>
> The documentation states that 'databaseSchema' is only
> necessary for Oracle
> databases. Is it required for SQL Server as well?
>
> Thanks.
>
> -chris
>
> >
> > 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
> >
> > > 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;Database
> > Name=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]>
>
> --
> 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]>
