db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: MSSQL JDBC2XML Task generates no XML
Date Thu, 10 Apr 2008 17:20:26 GMT
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:fischer@seitenbau.net]
> 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 <thoralf.rickert@cadooz.de> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message