發表文章

目前顯示的是 2016的文章

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, password) and try to  Test the Connection