| testsuite.BaseTestCase
 testsuite.regression.ConnectionRegressionTest
| ConnectionRegressionTest | | public class ConnectionRegressionTest extends BaseTestCase (Code) | | Regression tests for Connections
author:
Mark Matthews
version:
$Id: ConnectionRegressionTest.java,v 1.1.2.1 2005/05/13 18:58:38
version:
mmatthews Exp $ |
| Method Summary | |
| protected Properties | getMasterSlaveProps()
| | protected String | getMasterSlaveUrl()
| | public static void | main(String[] args)
| | public void | testBug10144()
Tests fix for BUG#10144 - Memory leak in ServerPreparedStatement if
serverPrepare() fails. | | public void | testBug10496()
| | public void | testBug11259()
Tests fix for BUG#11259, autoReconnect ping causes exception on
connection startup. | | public void | testBug11879()
Tests fix for BUG#11879 -- ReplicationConnection won't switch to slave,
throws "Catalog can't be null" exception. | | public void | testBug11976()
Tests fix for BUG#11976 - maxPerformance.properties mis-spells
"elideSetAutoCommits". | | public void | testBug12218()
Tests fix for BUG#12218, properties shared between master and slave with
replication connection. | | public void | testBug12229()
Tests fix for BUG#12229 - explainSlowQueries hangs with server-side
prepared statements. | | public void | testBug12752()
Tests fix for BUG#12752 - Cp1251 incorrectly mapped to win1251 for
servers newer than 4.0.x. | | public void | testBug12753()
Tests fix for BUG#12753, sessionVariables=....=...., doesn't work as it's
tokenized incorrectly. | | public void | testBug13048()
Tests fix for BUG#13048 - maxQuerySizeToLog is not respected. | | public void | testBug13453()
Tests fix for BUG#13453 - can't use & or = in URL configuration values
(we now allow you to use www-form-encoding). | | public void | testBug15065()
Tests fix for BUG#15065 - Usage advisor complains about unreferenced
columns, even though they've been referenced. | | public void | testBug15544()
| | public void | testBug15570()
Tests fix for BUG#15570 - ReplicationConnection incorrectly copies state,
doesn't transfer connection context correctly when transitioning between
the same read-only states. | | public void | testBug1914()
| | public void | testBug22643()
Test of a new feature to fix BUG 22643, specifying a
"validation query" in your connection pool that starts
with "slash-star ping slash-star" _exactly_ will cause the driver to " +
instead send a ping to the server (much lighter weight), and when using
a ReplicationConnection or a LoadBalancedConnection, will send
the ping across all active connections. | | public void | testBug23281()
Tests bug where downed slave caused round robin load balance not to
cycle back to first host in the list. | | public void | testBug23626()
Ensures that we don't miss getters/setters for driver properties in
ConnectionProperties so that names given in documentation work with
DataSources which will use JavaBean-style names and reflection to
set the values (and often fail silently! when the method isn't available). | | public void | testBug24706()
Tests to insure proper behavior for BUG#24706. | | public void | testBug25514()
Tests fix for BUG#25514 - Timer instance used for Statement.setQueryTimeout()
created per-connection, rather than per-VM, causing memory leak. | | public void | testBug25545()
Tests fix for BUG#25545 - Client flags not sent correctly during handshake
when using SSL. | | public void | testBug27655()
| | public void | testBug29852()
| | public void | testBug3554()
Tests fix for BUG#3554 - Not specifying database in URL causes
MalformedURL exception. | | public void | testBug3790()
| | public void | testBug4334()
Tests fix for BUG#4334, port #'s not being picked up for
failover/autoreconnect. | | public void | testBug6966()
Tests fix for BUG#6966, connections starting up failed-over (due to down
master) never retry master. | | public void | testBug7607()
Tests fix for BUG#7607 - MS932, SHIFT_JIS and Windows_31J not recog. | | public void | testBug7952()
Test fix for BUG#7952 -- Infinite recursion when 'falling back' to master
in failover configuration. | | public void | testBug8643()
In some case Connector/J's round-robin function doesn't work.
I had 2 mysqld, node1 "localhost:3306" and node2 "localhost:3307".
1. | | public void | testBug9206()
Tests fix for BUG#9206, can not use 'UTF-8' for characterSetResults
configuration property. | | public void | testCSC5765()
| | public void | testCollation41()
Tests if the driver configures character sets correctly for 4.1.x
servers. | | public void | testFailoverReadOnly()
Tests fix for issue where a failed-over connection would let
an application call setReadOnly(false), when that call
should be ignored until the connection is reconnected to a
writable master. | | public void | testNewCharsetsConfiguration()
These two charsets have different names depending on version of MySQL
server. | | public void | testPropertiesDescriptionsKeys()
| | public void | testSetReadOnly()
|
| ConnectionRegressionTest | | public ConnectionRegressionTest(String name)(Code) | | DOCUMENT ME!
Parameters:
name - the name of the testcase |
| main | | public static void main(String[] args)(Code) | | Runs all test cases in this test suite
Parameters:
args - |
| testBug10144 | | public void testBug10144() throws Exception(Code) | | Tests fix for BUG#10144 - Memory leak in ServerPreparedStatement if
serverPrepare() fails.
|
| testBug10496 | | public void testBug10496() throws Exception(Code) | | Tests fix for BUG#10496 - SQLException is thrown when using property
"characterSetResults"
|
| testBug11259 | | public void testBug11259() throws Exception(Code) | | Tests fix for BUG#11259, autoReconnect ping causes exception on
connection startup.
throws:
Exception - if the test fails. |
| testBug11879 | | public void testBug11879() throws Exception(Code) | | Tests fix for BUG#11879 -- ReplicationConnection won't switch to slave,
throws "Catalog can't be null" exception.
throws:
Exception - if the test fails |
| testBug11976 | | public void testBug11976() throws Exception(Code) | | Tests fix for BUG#11976 - maxPerformance.properties mis-spells
"elideSetAutoCommits".
throws:
Exception - if the test fails. |
| testBug12218 | | public void testBug12218() throws Exception(Code) | | Tests fix for BUG#12218, properties shared between master and slave with
replication connection.
throws:
Exception - if the test fails. |
| testBug12229 | | public void testBug12229() throws Exception(Code) | | Tests fix for BUG#12229 - explainSlowQueries hangs with server-side
prepared statements.
throws:
Exception - if the test fails. |
| testBug12752 | | public void testBug12752() throws Exception(Code) | | Tests fix for BUG#12752 - Cp1251 incorrectly mapped to win1251 for
servers newer than 4.0.x.
throws:
Exception - if the test fails. |
| testBug12753 | | public void testBug12753() throws Exception(Code) | | Tests fix for BUG#12753, sessionVariables=....=...., doesn't work as it's
tokenized incorrectly.
throws:
Exception - if the test fails. |
| testBug13048 | | public void testBug13048() throws Exception(Code) | | Tests fix for BUG#13048 - maxQuerySizeToLog is not respected.
throws:
Exception - if the test fails |
| testBug13453 | | public void testBug13453() throws Exception(Code) | | Tests fix for BUG#13453 - can't use & or = in URL configuration values
(we now allow you to use www-form-encoding).
throws:
Exception - if the test fails |
| testBug15065 | | public void testBug15065() throws Exception(Code) | | Tests fix for BUG#15065 - Usage advisor complains about unreferenced
columns, even though they've been referenced.
throws:
Exception - if the test fails. |
| testBug15544 | | public void testBug15544() throws Exception(Code) | | Tests fix for BUG#15544, no "dos" character set in MySQL > 4.1.0
throws:
Exception - if the test fails |
| testBug15570 | | public void testBug15570() throws Exception(Code) | | Tests fix for BUG#15570 - ReplicationConnection incorrectly copies state,
doesn't transfer connection context correctly when transitioning between
the same read-only states.
(note, this test will fail if the test user doesn't have permission to
"USE 'mysql'".
throws:
Exception - if the test fails. |
| testBug22643 | | public void testBug22643() throws Exception(Code) | | Test of a new feature to fix BUG 22643, specifying a
"validation query" in your connection pool that starts
with "slash-star ping slash-star" _exactly_ will cause the driver to " +
instead send a ping to the server (much lighter weight), and when using
a ReplicationConnection or a LoadBalancedConnection, will send
the ping across all active connections.
throws:
Exception - |
| testBug23281 | | public void testBug23281() throws Exception(Code) | | Tests bug where downed slave caused round robin load balance not to
cycle back to first host in the list.
throws:
Exception - if the test fails...Note, test is timing-dependent, butshould work in most cases. |
| testBug23626 | | public void testBug23626() throws Exception(Code) | | Ensures that we don't miss getters/setters for driver properties in
ConnectionProperties so that names given in documentation work with
DataSources which will use JavaBean-style names and reflection to
set the values (and often fail silently! when the method isn't available).
throws:
Exception - |
| testBug24706 | | public void testBug24706() throws Exception(Code) | | Tests to insure proper behavior for BUG#24706.
throws:
Exception - if the test fails. |
| testBug25514 | | public void testBug25514() throws Exception(Code) | | Tests fix for BUG#25514 - Timer instance used for Statement.setQueryTimeout()
created per-connection, rather than per-VM, causing memory leak.
throws:
Exception - if the test fails. |
| testBug25545 | | public void testBug25545() throws Exception(Code) | | Tests fix for BUG#25545 - Client flags not sent correctly during handshake
when using SSL.
Requires test certificates from testsuite/ssl-test-certs to be installed
on the server being tested.
throws:
Exception - if the test fails. |
| testBug27655 | | public void testBug27655() throws Exception(Code) | | Tests fix for BUG#27655 - getTransactionIsolation() uses
"SHOW VARIABLES LIKE" which is very inefficient on MySQL-5.0+
throws:
Exception - |
| testBug3554 | | public void testBug3554() throws Exception(Code) | | Tests fix for BUG#3554 - Not specifying database in URL causes
MalformedURL exception.
throws:
Exception - if an error ocurrs. |
| testBug4334 | | public void testBug4334() throws Exception(Code) | | Tests fix for BUG#4334, port #'s not being picked up for
failover/autoreconnect.
throws:
Exception - if an error occurs. |
| testBug6966 | | public void testBug6966() throws Exception(Code) | | Tests fix for BUG#6966, connections starting up failed-over (due to down
master) never retry master.
throws:
Exception - if the test fails...Note, test is timing-dependent, butshould work in most cases. |
| testBug7607 | | public void testBug7607() throws Exception(Code) | | Tests fix for BUG#7607 - MS932, SHIFT_JIS and Windows_31J not recog. as
aliases for sjis.
throws:
Exception - if the test fails. |
| testBug7952 | | public void testBug7952() throws Exception(Code) | | Test fix for BUG#7952 -- Infinite recursion when 'falling back' to master
in failover configuration.
throws:
Exception - if the tests fails. |
| testBug8643 | | public void testBug8643() throws Exception(Code) | | In some case Connector/J's round-robin function doesn't work.
I had 2 mysqld, node1 "localhost:3306" and node2 "localhost:3307".
1. node1 is up, node2 is up
2. java-program connect to node1 by using properties
"autoRecconect=true","roundRobinLoadBalance=true","failOverReadOnly=false".
3. node1 is down, node2 is up
4. java-program execute a query and fail, but Connector/J's round-robin
fashion failover work and if java-program retry a query it can succeed
(connection is change to node2 by Connector/j)
5. node1 is up, node2 is up
6. node1 is up, node2 is down
7. java-program execute a query, but this time Connector/J doesn't work
althought node1 is up and usable.
throws:
Exception - |
| testBug9206 | | public void testBug9206() throws Exception(Code) | | Tests fix for BUG#9206, can not use 'UTF-8' for characterSetResults
configuration property.
|
| testCollation41 | | public void testCollation41() throws Exception(Code) | | Tests if the driver configures character sets correctly for 4.1.x
servers. Requires that the 'admin connection' is configured, as this test
needs to create/drop databases.
throws:
Exception - if an error occurs |
| testFailoverReadOnly | | public void testFailoverReadOnly() throws Exception(Code) | | Tests fix for issue where a failed-over connection would let
an application call setReadOnly(false), when that call
should be ignored until the connection is reconnected to a
writable master.
throws:
Exception - if the test fails. |
| testNewCharsetsConfiguration | | public void testNewCharsetsConfiguration() throws Exception(Code) | | These two charsets have different names depending on version of MySQL
server.
throws:
Exception - if the test fails. |
| testPropertiesDescriptionsKeys | | public void testPropertiesDescriptionsKeys() throws Exception(Code) | | |
| testSetReadOnly | | public void testSetReadOnly() throws Exception(Code) | | Tests setReadOnly() being reset during failover
throws:
Exception - if an error occurs. |
| 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)
|
|
|