This discussion is archived
13 Replies Latest reply: Aug 14, 2009 1:03 PM by 843849 RSS

Databases on CDC

843849 Newbie
Currently Being Moderated
Hi everybody,

I am wondering if it is possible to install a real relationnal database such SQLite for example on an CDC Application ?
Which is the best / fastest database ?

Thanks for all.

Regards,
  • 1. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi geoinf,

    I have my application for Windows Mobile (Creme JVM / CDC).

    I use thinlet (GUI api), and I use HSQLDB (database) in Windows Mobile.

    Its run fast and very stable.

    All my application, with more then 15 forms, and my database HSQLDB with 15 tables, get the 11 mb. of memory RAM in Windows Mobile..

    thanks,

    Fabio Pinheiro
    Brazil
  • 2. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi Fabio,
    Thanks for your answer.
    Are you using HSQLDB like a local database ? Do you use an abstraction level like Hibernate can do with J2SE Application ?

    Somebody has another Database / Solution ?

    I am trying to gather all information :)

    Thanks,
  • 3. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hello,

    I'm trying to use hsqldb on windows mobile but on a different jvm (using cvm) and i'm receiving the following error message: java.lang.SecurityException: Prohibited package name: java.sql.

    I was successful using NSIcom's jvm as well using the following code:

    Class.forName("org.hsqldb.jdbcDriver");
    Connection c = DriverManager.getConnection("jdbc:hsqldb:file:testdb", "sa", "");

    any idea as to why this error maybe occurring?

    any help is appreciated.
  • 4. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi t00f,

    In the begin, I try use Hibernate, but without success. Its very slow in my Windows Mobile.

    In my application WEB, I use Hibernate.... But in Windows Mobile I cant.

    In the moment, I use JDBC default.. its a little work, but very fast.

    thanks,
    Fabio
  • 5. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi Fabio Pinheiro

    Please send me the link to download Creme JVM and HSQLDB database for Windoes Mobile.
    And please send a your sample application code which will connect to HSQLDB database.
    I tried with Mysaifu JVM and Oracle 9i Lite database. But i got an error while connecting to Oracle 9i Lite database from my application in Windows Mobile.

    Thanks in advance.

    Regards,
    Selladurai M
    selladurai.mani@gmail.com
  • 6. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi,

    I want use the CrEme with JDBC of PostgreSQL

    Is this possible?

    --

    Ola Fabio Pinheiro diz pra mim se � possivel usar qualquer JDBC com o CrEme??


    Dario.
  • 7. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi,

    Where i find document for instalation HSQLDB in Windows Mobile?

    Thanks,

    Dario.
  • 8. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    No installation required. More info @ http://sourceforge.net/projects/hsqldb/

    HTH
  • 9. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi Selladurai.M,

    How wrappingduke says..

    Just referenced in your buikd path the hsqldb.jar.

    If you use NetBeans, The hsqldb.jar will send together with your jar.

    just.

    thanks,
    Fabio
  • 10. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Fala Dario,
    Ent�o, eu nunca usei o Postgree no windows mobile.

    Sei que o hsqldb � muito leve, e roda perfeitamente nas minhas aplicacoes comerciais, com uma boa quantia de dados.

    O acesso � normal,

    Class.forName("org.hsqldb.jdbcDriver");
    connection = DriverManager.getConnection("jdbc:hsqldb:file:Windows/db/dbSample", "sa", "");

    abra�o,
    F�bio
  • 11. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi!

    My DB is very large. Some Tables have more than 30000 registers.
    I tested db4o and when i search a register in 30000, it trows a OutOfMemory Exception.
    Does HSQLDB support this load? Do you kwon any DB that support this load?

    -----

    Ol�

    Eu tenho um banco de dados muito grande. Algumas tabelas tem mais de 30000 registros.
    Eu testei o db4o e quando realizei uma busca em 30000 registros ele estourou a mem�ria.
    HSQLDB suporta toda essa carga? Voc� conhece algum banco de dados que possa suportar?
  • 12. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi all,

    can I make a connection with a database (mysql) that is in a remote server (localhost for while) with an application running CDC + CrEme in my pc??

    if i make a connection with DriverManager like a normal connection they are describing in the lastest posts, but instead of the local connection i make a connection to the local that my mysql database is, it will work???

    Regards.

    FABIO

    se vc souber como conectar ao database da minha aplicacao web com a aplicacao CDC eu ficaria mto grato de informacoes, preciso pro meu tcc, obrigado,
    ou me mande um email com alguma informacao.. daveroxx at gmail dot com
  • 13. Re: Databases on CDC
    843849 Newbie
    Currently Being Moderated
    Hi t00f

    Finally, wich database did you choose to work on j2me cdc?? I have to do the same as you. I´m working with sun java toolkit 1.0 for cdc and sqlite but always I get this bug: "java.lang.SecurityException: Prohibited package name: java.sql". Can you tell me what was your solution?? Maybe I need a change.

    Thank you!!!