Forum OpenACS Q&A: Re: nsoracle error?

Collapse
10: Re: nsoracle error? (response to 1)
Posted by Abrantes Filho on
Well, I'm still working on this and I think I'm getting close to a solution. Now I could run all the "clob-test.tcl" page until its end, with only some problems.

I did this:

First, I got the newer sources of nsoracle from git (git://github.com/aolserver/nsoracle.gi) and compiled whit the instructions on openACS site.

Next, I have installed this newer nsoracle into my AOLserver install.

Then, I did all of tests again:

http://desenv.saudenaweb.com.br:84/nsoracle/table-test.tcl

http://desenv.saudenaweb.com.br:84/nsoracle/bind-test.tcl

http://desenv.saudenaweb.com.br:84/nsoracle/error-test.tcl

http://desenv.saudenaweb.com.br:84/nsoracle/clob-test.tcl

As before, the table-test, the bind-test and the error-test just finished without error.

But this time, the clob-test could be run, with just some errors (the clob-test with nsoracle 2.7 never gets to the end of test, but with the newer sources from git, the test could be run).

Now I need to figure out the erros (in red font) on the clob-test below:
http://desenv.saudenaweb.com.br:84/nsoracle/clob-test.tcl

Collapse
11: Re: nsoracle error? (response to 10)
Posted by Abrantes Filho on
Just another information:

The "ns_ora clob_dml_file" correctly inserted a small file as clob in the test table.

The problem is with "ns_ora clob_get_file": when selecting the clob and writing it to a return file, the resulting file have a binary charset, and so a diff between the original file and the retrurned file fails (should be equal).

The ORIGINAL file inserted on database (ns_ora clob_dml_file):

cat markd-small.txt
this is a small test file

file -i markd-small.txt
markd-small.txt: text/plain; charset=us-ascii

The RETURNED file (ns_ora clob_get_file):

cat markd-small.txt-back
this is a small test file

file -i markd-small.txt-back
markd-small.txt-back: text/plain; charset=binary

Now, aparently the problem is in ns_ora clob_get_file: it is writing a "binary" file insted of a "character" file.

Any ideas?