Java JDBCDataSource类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› Java›Java编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Java中org.hsqldb.jdbc.JDBCDataSource类的典型用法代码示例。如果您正苦于以下问题：Java JDBCDataSource类的具体用法？Java JDBCDataSource怎么用？Java JDBCDataSource使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

JDBCDataSource类属于org.hsqldb.jdbc包，在下文中一共展示了JDBCDataSource类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: testSqlFilterComplex

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@SuppressWarnings("deprecation")
// @Test
public void testSqlFilterComplex() throws Exception {
  HashMap<String, Object> params = new HashMap<String, Object>();
  params.put("date_from", new Date("03/08/2003"));
  params.put("date_to", new Date("03/31/2010"));
  params.put("num_from", new Double(4));
  params.put("num_to", new Double(6));
  params.put("f", new Integer(3));
  params.put("t", new Integer(5));
  
  JDBCDataSource ds = new JDBCDataSource();
  ds.setDatabase(LocalTestConstants.TEST_DB_NAME);
  ds.setUser(LocalTestConstants.TEST_DB_USER);
  ds.setPassword(LocalTestConstants.TEST_DB_PASSWORD);
  
  HashMap<String, String[]> sparams = new HashMap<String, String[]>();
  sparams.put("conn", new String[] {"hsqldb"});
  testSqlFile("sql_filter_complex", true, 
                          SQL_FILTER_COMPLEX, params, ds, sparams);
}

开发者ID:osbitools，项目名称:OsBiToolsWs，代码行数:22，代码来源:DsDaemonTest.java

示例2: resetCredentialsCommand

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
/**
 * Reset admin credentials to username/password: admin/admin
 * 
 * @throws SQLException
 */
private static void resetCredentialsCommand() throws SQLException {
	System.out.println("*** RESET ADMIN CREDENTIALS TO admin / admin ***");
	JDBCDataSource dataSource = new JDBCDataSource();
	dataSource.setUrl("jdbc:hsqldb:hsql://localhost:" + System.getProperty("dbport") + "/data");
	dataSource.setUser("sa");
	dataSource.setPassword("");
	Connection connection = dataSource.getConnection();
	// admin ~
	// $2a$10$UHdpe.t2Xr3npu1AcDygO.FkiK5Ki4SmUU8oW.gD8liApMG4yDqw6
	PreparedStatement preparedStatement = connection
			.prepareStatement("update monit_configuration set admin_username = 'admin', admin_password = '$2a$10$UHdpe.t2Xr3npu1AcDygO.FkiK5Ki4SmUU8oW.gD8liApMG4yDqw6'");
	preparedStatement.executeUpdate();
	preparedStatement.close();
	connection.close();
}

开发者ID:jirkapinkas，项目名称:sitemonitoring-production，代码行数:21，代码来源:Main.java

示例3: Report

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
public Report(Configuration c) {
	reportSQL = c.reportSQL;
	reportDirectory = c.reportDirectory;

	log.info("Using database directory: " + c.databaseDirectory);		
	log.info("Using report directory: " + c.reportDirectory);
			
	File currentDir = new File("");
	String dbPath =  currentDir.getAbsolutePath() + File.separator + c.databaseDirectory + "db";
	connectionString = "jdbc:hsqldb:file:" + dbPath;

	datasource = new JDBCDataSource();
	((JDBCCommonDataSource)datasource).setUrl(connectionString);
	
	try {
		hsqldbDriver = (Driver) Class.forName("org.hsqldb.jdbcDriver").newInstance();
		DriverManager.registerDriver(hsqldbDriver);
	} catch (Exception e) {
		log.error("Could not instantiate database driver: " + e.getMessage());
	}

	write("DROP SCHEMA PUBLIC CASCADE");
	write("SET DATABASE DEFAULT RESULT MEMORY ROWS 1000");
	write("CREATE CACHED TABLE downloads ( url VARCHAR(4095), http_code INTEGER default 0, content_type VARCHAR(255), response_time INTEGER default 0, downloaded_at DATETIME default NOW, downloaded BOOLEAN)");
	write("CREATE CACHED TABLE links ( url_from VARCHAR(4095), url_to VARCHAR(4095))");
}

开发者ID:kristoffer-dyrkorn，项目名称:mightycrawler，代码行数:27，代码来源:Report.java

示例4: setup

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@BeforeEach
void setup() throws SQLException {
    registry = new SimpleMeterRegistry();

    ds = new JDBCDataSource();
    ds.setURL("jdbc:hsqldb:mem:test");

    try(Connection conn = ds.getConnection()) {
        conn.prepareStatement("CREATE TABLE foo (id int)").execute();
        conn.prepareStatement("INSERT INTO foo VALUES (1)").executeUpdate();
    }
}

开发者ID:micrometer-metrics，项目名称:micrometer，代码行数:13，代码来源:DatabaseTableMetricsTest.java

示例5: setUp

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@Before
public void setUp() throws Exception {
    final JDBCDataSource dataSource = HsqlUtil.setupDataSource();
    HsqlUtil.createCustomerTable(dataSource);
    final ConnectionManager connectionManager = new ConnectionManager(dataSource);
    transactionManager = new TransactionManager(connectionManager);
    jdbcService = new JdbcService(connectionManager);
}

开发者ID:oyvindBjerke，项目名称:jdbc-middleware，代码行数:9，代码来源:JdbcServiceTransactionTest.java

示例6: setupDataSource

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
public static JDBCDataSource setupDataSource() throws SQLException {
    final JDBCDataSource jdbcDataSource = new JDBCDataSource();
    jdbcDataSource.setDatabase("jdbc:hsqldb:mem:db");
    Statement statement = jdbcDataSource.getConnection().createStatement();
    statement.addBatch("DROP SCHEMA public CASCADE");
    statement.executeBatch();
    return jdbcDataSource;
}

开发者ID:oyvindBjerke，项目名称:jdbc-middleware，代码行数:9，代码来源:HsqlUtil.java

示例7: setUp

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@Before
public void setUp() {
	JDBCDataSource ds = new JDBCDataSource();
	ds.setURL("jdbc:hsqldb:mem:test");

	service = DatabaseService.builder(ds).setBackoffStrategy(attempt -> 0).build().start();
}

开发者ID:grahamedgecombe，项目名称:db，代码行数:8，代码来源:DatabaseServiceTest.java

示例8: setUp

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");

  JDBCDataSource dataSource = new JDBCDataSource();
  dataSource.setUrl("jdbc:hsqldb:mem:db4");
  dataSource.setUser("sa");
  dataSource.setPassword("");

  try (Connection conn = dataSource.getConnection()) {
    try (Reader reader = Resources.getResourceAsReader("org/mybatis/scripting/freemarker/create-db.sql")) {
      ScriptRunner runner = new ScriptRunner(conn);
      runner.setLogWriter(null);
      runner.setErrorLogWriter(null);
      runner.runScript(reader);
      conn.commit();
    }
  }

  TransactionFactory transactionFactory = new JdbcTransactionFactory();
  Environment environment = new Environment("development", transactionFactory, dataSource);

  // You can call configuration.setDefaultScriptingLanguage(FreeMarkerLanguageDriver.class)
  // after this to use FreeMarker driver by default.
  Configuration configuration = new Configuration(environment);

  configuration.addMapper(CustomizedDataContextMapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
}

开发者ID:mybatis，项目名称:freemarker-scripting，代码行数:30，代码来源:CustomizedDataContextTest.java

示例9: setUp

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");

  JDBCDataSource dataSource = new JDBCDataSource();
  dataSource.setUrl("jdbc:hsqldb:mem:db3");
  dataSource.setUser("sa");
  dataSource.setPassword("");

  try (Connection conn = dataSource.getConnection()) {
    try (Reader reader = Resources.getResourceAsReader("org/mybatis/scripting/freemarker/create-db.sql")) {
      ScriptRunner runner = new ScriptRunner(conn);
      runner.setLogWriter(null);
      runner.setErrorLogWriter(null);
      runner.runScript(reader);
      conn.commit();
    }
  }

  TransactionFactory transactionFactory = new JdbcTransactionFactory();
  Environment environment = new Environment("development", transactionFactory, dataSource);

  // You can call configuration.setDefaultScriptingLanguage(FreeMarkerLanguageDriver.class)
  // after this to use FreeMarker driver by default.
  Configuration configuration = new Configuration(environment);

  configuration.addMapper(PreparedParamsMapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
}

开发者ID:mybatis，项目名称:freemarker-scripting，代码行数:30，代码来源:PreparedParamsTest.java

示例10: setUp

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");

  JDBCDataSource dataSource = new JDBCDataSource();
  dataSource.setUrl("jdbc:hsqldb:mem:db1");
  dataSource.setUser("sa");
  dataSource.setPassword("");

  try (Connection conn = dataSource.getConnection()) {
    try (Reader reader = Resources.getResourceAsReader("org/mybatis/scripting/freemarker/create-db.sql")) {
      ScriptRunner runner = new ScriptRunner(conn);
      runner.setLogWriter(null);
      runner.setErrorLogWriter(null);
      runner.runScript(reader);
      conn.commit();
    }
  }

  TransactionFactory transactionFactory = new JdbcTransactionFactory();
  Environment environment = new Environment("development", transactionFactory, dataSource);

  // You can call configuration.setDefaultScriptingLanguage(FreeMarkerLanguageDriver.class)
  // after this to use FreeMarker driver by default.
  Configuration configuration = new Configuration(environment);

  configuration.addMapper(NameMapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
}

开发者ID:mybatis，项目名称:freemarker-scripting，代码行数:30，代码来源:FreeMarkerInAnnotationsTest.java

示例11: InMemoryDb

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
public InMemoryDb() throws SQLException {
  jdbcDataSource = new JDBCDataSource();
  jdbcDataSource.setUrl("jdbc:hsqldb:mem:test;MODE=PostgreSQL");
  jdbcDataSource.setUser("SA");
  jdbcDataSource.setPassword("");
  migrateDb(jdbcDataSource);
  addTestData();
}

开发者ID:javaBin，项目名称:heroes，代码行数:9，代码来源:InMemoryDb.java

示例12: bootstrapInMemoryDatabase

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
/** Create in-memory database table so that mapper methods might operate on something */
private JDBCDataSource bootstrapInMemoryDatabase() throws SQLException {
    JDBCDataSource dataSource = new JDBCDataSource();
    dataSource.setUrl( "jdbc:hsqldb:mem:guice-integration-test" );
    dataSource.setUser( "sa" );
    dataSource.setPassword( "" );

    try ( Connection connection = dataSource.getConnection() ) {
        connection.prepareStatement( "create table test (key varchar(20), value varchar(20))" ).execute();
    }

    return dataSource;
}

开发者ID:tguzik，项目名称:mybatis-metrics，代码行数:14，代码来源:GuiceIntegrationTest.java

示例13: bootstrapInMemoryDatabase

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
/** Create in-memory database table so that mapper methods might operate on something */
private JDBCDataSource bootstrapInMemoryDatabase() throws SQLException {
    JDBCDataSource dataSource = new JDBCDataSource();
    dataSource.setUrl( "jdbc:hsqldb:mem:purejava-integration-test" );
    dataSource.setUser( "sa" );
    dataSource.setPassword( "" );

    try ( Connection connection = dataSource.getConnection() ) {
        connection.prepareStatement( "create table test (key varchar(20), value varchar(20))" ).execute();
    }

    return dataSource;
}

开发者ID:tguzik，项目名称:mybatis-metrics，代码行数:14，代码来源:PureJavaIntegrationTest.java

示例14: getDataSource

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
private static DataSource getDataSource() {
  final JDBCDataSource dataSource = new JDBCDataSource();
  dataSource.setDatabase("jdbc:hsqldb:mem:persistence");
  dataSource.setUser("sa");
  dataSource.setPassword("");
  return dataSource;
}

开发者ID:google，项目名称:guice，代码行数:8，代码来源:EnsureJpaCanTakeObjectsInPropertiesTest.java

示例15: newDataSource

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
protected ProxyDataSource newDataSource() {
    JDBCDataSource actualDataSource = new JDBCDataSource();
    actualDataSource.setUrl("jdbc:hsqldb:mem:test");
    actualDataSource.setUser("sa");
    actualDataSource.setPassword("");
    ProxyDataSource proxyDataSource = new ProxyDataSource();
    proxyDataSource.setDataSource(actualDataSource);
    proxyDataSource.setListener(new SLF4JQueryLoggingListener());
    return proxyDataSource;
}

开发者ID:vladmihalcea，项目名称:hibernate-master-class，代码行数:11，代码来源:ExternalDataSourceConnectionProviderTest.java

示例16: newDataSource

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
protected ProxyDataSource newDataSource() {
    JDBCDataSource actualDataSource = new JDBCDataSource();
    actualDataSource.setUrl("jdbc:hsqldb:mem:test");
    actualDataSource.setUser("sa");
    actualDataSource.setPassword("");
    Properties properties = new Properties();
    properties.setProperty("hsqldb.tx_level", "SERIALIZABLE");
    actualDataSource.setProperties(properties);
    ProxyDataSource proxyDataSource = new ProxyDataSource();
    proxyDataSource.setDataSource(actualDataSource);
    proxyDataSource.setListener(new SLF4JQueryLoggingListener());
    return proxyDataSource;
}

开发者ID:vladmihalcea，项目名称:hibernate-master-class，代码行数:14，代码来源:TransactionIsolationExternalDataSourceExternalconfgiurationConnectionProviderTest.java

示例17: newDataSource

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
private ProxyDataSource newDataSource() {
    JDBCDataSource actualDataSource = new JDBCDataSource();
    actualDataSource.setUrl("jdbc:hsqldb:mem:test");
    actualDataSource.setUser("sa");
    actualDataSource.setPassword("");
    ProxyDataSource proxyDataSource = new ProxyDataSource();
    proxyDataSource.setDataSource(actualDataSource);
    proxyDataSource.setListener(new SLF4JQueryLoggingListener());
    return proxyDataSource;
}

开发者ID:vladmihalcea，项目名称:hibernate-master-class，代码行数:11，代码来源:AbstractJPATest.java

示例18: dataSource

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@Bean
public DataSource dataSource() {
  JDBCDataSource ds = new JDBCDataSource();
  ds.setUrl("jdbc:hsqldb:mem:plosrepo-unittest-hsqldb;shutdown=true;sql.syntax_mys=true");
  ds.setUser("");
  ds.setPassword("");
  return ds;
}

开发者ID:PLOS，项目名称:content-repo，代码行数:9，代码来源:TestSpringConfig.java

示例19: HsqlDB

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
@Inject
  public HsqlDB()
  {
    super();
    this.objectSequenceName = "objectSeq";
    this.transactionSequenceName = "transactionSeq";

    try
    {
      Context initContext = new InitialContext();
      Context envContext  = (Context)initContext.lookup("java:/comp/env");
      if (envContext == null) { throw new Exception("No Context Defined");}
      dataSource = (DataSource) envContext.lookup(DatabaseProperties.getJNDIDataSource());
    }
    catch (Exception e)
    {
      JDBCDataSource hsqlDataSource = new JDBCDataSource();
//      String path = "jdbc:hsqldb:mem:" + DatabaseProperties.getDatabaseName();
      // Database runs as a server
      String path = "jdbc:hsqldb:hsql://127.0.0.1/" + DatabaseProperties.getDatabaseName();
//      "jdbc:hsqldb:hsql://localhost/xdb
//      "jdbc:hsqldb:file:/opt/db/testdb", "sa", ""

      hsqlDataSource.setDatabase(path);
      hsqlDataSource.setUser(DatabaseProperties.getUser());
      hsqlDataSource.setPassword(DatabaseProperties.getPassword());

      this.dataSource = hsqlDataSource;

//      jdbcDataSource rootSource = new jdbcDataSource();
//      rootSource.setDatabase(path);
//      rootSource.setUser(DatabaseProperties.getRootUser());
//      rootSource.setPassword(DatabaseProperties.getRootPassword());
//      this.rootDataSource = rootSource;
    }
  }

开发者ID:terraframe，项目名称:Runway-SDK，代码行数:37，代码来源:HsqlDB.java

示例20: JqmAsyncTester

import org.hsqldb.jdbc.JDBCDataSource; //导入依赖的package包/类
public JqmAsyncTester()
{
    // Ext dir
    File extDir = new File("./ext");
    if (!extDir.exists() && !extDir.mkdir())
    {
        throw new RuntimeException(new IOException("./ext directory does not exist and cannot create it"));
    }

    s = Common.createHsqlServer();
    s.start();

    JDBCDataSource ds = new JDBCDataSource();
    ds.setDatabase("jdbc:hsqldb:mem:" + s.getDatabaseName(0, true));
    db = new Db(ds, true);
    cnx = db.getConn();

    Properties p2 = Common.dbProperties(s);
    p2.put("com.enioka.jqm.jdbc.contextobject", db);
    JqmClientFactory.setProperties(p2);
    JqmEngineFactory.setDatasource(db);
    JqmEngineFactory.initializeMetadata();
    cnx.runUpdate("dp_delete_all");
    cnx.runUpdate("q_delete_all");
    cnx.commit();

    // Needed parameters
    addGlobalParameter("defaultConnection", "");
    addGlobalParameter("disableWsApi", "true");
    addGlobalParameter("logFilePerLaunch", "false");

    // Prepare DB

}

开发者ID:enioka，项目名称:jqm，代码行数:35，代码来源:JqmAsyncTester.java

注：本文中的org.hsqldb.jdbc.JDBCDataSource类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。