Are there plans to upgrade BigIP LTM jdbc to a newer version?
Context: We recently ran into issues while setting up a health check on an LTM against a recently built Oracle 19c instance. Such health check was failing to return the expected result, in particular returning a dreaded "ora-01017 invalid username/password" error. After an unsuccessful attempt to get this fixed with support, our DBA came to notice the Oracle 19c password hash for our user/password on the database was not set to allow older versions than Oracle 11g. This was fixed, precisely, by updating the user configuration and allowing it to use the password hash equivalent to an Oracle 10g version. We would like to know if there is any roadmap to upgrade the jdbc version to a newer one. This is what our -recently- upgraded BigIP LTM shows: [root@BigIP-P:Active:In Sync] lib # /usr/java/java-1.7.0-openjdk/bin/java -jar /usr/share/monitors/ojdbc6.jar Oracle 11.2.0.1.0 JDBC 4.0 compiled with JDK6 root@(BigIP-P)(cfg-sync In Sync)(Active)(/Common)(tmos)# show /sys version Sys::Version Main Package Product BIG-IP Version 15.1.0.2 Build 0.0.9 Edition Point Release 2 Date Fri Mar 20 21:06:24 PDT 2020 Otherwise, is there any possibility to upgrade it without having support issues?
Oracle JDBC SSL Termination failing on F5
We have created a new f5 VIP to terminate SSL and redirect the traffic to backend Oracle Database and the client is java application. We have configured the certificate using *.pfx file in f5 VIP, the same is used at client side to configure jks file to access. We have configure keystore and truststore on client side while accessing the VIP. But F5 is keep on complaining that the request received at f5 is not SSL Error in f5: cat ltm | grep Mar 17 13:15:46 abc.net warning tmm[11711]: 01260009:4: 10.0.0.0:58857 -> 10.0.0.0:8443: Connection error: ssl_passthru:5935: alert(40) not SSL Java code accessing F5 vip String jdbcUrl = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=F5ENDPOINT.net)(PORT=8443))(CONNECT_DATA=(SERVICE_NAME=ABC)))"; System.setProperty("javax.net.ssl.keyStore", "C:\\Apps\\rspt\\keystore.jks"); System.setProperty("javax.net.ssl.keyStoreType", "JKS"); System.setProperty("javax.net.ssl.keyStorePassword", "changeit"); System.setProperty("javax.net.ssl.trustStore", "C:\\Apps\\rspt\\trustStore.jks"); System.setProperty("javax.net.ssl.trustStoreType", "JKS"); System.setProperty("javax.net.ssl.trustStorePassword", "changeit"); Properties props = new Properties(); props.setProperty("user", userName); props.setProperty("password", password); props.setProperty("javax.net.ssl.keyStore", "C:\\Apps\\rspt\\keystore.jks"); props.setProperty("javax.net.ssl.keyStorePassword","changeit"); props.setProperty("javax.net.ssl.trustStore", "C:\\Apps\\rspt\\trustStore.jks"); props.setProperty("javax.net.ssl.trustStorePassword","changeit"); String query = "SELECT name FROM department WHERE departmentid= 1"; try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); con = DriverManager.getConnection(jdbcUrl,props); Statement statement = con.createStatement(); // Execute the query and obtain the result set ResultSet resultSet = statement.executeQuery(query); while (resultSet.next()) { String name = resultSet.getString("name"); System.out.println(" Name: " + name); } } catch (SQLException e) { e.printStackTrace(); } We have tried this with 80 PORT AND tcp as protocol in jdbc connection string and its working as expected. Only when we enable SSL termination on 8443, we have this issue. Can you guide what we are missing here ?