CODEWITHSUNDEEP
javamysqljpaorm
Some Newbie
Some Newbie

Reputation: 1089

Checking table properties (i.e. size) with JPA

I am using JPA to do ORM. However, one thing I'd particularly like to do is to also be able to check the size of the tables that are being managed. Are there any streamlined ways of doing it or do I need to keep a set of separate JDBC scripts to do the more conventional DB management stuff?

Thanks.

Upvotes: 1

Views: 186

Answers (1)

DataNucleus
DataNucleus

Reputation: 15577

What size? you mean number of rows ? which you can obviously get with "SELECT COUNT(p) FROM Person p". JPA doesn't do physical size of a datastore, so you'd have to have some native queries to get that (datastore specific also).

Upvotes: 1

Related Questions