How to get OracleConnection in Oracle 12c WebLogic without specify IP weblogic server using Java Spring Framework









up vote
0
down vote

favorite












I have to deploy WAR to oracle 12c weblogic server and access it's datasource. but i will deploy it in several weblogic server with different IP. is there any way to get connection to weblogic datasource without specify ip of the weblogic itself? assuming that the WAR is deployed in the same weblogic server and needed to access it's datasouce specified in the weblogic?



i can get oracle connection but must specify the IP. here is my code :



try
String urlparam = "t3://101.102.103.104:7001";
String datasourceparam = "jdbc/devtest";

Hashtable env = new Hashtable();
env.put( Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory" );
env.put(Context.PROVIDER_URL, urlparam);

Context context=new InitialContext( env );
ds=(javax.sql.DataSource) context.lookup (datasourceparam);
conn=(OracleConnection) ds.getConnection();
System.out.println("Connection object details : " + conn);

catch(Exception ex)
ex.printStackTrace();



If i use this method, to deploy to 5 weblogic servers, i have to generate 5 different WAR with only different IP weblogic server.



Please help..










share|improve this question

























    up vote
    0
    down vote

    favorite












    I have to deploy WAR to oracle 12c weblogic server and access it's datasource. but i will deploy it in several weblogic server with different IP. is there any way to get connection to weblogic datasource without specify ip of the weblogic itself? assuming that the WAR is deployed in the same weblogic server and needed to access it's datasouce specified in the weblogic?



    i can get oracle connection but must specify the IP. here is my code :



    try
    String urlparam = "t3://101.102.103.104:7001";
    String datasourceparam = "jdbc/devtest";

    Hashtable env = new Hashtable();
    env.put( Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory" );
    env.put(Context.PROVIDER_URL, urlparam);

    Context context=new InitialContext( env );
    ds=(javax.sql.DataSource) context.lookup (datasourceparam);
    conn=(OracleConnection) ds.getConnection();
    System.out.println("Connection object details : " + conn);

    catch(Exception ex)
    ex.printStackTrace();



    If i use this method, to deploy to 5 weblogic servers, i have to generate 5 different WAR with only different IP weblogic server.



    Please help..










    share|improve this question























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I have to deploy WAR to oracle 12c weblogic server and access it's datasource. but i will deploy it in several weblogic server with different IP. is there any way to get connection to weblogic datasource without specify ip of the weblogic itself? assuming that the WAR is deployed in the same weblogic server and needed to access it's datasouce specified in the weblogic?



      i can get oracle connection but must specify the IP. here is my code :



      try
      String urlparam = "t3://101.102.103.104:7001";
      String datasourceparam = "jdbc/devtest";

      Hashtable env = new Hashtable();
      env.put( Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory" );
      env.put(Context.PROVIDER_URL, urlparam);

      Context context=new InitialContext( env );
      ds=(javax.sql.DataSource) context.lookup (datasourceparam);
      conn=(OracleConnection) ds.getConnection();
      System.out.println("Connection object details : " + conn);

      catch(Exception ex)
      ex.printStackTrace();



      If i use this method, to deploy to 5 weblogic servers, i have to generate 5 different WAR with only different IP weblogic server.



      Please help..










      share|improve this question













      I have to deploy WAR to oracle 12c weblogic server and access it's datasource. but i will deploy it in several weblogic server with different IP. is there any way to get connection to weblogic datasource without specify ip of the weblogic itself? assuming that the WAR is deployed in the same weblogic server and needed to access it's datasouce specified in the weblogic?



      i can get oracle connection but must specify the IP. here is my code :



      try
      String urlparam = "t3://101.102.103.104:7001";
      String datasourceparam = "jdbc/devtest";

      Hashtable env = new Hashtable();
      env.put( Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory" );
      env.put(Context.PROVIDER_URL, urlparam);

      Context context=new InitialContext( env );
      ds=(javax.sql.DataSource) context.lookup (datasourceparam);
      conn=(OracleConnection) ds.getConnection();
      System.out.println("Connection object details : " + conn);

      catch(Exception ex)
      ex.printStackTrace();



      If i use this method, to deploy to 5 weblogic servers, i have to generate 5 different WAR with only different IP weblogic server.



      Please help..







      java spring-mvc weblogic oracle12c






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 9 at 3:31









      Sudarsono Sung

      399




      399






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          It turns out that to look at it's own datasource, i mustn't include hashtable environment in my InitialContext. this way, it will get specified datasource in itself.



          try 
          String datasourceparam = "jdbc/devtest";

          Context context = new InitialContext();
          ds = (javax.sql.DataSource) context.lookup(datasourceparam);
          conn = (OracleConnection) ds.getConnection();
          catch (Exception ex)
          // handle the exception
          ex.printStackTrace();






          share|improve this answer




















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53219454%2fhow-to-get-oracleconnection-in-oracle-12c-weblogic-without-specify-ip-weblogic-s%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote













            It turns out that to look at it's own datasource, i mustn't include hashtable environment in my InitialContext. this way, it will get specified datasource in itself.



            try 
            String datasourceparam = "jdbc/devtest";

            Context context = new InitialContext();
            ds = (javax.sql.DataSource) context.lookup(datasourceparam);
            conn = (OracleConnection) ds.getConnection();
            catch (Exception ex)
            // handle the exception
            ex.printStackTrace();






            share|improve this answer
























              up vote
              0
              down vote













              It turns out that to look at it's own datasource, i mustn't include hashtable environment in my InitialContext. this way, it will get specified datasource in itself.



              try 
              String datasourceparam = "jdbc/devtest";

              Context context = new InitialContext();
              ds = (javax.sql.DataSource) context.lookup(datasourceparam);
              conn = (OracleConnection) ds.getConnection();
              catch (Exception ex)
              // handle the exception
              ex.printStackTrace();






              share|improve this answer






















                up vote
                0
                down vote










                up vote
                0
                down vote









                It turns out that to look at it's own datasource, i mustn't include hashtable environment in my InitialContext. this way, it will get specified datasource in itself.



                try 
                String datasourceparam = "jdbc/devtest";

                Context context = new InitialContext();
                ds = (javax.sql.DataSource) context.lookup(datasourceparam);
                conn = (OracleConnection) ds.getConnection();
                catch (Exception ex)
                // handle the exception
                ex.printStackTrace();






                share|improve this answer












                It turns out that to look at it's own datasource, i mustn't include hashtable environment in my InitialContext. this way, it will get specified datasource in itself.



                try 
                String datasourceparam = "jdbc/devtest";

                Context context = new InitialContext();
                ds = (javax.sql.DataSource) context.lookup(datasourceparam);
                conn = (OracleConnection) ds.getConnection();
                catch (Exception ex)
                // handle the exception
                ex.printStackTrace();







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 9 at 4:04









                Sudarsono Sung

                399




                399



























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53219454%2fhow-to-get-oracleconnection-in-oracle-12c-weblogic-without-specify-ip-weblogic-s%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    𛂒𛀶,𛀽𛀑𛂀𛃧𛂓𛀙𛃆𛃑𛃷𛂟𛁡𛀢𛀟𛁤𛂽𛁕𛁪𛂟𛂯,𛁞𛂧𛀴𛁄𛁠𛁼𛂿𛀤 𛂘,𛁺𛂾𛃭𛃭𛃵𛀺,𛂣𛃍𛂖𛃶 𛀸𛃀𛂖𛁶𛁏𛁚 𛂢𛂞 𛁰𛂆𛀔,𛁸𛀽𛁓𛃋𛂇𛃧𛀧𛃣𛂐𛃇,𛂂𛃻𛃲𛁬𛃞𛀧𛃃𛀅 𛂭𛁠𛁡𛃇𛀷𛃓𛁥,𛁙𛁘𛁞𛃸𛁸𛃣𛁜,𛂛,𛃿,𛁯𛂘𛂌𛃛𛁱𛃌𛂈𛂇 𛁊𛃲,𛀕𛃴𛀜 𛀶𛂆𛀶𛃟𛂉𛀣,𛂐𛁞𛁾 𛁷𛂑𛁳𛂯𛀬𛃅,𛃶𛁼

                    Edmonton

                    Crossroads (UK TV series)