org.hsqldb.test

Class TestOdbcTypes

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.hsqldb.test.AbstractTestOdbc

org.hsqldb.test.TestOdbcTypes

All Implemented Interfaces:

junit.framework.Test

public class TestOdbcTypes
extends AbstractTestOdbc

See AbstractTestOdbc for more general ODBC test information.

See Also:

AbstractTestOdbc

Constructor Summary

Constructors

Constructor and Description
TestOdbcTypes()
TestOdbcTypes(java.lang.String s) Accommodate JUnit's test-runner conventions.

Method Summary

Modifier and Type	Method and Description
static void	main(java.lang.String[] sa)
void	testBigIntComplex()
void	testBigIntSimpleRead()
void	testBinaryComplex()
void	testBinarySimpleRead()
void	testBitSimpleRead()
void	testBitVaryingSimpleRead()
void	testBooleanComplex()
void	testBooleanSimpleRead()
void	testCharComplex()
void	testCharSimpleRead()
void	testDateComplex() TODO: Find out if there is a way to select based on an expression using a named derived pseudo-column.
void	testDateSimpleRead()
void	testDaySecIntervalSimpleRead()
void	testDerivedStringSimpleRead()
void	testDoubleComplex()
void	testDoubleSimpleRead()
void	testFixedStringSimpleRead()
void	testFloatComplex()
void	testFloatSimpleRead()
void	testIntegerComplex()
void	testIntegerSimpleRead()
void	testSecIntervalSimpleRead()
void	testSmallIntComplex()
void	testSmallIntSimpleRead()
void	testTimeComplex()
void	testTimeSimpleRead()
void	testTimestampComplex()
void	testTimestampSimpleRead()
void	testTimestampWComplex()
void	testTimestampWSimpleRead()
void	testTinyIntComplex()
void	testTinyIntSimpleRead()
void	testVarBinaryComplex()
void	testVarBinarySimpleRead()
void	testVarCharComplex()
void	testVarCharSimpleRead()

Methods inherited from class org.hsqldb.test.AbstractTestOdbc

staticRunner

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runBare, setName, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

TestOdbcTypes

public TestOdbcTypes()

TestOdbcTypes

public TestOdbcTypes(java.lang.String s)

Accommodate JUnit's test-runner conventions.

Method Detail

testIntegerSimpleRead

public void testIntegerSimpleRead()

testTinyIntSimpleRead

public void testTinyIntSimpleRead()

testSmallIntSimpleRead

public void testSmallIntSimpleRead()

testBigIntSimpleRead

public void testBigIntSimpleRead()

testFloatSimpleRead

public void testFloatSimpleRead()

testDoubleSimpleRead

public void testDoubleSimpleRead()

testBooleanSimpleRead

public void testBooleanSimpleRead()

testCharSimpleRead

public void testCharSimpleRead()

testVarCharSimpleRead

public void testVarCharSimpleRead()

testFixedStringSimpleRead

public void testFixedStringSimpleRead()

testDerivedStringSimpleRead

public void testDerivedStringSimpleRead()

testDateSimpleRead

public void testDateSimpleRead()

testTimeSimpleRead

public void testTimeSimpleRead()

testTimestampSimpleRead

public void testTimestampSimpleRead()

testTimestampWSimpleRead

public void testTimestampWSimpleRead()

testBitSimpleRead

public void testBitSimpleRead()

testBitVaryingSimpleRead

public void testBitVaryingSimpleRead()

testBinarySimpleRead

public void testBinarySimpleRead()

testVarBinarySimpleRead

public void testVarBinarySimpleRead()

testDaySecIntervalSimpleRead

public void testDaySecIntervalSimpleRead()

testSecIntervalSimpleRead

public void testSecIntervalSimpleRead()

testIntegerComplex

public void testIntegerComplex()

testTinyIntComplex

public void testTinyIntComplex()

testSmallIntComplex

public void testSmallIntComplex()

testBigIntComplex

public void testBigIntComplex()

testFloatComplex

public void testFloatComplex()

testDoubleComplex

public void testDoubleComplex()

testBooleanComplex

public void testBooleanComplex()

testCharComplex

public void testCharComplex()

testVarCharComplex

public void testVarCharComplex()

testDateComplex

public void testDateComplex()

TODO: Find out if there is a way to select based on an expression using a named derived pseudo-column. public void testDerivedComplex() { PreparedStatement ps = null; ResultSet rs = null; try { ps = netConn.prepareStatement( "SELECT id, cv || 'app' appendage FROM alltypes\n" + "WHERE appendage = ?"); ps.setString(1, "cvapp"); rs = ps.executeQuery(); assertTrue("Got no rows appendage = 'cvapp'", rs.next()); assertEquals(String.class, rs.getObject("r").getClass()); assertTrue("Got only one row with appendage = 'cvapp'", rs.next()); assertEquals("cvapp", rs.getString("r")); assertFalse("Got too many rows with appendage = 'cvapp'", rs.next()); } catch (SQLException se) { junit.framework.AssertionFailedError ase = new junit.framework.AssertionFailedError(se.getMessage()); ase.initCause(se); throw ase; } finally { try { if (rs != null) { rs.close(); } if (ps != null) { ps.close(); } } catch(Exception e) { } } }

testTimeComplex

public void testTimeComplex()

testTimestampComplex

public void testTimestampComplex()

testTimestampWComplex

public void testTimestampWComplex()

testBinaryComplex

public void testBinaryComplex()

testVarBinaryComplex

public void testVarBinaryComplex()

main

public static void main(java.lang.String[] sa)