posts - 9, comments - 8, trackbacks - 0, articles - 3
          
	
 
BlogJava ::
首頁 ::
新隨筆 ::
聯系 ::
聚合
 ::
管理


          
		          		
	
          
	
          
		
			
          
			
          
		          		
		
			
          
				
					
	
          
		
		
          在ActiveMQ4.1 +Spring2.0的POJO JMS方案(Jencks 版)?基礎上增加了按照spring 2.0 新方式的持久化配置

          在<amq:broker>里面增加了
          ?

          ?? 

          <amq:persistenceAdapter>
          ????????????          <amq:jdbcPersistenceAdapter?id="jdbcAdapter"?dataSource="#hsql-ds"?createTablesOnStartup="true"?useDatabaseLock="false"/>
          ????????????          <!--?
          ????????????????Mysql?can?setup?useDatabaseLock="true",this?is?defualt
          ????????????????HSQLDB,MSSQL?plz?setup?useDatabaseLock="false",
          ????????????????if?u?setup?useDatabaseLock="true",u?will?catch?error:
          ????????????????MSSQL?Error?Info:FOR?UPDATE?clause?allowed?only?for?DECLARE?CURSOR?
          ????????????????HSQLDB?Error?Info:FOR?in?statement?[SELECT?*?FROM?ACTIVEMQ_LOCK?FOR?UPDATE]

          ????????????????see?http://www.nabble.com/ActiveMQ-JDBC-Persistence-with-SQL-Server-tf2022248.html#a5560296
          ????????????          -->
          ????????          </amq:persistenceAdapter>


          請注意MSSQL(2000/2005)和HSQL由于不支持[SELECT? * ACTIVEMQ_LOCK FOR UPDATE ]
          語法,因此不能使用默認的userDatabaseLock="true",只能設置成useDatabaseLock="false"

          時在spring里面配置了多個數據源


          1.SpringSide 使用內嵌的HSQL

          ?<!--?The?HSQL?Datasource?that?will?be?used?by?the?Broker?-->
          ????          <bean?id="hsql-ds"?class="org.apache.commons.dbcp.BasicDataSource"?destroy-method="close">
          ????????          <property?name="driverClassName">
          ????????????          <value>org.hsqldb.jdbcDriver</value>
          ????????          </property>
          ????????          <property?name="url">
          ????????????          <!--springside?use?HSQL,table?info?see?hsql/activemq.script-->
          ????????????          <value>jdbc:hsqldb:res:hsql/activemq</value>
          ????????          </property>
          ????????          <property?name="username">
          ????????????          <value>sa</value>
          ????????          </property>
          ????????          <property?name="password">
          ????????????          <value></value>
          ????????          </property>
          ????????          <property?name="poolPreparedStatements">
          ????????????          <value>true</value>
          ????????          </property>
          ????          </bean>

          2.MySql 

          ?<!--?MySql?DataSource?Sample?Setup?-->
          ????          <bean?id="mysql-ds"?class="org.apache.commons.dbcp.BasicDataSource"?destroy-method="close">
          ????????          <property?name="driverClassName">
          ????????????          <value>com.mysql.jdbc.Driver</value>
          ????????          </property>
          ????????          <property?name="url">
          ????????????          <value>jdbc:mysql://localhost/myproject?relaxAutoCommit=true</value>
          ????????          </property>
          ????????          <property?name="username">
          ????????????          <value>activemq</value>
          ????????          </property>
          ????????          <property?name="password">
          ????????????          <value>activemq</value>
          ????????          </property>
          ????          </bean>

          3.MSSQL

          <!--?The?MSSQL?Datasource?Sample?Setup?-->
          ????          <bean?id="mssql-ds"?class="org.apache.commons.dbcp.BasicDataSource"?destroy-method="close">
          ????????          <property?name="driverClassName">
          ????????????          <value>net.sourceforge.jtds.jdbc.Driver</value>
          ????????          </property>
          ????????          <property?name="url">
          ????????????          <value>jdbc:jtds:sqlserver://127.0.0.1:1433/YourDataBase</value>
          ????????          </property>
          ????????          <property?name="username">
          ????????????          <value>yourusername</value>
          ????????          </property>
          ????????          <property?name="password">
          ????????????          <value>youruserpassword</value>
          ????????          </property>
          ????????          <property?name="poolPreparedStatements">
          ????????????          <value>true</value>
          ????????          </property>
          ????          </bean>????
          
	
          
	


          
	    
    




          








          

				
			
          
		          		
	
          
	
          
		
			


		
	
          

          


    







          
        
	




主站蜘蛛池模板：
郴州市|
山东|
绍兴县|
恩平市|
尤溪县|
客服|
盱眙县|
巫山县|
昂仁县|
怀安县|
诸城市|
玉门市|
汾阳市|
方正县|
大石桥市|
恩平市|
南澳县|
兴山县|
东山县|
靖安县|
松原市|
盐源县|
上思县|
天长市|
车致|
元阳县|
三明市|
宁强县|
莱西市|
三台县|
鄂托克旗|
桂东县|
广南县|
兰西县|
连州市|
得荣县|
山丹县|
霍城县|
吉木萨尔县|
桐乡市|
广汉市|