Bug 180617 [Regression] Exception is thrown out when create a stored procedure data set [0703]
Description: Exception is thrown out when create a stored procedure data set Build number: 2.2.0.v20070403-0630 Steps to reproduce: 1. Add a data source, Driver:net.sourceforge.jtds.jdbc.Driver (v0.9) URL:jdbc:jtds:sqlserver://spmdb/gui, User:sa, Password:sa. 2. Add a data set, select data set type "SQL Stored Procedure Query", edit this data set "{call counterInT1(?)}". 3. Click "Finish". Expected result: No exception is thrown out. Actual result: Exception is thrown out. Error log: A BIRT exception occurred. Plug-in Provider:Eclipse.org Plug-in Name:BIRT Data Engine Plug-in ID:org.eclipse.birt.data Version:2.2.0.v20070401 Error Code:odaconsumer.CannotGetResultSetMetaData Error Message:Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: Parameter #1 has not been set.
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/CallStatement.java
logger.logp( java.util.logging.Level.FINE,
						CallStatement.class.getName( ),
						"prepare",
						"Query text can not be null." );
				throw new OdaException( "Query text can not be null." );
			}
			/*
			 * call the JDBC Connection.prepareCall(String) method to get the
			 * callableStatement
			 */
			procedureName = getProcedureName( command );
			this.callStat = conn.prepareCall( command );
			paramUtil = new SPParameterPositionUtil( command, '@' );
		}
		catch ( SQLException e )
		{
			throw new JDBCException( ResourceConstants.STATEMENT_CANNOT_PREPARE,
					e );
		}
	}
	
	/*
	 * @see org.eclipse.datatools.connectivity.oda.IQuery#setAppContext(java.lang.Object)
	 */
	public void setAppContext( Object context ) throws OdaException
	{
		if ( context instanceof Map )
		{
			parameterDefn = (IParameterMetaData) ( ( (Map) context ).get( "org.eclipse.birt.report.data.oda.jdbc.ParameterHints" ) );
		}