Hello all,
For a proof of concept I am trying to connect SAP HANA to my GeoServer
setup. My GeoServer is currently running locally and I have attached a
PostGis database to save geometries drawn with my application. The goal is
to replace the PostGis database with the SAP HANA one.
My application consists of the use of OpenLayers and JTS methods to
calculate intersections and to draw and edit features.
When searching for ways to connect my GeoServer to a Database not present in
the list inside GeoServer, I found out that you could download a plugin so
that you can adjust your JDBC-properties called jdbcConfig. My config file
currently has the following parameters:
enabled=false
initdb=false
initScript=${GEOSERVER_DATA_DIR}/jdbcconfig/scripts/initdb.oracle.sql
import=false
jdbcUrl=jdbc\:sap\://saphana1.creetion.com\:30015
driverClassName=com.sap.db.jdbc.Driver
username=SYSTEM
password=Creetion01
pool.minIdle=4
pool.maxActive=10
pool.poolPreparedStatements=true
pool.maxOpenPreparedStatements=50
pool.testOnBorrow=true
pool.validationQuery=SELECT SRS_OID from SYS.ST_SPATIAL_REFERENCE_SYSTEMS_
WHERE SRS_OID = 151798
When running GeoServer it instantly gives the following errors:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'geoServerLoader' defined in URL
[jar:file:/D:/Programs/GeoServer%202.4.0/webapps/geoserver/WEB-INF/lib/main-2.4.0.jar!/applicationContext.xml]:
Initialization of bean failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'JDBCGeoServerLoader' defined in URL
[jar:file:/D:/Programs/GeoServer%202.4.0/
webapps/geoserver/WEB-INF/lib/jdbcconfig-2.4-SNAPSHOT.jar!/applicationContext.xml]:
Error setting property values;
nested exception is org.springframework.beans.PropertyBatchUpdateException;
nested PropertyAccessExceptions (1) are:
PropertyAccessException 1:
org.springframework.beans.MethodInvocationException: Property
'catalogFacade' threw exception;
nested exception is org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [insert into
type (typename) values (?)];
SQL state [null]; error code [0]; Borrow prepareStatement from pool failed;
nested exception is org.apache.commons.dbcp.SQLNestedException: Borrow
prepareStatement from pool failed
My Database is currently behind a VPN connection and according to the errors
my validationQuery is correct.
Now, my question is:
Does anyone have any experience connecting an alternative database to
geoserver using the JDBC config plugin. If so, are there any adjustments I
should make to my file or?
Thanks in advance,
Niels
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Issues-connecting-GeoServer-to-SAP-HANA-tp5092357.html
Sent from the GeoServer - Dev mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
