Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of greg.monroe@dukece.com
 designates 152.3.166.24 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: RE: MSSQL JDBC2XML Task generates no XML
Date: Thu, 10 Apr 2008 13:20:26 -0400
Message-ID: <8F5843B903F59D4C8C6806BB49A3911906238570@dukece-mail3.dukece.com>
In-Reply-To: 
 <OF5540D949.55C0D6BF-ONC1257427.005AD8AD-C1257427.005AF75F@seitenbau.net>
Thread-Topic: MSSQL JDBC2XML Task generates no XML
Thread-Index: AcibKLoJRFjASgSSTiWU6wwzhna/BgAAovQQ
References: 
 <A864307CE9C0D54191507125C95FC59E0C6DEECB@srv-exchange.cadooz-ag.intern>
 <OF5540D949.55C0D6BF-ONC1257427.005AD8AD-C1257427.005AF75F@seitenbau.net>
From: "Greg Monroe" <Greg.Monroe@DukeCE.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Content-Type: text/plain;
	charset="us-ascii"

Hmm, this is interesting=2E  FWIW, I believe that the test-project=0D=0Acon=
tains a test for the jdbc task=2E  I ran the test suite using the =0D=0A3=
=2E3-RC3 candidate against a MS SQL Server 2000 install with the =0D=0AjTDS=
 driver and it passed=2E  But I'm not a 100% sure that the jdbc=0D=0Atask i=
s part of that=2E=0D=0A=0D=0AAlso, I just did a quick ant build jdbc task a=
gainst my development=0D=0ADB (which uses SQL 7=2E=2E I know=2E=2E old=2E=
=2E long sad story why=2E=2E=2E ) and =0D=0Ait worked=2E=0D=0A=0D=0AFWIW, t=
his was using jTDS 1=2E2 with only the ;TDS=3D7=2E0 parameter set=0D=0Aon t=
he test URL for the SQL 7 test=2E  E=2Eg=2E:=0D=0A=0D=0Ajdbc:jdts:sqlserver=
://sql=2Exxx=2Ecom/dbName;TDS=3D7=2E0=0D=0A=0D=0AOne question, the "tasks" =
part of torque uses your "build=2Eproperties"=0D=0Ainfo to connect to the s=
erver=2E  Are you changing the values here =0D=0Aor in the Torque=2Epropert=
ies file, which only effects the runtime?=0D=0A=0D=0AIt may be an SQL 2005 =
/ jTDS driver issue=2E  Also are you using named=0D=0Apipes as a connection=
 method or TCP/IP?  That may be another source=0D=0Aof trouble=2E I seem to=
 remember that with Named Pipes some alternate=0D=0Aforms of "authenticatio=
n" may be used, such as trying the current=0D=0Anetwork user info=2E=0D=0A=
=0D=0AThat's all that come to the top of mind right now=2E=0D=0A=0D=0AGreg=
=0D=0A=0D=0A> -----Original Message-----=0D=0A> From: Thomas Fischer [mailt=
o:fischer@seitenbau=2Enet]=0D=0A> Sent: Thursday, April 10, 2008 12:34 PM=
=0D=0A> To: Apache Torque Users List=0D=0A> Subject: AW: MSSQL JDBC2XML Tas=
k generates no XML=0D=0A> =0D=0A> Did you try to use the configured schema =
name instead of "%" ? Maybe a=0D=0A> case=0D=0A> sensitivity issue ?=0D=0A>=
 =0D=0A>     Sorry, just wild guesses,=0D=0A> =0D=0A>         Thomas=0D=0A>=
 =0D=0A> Thoralf Rickert <thoralf=2Erickert@cadooz=2Ede> schrieb am 10=2E04=
=2E2008=0D=0A> 18:05:45:=0D=0A> =0D=0A> > > What Torque does is it opens a =
connection to the db, goes for=0D=0A> > > the metadata of the connection an=
d makes the call=0D=0A> > >=0D=0A> > >  tableNames =3D dbMeta=2EgetTables(n=
ull, dbSchema, "%", types);=0D=0A> > >=0D=0A> > > Maybe you can try to do t=
his manually and play around to see=0D=0A> > > what goes wrong ?=0D=0A> > >=
=0D=0A> > > It may also be that you have a permission problem and the=0D=0A=
> > > orgasales user is not allowed to list all tables=2E=2E=2E=0D=0A> >=0D=
=0A> >=0D=0A> > Sorry, I forgot to tell you=2E I allready tried this:=0D=0A=
> >=0D=0A> > --=0D=0A> >=0D=0A>=0D=0AClass=2EforName("com=2Emicrosoft=2Esql=
server=2Ejdbc=2ESQLServerDriver")=2EnewInstan=0D=0A> ce();=0D=0A> =0D=0A> >=
 Connection connection =3D DriverManager=2EgetConnection=0D=0A> ("jdbc:sqls=
erver://srv-=0D=0A> >=0D=0A>=0D=0Aposeidon;instanceName=3Dorgasales;databas=
eName=3DOrgaSales;SelectMethod=3Dcur=0D=0A> sor;=0D=0A> > integratedSecurit=
y=3Dtrue", "orgasales", "password");=0D=0A> >=0D=0A> > DatabaseMetaData met=
adata =3D connection=2EgetMetaData();=0D=0A> > String[] names =3D {"TABLE"}=
;=0D=0A> > ResultSet tableNames =3D metadata=2EgetTables(null, "%", "%", na=
mes);=0D=0A> > int size =3D 0;=0D=0A> > while (tableNames=2Enext()) {=0D=0A=
> >   System=2Eout=2Eprintln(tableNames=2EgetString("TABLE_NAME"));=0D=0A> =
>   size++;=0D=0A> > }=0D=0A> > System=2Eout=2Eprintln("Found "+size+" tabl=
es");=0D=0A> > --=0D=0A> >=0D=0A> > The result has 346 tables=2E So the db =
user has access to the db and=0D=0A> can=0D=0A> read=0D=0A> > the metadata=
=2E=0D=0A> =0D=0A> =0D=0A> ------------------------------------------------=
---------------------=0D=0A> To unsubscribe, e-mail: torque-user-unsubscrib=
e@db=2Eapache=2Eorg=0D=0A> For additional commands, e-mail: torque-user-hel=
p@db=2Eapache=2Eorg=0D=0A=0D=0ADukeCE Privacy Statement:=0D=0APlease be adv=
ised that this e-mail and any files transmitted with=0Ait are confidential =
communication or may otherwise be privileged or=0Aconfidential and are inte=
nded solely for the individual or entity=0Ato whom they are addressed=2E If=
 you are not the intended recipient=0Ayou may not rely on the contents of t=
his email or any attachments,=0Aand we ask that you please not read, copy o=
r retransmit this=0Acommunication, but reply to the sender and destroy the =
email, its=0Acontents, and all copies thereof immediately=2E Any unauthoriz=
ed=0Adissemination, distribution or copying of this communication is=0Astri=
ctly prohibited=2E

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org