Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 96861 invoked from network); 10 Apr 2008 16:34:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 10 Apr 2008 16:34:08 -0000 Received: (qmail 22624 invoked by uid 500); 10 Apr 2008 16:34:08 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 22600 invoked by uid 500); 10 Apr 2008 16:34: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 22589 invoked by uid 99); 10 Apr 2008 16:34:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Apr 2008 09:34:08 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [217.24.207.26] (HELO mail.seitenbau.net) (217.24.207.26) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Apr 2008 16:33:26 +0000 Received: from [192.168.15.18] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1JjziS-0005WV-0E for torque-user@db.apache.org; Thu, 10 Apr 2008 18:33:36 +0200 In-Reply-To: Subject: AW: MSSQL JDBC2XML Task generates no XML To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 7.0.1 January 17, 2006 Message-ID: From: Thomas Fischer Date: Thu, 10 Apr 2008 18:33:35 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 7.0.1|January 17, 2006) at 10.04.2008 06:33:35 PM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org Did you try to use the configured schema name instead of "%" ? Maybe a case sensitivity issue ? Sorry, just wild guesses, Thomas Thoralf Rickert schrieb am 10.04.2008 18:05:45: > > What Torque does is it opens a connection to the db, goes for > > the metadata of the connection and makes the call > > > > tableNames = dbMeta.getTables(null, dbSchema, "%", types); > > > > Maybe you can try to do this manually and play around to see > > what goes wrong ? > > > > It may also be that you have a permission problem and the > > orgasales user is not allowed to list all tables... > > > Sorry, I forgot to tell you. I allready tried this: > > -- > Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); > Connection connection = DriverManager.getConnection ("jdbc:sqlserver://srv- > poseidon;instanceName=orgasales;databaseName=OrgaSales;SelectMethod=cursor; > integratedSecurity=true", "orgasales", "password"); > > DatabaseMetaData metadata = connection.getMetaData(); > String[] names = {"TABLE"}; > ResultSet tableNames = metadata.getTables(null, "%", "%", names); > int size = 0; > while (tableNames.next()) { > System.out.println(tableNames.getString("TABLE_NAME")); > size++; > } > System.out.println("Found "+size+" tables"); > -- > > The result has 346 tables. So the db user has access to the db and can read > the metadata. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org