Blob NOT WORKING with ORACLE 9i

Classic Servoy
1

TESTED in 2.1 RC2

  1. The dataprovider is not recognized by SERVOY, it appears as Unkown in the “Define Dataproviders Window”. Even If I create them with this interface. At first it creates ok by Next time you open Servoy the dataprovider is Unkown for Servoy. In the data base the field is created correctly.

  2. If the record is created outside servoy, with a file in the blob field. With servoy IM-4m not able to load the blob with this method:

var success = application.writeFile(“c:/temp/servoy/testfile.doc”, mediaDataproviderfield);
if (!success)
{
plugins.dialogs.showInfoDialog( “”,“Error”,“ok”);
}

application.readFile(“c:/temp/servoy/testfile.doc”);

The result is that it actualy writes the file testfile.doc, but it is a 1k file and the original is a 126k file.

  1. IM-4m not able to write a blob into the field either. IM-4m doing the simple thing, right click on the mediaDataproviderfield and use load image. I get this error:

java.sql.SQLException: invalid column type

please help…

2

can you try with 21RC3? With 2.1rc3 and the latest Oracle JDBC driver I can’t reproduce this issue

3

Tested in rc3:

Point 1: BOLB’s still appears as “< unknown >”

Point 2: the code provided in this point actually wrote a 574KB file to disk.
The instrucation application.readFile(“c:/temp/servoy/testfile.doc”); has had absolutely no effect whatsoever but if I double click on the file if opens correctly. (I used a pdf to the the test).

Point 3: I can see the image loaded intot the field but when I try to save it (click outside the field) I get the same error.

I use the oracle driver classes12.jar and use an OCI connection.

If you are interested to test this directly againt my oracle 9i instance let me know.

4

On of my customers also had a problem when using a NCLOB field type. As far as I understood him, he was investigating which field type to use for larger texts that also handles characters like the Euro sign. He said that Servoy displays the field correctly but when entering data it never gets stored in the database.

So question 1: Does anybody have experience with ORACLE 10g; if yes, which field type is recommendable for large texts with special signs like the EURO.

If NCLOB is the answer, is that supported from Servoy?

Thanks
Patrick

5

I don’t have oracle10g but oracle9i should be the same in that regard.

Here are the definitions of the fields:

BLOB:
A binary large object. Maximum size is 4 gigabytes.

CLOB:
A character large object containing single-byte
characters. Both fixed-width and variable-width
character sets are supported, both using the CHAR
database character set. Maximum size is 4 gigabytes.

NCLOB:
A character large object containing unicode
characters. Both fixed-width and variable-width
character sets are supported, both using the NCHAR
database character set. Maximum size is 4 gigabytes.
Stores national character set data.

6

Thanks! I guess that means NCLOB is the right answer.

Then he told me that there were problems using Servoy 2.0 on Oracle 10g. Is that the case? Has anyone ever tried?

7

Apparently this is a driver issue.
You should use a thin connection to oracle and a driver named “classes12.jar” of 1,35 MB (1.417.242 bytes).

The driver I used was called “classes12.jar” but it size was smaller (1,07 MB).