Bug 201232 Stored procedure dataset doesn't work in SQLServer[07]
Description: Stored procedure dataset doesn't work in SQLServer[07] Build number: 2.2.1.v20070827-0630 Steps to reproduce: 1, New a jdbc sqlserver datasource 2, New a stored procedure dataset 3, Preview Expected result: Be able to retrieve the data from strord procedure Actual result: Excption occurs Error log: org.eclipse.birt.data.engine.core.DataException: Cannot execute the statement. SQL statement does not return a ResultSet object. SQL error #1: The executeQuery method must return a result set. at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:567) at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:494) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:338) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:767) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:217) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:157) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.populateRecords(ResultSetPreviewPage.java:537) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.access$2(ResultSetPreviewPage.java:530) at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:486) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1: The executeQuery method must return a result set.
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/CallStatement.java
if ( packagePattern.trim( ).length( ) > 0 )
					rs = metaData.getProcedureColumns( packagePattern,
							schemaList.get( i ).toString( ),
							procedureNamePattern,
							columnNamePattern );
				else
					rs = metaData.getProcedureColumns( cataLog,
							schemaList.get( i ).toString( ),
							procedureNamePattern,
							columnNamePattern );
				while ( rs.next( ) )
				{
					ParameterDefn p = new ParameterDefn( );
					p.setParamName( rs.getString( "COLUMN_NAME" ) );
					p.setParamInOutType( rs.getInt( "COLUMN_TYPE" ) );
					p.setParamType( rs.getInt( "DATA_TYPE" ) );
					p.setParamTypeName( rs.getString( "TYPE_NAME" ) );
					p.setPrecision( rs.getInt( "PRECISION" ) );
					p.setScale( rs.getInt( "SCALE" ) );
					p.setIsNullable( rs.getInt( "NULLABLE" ) );
					if ( p.getParamType( ) == Types.OTHER )
						correctParamType( p );
					if ( p.getParamInOutType( ) != 5 )
						paramMetaDataList.add( p );
				}
				rs.close( );
			}
		}
		catch ( SQLException e )
		{