[oss-changes] [ opensubsystems-Feature Requests-1347838 ] Run search tests for all databases and fi
Brought to you by:
bastafidli
Menu
▾
▴
[oss-changes] [ opensubsystems-Feature Requests-1347838 ] Run search tests for all databases and fix bugs if found
|
From: SourceForge.net <no...@so...> - 2008-08-18 07:00:04
|
Feature Requests item #1347838, was opened at 2005-11-03 18:48 Message generated for change (Settings changed) made by bastafidli You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=659216&aid=1347838&group_id=111437 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Search (Filter) Group: Short term >Status: Open Resolution: None Priority: 5 Private: No Submitted By: Julian Legeny (jlegeny) Assigned to: Julian Legeny (jlegeny) Summary: Run search tests for all databases and fix bugs if found Initial Comment: Run search tests for all databases and fix bugs if found ---------------------------------------------------------------------- Comment By: SourceForge Robot (sf-robot) Date: 2008-08-05 21:20 Message: Logged In: YES user_id=1312539 Originator: NO This Tracker item was closed automatically by the system. It was previously set to a Pending status, and the original submitter did not respond within 999 days (the time period specified by the administrator of this Tracker). ---------------------------------------------------------------------- Comment By: Julian Legeny (jlegeny) Date: 2005-11-09 20:35 Message: Logged In: YES user_id=1072486 There is occured following error for Sybase ASE tests (decribed closer in previous comment): java.lang.Exception: org.opensubsystems.core.error.OSSDatabaseAccessException: Failed to retrieve specified list of data objects from the database. at org.opensubsystems.patterns.listdata.persist.db.ListDatabaseFactoryTest.utilLoadTestsGet(ListDatabaseFactoryTest.java:665) at org.opensubsystems.patterns.listdata.persist.db.ListDatabaseFactoryTest.processLoadPagesFromFirstToLast(ListDatabaseFactoryTest.java:794) at org.opensubsystems.security.patterns.listdata.persist.db.SecureListDatabaseFactoryTest.testLoadPagesFromFirstToLastForMoreDomains(SecureListDatabaseFactoryTest.java:269) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.framework.TestSuite.runTest(TestSuite.java:208) at org.opensubsystems.core.persist.db.DatabaseTestSuite.runTest(DatabaseTestSuite.java:143) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) Caused by: org.opensubsystems.core.error.OSSDatabaseAccessException: Failed to retrieve specified list of data objects from the database. at org.opensubsystems.patterns.listdata.persist.db.SybaseListDatabaseUtils.getObjectList(SybaseListDatabaseUtils.java:235) at org.opensubsystems.security.persist.db.DomainDatabaseFactory.get(DomainDatabaseFactory.java:118) at org.opensubsystems.patterns.listdata.persist.db.ListDatabaseFactoryTest.utilLoadTestsGet(ListDatabaseFactoryTest.java:563) ... 24 more Caused by: java.sql.SQLException: SELECT INTO command not allowed within multi-statement transaction. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:625) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:372) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:675) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.opensubsystems.patterns.listdata.persist.db.SybaseListDatabaseUtils.getObjectList(SybaseListDatabaseUtils.java:136) ... 26 more ---------------------------------------------------------------------- Comment By: Julian Legeny (jlegeny) Date: 2005-11-09 20:32 Message: Logged In: YES user_id=1072486 IBM DB2 version 8.2.2 ... search tests passed OK Sybase ASE 12.5.2 GA ... search tests DON'T passed There is problem with running tests that executes SELECT INTO query within the stored procedure. It is failed while following code is called: selectStatement = cntConnection.prepareCall("EXEC GET_LIST ?, ?"); selectStatement.setInt(1, options.getEndPosition()); selectStatement.setString(2, query); rsQueryResults = selectStatement.executeQuery(); There is constructed query that inserts data into temporary table and this query is than send as parameter into the stored procedure, e.g: select BF_USER.LOGIN_NAME, BF_USER.FIRST_NAME, BF_USER.LAST_NAME, BF_USER.EMAIL, BF_USER.PHONE, BF_USER.LOGIN_ENABLED, BF_USER.MODIFICATION_DATE, convert(NUMERIC(10, 0), BF_USER.ID) as ID1, BF_USER.SUPER_USER, BF_USER.GUEST_ACCESS_ENABLED, rownum = identity(9) into #tempA from BF_USER where BF_USER.DOMAIN_ID=41 and BF_USER.ID NOT IN(334) order by BF_USER.LOGIN_NAME asc select * from #tempA where rownum between 6 and 15 order by rownum If we comment tests used this SELECT INTO temp table query, all other tests pass ok. Tests that use problematic query are following: class ListControllerTest ======================== - testGetNextPage - testGetNextPageKeepSelected - testGetPrevPage - testGetPrevPageKeepSelected - testGetExactPage - testGetExactPageKeepSelected - testGetSetFilter - testGetOrderDesc - testGetOrderDescKeepSelected - testGetOrderAsc - testGetOrderAscKeepSelected - testGetSetPageSize - testGetSetPageSizeKeepSelected - testGetShowList - testGetShowListKeepSelected - testGetShowListWithPresetSize - testGetShowListWithPresetSizeKeepSelected class ListDatabaseFactoryTest ============================= - testLoadPagesFromFirstToLast - testLoadPagesFromLastToFirst - testLoadPagesFromLastToFirstMoreSortableColumns - testLoadPagesRandom - testGet class SecureListDatabaseFactoryTest =================================== - testLoadPagesFromFirstToLastForMoreDomains - testLoadPagesFromLastToFirstForMoreDomains - testLoadPagesRandomForMoreDomains ---------------------------------------------------------------------- Comment By: Julian Legeny (jlegeny) Date: 2005-11-08 19:16 Message: Logged In: YES user_id=1072486 MS SQL Server 2000 ... search tests passed OK Oracle 9i ... search tests passed OK ---------------------------------------------------------------------- Comment By: Julian Legeny (jlegeny) Date: 2005-11-07 17:50 Message: Logged In: YES user_id=1072486 SAP DB ... security tests passed OK HSQL DB 1.8 ... security tests passed OK PostgreSQL 8.0.3 ... security tests passed OK MySQL v. 4.1.15 and v.5.0.15 ... security tests passed OK ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=659216&aid=1347838&group_id=111437 |
