How to access JDBC Meta Data functions like getColumns or getMetaData

Update. I've moved this question over to StackOverflow:
http://stackoverflow.com/questions/21027904/using-jpype-how-can-i-access-jdbc-meta-data-functions

JayDeBeApi exposes a Python DB-API 2.0. So you should find your information here: http://www.python.org/dev/peps/pep-0249/#description
Please report if you are still missing something.

BTW: Please try to avoid double posting.

I should have mentioned I want to get all the tables too. I updated my SO question to reflect that.

It looks like the DBAPI doesn't offer that. So I'm guessing that makes this a Jpype question instead?

Usually your database offers this kind of information in system tables. Please check your database vendor manual. The advantage of the JDBC-methods is of course the platform independence. If you really want you can access JayDeBeApis Java JDBC connection using conn.jconn

jconn is a java.sql.Connection (http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html) and offers getMetaData()

To get all tables for example use
conn.jconn.getMetaData().getTables() and iterate over the ResultSet. See the link above for details and to navigate through the class documentation.

And yes, it's more of a JPype question. But maybe it's a good idea to extend JayDeBeApi to allow access to general (non .description) metadata.

Hey, this might be of interest for you http://stackoverflow.com/questions/878737/what-is-the-python-equivalent-to-jdbc-databasemetadata

Thanks again! It seems like I'm on the right track. Any idea why I might be getting this error?

> conn.jconn.metadata.getTables()
*** RuntimeError: No matching overloads found. at src/native/common/jp_method.cpp:121

Ok, I got it working. I just had to pass in the same parameters the method was expecting. I've posted the working code on the Stack Overflow question.

http://stackoverflow.com/questions/21027904/using-jpype-how-can-i-access-jdbc-meta-data-functions

Thank you, glad you solved the issue.