{"id":51,"date":"2017-04-15T13:24:44","date_gmt":"2017-04-15T05:24:44","guid":{"rendered":"http:\/\/av16874667.imwork.net:13582\/?p=51"},"modified":"2017-04-15T13:24:44","modified_gmt":"2017-04-15T05:24:44","slug":"ssh_demo-applicationcontext-xml%e4%b8%ad%e4%bd%bf%e7%94%a8hibernate%e8%bf%9e%e6%8e%a5%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.dd-home.top\/?p=51","title":{"rendered":"SSH_DEMO applicationContext.xml\u4e2d\u4f7f\u7528hibernate\u8fde\u63a5\u6570\u636e\u5e93"},"content":{"rendered":"

<\/p>\n

\u00a0<context:property-placeholder\u00a0location=\"classpath:jdbc.properties\"\/>\n\u00a0<!--\u00a0\u4ee5\u4e0b\u65b9\u6cd5\u4e3a\u4f7f\u7528hibernate\u76f4\u63a5\u8fde\u63a5\u6570\u636e\u5e93\u00a0-->\n\u00a0<bean\u00a0id=\"dataSource\"\u00a0class=\"org.apache.commons.dbcp2.BasicDataSource\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"driverClassName\"\u00a0value=\"${jdbc.driverClassName}\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"url\"\u00a0value=\"${jdbc.url}\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"username\"\u00a0value=\"${jdbc.username}\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<!--\u00a0property\u6c60\u542f\u52a8\u65f6\u7684\u521d\u59cb\u503c\u00a0\u00a0-->\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"password\"\u00a0value=\"${jdbc.password}\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u8fde\u63a5name=\"initialSize\"\u00a0value=\"${initialSize}\"\/>-->\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"initialSize\"\u00a0value=\"1\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u8fde\u63a5\u6c60\u7684\u6700\u5927\u503c\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"maxActive\"\u00a0value=\"500\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0-->\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u6700\u5927\u7a7a\u95f2\u503c.\u5f53\u7ecf\u8fc7\u4e00\u4e2a\u9ad8\u5cf0\u65f6\u95f4\u540e\uff0c\u8fde\u63a5\u6c60\u53ef\u4ee5\u6162\u6162\u5c06\u5df2\u7ecf\u7528\u4e0d\u5230\u7684\u8fde\u63a5\u6162\u6162\u91ca\u653e\u4e00\u90e8\u5206\uff0c\u4e00\u76f4\u51cf\u5c11\u5230maxIdle\u4e3a\u6b62\u00a0-->\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"maxIdle\"\u00a0value=\"2\"\/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u00a0\u6700\u5c0f\u7a7a\u95f2\u503c.\u5f53\u7a7a\u95f2\u7684\u8fde\u63a5\u6570\u5c11\u4e8e\u9600\u503c\u65f6\uff0c\u8fde\u63a5\u6c60\u5c31\u4f1a\u9884\u7533\u8bf7\u53bb\u4e00\u4e9b\u8fde\u63a5\uff0c\u4ee5\u514d\u6d2a\u5cf0\u6765\u65f6\u6765\u4e0d\u53ca\u7533\u8bf7\u00a0-->\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"minIdle\"\u00a0value=\"1\"\/>\n\n\u00a0\u00a0\u00a0\u00a0<\/bean>\n\u00a0\u00a0\u00a0\u00a0<bean\u00a0id=\"sessionFactory\"\u00a0class=\"org.springframework.orm.hibernate4.LocalSessionFactoryBean\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0p:dataSource-ref=\"dataSource\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"hibernateProperties\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<props>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.dialect\">${hibernate.dialect}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.show_sql\">${hibernate.show_sql}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.format_sql\">${hibernate.format_sql}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.hbm2ddl.auto\">${hibernate.hbm2ddl.auto}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.cache.use_second_level_cache\">${hibernate.cache.use_second_level_cache}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.cache.use_query_cache\">${hibernate.cache.use_query_cache}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<prop\u00a0key=\"hibernate.cache.region.factory_class\">${hibernate.cache.region.factory_class}<\/prop>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/props>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/property>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u52a0\u8f7dhibernate\u7684jpa\u6ce8\u89e3\u5f62\u5f0f\u5b9e\u4f53\u00a0-->\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"packagesToScan\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<list>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<value>com.nbad.*<\/value>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/list>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/property>\n\u00a0\u00a0\u00a0\u00a0<\/bean>\n\u00a0\u00a0\u00a0\u00a0\n\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u914d\u7f6e\u4e8b\u52a1\u7ba1\u7406\u5668\u00a0-->\n\u00a0\u00a0\u00a0\u00a0<bean\u00a0id=\"transactionManager\"\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0class=\"org.springframework.orm.hibernate4.HibernateTransactionManager\">\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property\u00a0name=\"sessionFactory\"\u00a0ref=\"sessionFactory\"\/>\n\u00a0\u00a0\u00a0\u00a0<\/bean>\n\n\u00a0\u00a0\u00a0\u00a0<!--\u00a0\u914d\u7f6e\u58f0\u660e\u5f0f\u4e8b\u52a1\uff1a\u65b9\u6cd5\u4e00\uff0c\u5728Service\u5b9e\u73b0\u7c7b\u6216\u8005public\u5b9e\u73b0\u65b9\u6cd5\u4e0a\u4f7f\u7528\u6ce8\u89e3@Transactional\uff0c\u5219\u6b64\u7c7b\u6216\u65b9\u6cd5\u5c31\u4f1a\u542f\u7528\u4e8b\u52a1\u673a\u5236\u00a0-->\n\u00a0\u00a0\u00a0\u00a0<tx:annotation-driven\u00a0transaction-manager=\"transactionManager\"\/><\/pre>\n
jdbc.properties<\/p>\n
####################### \u00a0DB Connection Config \u00a0#######################<\/p>\n
###—————– DB Type —————–<\/p>\n
#the database of the application:mysql|sqlserver|oracle<\/p>\n
databaseType=mysql<\/p>\n
#databaseType=sqlserver<\/p>\n
#databaseType=oracle<\/p>\n
###—————– MySQL5+ —————–<\/p>\n
jdbc.driverClassName=com.mysql.jdbc.Driver<\/p>\n
jdbc.url=jdbc:mysql:\/\/localhost:3306\/demo?useUnicode=true&characterEncoding=utf-8<\/p>\n
jdbc.username=root<\/p>\n
jdbc.password=root<\/p>\n
hibernate.dialect=org.hibernate.dialect.MySQLDialect<\/p>\n
###—————– SqlServer2005+ —————–<\/p>\n
#jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver<\/p>\n
#jdbc.url=jdbc:sqlserver:\/\/localhost:1433;DatabaseName=sampledb<\/p>\n
#jdbc.username=sa<\/p>\n
#jdbc.password=123456<\/p>\n
#hibernate.dialect=org.hibernate.dialect.SQLServerDialect<\/p>\n
###—————– Oracle10g+ —————–<\/p>\n
#jdbc.driverClassName=oracle.jdbc.driver.OracleDriver<\/p>\n
#jdbc.url=jdbc:oracle:thin:@localhost:1521:orac10g<\/p>\n
#jdbc.username=scott<\/p>\n
#jdbc.password=scott123<\/p>\n
#hibernate.dialect=org.hibernate.dialect.OracleDialect<\/p>\n
###—————– JNDI —————–<\/p>\n
#jndi.name=myjndi123<\/p>\n
###—————– Hibernate —————–<\/p>\n
hibernate.show_sql=true<\/p>\n
hibernate.format_sql=true<\/p>\n
hibernate.hbm2ddl.auto=update<\/p>\n
hibernate.jdbc.fetch_size=100<\/p>\n
hibernate.jdbc.batch_size=20<\/p>\n
hibernate.cache.use_second_level_cache=true<\/p>\n
hibernate.cache.use_query_cache=true<\/p>\n
hibernate.memcached.cacheTimeSeconds=10800<\/p>\n
#Hibernate4<\/p>\n
hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheRegionFactory<\/p>\n
#Hibernate3<\/p>\n
#hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheProvider<\/p>\n
###—————– C3P0 —————–<\/p>\n
c3p0.maxPoolSize=50<\/p>\n
c3p0.minPoolSize=1<\/p>\n
c3p0.initialPoolSize=1<\/p>\n
c3p0.maxIdleTime=20<\/p>\n
###—————– DBCP —————–<\/p>\n
dbcp.maxActive=50<\/p>\n
dbcp.maxIdle=50<\/p>\n
dbcp.minIdle=1<\/p>\n
dbcp.maxWait=10000<\/p>\n
dbcp.initialSize=1<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[46,55],"class_list":["post-51","post","type-post","status-publish","format-standard","hentry","category-web","tag-hibernate","tag-ssh"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/51","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=51"}],"version-history":[{"count":0,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/51\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=51"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=51"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=51"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}