Package org.hsqldb.jdbc

Examples of org.hsqldb.jdbc.JDBCDataSource

58
59
60
61
62
63
64
65
66
67
68
69
70
71
        super(testName);
    }

    private void initHypersonic() throws Exception {

        jdbcDataSource dataSource = new jdbcDataSource();

        dataSource.setDatabase("jdbc:hsqldb:mem:.");

//        dataSource.setDatabase("jdbc:hsqldb:hsql://localhost/yourtest");
        conn = dataSource.getConnection("sa", "");

        conn.setAutoCommit(false);
    }
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
        runTests(runs);
    }

    static void runTests(int runs) throws Exception {

        jdbcDataSource dataSource = new jdbcDataSource();

        dataSource.setDatabase(url);
        conn  = dataSource.getConnection("SA", "");
        stmnt = conn.createStatement();

        println("");
        println("***************************************");
        println("featuring cached (persistent) table");
        println("***************************************");

        // drop and recreate the test table
        println(drop_table_sql);
        stmnt.execute(drop_table_sql);
        println(create_cached + table_sql);
        stmnt.execute(create_cached + table_sql);
        preparedTestOne(runs);

        // drop the test table and shut down database
        println(drop_table_sql);
        stmnt.execute(drop_table_sql);
        println("---------------------------------------");
        println("shutting down database");
        stmnt.execute(shutdown_sql);
        println("---------------------------------------");

        // get the connection and statement
        conn  = dataSource.getConnection("SA", "");
        stmnt = conn.createStatement();

        println("");
        println("***************************************");
        println("featuring memory (persistent) table");
        println("***************************************");

        // drop and recreate the test table
        println(drop_table_sql);
        stmnt.execute(drop_table_sql);
        println(create_memory + table_sql);
        stmnt.execute(create_memory + table_sql);
        preparedTestOne(runs);

        // drop the test table and shut down database
        println(drop_table_sql);
        stmnt.execute(drop_table_sql);
        println("---------------------------------------");
        println("shutting down database");
        stmnt.execute(shutdown_sql);
        println("---------------------------------------");

        // get the connection and statement
        conn  = dataSource.getConnection("SA", "");
        stmnt = conn.createStatement();

        println("");
        println("***************************************");
        println("featuring temp (transient) table");
View Full Code Here
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
    }

    public static void preparedTestTwo() {

        try {
            jdbcDataSource dataSource = new jdbcDataSource();

            dataSource.setDatabase("jdbc:hsqldb:.");

            Connection con = dataSource.getConnection("SA", "");

            System.out.println("con=" + con);

            Statement stmt = con.createStatement();
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
    public static void test() throws Exception {

        Connection        conn;
        Statement         stmnt;
        PreparedStatement pstmnt;
        jdbcDataSource dataSource = new jdbcDataSource();
        dataSource.setDatabase("jdbc:hsqldb:mem:test");
        conn = dataSource.getConnection("SA", "");
        stmnt  = conn.createStatement();
        pstmnt = conn.prepareStatement("drop table t if exists");

        boolean result = pstmnt.execute();
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
      try {
        testProps.loadFromXML(AbstractServiceTest.class
            .getResourceAsStream("test.properties.xml"));

        // Create the mondrian datasource
        jdbcDataSource ds = new jdbcDataSource();
        ds.setDatabase(getTestProperty("context.database")); //$NON-NLS-1$
        ds.setUser(getTestProperty("context.username")); //$NON-NLS-1$
        ds.setPassword(getTestProperty("context.password")); //$NON-NLS-1$

        // Bind the datasource in the directory
        Context ctx = new InitialContext();
        ctx.bind(getTestProperty("context.jndi"), ds); //$NON-NLS-1$

        // Create the mondrian schema
        Connection c = ds.getConnection();
        Statement stm = c.createStatement();
        slurp(stm,
            AbstractServiceTest.class
                .getResourceAsStream("sampledata.sql")); //$NON-NLS-1$
        stm.executeBatch();
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
97
98
  public void setup() throws Exception {
    InputStream inputStream = getClass().getResourceAsStream("../connection.properties");
    testProps.load(inputStream); //$NON-NLS-1$

    jdbcDataSource ds = new jdbcDataSource();
    ds.setDatabase(getTestProperty("name")); //$NON-NLS-1$
    ds.setUser(getTestProperty("username")); //$NON-NLS-1$
    ds.setPassword(getTestProperty("password")); //$NON-NLS-1$


    try {
      Class.forName("org.hsqldb.jdbcDriver");
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
            HsqlProperties props      = new HsqlProperties(filepath);
            boolean        fileexists = props.checkFileExists();

            if (!network && !fileexists == false) {
                jdbcDataSource dataSource = new jdbcDataSource();

                dataSource.setDatabase(url + filepath);

                cConnection = dataSource.getConnection(user, password);
                sStatement  = cConnection.createStatement();

                sStatement.execute("SET SCRIPTFORMAT " + logType);
                sStatement.execute("SET LOGSIZE " + 400);
                sStatement.execute("SET WRITE_DELAY " + writeDelay);
                sStatement.execute("SHUTDOWN");
                cConnection.close();
                props.load();
                props.setProperty("hsqldb.cache_scale", "" + cacheScale);
                props.save();

                cConnection = dataSource.getConnection(user, password);
                sStatement  = cConnection.createStatement();
            }
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("TestSql.setUp() error: " + e.getMessage());
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
            sw.zero();

            cConnection = null;
            sStatement  = null;

            jdbcDataSource dataSource = new jdbcDataSource();

            dataSource.setDatabase(url + filepath);

            cConnection = dataSource.getConnection(user, password);

            System.out.println("connected: " + sw.elapsedTime());
            sw.zero();

            sStatement = cConnection.createStatement();
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
    protected void checkResults() {

        try {
            StopWatch      sw = new StopWatch();
            ResultSet      rs;
            jdbcDataSource dataSource = new jdbcDataSource();

            dataSource.setDatabase(url + filepath);

            cConnection = dataSource.getConnection(user, password);

            System.out.println("Reopened database: " + sw.elapsedTime());
            sw.zero();

            sStatement = cConnection.createStatement();
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
    protected void setUp() {

        try {
            createDatabase();

            jdbcDataSource dataSource = new jdbcDataSource();

            dataSource.setDatabase("jdbc:hsqldb:testdb");

            con = dataSource.getConnection("sa", "");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println(this + ".setUp() error: " + e.getMessage());
        }
    }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.