<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Database Replication"]]></title>
		<link>http://s4j.mentaframework.org/posts/list/2.page</link>
		<description><![CDATA[Latest messages posted in the topic "Database Replication"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Database Replication</title>
				<description><![CDATA[ We know that it is impossible to abandon your good and old relational database. You will probably need to do offline reports and heavy queries and a relational database is perfect for that. So what you need is to replicate all your Space4J commands to a relational database. To do this you can implement the executeSQL method for your commands so that you can later read the logs and execute them against a relational database.<br /> <br /> Check the method below from the [i]Command [/i]interface:<br /> <br /> [code]<br />     /**<br />      * This method will let you replicate your data in a relational database,<br />      * so you can continue creating your reports and using data data warehousing tools with SQL.<br />      * Doing this with Space4J and Commands is possible, but not recommended at all.<br />      * Note that this method is not abstract, therefore it is not required. <br />      * It is up to the system to replicate its data in a relational database.<br />      * &lt;i&gt;Rodolfo de Paula was the first one to raise this issue! Why not have the best of both worlds?&lt;/i&gt;<br />      * @param conn A connection to the database where this command will be executed through SQL.<br />      * @throws SQLException If there was an error executing the SQL.<br />      */<br />     public void executeSQL(Connection conn) throws SQLException {}<br /> [/code]<br /> <br /> [u]ToDo:[/u] Create a standalone program that read the logs and execute them against a JDBC connection.<br /> ]]></description>
				<guid isPermaLink="true">http://s4j.mentaframework.org/posts/preList/7/7.page</guid>
				<link>http://s4j.mentaframework.org/posts/preList/7/7.page</link>
				<pubDate><![CDATA[Fri, 5 Sep 2008 16:28:02]]> GMT</pubDate>
				<author><![CDATA[ saoj]]></author>
			</item>
	</channel>
</rss>