Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


2
(click on this box to dismiss)

Can I deserialise OBJECT types using java.sql.SQLData?

From what I've learned here http://www.cubrid.org/questions/318023, I understand that CUBRID tables (classes) can have columns (attributes) of an OBJECT type, where the concrete OBJECT type is in fact another table (class). This can be visualised with the following query:

select class_name, attr_name, domain_class_name
from db_attribute 
where data_type = 'OBJECT';


Which outputs (for instance):

 class_name

attr_name

 domain_class_name

 db_serial

 owner   

 db_user


So in principle, it can be said that db_serial.owner is of type db_user. This resembles what Oracle does with UDT's but it seems to be much more powerful, because tables and UDTs are the same in CUBRID. Especially the fact, that db_user attributes can be dereferenced from db_serial.owner (e.g. db_serial.owner.name) looks very similar to Oracle.

Now, my question is:

In Oracle JDBC, UDT's can be deserialised using java.sql.SQLData (which is extended by org.jooq.UDTRecord, for instance). Can this be done in CUBRID, as well? When I deserialise db_serial.owner, I get the CUBRIDOID object. But in fact, I might be interested in a complete deserialisation of that db_user, using SQLData.

link comment (0) accepted answer
asked 2 years ago
lukaseder
63
66 Answers
2

This is currently not implemented in CUBRID. This seems to be a driver thing and adding support for it is possible but it's not implemented at the moment. The driver gets only OID's 

link comment (2)
answered 2 years ago
ginarrbrik
516




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: