Hello,
i run the following test program and it works proper for me:
ResultSet rs = this.stmt.executeQuery ("Explain SELECT dummy, dummy
from dual");
ResultSetMetaData rsmd = rs.getMetaData();
while (rs.next() ) {
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
System.out.println("Erg "+i+": "+rs.getString(i));
}
}
Maybe you can send me a vtrace (http://sapdb.2scale.net/moin.cgi/VTrace) and
a jdbc-trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace).
BTW: Where can I get the Beta 3.0 of dbvisualizer?
Regards,
Marco
> -----Original Message-----
> From: Raimund Jacob [mailto:[EMAIL PROTECTED]]
> Sent: Dienstag, 28. Mai 2002 13:14
> To: SAPDB mailing list
> Subject: possible bug in jdbc 3.0 alpha
>
>
> hi!
>
> using dbvisualizer (3.0 beta 2 / jdbc 7.4.3 Build
> 001-000-078-671) i did:
>
> select dummy from dual
> -> ok
>
> select dummy, dummy from dual
> -> ok
>
> explain select dummy from dual
> -> ok
>
> explain select dummy, dummy from dual
> -> [-6001] (at 16) Duplicate column name:DUMMY
>
> i ran into this problem when i wanted to get a join explained where
> different tables had the same name for a column.
>
> i dont know if this problem exists for other jdbc drivers...
>
> --
> Raimund Jacob
> \|/ ____ \|/
> Pinuts Media+Science GmbH "@'/ ,. \`@"
> Potsdamer Str. 96 /_| \__/ |_\
> D-10785 Berlin \__U_/
> http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
