Skip to Content
0
Former Member
Oct 19, 2006 at 01:02 AM

[SAP_Portals][Oracle JDBC Driver]This driver is locked for use with embedd

68 Views

Hi,

When upgrading from Portal patch sp13 tp sp18 we get the following error when trying to connect to a remote oracle or sql server database. This used to work previously.

[SAP_Portals][Oracle JDBC Driver]This driver is locked for use with embedded applications.

Previously JDBC drivers were under the library com.sap.datadirect. This no longer exists after the patch, the drivers are now under library com.sap.portal.jdbcdrivers. When including the new library in Visual Administrator under JDBC Connector we can start the datasources, but get the error above when ever we try and use them from an application.

This code used to work prior to the patch. Can someone please advise of a solution?

The code used to connect is below.

public Connection connect()

throws NamingException, SQLException {

Connection conn;

InitialContext ctx = new InitialContext();

DataSource ds = (DataSource) ctx.lookup("jdbc/applications/bms/datasource/cdms_ds");

conn = ds.getConnection();

return conn;

}

Thanks

Warren