True to task, when I write an email for help the answer jumps out of the
bushes and attacks me. Torque was operating fine, however the SQL Server
permissions applied to the new database were somewhat limiting for the
new user.
I added the user to the database under the foolish assumption that any
new table would be added to the users permission, it appears this isn't
the case.
Torque Version: 3.2-rc1
Using: ANT, MSSQL
I have managed to get Torque working with MSSQL by setting the
{torque.database.schema} variable to the owner of the database. I am
running the MSSQL Profiler which tells me all of the sql commands run
through the server. Torque uses the following command to list tables:
sp_tables '%', 'dbo', null, "'TABLE','VIEW'"
Which returns:
bookstore dbo dtproperties TABLE NULL
bookstore dbo test TABLE NULL
bookstore dbo sysconstraints VIEW NULL
bookstore dbo syssegments VIEW NULL
Yet, for some reason that I haven't been able to figure out it only
processes 'dtproperties', 'syscontraints' and 'syssegments'. The 3
tables I really DON'T want.
I have listed the output log here to help with understanding what is
going on.
[torque-jdbc-transform] Torque - JDBCToXMLSchema starting
[torque-jdbc-transform] Your DB settings are:
[torque-jdbc-transform] driver :
com.microsoft.jdbc.sqlserver.SQLServerDriver
[torque-jdbc-transform] URL :
jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor
[torque-jdbc-transform] user : torque
[torque-jdbc-transform] schema : dbo
[torque-jdbc-transform] DB driver sucessfuly instantiated
[torque-jdbc-transform] DB connection established
[torque-jdbc-transform] Getting table list...
[torque-jdbc-transform] Building column/table map...
[torque-jdbc-transform] Processing table: dtproperties
[torque-jdbc-transform] Processing table: sysconstraints
[torque-jdbc-transform] Processing table: syssegments
[torque-jdbc-transform] ~edit~src/schema/schema.xml
[torque-jdbc-transform] Torque - JDBCToXMLSchema finished
If anyone could shed some light on this, I would be immensely grateful.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
