Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Resource
- name="jdbc/geonetwork"
- type="javax.sql.DataSource"
- auth="Container"
- driverClassName="org.postgresql.Driver"
- url="jdbc:postgresql://localhost:5432/geonetwork"
- username="geonetwork_user"
- password=""
- maxActive="20"
- maxIdle="20"
- maxWait="200"
- initialSize="20"
- removeAbandoned="true"
- removeAbandonedTimeout="120"
- logAbandoned="true"
- testOnBorrow="true"
- defaultReadOnly="false"
- defaultAutoCommit="false"
- validationQuery="SELECT 1"
- timeBetweenEvictionRunsMillis="10000"
- minEvictableIdleTimeMillis="1800000"
- testWhileIdle="true"
- numTestsPerEvictionRun="3"
- poolPreparedStatements="true"
- maxOpenPreparedStatements="1200"
- provideDataStore="true" --> tried this to build spatialindex table
- />
- <bean id="jdbcDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
- <property name="jndiName" value="java:/comp/env/jdbc/geonetwork"/>
- <property name="cache" value="true"/>
- <property name="exposeAccessContext" value="false"/>
- </bean>
- <bean id="jpaVendorAdapterDatabaseParam" class="java.lang.String">
- <constructor-arg value="POSTGRESQL"/>
- </bean>
- CREATE TABLE spatialindex
- (
- fid int not null,
- id varchar(250),
- primary key(fid)
- );
- CREATE INDEX spatialindexNDX1 ON spatialindex(id);
- SELECT AddGeometryColumn('spatialindex', 'the_geom', 4326, 'MULTIPOLYGON', 2 );
- CREATE INDEX spatialindexNDX2 on spatialindex USING GIST(the_geom);
- <import resource="defaultJdbcDataSource.xml" />
- <import resource="postgis-alternate-datasource.xml" />
- <bean id="jpaVendorAdapterDatabaseParam" class="java.lang.String">
- <constructor-arg value="POSTGRESQL"/>
- </bean>
- <bean id="jdbcDriverClassName" class="java.lang.String">
- <constructor-arg value="org.postgis.DriverWrapper"/>
- </bean>
- <bean id="jdbcURL" class="java.lang.String">
- <constructor-arg value="jdbc:postgresql_postGIS://${jdbc.host}:${jdbc.port}/${jdbc.database}"/>
- </bean>
Add Comment
Please, Sign In to add comment