~ubuntu-branches/ubuntu/oneiric/mysql-connector-java/oneiric

« back to all changes in this revision

Viewing changes to src/testsuite/simple/ResultSetTest.java

Committer: Bazaar Package Importer
Author(s): Michael Koch
Date: 2007-11-30 10:34:13 UTC
mfrom: (1.1.4 upstream)
Revision ID: james.westby@ubuntu.com-20071130103413-mxm4lpfrr4fnjbuj

Tags: 5.1.5+dfsg-1

http://bugs.debian.org/450718

* New upstream release. Closes: #450718.
* Add Homepage field to debian/control.

files added:
debian/README.Debian

src/com/mysql/jdbc/BufferRow.java

src/com/mysql/jdbc/ByteArrayRow.java

src/com/mysql/jdbc/CachedResultSetMetaData.java

src/com/mysql/jdbc/ConnectionImpl.java

src/com/mysql/jdbc/ConnectionLifecycleInterceptor.java

src/com/mysql/jdbc/ConnectionPropertiesImpl.java

src/com/mysql/jdbc/Extension.java

src/com/mysql/jdbc/IterateBlock.java

src/com/mysql/jdbc/JDBC4CallableStatement.java

src/com/mysql/jdbc/JDBC4ClientInfoProvider.java

src/com/mysql/jdbc/JDBC4ClientInfoProviderSP.java

src/com/mysql/jdbc/JDBC4CommentClientInfoProvider.java

src/com/mysql/jdbc/JDBC4Connection.java

src/com/mysql/jdbc/JDBC4DatabaseMetaData.java

src/com/mysql/jdbc/JDBC4DatabaseMetaDataUsingInfoSchema.java

src/com/mysql/jdbc/JDBC4MysqlSQLXML.java

src/com/mysql/jdbc/JDBC4NClob.java

src/com/mysql/jdbc/JDBC4PreparedStatement.java

src/com/mysql/jdbc/JDBC4PreparedStatementHelper.java

src/com/mysql/jdbc/JDBC4ResultSet.java

src/com/mysql/jdbc/JDBC4ServerPreparedStatement.java

src/com/mysql/jdbc/JDBC4UpdatableResultSet.java

src/com/mysql/jdbc/LoadBalancingConnectionProxy.java

src/com/mysql/jdbc/ParameterBindings.java

src/com/mysql/jdbc/PingTarget.java

src/com/mysql/jdbc/ResultSetImpl.java

src/com/mysql/jdbc/ResultSetInternalMethods.java

src/com/mysql/jdbc/ResultSetRow.java

src/com/mysql/jdbc/RowDataCursor.java

src/com/mysql/jdbc/RowDataKeyset.java

src/com/mysql/jdbc/StatementImpl.java

src/com/mysql/jdbc/StatementInterceptor.java

src/com/mysql/jdbc/StreamingNotifiable.java

src/com/mysql/jdbc/configs/5-0-Compat.properties

src/com/mysql/jdbc/configs/coldFusion.properties

src/com/mysql/jdbc/exceptions/MySQLStatementCancelledException.java

src/com/mysql/jdbc/exceptions/NotYetImplementedException.java

src/com/mysql/jdbc/exceptions/jdbc4

src/com/mysql/jdbc/exceptions/jdbc4/CommunicationsException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLDataException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLIntegrityConstraintViolationException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLInvalidAuthorizationSpecException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLNonTransientConnectionException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLNonTransientException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLSyntaxErrorException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLTimeoutException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLTransactionRollbackException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLTransientConnectionException.java

src/com/mysql/jdbc/exceptions/jdbc4/MySQLTransientException.java

src/com/mysql/jdbc/interceptors

src/com/mysql/jdbc/interceptors/ResultSetScannerInterceptor.java

src/com/mysql/jdbc/interceptors/ServerStatusDiffInterceptor.java

src/com/mysql/jdbc/interceptors/SessionAssociationInterceptor.java

src/com/mysql/jdbc/jdbc2/optional/JDBC4CallableStatementWrapper.java

src/com/mysql/jdbc/jdbc2/optional/JDBC4ConnectionWrapper.java

src/com/mysql/jdbc/jdbc2/optional/JDBC4PreparedStatementWrapper.java

src/com/mysql/jdbc/jdbc2/optional/JDBC4StatementWrapper.java

src/testsuite/simple/ResultSetTest.java

src/testsuite/simple/jdbc4

src/testsuite/simple/jdbc4/StatementsTest.java

src/testsuite/ssl-test-certs

src/testsuite/ssl-test-certs/ca-cert.pem

src/testsuite/ssl-test-certs/ca-key.pem

src/testsuite/ssl-test-certs/server-cert.pem

src/testsuite/ssl-test-certs/server-key.pem

src/testsuite/ssl-test-certs/server-req.pem

src/testsuite/ssl-test-certs/test-cert-store

files removed:
debug

docs/release-test-output

src/com/mysql/jdbc/CursorRowProvider.java

src/com/mysql/jdbc/ResultSet.java

files modified:
CHANGES

EXCEPTIONS-CONNECTOR-J

build.xml

debian/changelog

debian/control

debian/rules

docs/README

docs/README.txt

docs/connector-j.html

docs/connector-j.pdf

src/com/mysql/jdbc/Blob.java

src/com/mysql/jdbc/BlobFromLocator.java

src/com/mysql/jdbc/Buffer.java

src/com/mysql/jdbc/CallableStatement.java

src/com/mysql/jdbc/CharsetMapping.java

src/com/mysql/jdbc/Clob.java

src/com/mysql/jdbc/CommunicationsException.java

src/com/mysql/jdbc/Connection.java

src/com/mysql/jdbc/ConnectionFeatureNotAvailableException.java

src/com/mysql/jdbc/ConnectionProperties.java

src/com/mysql/jdbc/Constants.java

src/com/mysql/jdbc/DatabaseMetaData.java

src/com/mysql/jdbc/DatabaseMetaDataUsingInfoSchema.java

src/com/mysql/jdbc/DocsConnectionPropsHelper.java

src/com/mysql/jdbc/EscapeProcessor.java

src/com/mysql/jdbc/EscapeProcessorResult.java

src/com/mysql/jdbc/EscapeTokenizer.java

src/com/mysql/jdbc/ExportControlled.java

src/com/mysql/jdbc/Field.java

src/com/mysql/jdbc/LocalizedErrorMessages.properties

src/com/mysql/jdbc/MysqlDefs.java

src/com/mysql/jdbc/MysqlIO.java

src/com/mysql/jdbc/MysqlParameterMetadata.java

src/com/mysql/jdbc/NonRegisteringDriver.java

src/com/mysql/jdbc/NotUpdatable.java

src/com/mysql/jdbc/PreparedStatement.java

src/com/mysql/jdbc/ReplicationConnection.java

src/com/mysql/jdbc/ResultSetMetaData.java

src/com/mysql/jdbc/RowData.java

src/com/mysql/jdbc/RowDataDynamic.java

src/com/mysql/jdbc/RowDataStatic.java

src/com/mysql/jdbc/SQLError.java

src/com/mysql/jdbc/ServerPreparedStatement.java

src/com/mysql/jdbc/SingleByteCharsetConverter.java

src/com/mysql/jdbc/StandardSocketFactory.java

src/com/mysql/jdbc/Statement.java

src/com/mysql/jdbc/StringUtils.java

src/com/mysql/jdbc/TimeUtil.java

src/com/mysql/jdbc/UpdatableResultSet.java

src/com/mysql/jdbc/Util.java

src/com/mysql/jdbc/configs/3-0-Compat.properties

src/com/mysql/jdbc/configs/maxPerformance.properties

src/com/mysql/jdbc/integration/c3p0/MysqlConnectionTester.java

src/com/mysql/jdbc/integration/jboss/MysqlValidConnectionChecker.java

src/com/mysql/jdbc/jdbc2/optional/CallableStatementWrapper.java

src/com/mysql/jdbc/jdbc2/optional/ConnectionWrapper.java

src/com/mysql/jdbc/jdbc2/optional/MysqlDataSource.java

src/com/mysql/jdbc/jdbc2/optional/MysqlDataSourceFactory.java

src/com/mysql/jdbc/jdbc2/optional/MysqlPooledConnection.java

src/com/mysql/jdbc/jdbc2/optional/MysqlXAConnection.java

src/com/mysql/jdbc/jdbc2/optional/MysqlXADataSource.java

src/com/mysql/jdbc/jdbc2/optional/PreparedStatementWrapper.java

src/com/mysql/jdbc/jdbc2/optional/StatementWrapper.java

src/com/mysql/jdbc/jdbc2/optional/SuspendableXAConnection.java

src/com/mysql/jdbc/jdbc2/optional/WrapperBase.java

src/com/mysql/jdbc/log/LogUtils.java

src/com/mysql/jdbc/profiler/ProfileEventSink.java

src/com/mysql/jdbc/profiler/ProfilerEvent.java

src/com/mysql/jdbc/util/PropertiesDocGenerator.java

src/com/mysql/jdbc/util/ServerController.java

src/com/mysql/jdbc/util/VersionFSHierarchyMaker.java

src/doc/sources/errorMapToDocbook.xsl

src/testsuite/BaseTestCase.java

src/testsuite/regression/CallableStatementRegressionTest.java

src/testsuite/regression/ConnectionRegressionTest.java

src/testsuite/regression/DataSourceRegressionTest.java

src/testsuite/regression/EscapeProcessorRegressionTest.java

src/testsuite/regression/MetaDataRegressionTest.java

src/testsuite/regression/ResultSetRegressionTest.java

src/testsuite/regression/StatementRegressionTest.java

src/testsuite/regression/StressRegressionTest.java

src/testsuite/regression/StringRegressionTest.java

src/testsuite/regression/SubqueriesRegressionTest.java

src/testsuite/simple/BlobTest.java

src/testsuite/simple/CallableStatementTest.java

src/testsuite/simple/CharsetTests.java

src/testsuite/simple/ConnectionTest.java

src/testsuite/simple/DataSourceTest.java

src/testsuite/simple/MetadataTest.java

src/testsuite/simple/StatementsTest.java

Show diffs side-by-side

added added

removed removed

src/testsuite/simple/ResultSetTest.java

This program is free software; you can redistribute it and/or modify

it under the terms of version 2 of the GNU General Public License as

published by the Free Software Foundation.

There are special exceptions to the terms and conditions of the GPL

as it is applied to this software. View the full text of the

exception in file EXCEPTIONS-CONNECTOR-J in the directory of this

software distribution.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

package testsuite.simple;

import java.sql.Connection;

import java.sql.SQLException;

import java.util.Iterator;

import java.util.Properties;

import com.mysql.jdbc.CharsetMapping;

import testsuite.BaseTestCase;

public class ResultSetTest extends BaseTestCase {

public ResultSetTest(String name) {

super(name);

}

/**

* Runs all test cases in this test suite

* @param args

public static void main(String[] args) {

junit.textui.TestRunner.run(ResultSetTest.class);

}

public void testPadding() throws Exception {

if (!versionMeetsMinimum(4, 1, 0)) {

return;

}

Connection paddedConn = null;

int numChars = 32;

Iterator charsetNames = CharsetMapping.STATIC_CHARSET_TO_NUM_BYTES_MAP

.keySet().iterator();

StringBuffer columns = new StringBuffer();

StringBuffer emptyBuf = new StringBuffer();

StringBuffer abcBuf = new StringBuffer();

StringBuffer repeatBuf = new StringBuffer();

StringBuffer selectBuf = new StringBuffer();

int counter = 0;

while (charsetNames.hasNext()) {

String charsetName = charsetNames.next().toString();

if (charsetName.equalsIgnoreCase("LATIN7")

|| charsetName.equalsIgnoreCase("BINARY")) {

continue; // no mapping in Java

}

if (counter != 0) {

columns.append(",");

emptyBuf.append(",");

abcBuf.append(",");

repeatBuf.append(",");

selectBuf.append(",");

}

emptyBuf.append("''");

abcBuf.append("'abc'");

repeatBuf.append("REPEAT('b', " + numChars + ")");

columns.append("field_");

columns.append(charsetName);

columns.append(" CHAR(");

columns.append(numChars);

columns.append(") CHARACTER SET ");

columns.append(charsetName);

selectBuf.append("field_");

100

selectBuf.append(charsetName);

101

102

counter++;

103

}

104

105

createTable("testPadding", "(" + columns.toString() + ", ord INT)");

106

107

this.stmt.executeUpdate("INSERT INTO testPadding VALUES ("

108

+ emptyBuf.toString() + ", 1), (" + abcBuf.toString()

109

+ ", 2), (" + repeatBuf.toString() + ", 3)");

110

111

try {

112

Properties props = new Properties();

113

props.setProperty("padCharsWithSpace", "true");

114

115

paddedConn = getConnectionWithProps(props);

116

117

testPaddingForConnection(paddedConn, numChars, selectBuf);

118

119

props.setProperty("useDynamicCharsetInfo", "true");

120

121

paddedConn = getConnectionWithProps(props);

122

123

testPaddingForConnection(paddedConn, numChars, selectBuf);

124

} finally {

125

closeMemberJDBCResources();

126

127

if (paddedConn != null) {

128

paddedConn.close();

129

}

130

}

131

}

132

133

private void testPaddingForConnection(Connection paddedConn, int numChars,

134

StringBuffer selectBuf) throws SQLException {

135

136

String query = "SELECT " + selectBuf.toString()

137

+ " FROM testPadding ORDER by ord";

138

139

this.rs = paddedConn.createStatement().executeQuery(query);

140

int numCols = this.rs.getMetaData().getColumnCount();

141

142

while (this.rs.next()) {

143

for (int i = 0; i < numCols; i++) {

144

assertEquals("For column '"

145

+ this.rs.getMetaData().getColumnName(i + 1)

146

+ "' of collation "

147

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

148

.getMetaData()).getColumnCharacterSet(i + 1),

149

numChars, this.rs.getString(i + 1).length());

150

}

151

}

152

153

this.rs = ((com.mysql.jdbc.Connection) paddedConn)

154

.clientPrepareStatement(query).executeQuery();

155

156

while (this.rs.next()) {

157

for (int i = 0; i < numCols; i++) {

158

assertEquals("For column '"

159

+ this.rs.getMetaData().getColumnName(i + 1)

160

+ "' of collation "

161

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

162

.getMetaData()).getColumnCharacterSet(i + 1),

163

numChars, this.rs.getString(i + 1).length());

164

}

165

}

166

167

if (versionMeetsMinimum(4, 1)) {

168

this.rs = ((com.mysql.jdbc.Connection) paddedConn).serverPrepareStatement(

169

query).executeQuery();

170

171

while (this.rs.next()) {

172

for (int i = 0; i < numCols; i++) {

173

assertEquals("For column '"

174

+ this.rs.getMetaData().getColumnName(i + 1)

175

+ "' of collation "

176

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

177

.getMetaData())

178

.getColumnCharacterSet(i + 1), numChars,

179

this.rs.getString(i + 1).length());

180

}

181

}

182

}

183

184

this.rs = this.stmt.executeQuery(query);

185

186

while (this.rs.next()) {

187

for (int i = 0; i < numCols; i++) {

188

if (this.rs.getRow() != 3) {

189

assertTrue("For column '"

190

+ this.rs.getMetaData().getColumnName(i + 1)

191

+ "' of collation "

192

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

193

.getMetaData())

194

.getColumnCharacterSet(i + 1),

195

numChars != this.rs.getString(i + 1).length());

196

} else {

197

assertEquals("For column '"

198

+ this.rs.getMetaData().getColumnName(i + 1)

199

+ "' of collation "

200

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

201

.getMetaData())

202

.getColumnCharacterSet(i + 1), numChars,

203

this.rs.getString(i + 1).length());

204

}

205

}

206

}

207

208

this.rs = ((com.mysql.jdbc.Connection) this.conn)

209

.clientPrepareStatement(query).executeQuery();

210

211

while (this.rs.next()) {

212

for (int i = 0; i < numCols; i++) {

213

if (this.rs.getRow() != 3) {

214

assertTrue("For column '"

215

+ this.rs.getMetaData().getColumnName(i + 1)

216

+ "' of collation "

217

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

218

.getMetaData())

219

.getColumnCharacterSet(i + 1),

220

numChars != this.rs.getString(i + 1).length());

221

} else {

222

assertEquals("For column '"

223

+ this.rs.getMetaData().getColumnName(i + 1)

224

+ "' of collation "

225

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

226

.getMetaData())

227

.getColumnCharacterSet(i + 1), numChars,

228

this.rs.getString(i + 1).length());

229

}

230

}

231

}

232

233

if (versionMeetsMinimum(4, 1)) {

234

this.rs = ((com.mysql.jdbc.Connection) this.conn).serverPrepareStatement(

235

query).executeQuery();

236

237

while (this.rs.next()) {

238

for (int i = 0; i < numCols; i++) {

239

if (this.rs.getRow() != 3) {

240

assertTrue("For column '"

241

+ this.rs.getMetaData().getColumnName(i + 1)

242

+ "' of collation "

243

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

244

.getMetaData())

245

.getColumnCharacterSet(i + 1),

246

numChars != this.rs.getString(i + 1).length());

247

} else {

248

assertEquals("For column '"

249

+ this.rs.getMetaData().getColumnName(i + 1)

250

+ "' of collation "

251

+ ((com.mysql.jdbc.ResultSetMetaData) this.rs

252

.getMetaData())

253

.getColumnCharacterSet(i + 1),

254

numChars, this.rs.getString(i + 1).length());

255

}

256

}

257

}

258

}

259

}

260

}

Older »