As I’m working in Java again. I’m having to reacquaint myself with various Java lanaguge features and libraries. <\/p>\n
It’s been a long time since I’ve had to use JDBC, but here’s a snippet of code to demonstrate a accessing an Oracle LDAP datasource.<\/p>\n
\r\n\/\/ import java.sql.*;\r\n\r\nProperties connectionProps = new Properties();\r\nconnectionProps.put("user", "YOUR_USER_NAME");\r\nconnectionProps.put("password", "YOUR_PASSWORD");\r\n\r\nConnection conn = DriverManager.getConnection(\r\n "jdbc:oracle:thin:@ldap:\/\/SOME_URL:SOME_PORT\/,cn=OracleContext,dc=putridparrot,dc=com",\r\n connectionProps);\r\n\r\nStatement statement = conn.createStatement();\r\nResultSet rs = statement.executeQuery("select id, blob from SOME_TABLE");\r\n\r\nwhile(rs.next()) {\r\n String id = rs.getString(1);\r\n String blob = rs.getString(2);\r\n \/\/ do something with the results\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"As I’m working in Java again. I’m having to reacquaint myself with various Java lanaguge features and libraries. It’s been a long time since I’ve had to use JDBC, but here’s a snippet of code to demonstrate a accessing an Oracle LDAP datasource. \/\/ import java.sql.*; Properties connectionProps = new Properties(); connectionProps.put("user", "YOUR_USER_NAME"); connectionProps.put("password", "YOUR_PASSWORD"); […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[161,216],"tags":[],"class_list":["post-6229","post","type-post","status-publish","format-standard","hentry","category-java","category-jdbc"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/6229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=6229"}],"version-history":[{"count":3,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/6229\/revisions"}],"predecessor-version":[{"id":6239,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/6229\/revisions\/6239"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=6229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=6229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=6229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}