Is there a way for geotools PostGIS DataStore to use a JEE DataSource?
The geotools DataStoreFinder expects a Map of properties, including mainly the connectivity information, depending on the store.
For the PostGIS plugin this includes the dbtype (which must be "postgis") and the database host, port, schema, database, username and password.
http://docs.geotools.org/stable/userguide/library/jdbc/postgis.html
In my application, there are other tables which are being accessed using Spring Data (JPA Repositories / Hibernate and Hibernate Spatial).
Is there a way to make the PostGIS connection information to use the standard JEE DataSource that is injected by Spring? This way I won't have to duplicate the configuration to the same database and do custom property handling.
geotools
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
migrated from gis.stackexchange.com Nov 12 '18 at 8:53
This question came from our site for cartographers, geographers and GIS professionals.
add a comment |
The geotools DataStoreFinder expects a Map of properties, including mainly the connectivity information, depending on the store.
For the PostGIS plugin this includes the dbtype (which must be "postgis") and the database host, port, schema, database, username and password.
http://docs.geotools.org/stable/userguide/library/jdbc/postgis.html
In my application, there are other tables which are being accessed using Spring Data (JPA Repositories / Hibernate and Hibernate Spatial).
Is there a way to make the PostGIS connection information to use the standard JEE DataSource that is injected by Spring? This way I won't have to duplicate the configuration to the same database and do custom property handling.
geotools
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
migrated from gis.stackexchange.com Nov 12 '18 at 8:53
This question came from our site for cartographers, geographers and GIS professionals.
if you can get a JNDI reference for the datastore you could use that to create a new geotools datastore, otherwise I suspect you will need to write new code for the datastores.
– Ian Turton
Nov 12 '18 at 8:54
It should be possible to enable JNDI in Spring Boot's embedded Tomcat and add the DataSource to the NamingContext with some JNDI name. Will have a go at it.
– jbx
Nov 12 '18 at 8:59
add a comment |
The geotools DataStoreFinder expects a Map of properties, including mainly the connectivity information, depending on the store.
For the PostGIS plugin this includes the dbtype (which must be "postgis") and the database host, port, schema, database, username and password.
http://docs.geotools.org/stable/userguide/library/jdbc/postgis.html
In my application, there are other tables which are being accessed using Spring Data (JPA Repositories / Hibernate and Hibernate Spatial).
Is there a way to make the PostGIS connection information to use the standard JEE DataSource that is injected by Spring? This way I won't have to duplicate the configuration to the same database and do custom property handling.
geotools
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
The geotools DataStoreFinder expects a Map of properties, including mainly the connectivity information, depending on the store.
For the PostGIS plugin this includes the dbtype (which must be "postgis") and the database host, port, schema, database, username and password.
http://docs.geotools.org/stable/userguide/library/jdbc/postgis.html
In my application, there are other tables which are being accessed using Spring Data (JPA Repositories / Hibernate and Hibernate Spatial).
Is there a way to make the PostGIS connection information to use the standard JEE DataSource that is injected by Spring? This way I won't have to duplicate the configuration to the same database and do custom property handling.
geotools
geotools
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
asked Nov 11 '18 at 23:41
jbxjbx
10.6k1057110
10.6k1057110
migrated from gis.stackexchange.com Nov 12 '18 at 8:53
This question came from our site for cartographers, geographers and GIS professionals.
migrated from gis.stackexchange.com Nov 12 '18 at 8:53
This question came from our site for cartographers, geographers and GIS professionals.
if you can get a JNDI reference for the datastore you could use that to create a new geotools datastore, otherwise I suspect you will need to write new code for the datastores.
– Ian Turton
Nov 12 '18 at 8:54
It should be possible to enable JNDI in Spring Boot's embedded Tomcat and add the DataSource to the NamingContext with some JNDI name. Will have a go at it.
– jbx
Nov 12 '18 at 8:59
add a comment |
if you can get a JNDI reference for the datastore you could use that to create a new geotools datastore, otherwise I suspect you will need to write new code for the datastores.
– Ian Turton
Nov 12 '18 at 8:54
It should be possible to enable JNDI in Spring Boot's embedded Tomcat and add the DataSource to the NamingContext with some JNDI name. Will have a go at it.
– jbx
Nov 12 '18 at 8:59
if you can get a JNDI reference for the datastore you could use that to create a new geotools datastore, otherwise I suspect you will need to write new code for the datastores.
– Ian Turton
Nov 12 '18 at 8:54
if you can get a JNDI reference for the datastore you could use that to create a new geotools datastore, otherwise I suspect you will need to write new code for the datastores.
– Ian Turton
Nov 12 '18 at 8:54
It should be possible to enable JNDI in Spring Boot's embedded Tomcat and add the DataSource to the NamingContext with some JNDI name. Will have a go at it.
– jbx
Nov 12 '18 at 8:59
It should be possible to enable JNDI in Spring Boot's embedded Tomcat and add the DataSource to the NamingContext with some JNDI name. Will have a go at it.
– jbx
Nov 12 '18 at 8:59
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53258636%2fis-there-a-way-for-geotools-postgis-datastore-to-use-a-jee-datasource%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53258636%2fis-there-a-way-for-geotools-postgis-datastore-to-use-a-jee-datasource%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
if you can get a JNDI reference for the datastore you could use that to create a new geotools datastore, otherwise I suspect you will need to write new code for the datastores.
– Ian Turton
Nov 12 '18 at 8:54
It should be possible to enable JNDI in Spring Boot's embedded Tomcat and add the DataSource to the NamingContext with some JNDI name. Will have a go at it.
– jbx
Nov 12 '18 at 8:59