Annie, The documentation states that 'databaseSchema' is only necessary for Oracle databases. Is it required for SQL Server as well?
Thanks. -chris > -----Original Message----- > From: Annie Zhang [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 11:17 AM > To: Turbine Torque Users List > Subject: Re: project-jdbc (jdbc to xml) with SQL Server 7.x > > > 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;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]>
