{"id":5286,"date":"2012-07-18T20:43:34","date_gmt":"2012-07-19T01:43:34","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=5286"},"modified":"2012-08-25T22:46:47","modified_gmt":"2012-08-26T03:46:47","slug":"1z0-102-understanding-jdbc-and-configuring-data-sources","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=5286","title":{"rendered":"Understanding WebLogic 11g JDBC and Configuring Data Sources"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tConfigure a JDBC data source<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tData Source<\/a>\n\t\t\t<\/li>\n\t\t\t
    2. \n\t\t\t\tData Source Scope<\/a>\n\t\t\t<\/li>\n\t\t\t
    3. \n\t\t\t\tJDBC Drivers<\/a>\n\t\t\t<\/li>\n\t\t\t
    4. \n\t\t\t\tCreate Data Source with Admin Console<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    5. \n\t\tConfigure a connection pool<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tOverview<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tConfigure a Connection Pool<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      3. \n\t\tDescribe how data sources are used<\/a>\n\t<\/li>\n\t
      4. \n\t\tView the server JNDI tree via the admin console<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\tView JNDI Tree via WLST<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
        2. \n\t\tControl a data source (suspend \/ resume)<\/a>\n\t\t
            \n\t\t\t
          1. \n\t\t\t\tFixing Offline Data Source<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
          2. \n\t\tMonitor a data source via the admin console<\/a>\n\t\t
              \n\t\t\t
            1. \n\t\t\t\tMonitoring<\/a>\n\t\t\t<\/li>\n\t\t\t
            2. \n\t\t\t\tTesting<\/a>\n\t\t\t<\/li>\n<\/ol>\n<\/ol>\n<\/ol>\n<\/div>\n
               <\/div>\n

              << Previous<\/a><\/p>\n

              Configure a JDBC data source<\/h2><\/span>\n

              Data Source<\/h3><\/span>\n
              \"\"<\/a><\/h6><\/span>\n

              Data Source Scope<\/h3><\/span>\n

              * Each data source configuration or “module” is persisted as a separate XML document:
              \n– stored in config\/jdbc<\/em> directory
              \n– available to all applications in the domain
              \n* Application specific data sources are
              \n– configured in ear<\/em> archive
              \n– available to within the application<\/p>\n

              JDBC Drivers<\/h3><\/span>\n

              * Type 4 drivers are
              \n– all-Java<\/em> driver implementations
              \n– no need for client side configuration such as installing Oracle client application
              \n* Type 1 to 3 are mostly deprecated<\/p>\n

              Create Data Source with Admin Console<\/h3><\/span>\n

              * See this post<\/a><\/p>\n

              Configure a connection pool<\/h2><\/span>\n
              \"\"<\/a><\/h6><\/span>\n

              Overview<\/h3><\/span>\n

              * A connection pool
              \n– is a group of ready-to-use database connections
              \n– associated with a particular data source
              \n* Connection pools:
              \n– are created when WLS startup
              \n– can be administered using Admin Console
              \n– can be dynamically resized depending on usage<\/p>\n

              Configure a Connection Pool<\/h3><\/span>\n
              \"\"<\/a><\/h6><\/span>\n

              Describe how data sources are used<\/h2><\/span>\n
              \"\"<\/a><\/h6><\/span>\n

              View the server JNDI tree via the admin console<\/h2><\/span>\n
              \"\"<\/a><\/h6><\/span>\n
              \"\"<\/a><\/h6><\/span>\n

              View JNDI Tree via WLST<\/h3><\/span>\n
              \r\nconnect('weblogic', 'welcome1', 't3:\/\/wlbox:7001')\r\njndi()\r\nls()\r\n<\/pre>\n
              Control a data source (suspend \/ resume)<\/h2><\/span>\n
              \"\"<\/a><\/h6><\/span>\n
              Fixing Offline Data Source<\/h3><\/span>\n
              * Remove\/reattach to target:
              \n– Remove data source from target, save, activate
              \n– Reassign data source to target, save, activate<\/p>\n
              \"\"<\/a><\/h6><\/span>\n
              * Set Initial Capacity<\/p>\n
              \"\"<\/a><\/h6><\/span>\n
              – Set to 0 when starting WLS<\/p>\n
              \"\"<\/a><\/h6><\/span>\n
              – Set to 1 when database becomes available<\/p>\n
              \"\"<\/a><\/h6><\/span>\n
              Monitor a data source via the admin console<\/h2><\/span>\n
              Monitoring<\/h3><\/span>\n
              \"\"<\/a><\/h6><\/span>\n
              \"\"<\/a><\/h6><\/span>\n
              Testing<\/h3><\/span>\n
              \"\"<\/a><\/h6><\/span>\n
              Next <\/a>>><\/p>\n
              [mv_include id=’3268′]<\/p>\n","protected":false},"excerpt":{"rendered":"
              > [mv_include id=’3268′]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[107,104],"tags":[588,180,168,184],"class_list":["post-5286","post","type-post","status-publish","format-standard","hentry","category-certification","category-weblogic11g","tag-11g","tag-1z0-102","tag-admin","tag-jdbc"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-1ng","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/5286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5286"}],"version-history":[{"count":7,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/5286\/revisions"}],"predecessor-version":[{"id":5706,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/5286\/revisions\/5706"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}