Add third-party JDBC drivers on WebLogic
Oracle WebLogic data sources supports many databases types by default and also comes with some JDBC drivers for most of them. But, not very often, you are working with third-party databases (non-Oracle) and endup needing to download the JDBC drivers from the database provider and doing the setup on WebLogic by yourself. The steps are pretty simple, but some still have questions on how to do it and I will try to create a step-by-step guide on this post. In this example, the environment is Oracle WebLogic 12c running on a Mac OS X and doing the simulation of a Microsoft SQL Server JDBC Driver installation. To simulate the issue of a missing driver, try to create a new Data Source selecting the following parameters on a default installation: Database Type: MS SQL Server Database Driver: Microsoft’s SQL Server Driver (Type 4) Version: 2005 and later Complete the wizard with your database access information (host, port, username, passwor...