Java Doc for TimestampTest.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
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net 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.DatabaseTestCase
      net.sourceforge.jtds.test.TimestampTest

TimestampTest
public class TimestampTest extends DatabaseTestCase (Code)
test getting timestamps from the database.



Constructor Summary
public  TimestampTest(String name)
    

Method Summary
 Object[][]getDatatypes()
    
public  longgetTimeInMs(ResultSet rs)
     Java 1.3 Timestamp.getDate() does not add the nano seconds to the millisecond value returned.
public static  voidmain(String args)
    
public  voidtest1899Date()
     Test for bug [1234531] Dates before 01/01/1900 broken due to DateTime value markers.
public  voidtestBigint0000()
    
public  voidtestBlob0021()
    
public  voidtestConnection0038()
    
public  voidtestConnection0039()
    
public  voidtestDatetimeRounding1()
    
public  voidtestDatetimeRounding10()
    
public  voidtestDatetimeRounding2()
    
public  voidtestDatetimeRounding3()
    
public  voidtestDatetimeRounding4()
    
public  voidtestDatetimeRounding5()
    
public  voidtestDatetimeRounding6()
    
public  voidtestDatetimeRounding7()
    
public  voidtestDatetimeRounding8()
    
public  voidtestDatetimeRounding9()
    
public  voidtestDayOfWeek()
     Test for bug [1226210] {fn dayofweek()} depends on the language.
public  voidtestDecimalConversion0058()
    
public  voidtestEmptyResults0011()
    
public  voidtestEmptyResults0012()
    
public  voidtestEmptyResults0013()
    
public  voidtestErrors0036()
    
public  voidtestEscape(String sql, String expected)
    
public  voidtestEscapes0006()
    
public  voidtestForBrowse0014()
    
public  voidtestGetBoolean0025()
    
public  voidtestGetString()
     Test for bug [1235845] getTimestamp() returns illegal value after getString().
public  voidtestMetaData0046()
    
public  voidtestMissingParameter0016()
    
public  voidtestMultipleResults0015()
    
public  voidtestNestedStatements0022()
    
public  voidtestNestedStatements0026()
     SAfe Tests whether cursor-based statements still work ok when nested.
public  voidtestOutputParams()
    
public  voidtestPreparedStatement0007()
    
public  voidtestPreparedStatement0008()
    
public  voidtestPreparedStatement0009()
    
public  voidtestPreparedStatement0040()
    
public  voidtestPreparedStatement0041()
    
public  voidtestPreparedStatement0042()
    
public  voidtestPrimaryKeyFloat0023()
    
public  voidtestPrimaryKeyReal0024()
    
public  voidtestResultSet0043()
    
public  voidtestResultSet0044()
    
public  voidtestResultSet0045()
    
public  voidtestStatements0020()
    
public  voidtestTimestampRange()
     Test for bug [1040475] Possible bug when converting to and from datetime.

jTDS seems to accept dates outside the range accepted by SQL Server (i.e.

public  voidtestTimestampTimeZone()
     Test for bug [1036059] getTimestamp with Calendar applies tzone offset wrong way.
public  voidtestTimestamps0001()
    
public  voidtestTimestamps0004()
    
public  voidtestTimestamps0037()
    
public  voidtestTimestamps0047()
    
public  voidtestTimestamps0048()
    
public  voidtestTransactions0010()
    
public  voidtestWriteDate()
     Test that java.sql.Date objects are inserted and retrieved correctly (ie no time component).


Constructor Detail
TimestampTest
public TimestampTest(String name)(Code)




Method Detail
getDatatypes
Object[][] getDatatypes()(Code)



getTimeInMs
public long getTimeInMs(ResultSet rs) throws SQLException(Code)
Java 1.3 Timestamp.getDate() does not add the nano seconds to the millisecond value returned. This causes the timestamp tests to fail. If running under java 1.3 we add the nanos ourselves.
Parameters:
  rs - the result set returning the Timstamp value in column 1 the millisecond date value as a long.



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



test1899Date
public void test1899Date() throws Exception(Code)
Test for bug [1234531] Dates before 01/01/1900 broken due to DateTime value markers.



testBigint0000
public void testBigint0000() throws Exception(Code)



testBlob0021
public void testBlob0021() throws Exception(Code)



testConnection0038
public void testConnection0038() throws Exception(Code)



testConnection0039
public void testConnection0039() throws Exception(Code)



testDatetimeRounding1
public void testDatetimeRounding1() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding10
public void testDatetimeRounding10() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding2
public void testDatetimeRounding2() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding3
public void testDatetimeRounding3() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding4
public void testDatetimeRounding4() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding5
public void testDatetimeRounding5() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding6
public void testDatetimeRounding6() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding7
public void testDatetimeRounding7() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding8
public void testDatetimeRounding8() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDatetimeRounding9
public void testDatetimeRounding9() throws Exception(Code)
Test for bug [994916] datetime decoding in TdsData.java



testDayOfWeek
public void testDayOfWeek() throws Exception(Code)
Test for bug [1226210] {fn dayofweek()} depends on the language.



testDecimalConversion0058
public void testDecimalConversion0058() throws Exception(Code)



testEmptyResults0011
public void testEmptyResults0011() throws Exception(Code)



testEmptyResults0012
public void testEmptyResults0012() throws Exception(Code)



testEmptyResults0013
public void testEmptyResults0013() throws Exception(Code)



testErrors0036
public void testErrors0036() throws Exception(Code)



testEscape
public void testEscape(String sql, String expected) throws Exception(Code)



testEscapes0006
public void testEscapes0006() throws Exception(Code)



testForBrowse0014
public void testForBrowse0014() throws Exception(Code)



testGetBoolean0025
public void testGetBoolean0025() throws Exception(Code)



testGetString
public void testGetString() throws SQLException(Code)
Test for bug [1235845] getTimestamp() returns illegal value after getString().



testMetaData0046
public void testMetaData0046() throws Exception(Code)



testMissingParameter0016
public void testMissingParameter0016() throws Exception(Code)



testMultipleResults0015
public void testMultipleResults0015() throws Exception(Code)



testNestedStatements0022
public void testNestedStatements0022() throws Exception(Code)



testNestedStatements0026
public void testNestedStatements0026() throws Exception(Code)
SAfe Tests whether cursor-based statements still work ok when nested. Similar to testNestedStatements0022, which tests the same with plain (non-cursor-based) statements (and unfortunately fails).
throws:
  Exception - if an Exception occurs (very relevant, huh?)



testOutputParams
public void testOutputParams() throws Exception(Code)



testPreparedStatement0007
public void testPreparedStatement0007() throws Exception(Code)



testPreparedStatement0008
public void testPreparedStatement0008() throws Exception(Code)



testPreparedStatement0009
public void testPreparedStatement0009() throws Exception(Code)



testPreparedStatement0040
public void testPreparedStatement0040() throws Exception(Code)



testPreparedStatement0041
public void testPreparedStatement0041() throws Exception(Code)



testPreparedStatement0042
public void testPreparedStatement0042() throws Exception(Code)



testPrimaryKeyFloat0023
public void testPrimaryKeyFloat0023() throws Exception(Code)



testPrimaryKeyReal0024
public void testPrimaryKeyReal0024() throws Exception(Code)



testResultSet0043
public void testResultSet0043() throws Exception(Code)



testResultSet0044
public void testResultSet0044() throws Exception(Code)



testResultSet0045
public void testResultSet0045() throws Exception(Code)



testStatements0020
public void testStatements0020() throws Exception(Code)



testTimestampRange
public void testTimestampRange() throws SQLException(Code)
Test for bug [1040475] Possible bug when converting to and from datetime.

jTDS seems to accept dates outside the range accepted by SQL Server (i.e. 1753-9999).




testTimestampTimeZone
public void testTimestampTimeZone() throws SQLException(Code)
Test for bug [1036059] getTimestamp with Calendar applies tzone offset wrong way.



testTimestamps0001
public void testTimestamps0001() throws Exception(Code)



testTimestamps0004
public void testTimestamps0004() throws Exception(Code)



testTimestamps0037
public void testTimestamps0037() throws Exception(Code)



testTimestamps0047
public void testTimestamps0047() throws Exception(Code)



testTimestamps0048
public void testTimestamps0048() throws Exception(Code)



testTransactions0010
public void testTransactions0010() throws Exception(Code)



testWriteDate
public void testWriteDate() throws SQLException(Code)
Test that java.sql.Date objects are inserted and retrieved correctly (ie no time component).



Methods inherited from net.sourceforge.jtds.test.DatabaseTestCase
static int compareBytes(byte a1, byte a2)(Code)(Java Doc)
protected void dropFunction(String procname) throws SQLException(Code)(Java Doc)
protected void dropProcedure(String procname) throws SQLException(Code)(Java Doc)
protected void dropProcedure(Statement stmt, String procname) throws SQLException(Code)(Java Doc)
protected void dropTable(String tableName) throws SQLException(Code)(Java Doc)
protected String getLongString(int length)(Code)(Java Doc)
protected String getLongString(char ch)(Code)(Java Doc)
protected static int getType(Object o) throws SQLException(Code)(Java Doc)
protected static Map getTypemap()(Code)(Java Doc)

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
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.