This discussion is archived
10 Replies Latest reply: Jan 18, 2013 6:48 AM by 985768 RSS

Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...

948635 Newbie
Currently Being Moderated
Hello there!

I installed the package of Examples for Oracle 11g and did everything correctly about the configuration process of the PhotoAlbum example for JSP, but when I searched for the file "PhotoAlbumDBInfo.jsp" - funnily, the main file to run the example - it strangely wasn't in the package located in <ORACLE_HOME>\ord\http\demo\jsp. Then, I'm not able to run the program without this file.

I tried to search it through the internet, but with no success.

Maybe was it corrupted during the instalation? Or there is some issue about the Oracle Examples updated?

Can someone point out how to solve this situation? If I could get this JSP file, would be great.

Thank you very much! I'm really needing this to start a customized work to my university using Oracle Multimedia.

Greetings from Brazil!
  • 1. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post details of exact OS and DB versions, along with a link to the document you are following for your install process.

    HTH
    Srini
  • 2. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    948635 Newbie
    Currently Being Moderated
    OS: Windows 7 Home Basic (x64)
    DB: Oracle Database 11g Release 2 (Microsoft Windows (x64))

    Examples: Downloaded "Oracle Database 11g Release 2 Examples" - win64_11gR2_examples.zip (511,617,421 bytes) (cksum - 4056829576)

    And I'm following this documentation: http://docs.oracle.com/cd/E18283_01/appdev.112/e10777/ch_phtalbapps.htm#insertedID3

    In the "readme" file located in "<ORACLE_HOME>ord/http/demo/jsp" it mentions about the PhotoAlbumDBInfo.jsp, which should be in the package, along with the others JSP files (PhotoAlbumEntryViewer.jsp, PohtoAlbum.jsp, etc.), but it's not there.

    Do you know how can I get this file? Can you send me it or download from somewhere?

    Thank you very much for your help!

    글 수정: 945632
  • 3. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    mannamal Explorer
    Currently Being Moderated
    Oracle Multimedia examples are available by following the instructions here:

    http://docs.oracle.com/cd/E11882_01/install.112/e17861/toc.htm#BABBIBJF
  • 4. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    945632 wrote:
    OS: Windows 7 Home Basic (x64)
    DB: Oracle Database 11g Release 2 (Microsoft Windows (x64))
    Pl be aware that Windows Home versions are not certified for Oracle installs - http://docs.oracle.com/cd/E11882_01/install.112/e24186/reqs.htm#CHDHGGFE - so things may or may not work as advertised.
    Examples: Downloaded "Oracle Database 11g Release 2 Examples" - win64_11gR2_examples.zip (511,617,421 bytes) (cksum - 4056829576)

    And I'm following this documentation: http://docs.oracle.com/cd/E18283_01/appdev.112/e10777/ch_phtalbapps.htm#insertedID3

    In the "readme" file located in "<ORACLE_HOME>ord/http/demo/jsp" it mentions about the PhotoAlbumDBInfo.jsp, which should be in the package, along with the others JSP files (PhotoAlbumEntryViewer.jsp, PohtoAlbum.jsp, etc.), but it's not there.

    Do you know how can I get this file? Can you send me it or download from somewhere?

    Thank you very much for your help!

    글 수정: 945632
    HTH
    Srini
  • 5. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    948635 Newbie
    Currently Being Moderated
    Is there a way to get this file through somewhere else? Can someone give me this through here?

    Although it's not certified for Windows Home, I'm not having any problems yet, but I know I'll need to build everything again in another operational system.

    It probably was an installation problem, right? The file surely must be in the package, then?

    Thanks for all the information!
  • 6. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Is there a reference to "PhotoAlbumDBInfo.jsp" in the README.txt file in "<ORACLE_HOME>\ord\http\demo\jsp" ? Can you pl post the reference here ?

    If not, where do you see the reference to "PhotoAlbumDBInfo.jsp" - it is not in http://docs.oracle.com/cd/E18283_01/appdev.112/e10777/ch_phtalbapps.htm#insertedID3

    HTH
    Srini
  • 7. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    948635 Newbie
    Currently Being Moderated
    Yes, there is. As follows:

    "[...]

    About the JSP Sample Application
    ================================

    The Oracle Multimedia JavaServer Pages (JSP) Photo Album sample application
    shows how to use the Oracle Multimedia Servlets and JSP Java Classes library
    to upload and retrieve multimedia data to and from a database. Users can
    access the JSPs to view the contents of the photo album (including thumbnail
    versions of each photograph), to view the full-size version of any
    photograph, and upload new photographs into the album.

    The Oracle Multimedia JSP Photo Album sample application contains the
    following files:

    PhotoAlbumDBInfo.jsp
    A JSP that displays an HTML form that prompts users to enter the database
    schema, password and the database connection string.

    Users can choose one of these options for the database connection string.

    Option 1. A JDBC OCI driver specifying a SQL*Net service name.
    This option works on all platforms where an Oracle Database
    client is installed.

    Option 2. A JDBC Thin driver specifying a host, port and Oracle
    database SID. This option works on all platforms and does not
    require an Oracle Database client.

    PhotoAlbumBean.java uses the input information to connect to the database,
    retrieve and upload photographs.

    PhotoAlbum.jsp
    A JSP that displays the contents of the photo album using an image
    tag <IMG SRC="PhotoAlbumMediaViewer.jsp?media=thumb&...> to display
    the thumbnail images.

    [...]"

    A friend of mine did the same installation and configuration on a Windows Ultimate (x64) and the file is also missing there. Could it be possible that the "Oracle Database 11g Release 2 Examples" do not have this file in the version that I mentioned? None has the file or it's not permitted to share this file through this forum?

    Thanks!

    Edited by: 945632 on 11/07/2012 17:33

    Edited by: 945632 on 11/07/2012 17:40
  • 8. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    948635 Newbie
    Currently Being Moderated
    I read the description, once again, about the "PhotoAlbumDBInfo.jsp" and realize it is a very simple form containing an username, password and connectionString.

    So I incremented manually the following variables:

    String username = "system", password = "******", connString = "jdbc:oracle:thin:@localhost:1521:ORCL";

    At line 63 of "PhotoAlbum.jsp" and changed a bit of the code to set these properties in the Java "PhotoAlbumBean."

    Now the code is running brilliantly in my NetBeans! This "PhotoAlbumDBInfo.jsp" is only used to post these variables to "PhotoAlbum.jsp". Since I put it "hard-coded" in "PhotoAlbum.jsp," the connection was succeeded and everything is working alright.

    But I'm still suspecting it is some misleading information in the README.txt file in the package. It truly seems that does not exist anywhere anymore - maybe some version issue?

    Anyway, thanks everyone for all the efforts!
  • 9. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Thanks for the update - I have reported the issue in the Documentation forum - Issue with Multimedia example CD documentation ?

    Feel free to add more detail or clarify if you wish

    Srini
  • 10. Re: Oracle Multimedia: PhotoAlbum Sample - PhotoAlbumDBInfo.jsp file missing...
    985768 Newbie
    Currently Being Moderated
    Hi, could you please describe a little more detailed what have you done to make it work?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points