• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

Is �DataSource� connection type supported for Oracle database?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When I try to use �DataSource� as a connection type on the Install.jsp page I get the following error:

java.sql.SQLException: Unsupported feature

Thanks,
Rossita
[originally posted on jforum.net by rnikolova]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Can I use DataSource connection to Oracle database?
[originally posted on jforum.net by rnikolova]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Looks like a problem with the Oracle JDBC Driver. You may try to replace the version which is in WEB-INF/lib

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks for the reply.

I don't have problem when using the connection URL for the thin client-side driver ojdbc14.jar. This java.sql.SQLException: Unsupported feature only happens if I select DataSource from the dropdown connection type values on the install.jsp page.
(I have created the DataSource and the jforum schema before running the install)

Rossita
[originally posted on jforum.net by rnikolova]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
One quick thought is that DataSource connections are handled at the web container level. You will need to make sure that the ODBC driver is available there. E.g., in Tomcat 5.5. it has to be in the common/lib directory.

Also, you may be having class loader security problems if you have the JDBC jar in the web apps lib directory and at the container level. E.g., the class is initially loaded at the server level and now your webapp is trying to make the server use a class from it's library. This is a security issue and most containers will deny it (generally in strange ways like class not found errors...)

Try removing the jdbc jar from the web app.
[originally posted on jforum.net by monroe]
 
WARNING! Do not activate jet boots indoors or you will see a tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic