search

fatty- / daisy-pipeline

Automatically exported from code.google.com/p/daisy-pipeline
0 stars 0 forks source link

Options and ports are limited to 255 character long values #371

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Provide an option with a string longer that 255 characters. For instance, 
supply the dtbook-to-zedai option zedai-filename with a really long filename

What is the expected output? What do you see instead?
The error printed to the console is:
Caused by: java.sql.SQLDataException: A truncation error was encountered trying 
to shrink VARCHAR 
'123456789012345678901234567890123456789012345678901234567890&' to length 255.

All ports and options values in the fwk DB probably has this 255 char 
limitation. This is mainly an issue for scripts that accept multiple files as 
input, as they are stored as a space separated string.

Original issue reported on code.google.com by josteinaj@gmail.com on 11 Dec 2013 at 12:27

GoogleCodeExporter commented 9 years ago 
What you think it would be an acceptable limitation? 512? 1024? I'd prefer
not use blobs for performance issues

Original comment by capitan....@gmail.com on 11 Dec 2013 at 12:33

GoogleCodeExporter commented 9 years ago 
I think we need a practically unlimited size.

The input book might contain 100+ content files, which would probably cause a 
10000+ long string.

Options for future scripts might allow you to provide prose to be inserted 
somewhere in the book.

Original comment by josteinaj@gmail.com on 11 Dec 2013 at 12:35

GoogleCodeExporter commented 9 years ago 
https://github.com/daisy-consortium/pipeline-framework/commit/e060ee025e872463ec
6ee9ecf853e52b4b1e02ce

Original comment by capitan....@gmail.com on 31 Jan 2014 at 5:28