Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change the JDBC driver?

915091Jul 17 2013 — edited Jul 17 2013

Hello,

we're working with the JDev 11.1.2.3.0 and since the new 12c driver is released we wanted to create a POC with some of the new features of the 12c JDBC driver. However, when i replace the jdbc driver in the path ../middleware/welsserver_10.3/server/lib of the Integrated Weblogic with the new one. I can not connect with the database anymore in the JDeveloper. I get an error like NoSuchFieldError in o.jdbc.driver.T4CConnection:1318 or Test failed: thinJndiLdapConnectTimeout when I test the connection settings.


So I assume it's not enought to just change the jar in this directory. What else do I have to do so that I could test some of the new feature?

Thanks in advance.

Comments

John O'Toole
Hi,

The sdo_gtype of your sample geometry is 3002 which suggests you are storing x, y, z values. i.e. heights in the z.
Based on your explanation of the data, it sounds like you should be using Linear Referencing - read about it here (
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_lrs_concepts.htm#BABIIFFH).
Note that use of Linear Referencing requires an Oracle Spatial license - Locator is not enough.

SDO_LRS has a variety of functions/operators which will help you achieve your goal.
E.g. SDO_LRS.LOCATE_PT
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_lrs_ref.htm#i85478

John
1 person found this helpful
1013173
Hi,

Thanks for the tip.
I used the LOCATE_PT function with the SDO_UTIL.GETVERTICES function and it works.

My query is (for hisghway id = '1000' and km = 5000):

select li.*, t.*
from HIGHWAYS li , table( sdo_util.getvertices( SDO_LRS.LOCATE_PT( li.geom, 5000 ) )) t
where li.id = '1000'
;
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 14 2013
Added on Jul 17 2013
#11g, #12c, #application-development-in-java, #jdbc, #jdeveloper-and-adf
4 comments
753 views