Java JDBCDataSource.setDatabase方法代码示例

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);
}
 

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;
}
 

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;
}
 

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;
    }
  }
 

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

}
 

import org.hsqldb.jdbc.JDBCDataSource; //导入方法依赖的package包/类
public void testDirectDataSource() throws Exception {

        final Properties properties = new Properties();

        final JDBCDataSource dataSource = new JDBCDataSource();
        dataSource.setDatabase("jdbc:hsqldb:mem:testdb" + System.currentTimeMillis());
        dataSource.setUser("sa");
        dataSource.setPassword("");
        dataSource.getConnection().close();

        properties.put("DataSource", dataSource);
        properties.put("UseDatabaseLock", "false");
        properties.put("StartupTimeout", "10000");

        ActiveMQFactory.setThreadProperties(properties);
        BrokerService broker = null;
        try {
            broker = BrokerFactory.createBroker(new URI(getBrokerUri(
                "broker:(tcp://localhost:" + brokerPort + ")?useJmx=false")));
            assertNotNull("broker is null", broker);

            final PersistenceAdapter persistenceAdapter = broker.getPersistenceAdapter();
            assertNotNull("persistenceAdapter is null", persistenceAdapter);

            assertTrue("persistenceAdapter should be an instance of JDBCPersistenceAdapter",
                persistenceAdapter instanceof JDBCPersistenceAdapter);
            final JDBCPersistenceAdapter jdbcPersistenceAdapter = (JDBCPersistenceAdapter) persistenceAdapter;

            assertSame(dataSource, jdbcPersistenceAdapter.getDataSource());
        } finally {
            stopBroker(broker);
            ActiveMQFactory.setThreadProperties(null);
        }
    }
 

import org.hsqldb.jdbc.JDBCDataSource; //导入方法依赖的package包/类
/**
 * Create a {@link DataSource} attached database with the specified URL.
 * 
 * @param myURL the URL to the database
 * @return the DataSource
 */
private static DataSource createDataSourceFromURL(final String myURL) {
  final JDBCDataSource dataSource = new JDBCDataSource();
  dataSource.setDatabase(myURL);
  dataSource.setUser("sa");

  return dataSource;
}
 

import org.hsqldb.jdbc.JDBCDataSource; //导入方法依赖的package包/类
private JqmTester(String className)
{
    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();

    JqmSingleRunner.setConnection(db);

    Properties p2 = new Properties();
    p2.put("com.enioka.jqm.jdbc.contextobject", db);
    JqmClientFactory.setProperties(p2);

    // Needed parameters
    GlobalParameter.setParameter(cnx, "defaultConnection", "");
    cnx.commit();

    // 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"));
    }

    // Create node
    resDirectoryPath = Common.createTempDirectory();
    node = Node.create(cnx, "testtempnode", 12, resDirectoryPath.getAbsolutePath(), resDirectoryPath.getAbsolutePath(),
            resDirectoryPath.getAbsolutePath(), "test", "INFO");

    q = Queue.create(cnx, "default", "default test queue", true); // Only useful because JobDef.queue is non-null

    jd = JobDef.create(cnx, "test application", className, null, "/dev/null", q, 0, "TestApplication", null, null, null, null, null,
            false, null, PathType.MEMORY);

    ji = JobInstance.enqueue(cnx, State.SUBMITTED, q, jd, null, null, null, null, null, null, null, null, null, false, false, null, 0,
            Instruction.RUN, null);
    cnx.runUpdate("ji_update_poll", node.getId(), q, 10);

    cnx.commit();
}
 

import org.hsqldb.jdbc.JDBCDataSource; //导入方法依赖的package包/类
public void testLookupDataSource() throws Exception {

        final Properties properties = new Properties();

        final JDBCDataSource dataSource = new JDBCDataSource();
        dataSource.setDatabase("jdbc:hsqldb:mem:testdb" + System.currentTimeMillis());
        dataSource.setUser("sa");
        dataSource.setPassword("");
        dataSource.getConnection().close();

        MockInitialContextFactory.install(Collections.singletonMap("openejb/Resource/TestDs", dataSource));
        assertSame(dataSource, new InitialContext().lookup("openejb/Resource/TestDs"));

        final CoreContainerSystem containerSystem = new CoreContainerSystem(new IvmJndiFactory());
        containerSystem.getJNDIContext().bind("openejb/Resource/TestDs", dataSource);
        SystemInstance.get().setComponent(ContainerSystem.class, containerSystem);

        properties.put("DataSource", "TestDs");
        properties.put("UseDatabaseLock", "false");
        properties.put("StartupTimeout", "10000");

        ActiveMQFactory.setThreadProperties(properties);
        BrokerService broker = null;
        try {
            broker = BrokerFactory.createBroker(new URI(getBrokerUri(
                "broker:(tcp://localhost:" + brokerPort + ")?useJmx=false")));
            assertNotNull("broker is null", broker);

            final PersistenceAdapter persistenceAdapter = broker.getPersistenceAdapter();
            assertNotNull("persistenceAdapter is null", persistenceAdapter);

            assertTrue("persistenceAdapter should be an instance of JDBCPersistenceAdapter",
                persistenceAdapter instanceof JDBCPersistenceAdapter);
            final JDBCPersistenceAdapter jdbcPersistenceAdapter = (JDBCPersistenceAdapter) persistenceAdapter;

            assertSame(dataSource, jdbcPersistenceAdapter.getDataSource());
        } finally {
            stopBroker(broker);
            ActiveMQFactory.setThreadProperties(null);
        }
    }