|
| |
|
| testsuite.BaseTestCase
 testsuite.regression.CallableStatementRegressionTest
| CallableStatementRegressionTest | | public class CallableStatementRegressionTest extends BaseTestCase (Code) | | Tests fixes for bugs in CallableStatement code.
version:
$Id: CallableStatementRegressionTest.java,v 1.1.2.6 2004/12/09
version:
15:57:26 mmatthew Exp $ |
| Method Summary | |
| public static void | main(String[] args)
| | protected boolean | serverSupportsStoredProcedures()
| | public void | testBug10310()
Tests fix forBUG#10310 - Driver doesn't support {?=CALL(...)} for calling
stored functions. | | public void | testBug12417()
Tests fix for Bug#12417 - stored procedure catalog name is case-sensitive
on Windows (this is actually a server bug, but we have a workaround in
place for it now). | | public void | testBug15121()
| | public void | testBug15464()
Tests fix for BUG#15464 - INOUT parameter does not store IN value. | | public void | testBug17898()
Tests fix for BUG#17898 - registerOutParameter not working when some
parameters pre-populated. | | public void | testBug21462()
Tests fix for BUG#21462 - JDBC (and ODBC) specifications allow no-parenthesis
CALL statements for procedures with no arguments, MySQL server does not. | | public void | testBug22024()
Tests fix for BUG#22024 - Newlines causing whitespace to span confuse
procedure parser when getting parameter metadata for stored procedures. | | public void | testBug22297()
Tests workaround for server crash when calling stored procedures
via a server-side prepared statement (driver now detects
prepare(stored procedure) and substitutes client-side prepared statement). | | public void | testBug25379()
Tests fix for BUG#25379 - INOUT parameters in CallableStatements get doubly-escaped. | | public void | testBug25715()
| | public void | testBug26143()
| | public void | testBug26959()
Tests fix for BUG#26959 - comments confuse procedure parser. | | public void | testBug27400()
| | public void | testBug28689()
Tests fix for BUG#28689 - CallableStatement.executeBatch()
doesn't work when connection property "noAccessToProcedureBodies"
has been set to "true". | | public void | testBug3539()
| | public void | testBug3540()
| | public void | testBug7026()
| | public void | testBug9319()
Tests fix for BUG#9319 -- Stored procedures with same name in different
databases confuse the driver when it tries to determine parameter
counts/types. | | public void | testBug9682()
Tests fix for BUG#9682 - Stored procedures with DECIMAL parameters with
storage specifications that contained "," in them would fail. | | public void | testHugeNumberOfParameters()
| | public void | testPrepareOfMultiRs()
|
| CallableStatementRegressionTest | | public CallableStatementRegressionTest(String name)(Code) | | DOCUMENT ME!
Parameters:
name - |
| main | | public static void main(String[] args)(Code) | | Runs all test cases in this test suite
Parameters:
args - ignored |
| serverSupportsStoredProcedures | | protected boolean serverSupportsStoredProcedures() throws SQLException(Code) | | |
| testBug10310 | | public void testBug10310() throws Exception(Code) | | Tests fix forBUG#10310 - Driver doesn't support {?=CALL(...)} for calling
stored functions. This involved adding support for function retrieval to
DatabaseMetaData.getProcedures() and getProcedureColumns() as well.
throws:
Exception - if the test fails. |
| testBug12417 | | public void testBug12417() throws Exception(Code) | | Tests fix for Bug#12417 - stored procedure catalog name is case-sensitive
on Windows (this is actually a server bug, but we have a workaround in
place for it now).
throws:
Exception - if the test fails. |
| testBug15464 | | public void testBug15464() throws Exception(Code) | | Tests fix for BUG#15464 - INOUT parameter does not store IN value.
throws:
Exception - if the test fails |
| testBug17898 | | public void testBug17898() throws Exception(Code) | | Tests fix for BUG#17898 - registerOutParameter not working when some
parameters pre-populated. Still waiting for feedback from JDBC experts
group to determine what correct parameter count from getMetaData() should
be, however.
throws:
Exception - if the test fails |
| testBug21462 | | public void testBug21462() throws Exception(Code) | | Tests fix for BUG#21462 - JDBC (and ODBC) specifications allow no-parenthesis
CALL statements for procedures with no arguments, MySQL server does not.
throws:
Exception - if the test fails. |
| testBug22024 | | public void testBug22024() throws Exception(Code) | | Tests fix for BUG#22024 - Newlines causing whitespace to span confuse
procedure parser when getting parameter metadata for stored procedures.
throws:
Exception - if the test fails |
| testBug22297 | | public void testBug22297() throws Exception(Code) | | Tests workaround for server crash when calling stored procedures
via a server-side prepared statement (driver now detects
prepare(stored procedure) and substitutes client-side prepared statement).
throws:
Exception - if the test fails |
| testBug25379 | | public void testBug25379() throws Exception(Code) | | Tests fix for BUG#25379 - INOUT parameters in CallableStatements get doubly-escaped.
throws:
Exception - if the test fails. |
| testBug25715 | | public void testBug25715() throws Exception(Code) | | Tests fix for BUG#25715 - CallableStatements with OUT/INOUT parameters that
are "binary" have extra 7 bytes (which happens to be the _binary introducer!)
throws:
Exception - if the test fails. |
| testBug26959 | | public void testBug26959() throws Exception(Code) | | Tests fix for BUG#26959 - comments confuse procedure parser.
throws:
Exception - if the test fails |
| testBug27400 | | public void testBug27400() throws Exception(Code) | | Tests fix for BUG#27400 - CALL [comment] some_proc() doesn't work
|
| testBug28689 | | public void testBug28689() throws Exception(Code) | | Tests fix for BUG#28689 - CallableStatement.executeBatch()
doesn't work when connection property "noAccessToProcedureBodies"
has been set to "true".
The fix involves changing the behavior of "noAccessToProcedureBodies",
in that the driver will now report all paramters as "IN" paramters
but allow callers to call registerOutParameter() on them.
throws:
Exception - |
| testBug3539 | | public void testBug3539() throws Exception(Code) | | Tests fix for BUG#3539 getProcedures() does not return any procedures in
result set
throws:
Exception - if an error occurs. |
| testBug3540 | | public void testBug3540() throws Exception(Code) | | Tests fix for BUG#3540 getProcedureColumns doesn't work with wildcards
for procedure name
throws:
Exception - if an error occurs. |
| testBug7026 | | public void testBug7026() throws Exception(Code) | | Tests fix for BUG#7026 - DBMD.getProcedures() doesn't respect catalog
parameter
throws:
Exception - if the test fails. |
| testBug9319 | | public void testBug9319() throws Exception(Code) | | Tests fix for BUG#9319 -- Stored procedures with same name in different
databases confuse the driver when it tries to determine parameter
counts/types.
throws:
Exception - if the test fails |
| testBug9682 | | public void testBug9682() throws Exception(Code) | | Tests fix for BUG#9682 - Stored procedures with DECIMAL parameters with
storage specifications that contained "," in them would fail.
throws:
Exception - if the test fails. |
| testHugeNumberOfParameters | | public void testHugeNumberOfParameters() throws Exception(Code) | | |
| testPrepareOfMultiRs | | public void testPrepareOfMultiRs() throws Exception(Code) | | |
| Methods inherited from testsuite.BaseTestCase | protected void cleanupTempFiles(File exampleTempFile, String tempfilePrefix)(Code)(Java Doc)
protected void closeMemberJDBCResources()(Code)(Java Doc)
protected void createFunction(String functionName, String functionDefn) throws SQLException(Code)(Java Doc)
protected void createProcedure(String procedureName, String procedureDefn) throws SQLException(Code)(Java Doc)
protected void createSchemaObject(String objectType, String objectName, String columnsAndOtherStuff) throws SQLException(Code)(Java Doc)
protected void createTable(String tableName, String columnsAndOtherStuff) throws SQLException(Code)(Java Doc)
protected void dropFunction(String functionName) throws SQLException(Code)(Java Doc)
protected void dropProcedure(String procedureName) throws SQLException(Code)(Java Doc)
protected void dropSchemaObject(String objectType, String objectName) throws SQLException(Code)(Java Doc)
protected void dropTable(String tableName) throws SQLException(Code)(Java Doc)
protected Connection getAdminConnection() throws SQLException(Code)(Java Doc)
protected Connection getAdminConnectionWithProps(Properties props) throws SQLException(Code)(Java Doc)
protected Connection getConnectionWithProps(String propsList) throws SQLException(Code)(Java Doc)
protected Connection getConnectionWithProps(String url, String propsList) throws SQLException(Code)(Java Doc)
protected Connection getConnectionWithProps(Properties props) throws SQLException(Code)(Java Doc)
protected Connection getConnectionWithProps(String url, Properties props) throws SQLException(Code)(Java Doc)
protected int getInstanceNumber()(Code)(Java Doc)
protected String getMysqlVariable(Connection c, String variableName) throws SQLException(Code)(Java Doc)
protected String getMysqlVariable(String variableName) throws SQLException(Code)(Java Doc)
protected Properties getPropertiesFromTestsuiteUrl() throws SQLException(Code)(Java Doc)
protected int getRowCount(String tableName) throws SQLException(Code)(Java Doc)
protected Object getSingleIndexedValueWithQuery(Connection c, int columnIndex, String query) throws SQLException(Code)(Java Doc)
protected Object getSingleIndexedValueWithQuery(int columnIndex, String query) throws SQLException(Code)(Java Doc)
protected Object getSingleValue(String tableName, String columnName, String whereClause) throws SQLException(Code)(Java Doc)
protected Object getSingleValueWithQuery(String query) throws SQLException(Code)(Java Doc)
protected boolean isAdminConnectionConfigured()(Code)(Java Doc)
protected boolean isClassAvailable(String classname)(Code)(Java Doc)
protected boolean isRunningOnJRockit()(Code)(Java Doc)
protected boolean isRunningOnJdk131()(Code)(Java Doc)
protected boolean isServerRunningOnWindows() throws SQLException(Code)(Java Doc)
public void logDebug(String message)(Code)(Java Doc)
protected File newTempBinaryFile(String name, long size) throws IOException(Code)(Java Doc)
protected String randomString()(Code)(Java Doc)
final protected boolean runLongTests()(Code)(Java Doc)
protected boolean runMultiHostTests()(Code)(Java Doc)
protected boolean runTestIfSysPropDefined(String propName)(Code)(Java Doc)
public void setUp() throws Exception(Code)(Java Doc)
public void tearDown() throws Exception(Code)(Java Doc)
protected boolean versionMeetsMinimum(int major, int minor) throws SQLException(Code)(Java Doc)
protected boolean versionMeetsMinimum(int major, int minor, int subminor) throws SQLException(Code)(Java Doc)
|
|
|
|