Guest User

Untitled

a guest
Dec 3rd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.07 KB | None | 0 0
  1. <Resource
  2. name="jdbc/geonetwork"
  3. type="javax.sql.DataSource"
  4. auth="Container"
  5. driverClassName="org.postgresql.Driver"
  6. url="jdbc:postgresql://localhost:5432/geonetwork"
  7. username="geonetwork_user"
  8. password=""
  9. maxActive="20"
  10. maxIdle="20"
  11. maxWait="200"
  12. initialSize="20"
  13. removeAbandoned="true"
  14. removeAbandonedTimeout="120"
  15. logAbandoned="true"
  16. testOnBorrow="true"
  17. defaultReadOnly="false"
  18. defaultAutoCommit="false"
  19. validationQuery="SELECT 1"
  20. timeBetweenEvictionRunsMillis="10000"
  21. minEvictableIdleTimeMillis="1800000"
  22. testWhileIdle="true"
  23. numTestsPerEvictionRun="3"
  24. poolPreparedStatements="true"
  25. maxOpenPreparedStatements="1200"
  26. provideDataStore="true" --> tried this to build spatialindex table
  27. />
  28.  
  29. <bean id="jdbcDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  30. <property name="jndiName" value="java:/comp/env/jdbc/geonetwork"/>
  31. <property name="cache" value="true"/>
  32. <property name="exposeAccessContext" value="false"/>
  33. </bean>
  34. <bean id="jpaVendorAdapterDatabaseParam" class="java.lang.String">
  35. <constructor-arg value="POSTGRESQL"/>
  36. </bean>
  37.  
  38. CREATE TABLE spatialindex
  39. (
  40. fid int not null,
  41. id varchar(250),
  42. primary key(fid)
  43. );
  44. CREATE INDEX spatialindexNDX1 ON spatialindex(id);
  45. SELECT AddGeometryColumn('spatialindex', 'the_geom', 4326, 'MULTIPOLYGON', 2 );
  46. CREATE INDEX spatialindexNDX2 on spatialindex USING GIST(the_geom);
  47.  
  48. <import resource="defaultJdbcDataSource.xml" />
  49. <import resource="postgis-alternate-datasource.xml" />
  50.  
  51. <bean id="jpaVendorAdapterDatabaseParam" class="java.lang.String">
  52. <constructor-arg value="POSTGRESQL"/>
  53. </bean>
  54.  
  55. <bean id="jdbcDriverClassName" class="java.lang.String">
  56. <constructor-arg value="org.postgis.DriverWrapper"/>
  57. </bean>
  58.  
  59. <bean id="jdbcURL" class="java.lang.String">
  60. <constructor-arg value="jdbc:postgresql_postGIS://${jdbc.host}:${jdbc.port}/${jdbc.database}"/>
  61. </bean>
Add Comment
Please, Sign In to add comment