Hi, I am using derby in the embedded mode for a Java Windows desktop application. I am trying to find a way that I can determine what version my database is. When I use the Java Connection class getMetaData().getDatabaseProductVersion() call it always returns the version of the derby driver I am running, rather than the version of the actual database. Or else it's returning the version of the database after a soft upgrade, but not the underlying database version. Same for getMetaData().getDatabaseMajorVersion() and getMetaData().getDatabaseMinorVersion(). The reason I want to know the version of the database is so I can determine if I need/want to do a hard upgrade on the database. Is there any way for me to get the version of the database from inside a Java program?
Thank you. Lisa