Menu

#61 setup.sh creates incorrect Oracle 11 jdbc urls.

JobScheduler Setup
closed-fixed
nobody
install (1)
5
2015-05-18
2015-04-30
No

Using jobscheduler.1.9.0-RC1 and oracle 11G.
Doing headless install. The jdbc urls created are incorrect.
The following command corrects them; cd to the config directory.
sed -i "s/1521:/1521\//g" factory.ini hibernate.cfg.xml sos_settings.ini

Discussion

  • Andreas

    Andreas - 2015-05-03

    Sorry for this inconvenience.

    It seems that a similar problem addressed by JS-1025 is active. Pleaese watch JS-1368 for the resolution.

     
    • orientphoebus

      orientphoebus - 2015-07-07

      I am using 1.9.2, the installer generated url as this, after I put value in the "Database" box:
      jdbc:oracle:thin:@[HOST][:PORT][/SERVICE_NAME]
      It is missing the "//" after @, if it is considering what I input as a SERVICE_NAME.
      If it is considering it as a SID, shall it use ":" instead of "/"?

      Shall the installer GUI have an option to let people specify whether the input is SID or SERVICE_NAME? See attached screen shot.

       
  • Oliver Haufe

    Oliver Haufe - 2015-05-04

    The installer creates a JDBC url in the form

    jdbc:oracle:thin:@[HOST][:PORT][:SERVICE]

    That's not up-to-date for 11g. It should be

    jdbc:oracle:thin:@//[HOST][:PORT][/SERVICE]

     
  • Andreas

    Andreas - 2015-05-18
    • status: open --> closed-fixed
     
  • Andreas

    Andreas - 2015-05-18

    fixed with Release 1.9.1

     

Log in to post a comment.

MongoDB Logo MongoDB