- 3,715,652 Users
- 2,242,820 Discussions
- 7,845,479 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 467 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 416 SQLcl
- 42 SQL Developer Data Modeler
- 184.8K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 8 DevOps
- 3K QA/Testing
- 247 Java
- 5 Java Learning Subscription
- 10 Database Connectivity
- 66 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 10 Español
- 1.9K Japanese
- 2 Portuguese
Support for advanced datatypes (Spatial, XMLType, JSON) with Managed Driver

Hi,
were using the Oracle database especially for the advanced features in the spatial areas. In the last years, other interchangeable dataformats like XMLTYPE and Json become more and more important also for us.
On the other side our client-software changes more and more to C#. We're using the Unmanaged-driver at the moment and are able to deal with Sptail by using the UDT-features at the moment. But sooner or later we will be forced to go forward to use the managed-driver, which does not seem to develop forward to support any of the mentioned datatypes.
Are there any plans to change this in the near future (and i mean near future, i asked the question about Spatial several years ago and nothing happend til now).?
Answers
-
Unfortunately, not in the near future. Porting UDTs to 100% managed code is a very big task.
Other ODP.NET Spatial customers have used well-known text to make the jump from unmanaged to managed ODP.NET.
-
Ok, but even if something is a very big task it needs to be done either at some point in time. Otherwise you will loose the strength of your product in my opinion.
And about WKT... That might work with small and few geometries. We have geometries with more than 100.000 vertices. That doesn't work for us. And we have business objects which consist of about 1000 records with such geometries. So even if it would work technically, it would be a performance nightmare.