Is �DataSource� connection type supported for Oracle database?

[Migrated From Jforum.net]

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]

Can I use DataSource connection to Oracle database?
[originally posted on jforum.net by rnikolova]

[Migrated From Jforum.net]

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]

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]

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]