On 12/16/21 21:47, Jiří Činčura wrote:
Sending binary to devel failed - Jiri if you still need it send me your
private email.
A.
Is that the msgLen in BlrFromMessage::buildBlr? Looking at the code
then the length for SQL_LONG should be 6 (4 + 2), isn't it?
Yes.
When you will send >1 message - pay attention that there is also
alignedMessageLength, which is 8 in this case.
For now I'm just trying to send one message. Baby steps.
But still no success. Can you maybe build Firebird with truck-load
(and I mean borderline masochistic amount) of logging around the
batching, so I can see at what point was something not as expected?
Both patch and fbclient.
Will print this way:
# ./isql -user sysdba -pas masterkey localhost:employee
Send: 00 00 00 01 00 00 00 13 00 00 00 03 00 00 00 24 00 00 00 08 65 6d
70 6c 6f 79 65 65 00 00 00 08 00 00 01 44 09 06 73 79 73 64 62 61 08 06
53 72 70 32 35 36 0a 18 53 72 70 32 35 36 2c 20 53 72 70 2c 20 4c 65 67
61 63 79 5f 41 75 74 68 07 ff 00 35 45 44 38 38 42 45 31 37 42 41 45 43
44 38 30 41 43 41 34 39 37 34 32 36 45 45 44 43 32 36 34 34 37 33 43 38
34 41 43 42 30 30 31 34 46 41 34 32 31 34 36 46 41 34 45 37 45 39 44 34
46 41 34 44 31 43 37 35 30 37 41 42 42 38 45 36 37 41 41 37 30 35 30 41
33 46 38 36 45 30 33 31 44 41 45 46 41 35 41 30 41 33 39 43 43 34 35 42
32 34 41 44 45 32 43 36 30 39 32 44 42 33 33 33 35 34 31 30 41 34 44 43
41 42 45 39 30 42 45 35 36 36 39 37 32 42 46 31 36 44 38 43 32 30 41 43
39 35 32 35 31 30 42 36 31 41 31 43 33 33 34 38 43 45 32 37 31 37 37 31
45 39 33 35 34 30 32 32 43 45 38 45 42 33 37 37 43 39 34 31 33 45 37 32
44 31 41 39 45 46 41 33 36 36 31 31 39 30 33 45 41 46 31 44 41 31 46 35
46 41 36 46 37 43 37 41 30 45 42 37 31 46 32 43 36 34 34 34 31 32 42 46
42 07 03 01 45 39 0b 04 01 00 00 00 01 04 72 6f 6f 74 04 04 66 62 73 33
06 00 00 00 00 0a 00 00 00 01 00 00 00 00 00 00 00 05 00 00 00 02 ff ff
80 0b 00 00 00 01 00 00 00 00 00 00 00 05 00 00 00 04 ff ff 80 0c 00 00
00 01 00 00 00 00 00 00 00 05 00 00 00 06 ff ff 80 0d 00 00 00 01 00 00
00 00 00 00 00 05 00 00 00 08 ff ff 80 0e 00 00 00 01 00 00 00 00 00 00
00 05 00 00 00 0a ff ff 80 0f 00 00 00 01 00 00 00 00 00 00 00 05 00 00
00 0c ff ff 80 10 00 00 00 01 00 00 00 00 00 00 00 05 00 00 00 0e ff ff
80 11 00 00 00 01 00 00 00 00 00 00 00 05 00 00 00 10
Send: 00 00 00 5c 00 00 00 3f 43 35 44 45 45 44 34 45 38 42 44 38 37 32
30 44 32 41 34 39 41 39 33 46 44 31 39 33 34 44 30 41 44 32 30 37 37 34
39 38 32 39 34 34 46 39 46 36 44 37 39 32 31 32 46 36 32 41 45 30 43 39
34 00 00 00 00 06 53 72 70 32 35 36 00 00 00 00 00 18 53 72 70 32 35 36
2c 20 53 72 70 2c 20 4c 65 67 61 63 79 5f 41 75 74 68 00 00 00 00
Send: 00 00 00 60 00 00 00 08 43 68 61 43 68 61 36 34 00 00 00 09 53 79
6d 6d 65 74 72 69 63 00 00 00
Send: 00 00 00 13 00 00 00 00 00 00 00 08 65 6d 70 6c 6f 79 65 65 00 00
00 ad 01 4a 3b 2f 75 73 72 2f 68 6f 6d 65 2f 66 69 72 65 62 69 72 64 2f
42 34 2e 30 2d 72 65 6c 65 61 73 65 2f 67 65 6e 2f 44 65 62 75 67 2f 66
69 72 65 62 69 72 64 2f 62 69 6e 2f 69 73 71 6c 50 1f 4c 49 2d 56 34 2e
30 2e 31 2e 32 36 38 39 2d 64 65 76 20 46 69 72 65 62 69 72 64 20 34 2e
30 3e 36 2f 75 73 72 2f 68 6f 6d 65 2f 66 69 72 65 62 69 72 64 2f 42 34
2e 30 2d 72 65 6c 65 61 73 65 2f 67 65 6e 2f 44 65 62 75 67 2f 66 69 72
65 62 69 72 64 2f 62 69 6e 4d 00 1c 06 73 79 73 64 62 61 3a 04 00 00 00
00 47 04 13 55 00 00 00 00 00
Send: 00 00 00 5b 00 00 00 01
Send: 00 00 00 28 00 00 00 00 00 00 00 00 00 00 00 06 20 21 3e 65 01 01
00 00 00 00 04 00
Send: 00 00 00 40 00 00 00 00 00 00 00 00 00 00 00 03 00 00 00 0f 53 45
54 20 54 52 41 4e 53 41 43 54 49 4f 4e 00 00 00 00 00 00 00 00 00
Send: 00 00 00 1d 00 00 00 00 00 00 00 05 01 09 0f 06 12 00 00 00
Send: 00 00 00 28 00 00 00 00 00 00 00 00 00 00 00 02 93 94 00 00 00 00
02 02
Database: localhost:employee, User: SYSDBA
SQL>
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
