svn checkout http://h2database.googlecode.com/svn/trunk/ h2database-read-only
 cd h2database-read-only/h2
 ./build.sh mavenInstallLocal
 

<project>
 	...
 	<dependencies>
 		...
 		<dependency>
 			<groupId>com.h2database</groupId>
 			<artifactId>h2</artifactId>
 			<version>1.0-SNAPSHOT</version>
 		</dependency>
 		...
 	</dependencies>
 	...
 </project>

<IfModule mod_rewrite.c>
 	RewriteEngine On
 
 	RewriteCond %{REQUEST_URI} ^(system|application).*
 	RewriteRule ^(.*)$ /index.php?/$1 [L]
 
 	RewriteCond %{REQUEST_FILENAME} !-f
 	RewriteCond %{REQUEST_FILENAME} !-d
 	RewriteRule ^(.*)$ index.php?/$1 [L]
 </IfModule>
 
 <IfModule !mod_rewrite.c>
 	ErrorDocument 404 /index.php
 </IfModule>

$assign_to_config = array();

$db['default']['hostname'] = 'mysql:';
 $db['default']['dbdriver'] = 'pdo';

	/**
 	 * Number of rows in the result set
 	 *
 	 * @access	public
 	 * @return	integer
 	 */
 	function num_rows()
 	{
 		$sql = $this->result_id->queryString;
 		if(NULL === $sql) {
 			$sql = print_r($this->result_id, TRUE);
 			$quercus_preg = '/\Aresource\(PDOStatement\[(.*)\]\)\z/is';
 			$php_preg = '/\APDOStatement Object\s*\(.*=>\s*(.*)\)\s*\z/is';
 			if(preg_match($quercus_preg, $sql)) {
 				// We're running in Quercus
 				$sql = preg_replace($quercus_preg, '\1', $sql);
 			} else if(preg_match($php_preg, $sql)) {
 				// We're running in PHP
 				$sql = trim(preg_replace($php_preg, '\1', $sql));
 			} else {
 				// No clue about what is running this script!
 				$sql = NULL;
 			}
 		}
 		if (is_numeric(stripos($sql, 'SELECT')))
 		{
 			$count = count($this->result_id->fetchAll());
 			$this->result_id->execute();
 			return $count;
 		}
 		else
 		{
 			return $this->result_id->rowCount();
 		}
 	}

<?php
 
 class Test extends CI_Controller {
 	public function index() {
 		$this->load->database();
 		$sql = $this->db->query('CREATE TABLE IF NOT EXISTS test (value DATETIME)');
 		$sql = $this->db->set('value', 'NOW()', FALSE)->insert('test');
 		var_dump($this->db->get('test')->result());
 	}
 }