On 03.10.2016 21:19, Mark Rotteveel wrote:
> 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.
Well, I really did not pay much attention to v.1 specific solutions. I
was sure nobody is using isc_spb_command_line except gbak...
>> 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.
OK, I will recheck services once more.
------------------------------------------------------------------------------
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
