Java SqlJetDb.open方法代码示例

import org.tmatesoft.sqljet.core.table.SqlJetDb; //导入方法依赖的package包/类
/**
 * Export the Access database to the given SQLite database. The referenced
 * SQLite database should be empty.
 * 
 * @param mdbFile The MS Access file.
 * @param sqliteFile The SQLite file.
 * @throws SQLException
 * @throws SqlJetException
 */
public static void export(File mdbFile, File sqliteFile) throws Exception {
	Database mdb = DatabaseBuilder.open(mdbFile);

	SqlJetDb sqlite = SqlJetDb.open(sqliteFile, true);
	sqlite.getOptions().setAutovacuum(true);
	sqlite.beginTransaction(SqlJetTransactionMode.WRITE);

	// Create the tables
	MDB2SQLite.createTables(mdb, sqlite);

	// Populate the tables
	for (String tableName : mdb.getTableNames()) {
		MDB2SQLite.populateTable(sqlite, mdb.getTable(tableName));
	}
}
 

import org.tmatesoft.sqljet.core.table.SqlJetDb; //导入方法依赖的package包/类
public P2PBlobRepositoryFS(File repositoryDirectory) throws Exception {
	this.repositoryDirectory=repositoryDirectory;
	if(repositoryDirectory.exists()==false){
	  repositoryDirectory.mkdirs();
	}
	
	try {
		File dbFile=new File(repositoryDirectory, REPOSITORY_DB_FILENAME);
		boolean schemaNeedsToBeCreated=dbFile.exists()==false;
		db = new SqlJetDb(dbFile, true);
		db.open();
		maybeCreateSchema(schemaNeedsToBeCreated);
	} catch (SqlJetException e) {
		throw new RuntimeException(e);
	}
	
	for(File nonRepositoryFile:repositoryDirectory.listFiles(nonRepositoryFilenameFilter)){
		importFileIntoRepository(nonRepositoryFile);
	}

}
 

import org.tmatesoft.sqljet.core.table.SqlJetDb; //导入方法依赖的package包/类
public HashToPublicKeyDB() {
	super(UnsignedLong.ONE); // FIXME Get the db version number from SQL
	try {
		db = new SqlJetDb(SqlJetDb.IN_MEMORY, true);
		db.open();
		maybeCreateSchema();
	} catch (SqlJetException e) {
		throw new RuntimeException(e);
	}
}
 

import org.tmatesoft.sqljet.core.table.SqlJetDb; //导入方法依赖的package包/类
public SelfRegistrationDHT(ServerMain serverMain) throws Exception {
  super(serverMain);
  setEntryTimeToLive(1, TimeUnit.DAYS);
  setEntryMaximumCardinality(1000);
  setEntryOverflowHandling(OverflowHandling.LIFO); //LIFO or FIFO    

  File serverFile=serverMain.getConfig().getFileRelativeFromConfigDirectory(DHT_FILENAME);
  boolean dbExists=serverFile.exists();
  db = new SqlJetDb(serverFile, true);
  db.open();
  if(dbExists==false){
    createSchema();
  }
  dhtValueTable=db.getTable(DHT_VALUE_TABLE_NAME);
}
 

import org.tmatesoft.sqljet.core.table.SqlJetDb; //导入方法依赖的package包/类
/**
 * Get a connection to the database for the current thread. Also closes all invalid connections for the current
 * thread.
 * @return
 *      The connection or null if the connection couldn't be established.
 *
 * @see #connections
 */
private SqlJetDb getDatabaseConnection() {
    Thread t = Thread.currentThread();
    File folder = folderHolder.getKachleCacheFolder().getEffectiveFile();
    File f = new File(folder, FILE_NAME);
    AbstractMap.SimpleImmutableEntry<Thread, File> mapKey = new AbstractMap.SimpleImmutableEntry<>(t, f);

    if (connections.containsKey(mapKey)) {
        // Got a valid connection
        return connections.get(mapKey);
    } else {
        try {
            // create a new connection
            SqlJetDb database = SqlJetDb.open(f, true);

            // Initialize the DB if needed
            if (!isDbInitialized(database)) {
                initDb(database);
            }

            // Close all deprecated connections (should be exactly one or zero)
            // Done here for synchronization reasons. This way, we never close an active connection that's
            // needed elsewhere at the same moment and there's always at most one connection per thread.
            for (Map.Entry<Map.Entry<Thread, File>, SqlJetDb> conn : connections.entrySet()) {
                if (conn.getKey().getKey().equals(t)) {
                    conn.getValue().close();
                    connections.remove(conn.getKey());
                }
            }

            // Now, store the new connection and return it
            connections.put(mapKey, database);
            return database;
        } catch (SqlJetException e) {
            log.error("Unable to establish the DB connection!", e);
            return null;
        }
    }
}