Okay, that was the problem. The schema must be "dbo". My fault.
Thanks Thoralf > -----Ursprüngliche Nachricht----- > Von: Thomas Fischer [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 10. April 2008 18:34 > An: Apache Torque Users List > Betreff: AW: MSSQL JDBC2XML Task generates no XML > > Did you try to use the configured schema name instead of "%" > ? Maybe a case sensitivity issue ? > > Sorry, just wild guesses, > > Thomas > > Thoralf Rickert <[EMAIL PROTECTED]> 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;SelectM > ethod=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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
smime.p7s
Description: S/MIME cryptographic signature
