This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Aug 30, 2012 7:42 AM by userBDBDMS RSS

Berkeley DB + Oracle Mobile Server

957451 Newbie
Currently Being Moderated
Hi,
sry for beeing such a noob but i am starting to develop an Android Application with a Database. So the first thought was to take the Oracle Database Mobile Server 11g because of the sync feature for databases right on the Android device.

I tried to install it. Then i found out that i need something like Weblogic or Glassfish to install the Oracle Database Mobile Server 11g.

My next Problem is the "Mobile Repository".
What do i need to set this up? Do i need Oracle Database 11g for this?

If i enter the information from the glassfish setup i allways get an Error "I/O - The network adapter could not establish connection". I tried everything like turning off the Firewall ect.
jdbc:oracle:thin:@//localhost:1521/domain1Service this is the string i use for connection

Please help me.
  • 1. Re: Berkeley DB + Oracle Mobile Server
    userBDBDMS Guru Moderator
    Currently Being Moderated
    please provide some details on what you are trying to do, and some contact information and we will contact you directly. Specific to your question, Database Mobile Server requires a client setup and a server side setup. On the server side you will need an Oracle database (10g or 11g are acceptable), and you will need an application server (Oracle Application Server, Glassfish, Weblogic).

    thanks
    mike
  • 2. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    hi thank you for your answer, my email should now be visible for you.

    so i am using windows7 ultimate
    On this pc i want to set up the Server with the database. In this database i want to store questions for a quiz. these questions sould be pushed all the android devices that install my android app. thats what i want to do.

    do i need a windows server or does this work with windows7?
    if yes on my Windows7 i need to install
    1. Oracle Database (10g or 11g)
    2. Application Server (Oracle Application Server, Glassfish, Weblogic,...)
    3. Oracle Database Mobile Server (in the setup i saw that i can choose berkeley db (bdb) here)

    are there any specific things i have to enter during the installation?

    and on the Android device i want to have a local database that updates for example all 5 minutes. i want to have an local database there because if the connection would be lost the application should still be working.however first i want to set up the serverside afterwards i follow these instructions http://docs.oracle.com/cd/E12095_01/doc.10303/e16214/sandroid.htm
  • 3. Re: Berkeley DB + Oracle Mobile Server
    userBDBDMS Guru Moderator
    Currently Being Moderated
    What version of Database Mobile Server do you have? Where did you get a copy of it? The answers below are for 11gR1 release.

    On the server side you need to run the Oracle database. This will work on a machine that is running Windows 7.
    On the client Android device, we support Android versions 2.2, 2.3, 3.1
    the application server we support iAS 10.1.3.5.0, Oracle WebLogic Server 11gR1 (10.3.5), Oracle GlassFish Server 3.1 or the opensource version of Glassfish
    On the client Android device is where BDB will run.

    Installation instructions are detailed in our documentation which comes bundled with the release. There are also sample bundled in with the release.
  • 4. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    My Server is now running

    Status          Hochgefahren
    Hochgefahren seit          23.08.2012 14.34 Uhr CEST
    Instanzname          orcl
    Version          11.2.0.1.0
    Host          localhost
    Listener          LISTENER_localhost

    i downloaded everything form the oracle website everywhere the latest version.



    1. so my server is running do i have to configure something or just install Oracle Weblogic 12c R1?
    sry but i want to make it step for step.

    2. i installed it at C:\app do i have to install the weblogic server in the same dir?
    or C:\Oracle\Middleware

    3. and afterwards i have to create a new domain. am i right? a Basic Weblogic Server Domain

    thank you very much.
  • 5. Re: Berkeley DB + Oracle Mobile Server
    userBDBDMS Guru Moderator
    Currently Being Moderated
    the oracle website often contains a few different versions and the only thing I can tell so far is you are using Oracle 11g (11.2).

    You can just install Weblogic. C:\app should be fine.

    You will need a compatible JDK - see doc for you specific case.

    standard domain is fine.


    thanks
    mike
  • 6. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    Weblogic 12c R1 (12.1.1) ~800mb
    Mobile Database 11g (11.1.0.0.0) ~1,2gb

    C:\Oracle\Middleware\user_projects\domains\base_domain>startWebLogic.cmd
    "\Java\jre7\lib\ext\QTJava.zip" kann syntaktisch an dieser Stelle nicht verarbeitet werden.

    i am getting this error if i want to start my admin server

    is this because of the wron jdk? where do i find which jdk fits?
    thank you
    jedi
  • 7. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    Weblogic 12c R1 (12.1.1) ~800mb
    Mobile Database 11g (11.1.0.0.0) ~1,2gb

    C:\Oracle\Middleware\user_projects\domains\base_domain>startWebLogic.cmd
    "\Java\jre7\lib\ext\QTJava.zip" kann syntaktisch an dieser Stelle nicht verarbeitet werden.

    i am getting this error if i want to start my admin server

    is this because of the wron jdk? where do i find which jdk fits?
    thank you
    jedi
  • 8. Re: Berkeley DB + Oracle Mobile Server
    userBDBDMS Guru Moderator
    Currently Being Moderated
    this looks like an issue in the weblogic domain. I would suggest you put a note on forum for weblogic and see what comes back there.
    It looks like you are running with JDK 1.7 but I cannot tell for sure. Have you tried JRocket_1.6?

    thanks
    mike
  • 9. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    okay i'll ask them maybe they know whats the problem


    so if it's running what do i have to do next?

    thank you
    greets from austria
    jedi
  • 10. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    hey :)
    all the parts are now running i cant believe it. i did a clean istall of my win7 and now it is working :)

    so my next question is
    how do i set berkley db as backend database?

    and hod can i connect to this database from android?

    thank you :)
  • 11. Re: Berkeley DB + Oracle Mobile Server
    userBDBDMS Guru Moderator
    Currently Being Moderated
    on the server side (backend) you can only configure the Oracle database.
    on the client side (device) you can put BDB there.
    You will need to deploy the BDB Android client.
    The correct way to deploy the BDB Android client is contained in the docs.


    thanks
    mike
  • 12. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    do you mean this or is there another doc?
    http://docs.oracle.com/cd/E22663_01/doc.11100/e22681/instsqlite.htm (edited now correct doc)

    thank you :)
  • 13. Re: Berkeley DB + Oracle Mobile Server
    userBDBDMS Guru Moderator
    Currently Being Moderated
    you had said in an earlier post that you were using DMS 11gR1 (11.1.0.0).
    The reference doc you listed is for 10.3.
    For the 10.3 version of the product, BDB cannot be used on an Android client.
    You should not mix doc versions for the product as things change from release
    to release.
    Please provide some additional contact information, like phone number and we
    can have someone contact you. If you prefer, I will give you my email and
    you can send this information direct to me.

    thanks
    mike
  • 14. Re: Berkeley DB + Oracle Mobile Server
    957451 Newbie
    Currently Being Moderated
    Hi sry i for posting the wrong link i updated it. now this should be correct.
    sure, if you want to we can also write emails.

    my app is now running on my device
    but what do i have to enter as ServerURL?

    my url to the oracle database 11g console?
    https://localhost:1158/em/console/logon/logon

    or weblogic url?
    http://localhost:7777/console/login/LoginForm.jsp

    thank you
1 2 Previous Next

Legend

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