[DL-Learner SVN] SF.net SVN: dl-learner:[3725] trunk/components-core/src/main/java/org/ dllearner/kb/sparql/ExtractionDBCache.java

[<ki...@us...>]

Revision: 3725
          http://dl-learner.svn.sourceforge.net/dl-learner/?rev=3725&view=rev
Author:   kirdie
Date:     2012-06-07 11:06:43 +0000 (Thu, 07 Jun 2012)
Log Message:
-----------
added new constructor to extraction db cache

Modified Paths:
--------------
    trunk/components-core/src/main/java/org/dllearner/kb/sparql/ExtractionDBCache.java

Modified: trunk/components-core/src/main/java/org/dllearner/kb/sparql/ExtractionDBCache.java
===================================================================
--- trunk/components-core/src/main/java/org/dllearner/kb/sparql/ExtractionDBCache.java	2012-06-01 09:27:59 UTC (rev 3724)
+++ trunk/components-core/src/main/java/org/dllearner/kb/sparql/ExtractionDBCache.java	2012-06-07 11:06:43 UTC (rev 3725)
@@ -69,6 +69,14 @@
 	
 	private Monitor mon = MonitorFactory.getTimeMonitor("Query");
 	
+	public ExtractionDBCache(Connection conn) throws SQLException
+	{
+		this.conn=conn;
+	        // create cache table if it does not exist
+		Statement stmt = conn.createStatement();
+		stmt.execute("CREATE TABLE IF NOT EXISTS QUERY_CACHE(QUERYHASH BINARY PRIMARY KEY,QUERY VARCHAR(20000), TRIPLES CLOB, STORE_TIME TIMESTAMP)");		
+	}
+
 	public ExtractionDBCache(String cacheDir) {
 		databaseDirectory = cacheDir;
 		try {

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.