######################### JDBC ################################## #jdbc.driverClassName=com.mysql.jdbc.Driver #jdbc.url=jdbc:mysql://127.0.0.1:3306/room?characterEncoding=UTF-8 #jdbc.url=jdbc:mysql://127.0.0.1:3306/eoas?zeroDateTimeBehavior=convertToNull&characterEncoding=UTF-8 #jdbc.username=root #jdbc.password=40342123 jdbc.driverClassName=oracle.jdbc.driver.OracleDriver #jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl jdbc.url=jdbc:oracle:thin:@192.168.31.30:1521:orcl #jdbc.url=jdbc:oracle:thin:@47.92.168.204:30051:EE #jdbc.url=jdbc:oracle:thin:@47.104.236.109:1521:orcl jdbc.username=CLOUDS_HL jdbc.password=CLOUDS_HL #jdbc.username=fycloudsplus #jdbc.password=fycloudsplus #jdbc.username=fycloudsplus_yq #jdbc.password=fycloudsplus_yq #jdbc.username=clouds_qx #jdbc.password=clouds_qx #jdbc.username=clouds_cj #jdbc.password=clouds_cj #c3p0 config #\u5F53\u8FDE\u63A5\u6C60\u4E2D\u7684\u8FDE\u63A5\u8017\u5C3D\u7684\u65F6\u5019c3p0\u4E00\u6B21\u540C\u65F6\u83B7\u53D6\u7684\u8FDE\u63A5\u6570 #c3p0.acquireIncrement=10 #\u521D\u59CB\u5316\u65F6\u8FDE\u63A5\u6570,\u53D6\u503C\u5E94\u5728minPoolSize\u4E0EmaxPoolSize\u4E4B\u95F4 #c3p0.initialPoolSize=30 #\u68C0\u67E5\u6240\u6709\u8FDE\u63A5\u6C60\u4E2D\u7684\u7A7A\u95F2\u8FDE\u63A5\u7684\u95F4\u9694\u79D2\u6570 #c3p0.idleConnectionTestPeriod=60 #\u8FDE\u63A5\u6C60\u4E2D\u4FDD\u7559\u7684\u6700\u5C0F\u8FDE\u63A5\u6570 #c3p0.minPoolSize=20 #\u8FDE\u63A5\u6C60\u4E2D\u4FDD\u7559\u7684\u6700\u5927\u8FDE\u63A5\u6570 #c3p0.maxPoolSize=80 #\u6570\u636E\u6E90\u5185\u52A0\u8F7D\u7684PreparedStatements\u6570\u91CF #c3p0.maxStatements=100 #\u652F\u6301\u7684\u5E2E\u52A9\u8FDB\u7A0B\u6570 #c3p0.numHelperThreads=10 #\u6700\u5927\u7A7A\u95F2\u65F6\u95F4,600\u79D2\u5185\u672A\u4F7F\u7528\u5219\u8FDE\u63A5\u88AB\u4E22\u5F03\u3002\u82E5\u4E3A0\u5219\u6C38\u4E0D\u4E22\u5F03 #c3p0.maxIdleTime=600 #druid config druid.initialSize=10 druid.minIdle=10 druid.maxActive=100 #\u914D\u7F6E\u83B7\u53D6\u8FDE\u63A5\u7B49\u5F85\u8D85\u65F6\u7684\u65F6\u95F4 druid.maxWait=10000 #\u914D\u7F6E\u95F4\u9694\u591A\u4E45\u624D\u8FDB\u884C\u4E00\u6B21\u68C0\u6D4B\uFF0C\u68C0\u6D4B\u9700\u8981\u5173\u95ED\u7684\u7A7A\u95F2\u8FDE\u63A5\uFF0C\u5355\u4F4D\u662F\u6BEB\u79D2 druid.timeBetweenEvictionRunsMillis=60000 #\u914D\u7F6E\u4E00\u4E2A\u8FDE\u63A5\u5728\u6C60\u4E2D\u6700\u5C0F\u751F\u5B58\u7684\u65F6\u95F4\uFF0C\u5355\u4F4D\u662F\u6BEB\u79D2 druid.minEvictableIdleTimeMillis=300000 #druid.validationQuery=SELECT 'x' FROM DUAL"/> #druid.testWhileIdle=true"/> #druid.testOnBorrow=false"/> #druid.testOnReturn=false"/> #\u6253\u5F00PSCache\uFF0C\u5E76\u4E14\u6307\u5B9A\u6BCF\u4E2A\u8FDE\u63A5\u4E0APSCache\u7684\u5927\u5C0F \u5982\u679C\u7528Oracle\uFF0C\u5219\u628ApoolPreparedStatements\u914D\u7F6E\u4E3Atrue\uFF0Cmysql\u53EF\u4EE5\u914D\u7F6E\u4E3Afalse druid.poolPreparedStatements=true druid.maxPoolPreparedStatementPerConnectionSize=20 #hibernate config #hibernate.dialect=org.hibernate.dialect.Oracle10gDialect #hibernate.dialect=net.obj8.core.mysql.dialect.MySQLLocalDialect #hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect #hibernate.jdbc.batch_size=25 #hibernate.jdbc.fetch_size=50 #hibernate.show_sql=true #hibernate.hbm2ddl.auto=none #hibernate.temp.use_jdbc_metadata_defaults=false #hibernate.jdbc.use_scrollable_resultset=true #hibernate.cache.provider_class=org.hibernate.cache.OSCacheProvider #hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider #hibernate.cache.provider_class=org.hibernate.connection.C3P0ConnectionProvider #hibernate.connection.pool_size=30 #hibernate.cache.use_query_cache=true