Re: problem with datanode.xml

From: G.Venu (venumadhav...2bsoftech.com)
Date: Mon Sep 22 2003 - 06:40:48 EDT

  • Next message: Mike Kienenberger: "Implementing Entity "restricting qualifier" in application?"

    hi Andrus,

    Thanks for the suggestions.I will upgrade to the Final build very soon.Meanwhile this is my insert code.If I am doing something wrong let me know.

    DataContext ctxt =BasicServletConfiguration.getDefaultContextrequest.getSession());

    Products prodadd = (Products)ctxt.createAndRegisterNewObject"Products");

    prodadd.setProductNameE(request.getParameter("prodnameE"));
    prodadd.setProductNameG(request.getParameter("prodnameG"));
    ...........
    ..........
    ..........

    ctxt.commitChanges();

    >Hi Venu,
    >
    >Yes the stack trace shows a problem with connection pool. Could you
    >please post java Cayenne code you use to insert the records? Also...
    >This is kind of a random suggestion, but anyway... There was a weird
    >bug with connection pool that only exposed itself with FireBird
    >database:
    >
    > http://objectstyle.org/cayenne/lists/cayenne-devel/2003/09/0045.html
    >
    >This was fixed in Cayenne 1.0 final. Could you try to upgrade from RC1
    >to 1.0 final and confirm that your problem persists.
    >
    >Thanks,
    >Andrus
    >
    >
    >On Sunday, September 21, 2003, at 08:33 PM, G.Venu wrote:
    >
    >>
    >> hi andrus,
    >>
    >> I still have the problem when i changed my datanode.xml.I added
    >> autoreconnet=true in my datanode.xml.My datanode.xml looks like this.
    >>
    >> <driver project-version="1.0" class="org.gjt.mm.mysql.Driver">
    >> <url value="jdbc:mysql://ip:port/databse?autoReconnect=true"/>
    >> <connectionPool min="1" max="10 />
    >> <login userName="venumadhav" password="venumadhav"/>
    >> </driver>
    >>
    >> With the above xml I can only add 10 records.The problem is not with
    >> the transactions but when i add records to the database.If i add more
    >> than the number of connections specified in datanode.xml i get the
    >> following server output error in the browser.I am using Mysql 3.1.4
    >> and Tomcat 4.1.12.
    >
    > 

    --
With regards,

    Venu
--

    This archive was generated by hypermail 2.0.0 : Mon Sep 22 2003 - 09:58:37 EDT