db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thoralf Rickert <thoralf.rick...@cadooz.de>
Subject AW: MSSQL JDBC2XML Task generates no XML
Date Fri, 11 Apr 2008 08:14:14 GMT
Okay, that was the problem.

The schema must be "dbo". My fault.

Thanks
Thoralf





> -----Urspr√ľngliche Nachricht-----
> Von: Thomas Fischer [mailto:fischer@seitenbau.net]
> 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 <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").
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>

Mime
View raw message