Examples of org.h2.jaqu.Table

org.h2.store.FileLock

A class that implements this interface can be used as a database table.

You may implement the Table interface on your model object and optionally use JQColumn annotations (which imposes a compile-time and runtime-dependency on JaQu), or may choose to use the JQTable and JQColumn annotations only (which imposes a compile-time and runtime-dependency on this file only).

If a class is annotated with JQTable and at the same time implements Table, the define() method is not called.

Supported data types:

java.lang.String	VARCHAR (maxLength > 0) / TEXT (maxLength == 0)
java.lang.Boolean	BIT
java.lang.Byte	TINYINT
java.lang.Short	SMALLINT
java.lang.Integer	INT
java.lang.Long	BIGINT
java.lang.Float	REAL
java.lang.Double	DOUBLE
java.math.BigDecimal	DECIMAL
java.util.Date	TIMESTAMP
java.sql.Date	DATE
java.sql.Time	TIME
java.sql.Timestamp	TIMESTAMP

Unsupported data types: binary types (BLOB, etc), and custom types.

Table and field mapping: by default, the mapped table name is the class name and the public fields are reflectively mapped, by their name, to columns. As an alternative, you may specify both the table and column definition by annotations.

Table Interface: you may set additional parameters such as table name, primary key, and indexes in the define() method.

Annotations: you may use the annotations with or without implementing the Table interface. The annotations allow you to decouple your model completely from JaQu other than this file.

Automatic model generation: you may automatically generate model classes as strings with the Db and DbInspector objects:

 Db db = Db.open("jdbc:h2:mem:", "sa", "sa"); DbInspector inspector = new DbInspector(db); List<String> models = inspector.generateModel(schema, table, packageName, annotateSchema, trimStrings)

Or you may use the GenerateModels tool to generate and save your classes to the file system:

 java -cp h2jaqu.jar org.h2.jaqu.util.GenerateModels -url "jdbc:h2:mem:" -user sa -password sa -schema schemaName -table tableName -package packageName -folder destination -annotateSchema false -trimStrings true

Model validation: you may validate your model class with DbInspector object. The DbInspector will report errors, warnings, and suggestions:

 Db db = Db.open("jdbc:h2:mem:", "sa", "sa"); DbInspector inspector = new DbInspector(db); List<Validation> remarks = inspector.validateModel(new MyModel(), throwOnError); for (Validation remark : remarks) { System.out.println(remark); }

                getConnection("jdbc:h2:mem:;init=runscript from 'wrong.file'");
    }


    private void testConnectionInfo() throws Exception {
        Properties info = new Properties();
        ConnectionInfo connectionInfo = new ConnectionInfo(
                "jdbc:h2:mem:test" +
                        ";LOG=2" +
                        ";ACCESS_MODE_DATA=rws" +
                        ";INIT=CREATE this...\\;INSERT that..." +
                        ";IFEXISTS=TRUE",
                info);


        assertEquals("jdbc:h2:mem:test", connectionInfo.getURL());


        assertEquals("2", connectionInfo.getProperty("LOG", ""));
        assertEquals("rws", connectionInfo.getProperty("ACCESS_MODE_DATA", ""));
        assertEquals("CREATE this...;INSERT that...", connectionInfo.getProperty("INIT", ""));
        assertEquals("TRUE", connectionInfo.getProperty("IFEXISTS", ""));
        assertEquals("undefined", connectionInfo.getProperty("CACHE_TYPE", "undefined"));
    }

View Full Code Here

        assertEquals("undefined", connectionInfo.getProperty("CACHE_TYPE", "undefined"));
    }


    private void testName() throws Exception {
        char differentFileSeparator = File.separatorChar == '/' ? '\\' : '/';
        ConnectionInfo connectionInfo = new ConnectionInfo("test" + differentFileSeparator + "subDir");
        File file = new File("test" + File.separatorChar + "subDir");
        assertEquals(file.getCanonicalPath(), connectionInfo.getName());
    }

View Full Code Here

        testReadOnly();
        testAdapter();
    }


    private static void testAdapter() {
        TraceSystem ts = new TraceSystem(null);
        ts.setLevelFile(TraceSystem.ADAPTER);
        ts.getTrace("test").info("test");
        ts.close();
    }

View Full Code Here

        ts.getTrace("test").info("test");
        ts.close();
    }


    private void testTraceDebug() {
        TraceSystem ts = new TraceSystem(null);
        ByteArrayOutputStream out = new ByteArrayOutputStream();
        ts.setSysOut(new PrintStream(out));
        ts.setLevelSystemOut(TraceSystem.DEBUG);
        ts.getTrace("test").debug(new Exception("error"), "test");
        ts.close();
        String outString = new String(out.toByteArray());
        assertContains(outString, "error");
        assertContains(outString, "Exception");
        assertContains(outString, "test");
    }

View Full Code Here

    private void testReadOnly() throws Exception {
        String readOnlyFile = getBaseDir() + "/readOnly.log";
        IOUtils.delete(readOnlyFile);
        IOUtils.openFileOutputStream(readOnlyFile, false).close();
        FileSystem.getInstance(getBaseDir()).setReadOnly(readOnlyFile);
        TraceSystem ts = new TraceSystem(readOnlyFile);
        ts.setLevelFile(TraceSystem.INFO);
        ts.getTrace("test").info("test");
        IOUtils.delete(readOnlyFile);
        ts.close();
    }

View Full Code Here

    private void testFutureModificationDate() throws Exception {
        File f = new File(getFile());
        f.delete();
        f.createNewFile();
        f.setLastModified(System.currentTimeMillis() + 10000);
        FileLock lock = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        lock.lock(FileLock.LOCK_FILE);
        lock.unlock();
    }

View Full Code Here

        lock.lock(FileLock.LOCK_FILE);
        lock.unlock();
    }


    private void testSimple() {
        FileLock lock1 = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        FileLock lock2 = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        lock1.lock(FileLock.LOCK_FILE);
        createClassProxy(FileLock.class);
        assertThrows(ErrorCode.DATABASE_ALREADY_OPEN_1, lock2).
                lock(FileLock.LOCK_FILE);
        lock1.unlock();
        lock2 = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        lock2.lock(FileLock.LOCK_FILE);
        lock2.unlock();
    }

View Full Code Here

    }


    public void run() {
        FileLock lock = null;
        while (!stop) {
            lock = new FileLock(new TraceSystem(null), getFile(), 100);
            try {
                lock.lock(allowSockets ? FileLock.LOCK_SOCKET : FileLock.LOCK_FILE);
                base.trace(lock + " locked");
                locks++;
                if (locks > 1) {

View Full Code Here

    private void testFutureModificationDate() throws Exception {
        File f = new File(getFile());
        f.delete();
        f.createNewFile();
        f.setLastModified(System.currentTimeMillis() + 10000);
        FileLock lock = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        lock.lock(FileLock.LOCK_FILE);
        lock.unlock();
    }

View Full Code Here

        lock.lock(FileLock.LOCK_FILE);
        lock.unlock();
    }


    private void testSimple() {
        FileLock lock1 = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        FileLock lock2 = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        lock1.lock(FileLock.LOCK_FILE);
        createClassProxy(FileLock.class);
        assertThrows(ErrorCode.DATABASE_ALREADY_OPEN_1, lock2).
                lock(FileLock.LOCK_FILE);
        lock1.unlock();
        lock2 = new FileLock(new TraceSystem(null), getFile(), Constants.LOCK_SLEEP);
        lock2.lock(FileLock.LOCK_FILE);
        lock2.unlock();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.h2.jaqu.Table

com.btmatthews.maven.plugins.inmemdb.db.h2.H2Database

com.carrotsearch.junitbenchmarks.h2.H2Consumer

com.nurkiewicz.jdbcrepository.StandaloneUsageTest

com.proofpoint.dbpool.H2EmbeddedDataSource

io.airlift.dbpool.H2EmbeddedDataSource

net.pms.dlna.DLNAMediaDatabase

org.apache.felix.example.jaas.jdbc.internal.H2Activator

org.apache.jackrabbit.oak.plugins.document.persistentCache.PersistentCache

org.apache.syncope.buildtools.H2StartStopListener

org.drools.karaf.itest.KieSpringOnKarafIntegrationTest

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.