Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Problem with Java and Sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with Java and Sybase" Watch "Problem with Java and Sybase" New topic
Author

Problem with Java and Sybase

Bruno Pimenta
Greenhorn

Joined: May 13, 2008
Posts: 5
The Java DataSource identify all the schemas of the database, but don't identify the tables.

Anyone had this roblem sometime? How can I solve it?

Thanks,
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

If you're trying to read the table names/fields from the database, you should review the JDBC MetaData API: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html


My Blog: Down Home Country Coding with Scott Selikoff
Bruno Pimenta
Greenhorn

Joined: May 13, 2008
Posts: 5
The problem is that I can't view the Tables of the schema in the DataSource of Eclipse. The DataSouce show de schemas, bot don't show the tables.

Thanks,
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

Umm, how exactly is Eclipse showing you data sources, through some kind of admin console? Either way, most (all?) admin consoles will *not* show you the tables. That's what you have SQL clients for. Try searching google for a sybase sql client.
Bruno Pimenta
Greenhorn

Joined: May 13, 2008
Posts: 5
The way that Eclipse show me is the default for it. Have some way different to make Eclipse show me my database?
Haw can I do it?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18656
    
    8

Bruno, I don't think Scott meant you were doing it the wrong way in Eclipse. I think he wanted to know how you were doing it in Eclipse because he didn't know of any way to do it. I might be wrong about that, but I think I'm right because I don't know how you use Eclipse to do it either. So... again... what do you do in Eclipse which shows you database schemas?
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

It sounded like he was accessing his J2EE server inside an eclipse window. Either way, you should use a database SQL tool for sybase to access it directly.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with Java and Sybase