-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Ray Tayek wrote:
> hi, just donwloaded mysql and connector/j. the driver seems to work fine > for simple stuff. but i can not get all of the tests to run ...
I actually get all of the tests to run (on every commit to the source repository, in fact). What error messages are the tests themselves producing?
looks like they are failing for a variety of reasons. maybe i forgot to do some basic part of the install? (my java code can connect and get some type info from the metadata).
thanks
failures:
../build-mysql-jdbc/junit/TEST-testsuite.perf.BasePerfTest.txt:
Testsuite: testsuite.perf.BasePerfTest Tests run: 1, Failures: 1, Errors: 0, Time elapsed: 4.085 sec
Testcase: warning took 0.039 sec
FAILED
No tests found in testsuite.perf.BasePerfTest
junit.framework.AssertionFailedError: No tests found in testsuite.perf.BasePerfTest
Testcase: warning
../build-mysql-jdbc/junit/TEST-testsuite.perf.LoadStorePerfTest.txt:
Testsuite: testsuite.perf.LoadStorePerfTest
Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 741.556 sec
------------- Standard Output ---------------
jdbc:mysql:///test?user=root&password=opencms ****************************
Warm-up period (10 iterations)..........
Warm-up period ends
23801.636363636364 mean value, 1256.2030288081528 stddev, , Margin Of Error=833.6495808772103 confidence level=7.3468818978610395
24082.833333333332 mean value, 1521.9498367408682 stddev, , Margin Of Error=957.3416321756698 confidence level=8.303929274664474
24118.153846153848 mean value, 1467.35218603777 stddev, , Margin Of Error=879.0557891688037 confidence level=7.587233084336467
24173.928571428572 mean value, 1428.2046904260965 stddev, , Margin Of Error=818.7545636307784 confidence level=7.029571239243855
24107.333333333332 mean value, 1402.095939022085 stddev, , Margin Of Error=771.4637990844715 confidence level=6.624879541838586
24054.5625 mean value, 1372.8719427148878 stddev, , Margin Of Error=727.6221296388906 confidence level=6.248169378369745
24009.352941176472 mean value, 1344.1021469050925 stddev, , Margin Of Error=687.8445005989606 confidence level=5.906147360401785
23970.666666666668 mean value, 1315.9354087492288 stddev, , Margin Of Error=651.6649647414264 confidence level=5.594819084218729
23936.947368421053 mean value, 1288.8019517808495 stddev, , Margin Of Error=618.8403356023222 confidence level=5.312273075418013
23901.75 mean value, 1265.5031361083227 stddev, , Margin Of Error=590.2860665429411 confidence level=5.067584807058515
23872.714285714286 mean value, 1241.812313970695 stddev, , Margin Of Error=563.6501795054226 confidence level=4.838742314335374
23842.68181818182 mean value, 1221.0419316142795 stddev, , Margin Of Error=539.9182281153151 confidence level=4.635585283555991
23816.869565217392 mean value, 1200.3240252512915 stddev, , Margin Of Error=517.8393770032742 confidence level=4.446240666817372
23794.541666666668 mean value, 1179.9201943057656 stddev, , Margin Of Error=497.11481507980966 confidence level=4.268261911173509
23780.36 mean value, 1158.1666850673957 stddev, , Margin Of Error=477.16467424776704 confidence level=4.095851840161131
23759.30769230769 mean value, 1140.5435873109861 stddev, , Margin Of Error=459.8840246169451 confidence level=3.947855124197291
23740.074074074073 mean value, 1123.5117539125695 stddev, , Margin Of Error=443.6833124744453 confidence level=3.809046098360691
23725.321428571428 mean value, 1105.9265686541319 stddev, , Margin Of Error=428.03297557326016 confidence level=3.6744492426832407
23710.655172413793 mean value, 1089.4592228878118 stddev, , Margin Of Error=413.7188350956124 confidence level=3.55149917035769
23696.866666666665 mean value, 1073.7182663788278 stddev, , Margin Of Error=400.2998726092975 confidence level=3.436261062761972
------------- ---------------- ---------------
Testcase: test1000Transactions took 737.301 sec
Caused an ERROR
30
java.lang.ArrayIndexOutOfBoundsException: 30
at testsuite.perf.BasePerfTest.getConfidenceLookup(Unknown Source)
at testsuite.perf.BasePerfTest.addResult(Unknown Source)
at testsuite.perf.LoadStorePerfTest.doOneIteration(Unknown Source)
at testsuite.perf.BasePerfTest.doIterations(Unknown Source)
at testsuite.perf.LoadStorePerfTest.test1000Transactions(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: test1000Transactions
../build-mysql-jdbc/junit/TEST-testsuite.perf.RetrievalPerfTest.txt:
Testsuite: testsuite.perf.RetrievalPerfTest Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 136.476 sec ------------- Standard Output --------------- jdbc:mysql:///test?user=root&password=opencms ****************************
HEAP Table Retrieval
Full test took: 43.475 seconds. Queries/second: 230.01725129384704 Rows/second: 18401.380103507763 Avg. Query Exec Time: 2.5853999999999475 ms Avg. Traversal Time: 1.75029999999984 ms jdbc:mysql:///test?user=root&password=opencms ****************************
Query Cache From Heap Retrieval
Full test took: 41.053 seconds. Queries/second: 243.5875575475605 Rows/second: 19487.00460380484 Avg. Query Exec Time: 2.3390999999998767 ms Avg. Traversal Time: 1.7543999999998399 ms jdbc:mysql:///test?user=root&password=opencms ****************************
MyIsam Retrieval
Full test took: 44.262 seconds. Queries/second: 225.92743210880664 Rows/second: 18074.194568704534 Avg. Query Exec Time: 2.7531000000001673 ms Avg. Traversal Time: 1.65959999999985 ms ------------- ---------------- ---------------
Testcase: testRetrievalHeap took 46.423 sec Testcase: testRetrievalCached took 41.301 sec Testcase: testRetrievalMyIsam took 44.564 sec
../build-mysql-jdbc/junit/TEST-testsuite.simple.BlobTest.txt:
Testsuite: testsuite.simple.BlobTest Tests run: 2, Failures: 0, Errors: 2, Time elapsed: 10.143 sec ------------- Standard Output --------------- jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** ------------- ---------------- ---------------
Testcase: testBytesInsert took 5.582 sec
Caused an ERROR
Connection.close() has already been called. Invalid operation in this state.
java.sql.SQLException: Connection.close() has already been called. Invalid operation in this state.
at com.mysql.jdbc.Connection.getMutex(Connection.java:1727)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1215)
at testsuite.simple.BlobTest.tearDown(Unknown Source)
Testcase: testBytesInsertTestcase: testByteStreamInsert took 0.288 sec
Caused an ERROR
Connection.close() has already been called. Invalid operation in this state.
java.sql.SQLException: Connection.close() has already been called. Invalid operation in this state.
at com.mysql.jdbc.Connection.getMutex(Connection.java:1727)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1215)
at testsuite.simple.BlobTest.tearDown(Unknown Source)
Testcase: testByteStreamInsert
../build-mysql-jdbc/junit/TEST-testsuite.simple.StatementsTest.txt:
Testsuite: testsuite.simple.StatementsTest Tests run: 9, Failures: 1, Errors: 0, Time elapsed: 8.519 sec ------------- Standard Output --------------- jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** 6 columns = 12 14 columns = 25 22 columns = 90 30 columns = 73 38 columns = 80 jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** jdbc:mysql:///test?user=root&password=opencms **************************** ------------- ---------------- ---------------
Testcase: testAccessorsAndMutators took 2.74 sec
Testcase: testSelectColumns took 0.491 sec
Testcase: testAutoIncrement took 0.172 sec
Testcase: testClose took 0.13 sec
Testcase: testInsert took 0.123 sec
FAILED
Exception thrown for unknown reason
junit.framework.AssertionFailedError: Exception thrown for unknown reason
at testsuite.simple.StatementsTest.testInsert(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testInsertTestcase: testPreparedStatement took 0.354 sec Testcase: testPreparedStatementBatch took 0.24 sec Testcase: testStubbed took 0.095 sec Testcase: testNulls took 0.153 sec
../build-mysql-jdbc/junit/TEST-testsuite.simple.DataSourceTest.txt:
Testsuite: testsuite.simple.DataSourceTest Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 6.882 sec ------------- Standard Output --------------- jdbc:mysql:///test?user=root&password=opencms **************************** ------------- ---------------- ---------------
Testcase: testDataSource took 2.69 sec
Caused an ERROR
Cannot instantiate class: com.sun.jndi.fscontext.RefFSContextFactory
javax.naming.NoInitialContextException: Cannot instantiate class: com.sun.jndi.fscontext.RefFSContextFactory. Root exception is java.lang.ClassNotFoundException: com.sun.jndi.fscontext.RefFSContextFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:217)
at com.sun.naming.internal.VersionHelper12.loadClass(VersionHelper12.java:42)
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:649)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:243)
at javax.naming.InitialContext.init(InitialContext.java:219)
at javax.naming.InitialContext.<init>(InitialContext.java:195)
at testsuite.simple.DataSourceTest.registerDataSource(Unknown Source)
at testsuite.simple.DataSourceTest.setUp(Unknown Source)
Testcase: testDataSource
../build-mysql-jdbc/junit/TEST-testsuite.simple.TimeTest.txt:
Testsuite: testsuite.simple.TimeTest Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 7.109 sec ------------- Standard Output --------------- jdbc:mysql:///test?user=root&password=opencms **************************** ------------- ---------------- ---------------
Testcase: testTimezone took 2.896 sec
Caused an ERROR
The server timezone value 'PDT' represents more than one timezone. You must configure either the server or client to use a more specifc timezone value if you want to enable timezone support. The timezones that 'PDTmaps to are: America/Los_Angeles, America/Juneau, America/Boise, America/Vancouver, America/Dawson_Creek, America/Inuvik, America/Whitehorse, America/Dawson, America/Tijuana
java.sql.SQLException: The server timezone value 'PDT' represents more than one timezone. You must configure either the server or client to use a more specifc timezone value if you want to enable timezone support. The timezones that 'PDTmaps to are: America/Los_Angeles, America/Juneau, America/Boise, America/Vancouver, America/Dawson_Creek, America/Inuvik, America/Whitehorse, America/Dawson, America/Tijuana
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:2379)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1578)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at testsuite.simple.TimeTest.testTimezone(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testTimezone
--- ray tayek http://tayek.com/ actively seeking mentoring or telecommuting work vice chair orange county java users group http://www.ocjug.org/ hate spam? http://samspade.org/ssw/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
