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 register postgres JDBC driver and register postgis correctly in jdev

mkaatrJul 13 2012 — edited Jul 13 2012
Hi there guys...

This is my first time using postgis. I created a simple application that uses postgres JDBC driver, and was able to connect to postgres db successfully and query it. Later I added postgis library, and tried executing a query. I got the following error:


*<org.postgresql.util.PSQLException: ERROR: type "geoms" does not exist Where: compilation of PL/pgSQL function "dijkstra_sp" near line 6>*


I executed the same query in postgres query terminal : select id, gid from public.dijkstra_sp('roads',22,33)

and it worked perfectly fine.

So I think I am not registering the Postgres/PostGIS drivers correctly. Does anyone know how to register the drivers in jdeveloper?

Any advice is highly appreciated.

yours sincerely
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2012
Added on Jul 13 2012
#application-development-in-java, #jdeveloper, #jdeveloper-and-adf
3 comments
1,028 views