On 3-10-2016 11:42, Alex Peshkoff wrote:
> On 01.10.2016 16:47, Mark Rotteveel wrote:
>> After upgrading to Firebird 3.0.1 a test that uses the services API to
>> obtain table statistics nows fails with an exception:
>>
>> unrecognized service parameter block; All services except for getting
>> server log require switches [SQLState:42000, ISC error code:335544562]
>>
>> This test, org.firebirdsql.management.TestFBStatisticsManager method
>> testGetTableStatistics works fine in 3.0.0 and earlier.
>>
>> The test itself is:
>>
>> statManager.getTableStatistics(new String[]{"TEST"});
>>
>> where getTableStatistics is:
>>
>> public void getTableStatistics(String[] tableNames) throws
>> SQLException {
>> // create space-separated list of tables
>> StringBuilder commandLine = new StringBuilder();
>> for (int i = 0; i < tableNames.length; i++) {
>> commandLine.append(tableNames[i]);
>> if (i < tableNames.length - 1)
>> commandLine.append(' ');
>> }
>>
>> try (FbService service = attachServiceManager()) {
>> ServiceRequestBuffer srb = createStatsSRB(service,
>> isc_spb_sts_table);
>> srb.addArgument(isc_spb_command_line, commandLine.toString());
>> executeServicesOperation(service, srb);
>> }
>> }
>>
>> Is the above doing something wrong (if so what?), or is this a regression?
>
> I hardly understand how could that work at all, why use services v.1
> isc_spb_command_line switch?
I didn't implement this, but it has been this way for over 10 years
(April 2006), and it works up to and including 3.0.0, and 3.0.1 breaks it.
> If you need >1 table just repeat isc_spb_sts_table tag as many times as
> you need:
>
> fbsvcmgr service_mgr action_db_stats dbname employee sts_table COUNTRY
> sts_table EMPLOYEE
I'll see if I can reimplement it that way, but I still think it is a
regression.
Mark
--
Mark Rotteveel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
