Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 41549 invoked from network); 28 Jul 2005 13:28:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Jul 2005 13:28:11 -0000 Received: (qmail 82827 invoked by uid 500); 28 Jul 2005 13:28:08 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 82809 invoked by uid 500); 28 Jul 2005 13:28:08 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 82779 invoked by uid 99); 28 Jul 2005 13:28:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jul 2005 06:28:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [63.151.42.144] (HELO provima.com) (63.151.42.144) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jul 2005 06:27:57 -0700 Received: from [10.40.10.105] [65.107.244.34] by provima.com with ESMTP (SMTPD32-8.15) id A917209013E; Thu, 28 Jul 2005 09:09:43 -0400 Message-ID: <42E8DD59.1010901@provima.com> Date: Thu, 28 Jul 2005 09:27:53 -0400 From: Trey Long User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: torque-user@db.apache.org Subject: JDBC Task & System Tables Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org