This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, we are using Lightspeed(version 3.0.789.12667) to do our mapping to an Oracle DB. We have a table column that is of type XMLType. What Data type do I need to specify in my Lightspeed model for that column? So far I tried String and Blob but both raise an exception when I try to save the entity to the DB. Thanks Susan |
|
|
|
|
String works for me when saving. I do, however, get an error when loading, but this seems to be an Oracle internal issue rather than a LightSpeed (the error occurs within the Oracle driver and reads "Unsupported Oracle data type USERDEFINED encountered," long before LightSpeed gets to the data). So it may be that my XML column is set up differently from yours. I used SYS.XMLTYPE with STORE AS BASICTYPE CLOB, and I was testing on Oracle 11g Express server with the 11.2 client. If you can't get string working for you then please provide a minimal repro including your Oracle CREATE TABLE statement and details of server and client Oracle versions, and we will investigate further. |
|
|
|
