Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@activemq.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Date: Thu, 29 Mar 2012 07:57:30 -0700 (PDT)
From: mikmela <mikmela@yahoo.com>
To: users@activemq.apache.org
Message-ID: <1333033050236-4515693.post@n4.nabble.com>
In-Reply-To: <1332614997346-4501897.post@n4.nabble.com>
References: <1332614997346-4501897.post@n4.nabble.com>
Subject: Re: how to make activemq switch to JDBCPersistenceAdapter in source
 code?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

There are many ways to  do it, but steps are
1. Create a datasource
2. Set it on JDBCPersistenceAdapter object.
3. Set PersistenceAdapter object on the broker instance...

Below code for illustration only...

 protected PersistenceAdapter createJDBCPersistenceAdapter(DataSource ds,
boolean createOnStartup)       {
    	JDBCPersistenceAdapter persistenceAdapter = null;
         ....
    	
    	persistenceAdapter = new JDBCPersistenceAdapter();
    	persistenceAdapter.setDataSource(ds);
    	persistenceAdapter.setCreateTablesOnStartup(createOnStartup);
    	
    	
    	return persistenceAdapter;
    }
    protected void configureJDBC() {
		DataSource ds = createDataSource();

		PersistenceAdapter persistenceAdapter = createJDBCPersistenceAdapter(ds,
false);
		try {
				this.broker.setPersistenceAdapter(persistenceAdapter);
			} catch ( IOException ex ) {
				throw new Exception ( "Failed to set JDBC: " + ex.toString());
			}
	}

    protected DataSource createDataSource(String url, String driverFQN,
String user, String password) 
    {
    	BasicDataSource ds = new BasicDataSource();
    	ds.setUsername(user);
    	ds.setPassword(password);
    	ds.setDriverClassName(driverFQN);//"oracle.jdbc.driver.OracleDriver");
    	ds.setUrl(url);//"jdbc:oracle:thin:@//haha:1521/haha1");
    	ds.setPoolPreparedStatements(true);
    	return ds;
    }


--
View this message in context: http://activemq.2283324.n4.nabble.com/how-to-make-activemq-switch-to-JDBCPersistenceAdapter-in-source-code-tp4501897p4515693.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.