[SIS-395] Need a public way to get connection to "SpatialMetadata" database

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5, 0.6, 0.7, 0.8
• Fix Version/s: 1.0
• Component/s: Metadata, Referencing
• Assignee: Martin Desruisseaux
• Reporter: Martin Desruisseaux
• Created: 06/Feb/18 09:16
• Updated: 24/Sep/21 20:35
• Resolved: 09/Sep/19 12:43

Description

There is currently no public API for getting the javax.sql.DataSource instance for Apache SIS SpatialMetadata database. There is Initializer.getDataSource() method in the org.apache.sis.internal.metadata.sql but this is non-public API, subject to change in any future SIS version and will not be accessible in Java 9 (unless the restriction is bypassed by Java options on the command-line).

A standard way to provide DataSource in Java is with Java Naming and Directory Interface (JNDI). However there is no JNDI environment by default in standard Java installation; JNDI are rather provided by containers like Tomcat. We could provide our own micro-JNDI when no environment is installed, but it may be disruptive as installing our own JNDI environment would have a JVM-wide impact.

A last-resort approach would be a public static DataSource getXXX() method somewhere, but it would not follow standard mechanisms (JNDI, dependency injection, etc.).

Issue Links

• depends upon: SIS-86 Refactor @Configuration annotation into a real Configuration class