2 Replies Latest reply: Jul 19, 2013 8:31 AM by xin1008396 RSS

    How to set JDBC Data Sources in Oracle MapViewer for Oracle database 12c Release 1 (12.1.0.1)

    xin1008396

      How to set JDBC Data Sources in Oracle MapViewer for Oracle database 12c Release 1 (12.1.0.1)?

       

      The following is my configuration in the conf\mapViewerConfig.xml:


      <map_data_source name="mvdemo12"

      jdbc_host="127.0.0.1"

      jdbc_sid="orcl12c1"

      jdbc_port="1522"

      jdbc_user="mvdemo"

      jdbc_password="7OVl2rJ+hOYxG5T3vKJQb+hW4NPgy9EN"

      jdbc_mode="thin"

      number_of_mappers="3"

      allow_jdbc_theme_based_foi="true"

      editable="true"/>

      <!--  ****  -->

       

      But it does not work.

       

      After use "sqlplus mvdemo/mvdemo@127.0.0.1:1522/pdborcl", it connected to the Oracle database 12c.

       

      Does anyone know it?

       

      Thanks,

        • 1. Re: How to set JDBC Data Sources in Oracle MapViewer for Oracle database 12c Release 1 (12.1.0.1)
          jsharma-Oracle

          For 11.1.1.7.1 use the syntax for jdbc_sid, i.e.

          //mypdb1.foo.com as described in the README,

          - MapViewer native (non-container) data sources can now use database service name in place of SID. To supply a db service name, you will use the same jdbc_sid attribute, but specify the service name with double slashes in front, such as follows:

            <map_data_source name="myds"

              jdbc_host="foo.com"

              jdbc_sid="//mypdb1.foo.com"

              jdbc_port="1522"

              ... ...

            />

           

          For 11.1.1.7.0 use a container_ds instead.

          i.e. instead of using

          <map_data_source name="my_12c_test"

                             jdbc_host="mydbinstance"

                             jdbc_sid="pdborcl12c"

                             jdbc_port="1522"

                             jdbc_user="mytestuser"

                             jdbc_password="m2E7T48U3LfRjKwR0YFETQcjNb4gCMLG8/X0KWjO00Q="

                             jdbc_mode="thin"

                             number_of_mappers="6"

                             allow_jdbc_theme_based_foi="false"

                             editable="false"

             />

          use

            <map_data_source name="my_12c_test"

                             container_ds="jdbc/db12c"

                             number_of_mappers="6"

                             allow_jdbc_theme_based_foi="false"

                             editable="false"

             />

          In my case the Glassfish 3.1.2.2 JDBC connection pool definition was

          Property

          url  jdbc:oracle:thin:@mydbinstance:1522/pdborcl12c.rest_of.service.name

          Uncheck the Wrap JDBC Objects option in Advanced panel, i.e. the Edit JDBC Connection Pool Advanced properties page.

           

          Add a JDBC resource for that newly created pool

          Use that in mapviewerconfig.xml as above

          • 2. Re: How to set JDBC Data Sources in Oracle MapViewer for Oracle database 12c Release 1 (12.1.0.1)
            xin1008396

            Jsharma,

             

            Thank you very much!

             

            the best of luck with you!

             

            thank,