ResultSet.getStatement returns null in some cases.

[dmjpro]

I am trying out to find out how many Schemas are there in a Database.

ResultSet schema_rs = db_metadata.getSchemas();
 
        while(schema_rs.next()){
            String schema_name = schema_rs.getString("TABLE_SCHEM");
            System.out.println("Schema Name: " + schema_name);
        }
        System.out.println("Yahoo: " + schema_rs.getStatement());
        schema_rs.getStatement().close();
 

Actually i read out API there it is told that if the ResultSet generated some other way as for example, through DatabaseMeta then it returns null.
Here it matches the condition.
Here no Schemas found ...and here I am using MySQL.
If i tried with some other database so far I tried with PostgreSQL and Sybase.
There I found some Schemas and there the ResultSet.getStatement does not return null as it generated through DatabaseMetadata.

Is it database dependent?Or if no schemas found then it happens.
Or it is a specific problem with MySQL?

Debasis Jana.

[Dököll]

What does Google have to say about this? Have you tried there? I do not use MySQL so I could not tell you. Just making sure your question is answered:-)

[JosAH]

Your question is quite chaotic; read the API documentation for the ResultSet interface:

Retrieves the Statement object that produced this ResultSet object. If the result set was generated some other way, such as by a DatabaseMetaData method, this method may return null.

You didn't get your ResultSet by a Statement and hence the source Statement can be null.

kind regards,

Jos