In my last contribution, I have proposed a first version of Update and
Insert methods for impl.data.xml component.
One of the insert method limitations is that the table must only have
columns which types are char or varchar. However, I want to improve this,
allowing any sql primitive type.
The fact is, the syntax to insert a varchar, for example, is different to
insert a integer. So, it's necessary to know the types of the column.
I could resolve this problem in, at least, to different ways: First, I could
use metadata information on the InsertInvoker, and discover the types of
columns. Another way to do this, is to add the column type information in
the xml stream retrieved by the get method. So, we would have something like
this:
<resultSet>
<record>
<column name="NAME" type="VARCHAR">New Coorporation I</column>
<column name="PHONE" type="INTEGER">+5511990202146</column>
. . .
</record>
</resultSet>
I am not sure if other metadata informations should be added to the xml
stream. But, at the moment, I think that column type would be useful.
Thoughts?
--
Douglas Siqueira Leite
Computer Science Master's degree student of University of Campinas (Unicamp)
