Examples of org.hsqldb.jdbc.jdbcDataSource

org.hsqldb.jdbc.JDBCDataSource
A factory for connections to the physical data source that this DataSource object represents. An alternative to the DriverManager facility, a DataSource object is the preferred means of getting a connection. An object that implements the DataSource interface will typically be registered with a naming service based on the Java^TM Naming and Directory (JNDI) API.
The DataSource interface is implemented by a driver vendor. There are three types of implementations:
1. Basic implementation -- produces a standard Connection object
2. Connection pooling implementation -- produces a Connection object that will automatically participate in connection pooling. This implementation works with a middle-tier connection pooling manager.
3. Distributed transaction implementation -- produces a Connection object that may be used for distributed transactions and almost always participates in connection pooling. This implementation works with a middle-tier transaction manager and almost always with a connection pooling manager.
A DataSource object has properties that can be modified when necessary. For example, if the data source is moved to a different server, the property for the server can be changed. The benefit is that because the data source's properties can be changed, any code accessing that data source does not need to be changed.
A driver that is accessed via a DataSource object does not register itself with the DriverManager. Rather, a DataSource object is retrieved though a lookup operation and then used to create a Connection object. With a basic implementation, the connection obtained through a DataSource object is identical to a connection obtained through the DriverManager facility. @since JDK 1.4 @author deforest@users @author boucherb@users @version 2.0 @revised JDK 1.6, HSQLDB 2.0

    injector.getInstance(UnitOfWork.class).end();
    injector.getInstance(EntityManagerFactory.class).close();
  }


  private static DataSource getDataSource() {
    final JDBCDataSource dataSource = new JDBCDataSource();
    dataSource.setDatabase("jdbc:hsqldb:mem:persistence");
    dataSource.setUser("sa");
    dataSource.setPassword("");
    return dataSource;
  }

View Full Code Here

    JdbcDataSource realDs2 = new JdbcDataSource();
    realDs2.setUser("sa");
    realDs2.setURL("jdbc:h2:mem:multids2");
    jndiResources.add(new Resource("jdbc/realDs2", realDs2));


    JDBCDataSource realDs3 = new JDBCDataSource();
    realDs3.setUser("sa");
    realDs3.setPassword("");
    realDs3.setUrl("jdbc:hsqldb:mem:multids3");
    jndiResources.add(new Resource("jdbc/realDs3", realDs3));


    // create the spy wrapper data sources and bind to jndi
    P6DataSource spyDs1 = new P6DataSource();
    spyDs1.setRealDataSource("jdbc/realDs1");

View Full Code Here


        // setup the hsqldb database engine
        m_hu.setUp();


        // Create the connection pool
        JDBCDataSource cpds = new JDBCDataSource();
        cpds.setDatabase( "jdbc:hsqldb:hsql://localhost/jspwiki" );
        cpds.setLoginTimeout( 10 );
        cpds.setUser( "SA" );
        cpds.setPassword( null );


        // Configure and bind DataSource to JNDI for user database
        userDB = new Resource( "jdbc/UserDatabase", cpds );
        log.error( "Configured datasource " + userDB);
        userDB.bindToENC("jdbc/UserDatabase");

View Full Code Here


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


        ActiveMQFactory.setThreadProperties(properties);

View Full Code Here


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

View Full Code Here

        assertEquals("sa", bds.getUsername());
        assertEquals("", bds.getPassword());


        final Field fieldDs = bds.getClass().getDeclaredField("ds");
        fieldDs.setAccessible(true);
        final JDBCDataSource realDs = (JDBCDataSource) fieldDs.get(bds);
        assertEquals("jdbc:hsqldb:mem:superDS", realDs.getUrl());
        assertEquals("sa", realDs.getUser());
    }

View Full Code Here

     * @return Returns {@code dataSource} which was initialised by the
     *         constructor.
     */
    @Override
    public DataSource getDataSource(final Map<String, String> attributes) {
        final JDBCDataSource dataSource = new JDBCDataSource();
        dataSource.setUrl(getUrl(attributes));
        dataSource.setUser(getUsername());
        dataSource.setPassword(getPassword());
        return dataSource;
    }

View Full Code Here

    {
      System.out.println(genre);
      System.out.println(title);
      System.out.println(author);


      JDBCDataSource ds = new JDBCDataSource();
      
      // setup URL according to HSQLDB specs
      ds.setUrl("jdbc:hsqldb:hsql://localhost/");
      
      // set other data source properties
      ds.setPassword("");
      ds.setUser("SA");


      
      conn = ds.getConnection();
      stmt = conn.createStatement();
      
      String querySQL = "select * from book"; 
      
      if(StringUtils.isNotBlank(title) || StringUtils.isNotBlank(author) || StringUtils.isNotBlank(genre))

View Full Code Here


public class ConsoleJDBC {
  public static void main(String[] args)
  {
    try {
      JDBCDataSource ds = new JDBCDataSource();
      
      // setup URL according to HSQLDB specs
      ds.setUrl("jdbc:hsqldb:hsql://localhost/");
      
      // set other data source properties
      ds.setPassword("");
      ds.setUser("SA");
      
      // setup connection and query
      Connection conn = ds.getConnection();
      Statement statement = conn.createStatement();
      
      // send query to database
      ResultSet rs = statement.executeQuery("select * from Book");
      ResultSetMetaData rsmd = rs.getMetaData();

View Full Code Here


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

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.jdbc.jdbcDataSource

com.aconex.scrutineer.jdbc.HSQLHelper

com.btmatthews.maven.plugins.inmemdb.db.hsqldb.HSQLDBDatabase

com.ecyrd.jspwiki.web.TestContainer

com.google.inject.persist.jpa.EnsureJpaCanTakeObjectsInPropertiesTest

com.jcasey.BookQuery

com.p6spy.engine.spy.MultipleDataSourceTest

com.taobao.datasource.resource.adapter.jdbc.local.LocalTxDataSourceHsqldbTest

ConsoleJDBC

liquibase.integration.cdi.CDITestProducer

org.apache.ftpserver.usermanager.DbUserManagerTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.