Hmm, this is interesting. FWIW, I believe that the test-project contains a test for the jdbc task. I ran the test suite using the 3.3-RC3 candidate against a MS SQL Server 2000 install with the jTDS driver and it passed. But I'm not a 100% sure that the jdbc task is part of that.
Also, I just did a quick ant build jdbc task against my development DB (which uses SQL 7.. I know.. old.. long sad story why... ) and it worked. FWIW, this was using jTDS 1.2 with only the ;TDS=7.0 parameter set on the test URL for the SQL 7 test. E.g.: jdbc:jdts:sqlserver://sql.xxx.com/dbName;TDS=7.0 One question, the "tasks" part of torque uses your "build.properties" info to connect to the server. Are you changing the values here or in the Torque.properties file, which only effects the runtime? It may be an SQL 2005 / jTDS driver issue. Also are you using named pipes as a connection method or TCP/IP? That may be another source of trouble. I seem to remember that with Named Pipes some alternate forms of "authentication" may be used, such as trying the current network user info. That's all that come to the top of mind right now. Greg > -----Original Message----- > From: Thomas Fischer [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 10, 2008 12:34 PM > To: Apache Torque Users List > Subject: 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").newInstan > ce(); > > > Connection connection = DriverManager.getConnection > ("jdbc:sqlserver://srv- > > > poseidon;instanceName=orgasales;databaseName=OrgaSales;SelectMethod=cur > sor; > > 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] DukeCE Privacy Statement: Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
