Java Doc for PreparedStatementTest.java in » Database-JDBC-Connection-Pool » jTDS » net » sourceforge » jtds » test » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation

1.	6.0 JDK Core
2.	6.0 JDK Modules
3.	6.0 JDK Modules com.sun
4.	6.0 JDK Modules com.sun.java
5.	6.0 JDK Modules sun
6.	6.0 JDK Platform
7.	Ajax
8.	Apache Harmony Java SE
9.	Aspect oriented
10.	Authentication Authorization
11.	Blogger System
12.	Build
13.	Byte Code
14.	Cache
15.	Chart
16.	Chat
17.	Code Analyzer
18.	Collaboration
19.	Content Management System
20.	Database Client
21.	Database DBMS
22.	Database JDBC Connection Pool
23.	Database ORM
24.	Development
25.	EJB Server geronimo
26.	EJB Server GlassFish
27.	EJB Server JBoss 4.2.1
28.	EJB Server resin 3.1.5
29.	ERP CRM Financial
30.	ESB
31.	Forum
32.	GIS
33.	Graphic Library
34.	Groupware
35.	HTML Parser
36.	IDE
37.	IDE Eclipse
38.	IDE Netbeans
39.	Installer
40.	Internationalization Localization
41.	Inversion of Control
42.	Issue Tracking
43.	J2EE
44.	JBoss
45.	JMS
46.	JMX
47.	Library
48.	Mail Clients
49.	Net
50.	Parser
51.	PDF
52.	Portal
53.	Profiler
54.	Project Management
55.	Report
56.	RSS RDF
57.	Rule Engine
58.	Science
59.	Scripting
60.	Search Engine
61.	Security
62.	Sevlet Container
63.	Source Control
64.	Swing Library
65.	Template Engine
66.	Test Coverage
67.	Testing
68.	UML
69.	Web Crawler
70.	Web Framework
71.	Web Mail
72.	Web Server
73.	Web Services
74.	Web Services apache cxf 2.0.1
75.	Web Services AXIS2
76.	Wiki Engine
77.	Workflow Engines
78.	XML
79.	XML UI

Java

Java Tutorial

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database JDBC Connection Pool » jTDS » net.sourceforge.jtds.test

Source Cross Reference Class Diagram Java Document (Java Doc)

net.sourceforge.jtds.test .TestBase

net.sourceforge.jtds.test .PreparedStatementTest

PreparedStatementTest
public class PreparedStatementTest extends TestBase (Code)
	version: $Id: PreparedStatementTest.java,v 1.46 2007/07/08 18:26:26 bheineman Exp $

Inner Class :static class TestMultiThread extends Thread

Constructor Summary
public	PreparedStatementTest(String name)

Method Summary
public static void	main(String[] args)
public void	testBigDecBadParamSpec() Test for bug [1094621] Decimal conversion error: A prepared statement with a decimal parameter that is -1E38 will fail as a result of the driver generating a parameter specification of decimal(38,10) rather than decimal(38,0).
public void	testEscapedParams() Test for parameter markers in function escapes.
public void	testFloatValues() Tests that float (single precision - 32 bit) values are not converted to double (thus loosing precision).
public void	testIllegalParameters() Test for bug [1111516 ] Illegal Parameters in PreparedStatement.
public void	testLongStatement() Test for bug [1022968] Long SQL expression error. NB.
public void	testManyParametersStatement() Test for bug [1047330] prep statement with more than 2100 params fails.
public void	testMaxRows() Test for bug [1010660] 0.9-rc1 setMaxRows causes unlimited temp stored procedures.
public void	testMetaData() Test for bad truncation in prepared statements on metadata retrieval (patch [1076383] ResultSetMetaData for more complex statements for SQL Server).
public void	testMetaDataClearsResultSet() Test for bug [1050660] PreparedStatement.getMetaData() clears resultset.
public void	testMissingWhitespace() Test for bug [ 1059916 ] whitespace needed in preparedStatement.
public void	testMultiThread() Test `Connection` concurrency by running `PreparedStatement`s and rollbacks at the same time to see whether handles are not lost in the process.
public void	testNegativeScale()
public void	testNoPrepare() Test that statements which cannot be prepared are remembered.
public void	testOuterJoinParameters() Test for bug [1071397] Error in prepared statement (parameters in outer join escapes are not recognized).
public void	testPrepareFailWarning() Test for bug [1180777] collation-related execption on update.
public void	testPrepareModes() Test that preparedstatement logic copes with commit modes and database changes.
public void	testPrepareSQL0()
public void	testPreparedStatement()
public void	testPreparedStatementAddBatch1()
public void	testPreparedStatementParsing1()
public void	testPreparedStatementParsing2()
public void	testPreparedStatementParsing3() Test for "invalid parameter index" error.
public void	testPreparedStatementRollback1()
public void	testPreparedStatementSetObject1()
public void	testPreparedStatementSetObject2()
public void	testPreparedStatementSetObject3()
public void	testPreparedStatementSetObject4()
public void	testPreparedStatementSetObject5()
public void	testPreparedStatementSetObject6() Test for bug [1204658] Conversion from Number to BigDecimal causes data corruption.
public void	testScrollablePreparedStatement()
public void	testUpdateCount1()

Constructor Detail

PreparedStatementTest
public PreparedStatementTest(String name)(Code)

Method Detail

main
public static void main(String[] args)(Code)

testBigDecBadParamSpec
public void testBigDecBadParamSpec() throws Exception(Code)
	Test for bug [1094621] Decimal conversion error: A prepared statement with a decimal parameter that is -1E38 will fail as a result of the driver generating a parameter specification of decimal(38,10) rather than decimal(38,0).

testEscapedParams
public void testEscapedParams() throws Exception(Code)
	Test for parameter markers in function escapes.

testFloatValues
public void testFloatValues() throws Exception(Code)
	Tests that float (single precision - 32 bit) values are not converted to double (thus loosing precision).

testIllegalParameters
public void testIllegalParameters() throws Exception(Code)
	Test for bug [1111516 ] Illegal Parameters in PreparedStatement.

testLongStatement
public void testLongStatement() throws Exception(Code)
	Test for bug [1022968] Long SQL expression error. NB. Test must be run with TDS=7.0 to fail.

testManyParametersStatement
public void testManyParametersStatement() throws Exception(Code)
	Test for bug [1047330] prep statement with more than 2100 params fails.

testMaxRows
public void testMaxRows() throws SQLException(Code)
	Test for bug [1010660] 0.9-rc1 setMaxRows causes unlimited temp stored procedures. This test has to be run with logging enabled or while monitoring it with SQL Profiler to see whether the temporary stored procedure is executed or the SQL is executed directly.

testMetaData
public void testMetaData() throws Exception(Code)
	Test for bad truncation in prepared statements on metadata retrieval (patch [1076383] ResultSetMetaData for more complex statements for SQL Server).

testMetaDataClearsResultSet
public void testMetaDataClearsResultSet() throws Exception(Code)
	Test for bug [1050660] PreparedStatement.getMetaData() clears resultset.

testMissingWhitespace
public void testMissingWhitespace() throws Exception(Code)
	Test for bug [ 1059916 ] whitespace needed in preparedStatement.

testMultiThread
public void testMultiThread() throws Exception(Code)
	Test `Connection` concurrency by running `PreparedStatement`s and rollbacks at the same time to see whether handles are not lost in the process.

testNegativeScale
public void testNegativeScale() throws Exception(Code)

testNoPrepare
public void testNoPrepare() throws Exception(Code)
	Test that statements which cannot be prepared are remembered.

testOuterJoinParameters
public void testOuterJoinParameters() throws SQLException(Code)
	Test for bug [1071397] Error in prepared statement (parameters in outer join escapes are not recognized).

testPrepareFailWarning
public void testPrepareFailWarning() throws SQLException(Code)
	Test for bug [1180777] collation-related execption on update. If a statement prepare fails the statement should still be executed (unprepared) and a warning should be added to the connection (the prepare failed, this is a connection event even if it happened on statement execute).

testPrepareModes
public void testPrepareModes() throws Exception(Code)
	Test that preparedstatement logic copes with commit modes and database changes.

testPrepareSQL0
public void testPrepareSQL0() throws Exception(Code)
	Test for bug [1623668] Lost apostrophes in statement parameter values(prepareSQL=0)

testPreparedStatement
public void testPreparedStatement() throws Exception(Code)

testPreparedStatementAddBatch1
public void testPreparedStatementAddBatch1() throws Exception(Code)

testPreparedStatementParsing1
public void testPreparedStatementParsing1() throws Exception(Code)
	Test for [924030] EscapeProcesser problem with "{}" brackets

testPreparedStatementParsing2
public void testPreparedStatementParsing2() throws Exception(Code)
	Test for bug [1008882] Some queries with parameters cannot be executed with 0.9-rc1

testPreparedStatementParsing3
public void testPreparedStatementParsing3() throws Exception(Code)
	Test for "invalid parameter index" error.

testPreparedStatementRollback1
public void testPreparedStatementRollback1() throws Exception(Code)
	Test for [931090] ArrayIndexOutOfBoundsException in rollback()

testPreparedStatementSetObject1
public void testPreparedStatementSetObject1() throws Exception(Code)
	Test for bug [938494] setObject(i, o, NUMERIC/DECIMAL) cuts off decimal places

testPreparedStatementSetObject2
public void testPreparedStatementSetObject2() throws Exception(Code)
	Test for bug [938494] setObject(i, o, NUMERIC/DECIMAL) cuts off decimal places

testPreparedStatementSetObject3
public void testPreparedStatementSetObject3() throws Exception(Code)
	Test for bug [938494] setObject(i, o, NUMERIC/DECIMAL) cuts off decimal places

testPreparedStatementSetObject4
public void testPreparedStatementSetObject4() throws Exception(Code)
	Test for bug [938494] setObject(i, o, NUMERIC/DECIMAL) cuts off decimal places

testPreparedStatementSetObject5
public void testPreparedStatementSetObject5() throws Exception(Code)
	Test for bug [938494] setObject(i, o, NUMERIC/DECIMAL) cuts off decimal places

testPreparedStatementSetObject6
public void testPreparedStatementSetObject6() throws Exception(Code)
	Test for bug [1204658] Conversion from Number to BigDecimal causes data corruption.

testScrollablePreparedStatement
public void testScrollablePreparedStatement() throws Exception(Code)

testUpdateCount1
public void testUpdateCount1() throws Exception(Code)
	Test for bug [985754] row count is always 0

Fields inherited from net.sourceforge.jtds.test.TestBase

Connection con(Code)(Java Doc)
final public static Properties props(Code)(Java Doc)

Methods inherited from net.sourceforge.jtds.test.TestBase

public void compareInputStreams(InputStream is1, InputStream is2) throws IOException(Code)(Java Doc)
public void compareReaders(Reader r1, Reader r2) throws IOException(Code)(Java Doc)
protected void connect() throws Exception(Code)(Java Doc)
public void dump(ResultSet rs) throws SQLException(Code)(Java Doc)
public void dumpRow(ResultSet rs) throws SQLException(Code)(Java Doc)
public Connection getConnection() throws Exception(Code)(Java Doc)
public Connection getConnection(Properties override) throws Exception(Code)(Java Doc)
public void makeObjects(Statement stmt, int count) throws SQLException(Code)(Java Doc)
protected void makeTestTables(Statement stmt) throws SQLException(Code)(Java Doc)
public void setUp() throws Exception(Code)(Java Doc)
public void tearDown() throws Exception(Code)(Java Doc)

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.