Chris & Annie,
Thanks! I was looking into this very thing today, and ran into the same
problem. I was going to dig into the source code tonight, but now I
don't have to.
Thanks,
Jim Seach
--- Chris McCann <[EMAIL PROTECTED]> wrote:
> 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]>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
