File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes MS Temporary tables and metadata Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MS Temporary tables and metadata" Watch "MS Temporary tables and metadata" New topic

MS Temporary tables and metadata

Mirko Bonasorte
Ranch Hand

Joined: May 14, 2007
Posts: 244

I have a problem related to database metadata.
I'm working with Microsoft Sql Server 2005, driver Jtds and I have the following code:

Well, my code simply does not find any row at (1).
But if I replace (2) with null, I get ALL tables, views and so on, BUT my temporary table.
So.... is there any reason why I can't access temporary tables metadata?

Thanks in advances.

SCJP<br />SCWCD 1.4 Upgrade (Remember: me stupid)<br />SCWCD 1.4<br /><a href="" target="_blank" rel="nofollow">SCBCD 5.0</a><br /><a href="" target="_blank" rel="nofollow">SCBCD 5.0 mock exam</a> <br /> <br />SCEA 5 Part1: Preparing...
I agree. Here's the link:
subject: MS Temporary tables and metadata
It's not a secret anymore!