How can I get the name of all tables in a JavaDB database?

Posted by Jonas on Stack Overflow See other posts from Stack Overflow or by Jonas
Published on 2010-05-10T21:01:26Z Indexed on 2010/05/10 21:04 UTC
Read the original article Hit count: 258

Filed under:

javadb

|

jdbc

|

java

|

database

|

tables

How can i programmatically get the names of all tables in a JavaDB database? Is there any specific SQL-statement over JDBC I can use for this or any built in function in JDBC?

I will use it for exporting the tables to XML, and would like to do it this way so I don't miss any tables from the database when exporting.

© Stack Overflow or respective owner

Related posts about javadb

NETBEANS JAVADB - How do I integrate a JavaDB DataBase into my main Java Package

as seen on Stack Overflow - Search for 'Stack Overflow'
JAVA I am working on a desktop application which uses JavaDB. I am using NetBeans 6.8 and JDK 6 Update 20 I created the database I need and connected to it through my application using ClientDriver: String driver = "org.apache.derby.jdbc.ClientDriver"; String connectionURL = "jdbc:derby://localhost:1527/myDB;create=true;user=user;password=pass"; … >>> More
Configuring Quercus to talk to JavaDB

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to get the Quercus PHP engine to connect with the JavaDB. I have successfully deployed Quercus in Glassfish, but I can't get Quercus to successfully connect with my database in JavaDB. Can anyone point me to an article or tutorial that treats this subject? >>> More
user table with javaDB and Hibernate from within grails

as seen on Stack Overflow - Search for 'Stack Overflow'
let's see if I can ask this in an understandable way... I started with grails and created a domain class called user. As far as I understand, Hibernate is used to map this domain class to the database. This works pretty fine with hsqldb. Now I tried to switch to javaDB and get an error message because… >>> More
user table with javaDB and hybernate from within grails

as seen on Stack Overflow - Search for 'Stack Overflow'
let's see if I can ask this in an understandable way... I started with grails and created a domain class called user. As far as I understand, hybernate is used to map this domain class to the database. This works pretty fine with hsqldb. Now I tried to switch to javaDB and get an error message because… >>> More
what does mean "SQL Error: 30000, SQLState: XSAI3" ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using javadb/derbydb 10.5.3.0 with hibernate 3.5-Final I get this error at the end of EM initialisation : 4427 [SwingWorker-pool-1-thread-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 30000, SQLState: XSAI3 4427 [SwingWorker-pool-1-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter… >>> More

Related posts about jdbc

JDBC: What is the correct JDBC URL to connect to a RAC database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We were connecting to Oracle from our code with a simple (custom) JDBC connector class. This class reads the connection properties from a resource file and tries to make a connection to Oracle (thin connection). However, recently the database have moved to a RAC and now the application is unable… >>> More
JDBC Licensing - Packaging jdbc in jar

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there. I'm packaging my open-source non-commercial java application in a .jar and I'd like to package the JDBC mysql-connector with it as it is a dependency. The issue that I am having is that I'm uncertain whether or not this is frowned upon or even illegal due to the JDBC license. I've also… >>> More
jdbc:jtds:sqlserver driver problem

as seen on Stack Overflow - Search for 'Stack Overflow'
sonar.jdbc.url: jdbc:jtds:sqlserver://127.0.0.1/SQL2008:1433/Sonar sonar.jdbc.driverClassName: net.sourceforge.jtds.jdbc.Driver sonar.jdbc.validationQuery: select 1 sonar.jdbc.username: Sonar sonar.jdbc.password: … >>> More
Memory Leak Issue in Weblogic, SUN, Apache and Oracle classes Options

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please find below the description of memory leaks issues. Statistics show major growth in the perm area (static classes). Flows were ran for 8 hours , Heap dump was taken after 2 hours and at the end. A growth in Perm area was identified Statistics show from our last run 240MB growth… >>> More
?????????????????????????|WebLogic Channel|??????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Java EE????????·????????????????/??????????????????????·?????????????????????????WebLogic Server?????????????WebLogic Server???????????????????·??????????????????????????????????????????????????????????(???)???????WebLogic Server???????　????WebLogic Server 11g(10.3.5)??????????????????????… >>> More