net.sourceforge.jtds.jdbc
Class GenKeyTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          net.sourceforge.jtds.jdbc.TestBase
              net.sourceforge.jtds.jdbc.GenKeyTest

All Implemented Interfaces:

junit.framework.Test

public class GenKeyTest

extends TestBase

Test case to illustrate JDBC 3 GetGeneratedKeys() function.

Version:

1.0

Field Summary

Fields inherited from class net.sourceforge.jtds.jdbc.TestBase

con, props

Fields inherited from class junit.framework.TestCase

Constructor Summary

GenKeyTest(java.lang.String name)

Method Summary

static void	main(java.lang.String[] args)
void	testNoKeys() Test empty result set returned when no keys available.
void	testParams()
void	testSelect() Test that SELECT statements work correctly with PreparedStatements created with RETURN_GENERATED_KEYS.
void	testTrigger1() Test for bug [930305] getGeneratedKeys() does not work with triggers

Methods inherited from class net.sourceforge.jtds.jdbc.TestBase

compareInputStreams, compareReaders, connect, dropDatabase, dropFunction, dropProcedure, dropTable, dropTrigger, dropType, dropView, dump, dump, dumpAll, dumpKeys, dumpRow, dumpRow, getConnection, getConnection, makeObjects, makeTestTables, setUp, tearDown

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runBare, runTest, setName, toString

Methods inherited from class junit.framework.Assert

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, fail, fail

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

GenKeyTest

public GenKeyTest(java.lang.String name)

Method Detail

testParams

public void testParams()
                throws java.lang.Exception

Throws:

java.lang.Exception

testTrigger1

public void testTrigger1()
                  throws java.lang.Exception

Test for bug [930305] getGeneratedKeys() does not work with triggers

Throws:

java.lang.Exception

testNoKeys

public void testNoKeys()
                throws java.lang.Exception

Test empty result set returned when no keys available.

Throws:

java.lang.Exception

testSelect

public void testSelect()
                throws java.sql.SQLException

Test that SELECT statements work correctly with PreparedStatements created with RETURN_GENERATED_KEYS.

Throws:

java.sql.SQLException

main

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