CallableStatementTest (jTDS API)

java.lang.Object
- TestCase
- - net.sourceforge.jtds.jdbc.TestBase
  - - net.sourceforge.jtds.jdbc.CallableStatementTest

public class CallableStatementTest
extends TestBase

Version:: 1.0

Field Summary

Fields
Modifier and Type Field and Description

private boolean SILENT
set to false to enable verbose console output
- Fields inherited from class net.sourceforge.jtds.jdbc.TestBase
  con, props

Fields
Modifier and Type	Field and Description
`private boolean`	`SILENT` set to false to enable verbose console output

Constructor Summary

Constructors
Constructor and Description

CallableStatementTest(java.lang.String name)

Constructors
Constructor and Description
`CallableStatementTest(java.lang.String name)`

Method Summary

Methods
Modifier and Type	Method and Description
`static void`	`main(java.lang.String[] args)` Test that output result sets, return values and output parameters are correctly handled for a remote procedure call.
`void`	`testBigDecimal()` Test for bug [1236078] Procedure doesn't get called for some BigDecimal values - invalid bug.
`void`	`testBug637()`
`void`	`testCallableError1()` Test for bug [991640] java.sql.Date error and RAISERROR problem
`void`	`testCallableRegisterOutParameter1()` Test for bug [974284] retval on callable statement isn't handled correctly
`void`	`testCallableRegisterOutParameter2()` Test for bug [994888] Callable statement and Float output parameter
`void`	`testCallableRegisterOutParameter3()` Test for bug [994988] Network error when null is returned via int output parm
`void`	`testCallableRegisterOutParameter4()` Test for bug [983432] Prepared call doesn't work with jTDS 0.8
`void`	`testCallableRegisterOutParameter5()` Test for bug [946171] null boolean in CallableStatement bug
`void`	`testCallableRegisterOutParameter6()` Test for bug [992715] wasnull() always returns false
`void`	`testCallableSetNull1()` Test for reature request [956800] setNull(): Not implemented.
`void`	`testCallableStatement()`
`void`	`testCallableStatement1()`
`void`	`testCallableStatementCall1()`
`void`	`testCallableStatementCall2()`
`void`	`testCallableStatementCall3()`
`void`	`testCallableStatementCall4()` Test for bug [974801] stored procedure error in Northwind
`void`	`testCallableStatementExec1()`
`void`	`testCallableStatementExec2()`
`void`	`testCallableStatementExec3()`
`void`	`testCallableStatementExec4()`
`void`	`testCallableStatementExec5()`
`void`	`testCallableStatementExec6()`
`void`	`testCallableStatementExec7()`
`void`	`testCallableStatementExec8()`
`void`	`testCallableStatementExec9()` Test for bug [978175] 0.8: Stored Procedure call doesn't work anymore
`void`	`testCallableStatementParsing1()`
`void`	`testCallableStatementParsing2()` Test for bug [938632] String index out of bounds error in 0.8rc1.
`void`	`testCallableStatementParsing3()` Test for bug [1006845] Stored procedure with 18 parameters.
`void`	`testCallableStatementParsing4()` Test for incorrect exception thrown/no exception thrown when invalid call escape is used.
`void`	`testCallableStatementParsing5()` Test for bug [1052942] Error processing JDBC call escape.
`void`	`testCallableStatementParsing6()` Test for incorrect exception thrown/no exception thrown when invalid call escape is used.
`void`	`testCallableStatementParsing7()` Test for incorrect exception thrown/no exception thrown when invalid call escape is used.
`void`	`testCallWithResultSet()` Test retrieving multiple resultsets, the return value and an additional output parameter from a single procedure call.
`void`	`testCommentProcessing()` Test comment processing, bug #634 (and #676).
`void`	`testErrorOutputParams()` Test for bug [1047208] SQLException chaining not implemented correctly: checks that all errors are returned and that output variables are also returned.
`void`	`testInOutParameters()` Test for separation of IN and INOUT/OUT parameter values
`void`	`testNamedParameters0001()` Test named parameters.
`void`	`testNamedParameters0002()` Test named parameters.
`void`	`testNonRpcProc1()` Test that procedure calls with both literal parameters and parameterr markers are executed correctly (bug [1078927] Callable statement fails).
`void`	`testNonRpcProc2()` Test that procedure calls with both literal parameters and parameterr markers are executed correctly (bug [1078927] Callable statement fails).
`void`	`testProcessUpdateCounts1()` Test that procedure outputs are available immediately for procedures that do not return ResultSets (i.e that update counts are cached).
`void`	`testProcessUpdateCounts2()` Test that procedure outputs are available immediately after processing the last ResultSet returned by the procedure (i.e that update counts are cached).
`void`	`testProcessUpdateCounts3()` Test that procedure outputs are available immediately after processing the last ResultSet returned by the procedure (i.e that update counts are cached) even if getMoreResults() is not called.
`void`	`testProcessUpdateCounts4()` Test that procedure outputs are available immediately after processing the last ResultSet returned by the procedure (i.e that update counts are cached) even if getMoreResults() and ResultSet.close() are not called.
`void`	`testSemicolonProcedures()` Test that procedure names containing semicolons are parsed correctly.
`void`	`testTsEscape()` Test for bug [ 1062671 ] SQLParser unable to parse CONVERT(char,{ts ?}
`void`	`testWritetext()` Test for bug [1152329] Spurious output params assigned (TIMESTMP).

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 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - SILENT
```
private final boolean SILENT
```
    set to false to enable verbose console output
    
    See Also:
    Constant Field Values
- Constructor Detail
  - CallableStatementTest
```
public CallableStatementTest(java.lang.String name)
```
- Method Detail
  - testCommentProcessing
```
public void testCommentProcessing()
                           throws java.sql.SQLException
```
    Test comment processing, bug #634 (and #676).
    
    Throws:
    
    java.sql.SQLException
  - testCallableStatement
```
public void testCallableStatement()
                           throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatement1
```
public void testCallableStatement1()
                            throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementCall1
```
public void testCallableStatementCall1()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementCall2
```
public void testCallableStatementCall2()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementCall3
```
public void testCallableStatementCall3()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementCall4
```
public void testCallableStatementCall4()
                                throws java.lang.Exception
```
    Test for bug [974801] stored procedure error in Northwind
    
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec1
```
public void testCallableStatementExec1()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec2
```
public void testCallableStatementExec2()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec3
```
public void testCallableStatementExec3()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec4
```
public void testCallableStatementExec4()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec5
```
public void testCallableStatementExec5()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec6
```
public void testCallableStatementExec6()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec7
```
public void testCallableStatementExec7()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec8
```
public void testCallableStatementExec8()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementExec9
```
public void testCallableStatementExec9()
                                throws java.lang.Exception
```
    Test for bug [978175] 0.8: Stored Procedure call doesn't work anymore
    
    Throws:
    
    java.lang.Exception
  - testCallableStatementParsing1
```
public void testCallableStatementParsing1()
                                   throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCallableStatementParsing2
```
public void testCallableStatementParsing2()
                                   throws java.lang.Exception
```
    Test for bug [938632] String index out of bounds error in 0.8rc1.
    
    Throws:
    
    java.lang.Exception
  - testCallableStatementParsing3
```
public void testCallableStatementParsing3()
                                   throws java.lang.Exception
```
    Test for bug [1006845] Stored procedure with 18 parameters.
    
    Throws:
    
    java.lang.Exception
  - testCallableStatementParsing4
```
public void testCallableStatementParsing4()
                                   throws java.sql.SQLException
```
    Test for incorrect exception thrown/no exception thrown when invalid call escape is used.
    See https://sourceforge.net/forum/forum.php?thread_id=1144619&forum_id=104389 for more detail.
    
    Throws:
    
    java.sql.SQLException
  - testCallableStatementParsing5
```
public void testCallableStatementParsing5()
                                   throws java.lang.Exception
```
    Test for bug [1052942] Error processing JDBC call escape. (A blank before the final } causes the parser to fail).
    
    Throws:
    
    java.lang.Exception
  - testCallableStatementParsing6
```
public void testCallableStatementParsing6()
                                   throws java.sql.SQLException
```
    Test for incorrect exception thrown/no exception thrown when invalid call escape is used.
    A message containing the correct missing terminator should be generated.
    
    Throws:
    
    java.sql.SQLException
  - testCallableStatementParsing7
```
public void testCallableStatementParsing7()
                                   throws java.sql.SQLException
```
    Test for incorrect exception thrown/no exception thrown when invalid call escape is used.
    A message containing the correct missing terminator should be generated.
    
    Throws:
    
    java.sql.SQLException
  - testCallableSetNull1
```
public void testCallableSetNull1()
                          throws java.lang.Exception
```
    Test for reature request [956800] setNull(): Not implemented.
    
    Throws:
    
    java.lang.Exception
  - testCallableRegisterOutParameter1
```
public void testCallableRegisterOutParameter1()
                                       throws java.lang.Exception
```
    Test for bug [974284] retval on callable statement isn't handled correctly
    
    Throws:
    
    java.lang.Exception
  - testCallableRegisterOutParameter2
```
public void testCallableRegisterOutParameter2()
                                       throws java.lang.Exception
```
    Test for bug [994888] Callable statement and Float output parameter
    
    Throws:
    
    java.lang.Exception
  - testCallableRegisterOutParameter3
```
public void testCallableRegisterOutParameter3()
                                       throws java.lang.Exception
```
    Test for bug [994988] Network error when null is returned via int output parm
    
    Throws:
    
    java.lang.Exception
  - testCallableRegisterOutParameter4
```
public void testCallableRegisterOutParameter4()
                                       throws java.lang.Exception
```
    Test for bug [983432] Prepared call doesn't work with jTDS 0.8
    
    Throws:
    
    java.lang.Exception
  - testCallableRegisterOutParameter5
```
public void testCallableRegisterOutParameter5()
                                       throws java.lang.Exception
```
    Test for bug [946171] null boolean in CallableStatement bug
    
    Throws:
    
    java.lang.Exception
  - testCallableRegisterOutParameter6
```
public void testCallableRegisterOutParameter6()
                                       throws java.lang.Exception
```
    Test for bug [992715] wasnull() always returns false
    
    Throws:
    
    java.lang.Exception
  - testCallableError1
```
public void testCallableError1()
                        throws java.lang.Exception
```
    Test for bug [991640] java.sql.Date error and RAISERROR problem
    
    Throws:
    
    java.lang.Exception
  - testNamedParameters0001
```
public void testNamedParameters0001()
                             throws java.lang.Exception
```
    Test named parameters.
    
    Throws:
    
    java.lang.Exception
  - testNamedParameters0002
```
public void testNamedParameters0002()
                             throws java.lang.Exception
```
    Test named parameters.
    
    Throws:
    
    java.lang.Exception
  - testProcessUpdateCounts1
```
public void testProcessUpdateCounts1()
                              throws java.sql.SQLException
```
    Test that procedure outputs are available immediately for procedures that do not return ResultSets (i.e that update counts are cached).
    
    Throws:
    
    java.sql.SQLException
  - testProcessUpdateCounts2
```
public void testProcessUpdateCounts2()
                              throws java.sql.SQLException
```
    Test that procedure outputs are available immediately after processing the last ResultSet returned by the procedure (i.e that update counts are cached).
    
    Throws:
    
    java.sql.SQLException
  - testProcessUpdateCounts3
```
public void testProcessUpdateCounts3()
                              throws java.sql.SQLException
```
    Test that procedure outputs are available immediately after processing the last ResultSet returned by the procedure (i.e that update counts are cached) even if getMoreResults() is not called.
    
    Throws:
    
    java.sql.SQLException
  - testProcessUpdateCounts4
```
public void testProcessUpdateCounts4()
                              throws java.sql.SQLException
```
    Test that procedure outputs are available immediately after processing the last ResultSet returned by the procedure (i.e that update counts are cached) even if getMoreResults() and ResultSet.close() are not called.
    
    Throws:
    
    java.sql.SQLException
  - testTsEscape
```
public void testTsEscape()
                  throws java.lang.Exception
```
    Test for bug [ 1062671 ] SQLParser unable to parse CONVERT(char,{ts ?},102)
    
    Throws:
    
    java.lang.Exception
  - testInOutParameters
```
public void testInOutParameters()
                         throws java.lang.Exception
```
    Test for separation of IN and INOUT/OUT parameter values
    
    Throws:
    
    java.lang.Exception
  - testSemicolonProcedures
```
public void testSemicolonProcedures()
                             throws java.lang.Exception
```
    Test that procedure names containing semicolons are parsed correctly.
    
    Throws:
    
    java.lang.Exception
  - testNonRpcProc1
```
public void testNonRpcProc1()
                     throws java.lang.Exception
```
    Test that procedure calls with both literal parameters and parameterr markers are executed correctly (bug [1078927] Callable statement fails).
    
    Throws:
    
    java.lang.Exception
  - testNonRpcProc2
```
public void testNonRpcProc2()
                     throws java.lang.Exception
```
    Test that procedure calls with both literal parameters and parameterr markers are executed correctly (bug [1078927] Callable statement fails).
    
    Throws:
    
    java.lang.Exception
  - testWritetext
```
public void testWritetext()
                   throws java.lang.Exception
```
    Test for bug [1152329] Spurious output params assigned (TIMESTMP).
    If a stored procedure execute WRITETEXT or UPDATETEXT commands, spurious output parameter data is returned to the client. This additional data can be confused with the real output parameter data leading to an output string parameter returning the text ?TIMESTMP? on SQL Server 7+ or binary garbage on other servers.
    
    Throws:
    
    java.lang.Exception
  - testErrorOutputParams
```
public void testErrorOutputParams()
                           throws java.lang.Exception
```
    Test for bug [1047208] SQLException chaining not implemented correctly: checks that all errors are returned and that output variables are also returned.
    
    Throws:
    
    java.lang.Exception
  - testBigDecimal
```
public void testBigDecimal()
                    throws java.lang.Exception
```
    Test for bug [1236078] Procedure doesn't get called for some BigDecimal values - invalid bug.
    
    Throws:
    
    java.lang.Exception
  - testCallWithResultSet
```
public void testCallWithResultSet()
                           throws java.lang.Exception
```
    Test retrieving multiple resultsets, the return value and an additional output parameter from a single procedure call.
    
    Throws:
    
    java.lang.Exception
  - testBug637
```
public void testBug637()
                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - main
```
public static void main(java.lang.String[] args)
```
    Test that output result sets, return values and output parameters are correctly handled for a remote procedure call. To set up this test you will a local and remote server where the remote server allows logins from the local test server. Install the following stored procedure on the remote server: create proc jtds_remote @in varchar(16), @out varchar(32) output as begin select 'result set' set @out = 'Test ' + @in; return 1 end Uncomment this test and amend the remoteserver name in the prepareCall statement below to be the actual name of your remote server. The TDS stream for this test will comprise a result set, a dummy return (0x79) value and then the actual return and output parameter (0xAC) records. This call will fail with jtds 1.1 as the dummy return value of 0 in the TDS stream will preempt the capture of the actual value 1. In addition the return value will be assigned to the output parameter and the actual output parameter value will be lost. public void testRemoteCallWithResultSet() throws Exception { CallableStatement cstmt = con.prepareCall( "{?=call remoteserver.database.user.jtds_remote(?,?)}"); cstmt.registerOutParameter(1, Types.INTEGER); cstmt.setString(2, "data"); cstmt.registerOutParameter(3, Types.VARCHAR); cstmt.execute(); ResultSet rs = cstmt.getResultSet(); assertNotNull(rs); assertTrue(rs.next()); assertEquals("result set", rs.getString(1)); assertFalse(rs.next()); rs.close(); assertEquals(1, cstmt.getInt(1)); assertEquals("Test data", cstmt.getString(3)); cstmt.close(); }

Class CallableStatementTest

Field Summary

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

Constructor Summary

Method Summary

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

Methods inherited from class java.lang.Object

Field Detail

SILENT

Constructor Detail

CallableStatementTest

Method Detail

testCommentProcessing

testCallableStatement

testCallableStatement1

testCallableStatementCall1

testCallableStatementCall2

testCallableStatementCall3

testCallableStatementCall4

testCallableStatementExec1

testCallableStatementExec2

testCallableStatementExec3

testCallableStatementExec4

testCallableStatementExec5

testCallableStatementExec6

testCallableStatementExec7

testCallableStatementExec8

testCallableStatementExec9

testCallableStatementParsing1

testCallableStatementParsing2

testCallableStatementParsing3

testCallableStatementParsing4

testCallableStatementParsing5

testCallableStatementParsing6

testCallableStatementParsing7

testCallableSetNull1

testCallableRegisterOutParameter1

testCallableRegisterOutParameter2

testCallableRegisterOutParameter3

testCallableRegisterOutParameter4

testCallableRegisterOutParameter5

testCallableRegisterOutParameter6

testCallableError1

testNamedParameters0001

testNamedParameters0002

testProcessUpdateCounts1

testProcessUpdateCounts2

testProcessUpdateCounts3

testProcessUpdateCounts4

testTsEscape

testInOutParameters

testSemicolonProcedures

testNonRpcProc1

testNonRpcProc2

testWritetext

testErrorOutputParams

testBigDecimal

testCallWithResultSet

testBug637

main