Hmm... everything looks good. I can't think of reason for Cayenne to
open multiple parallel connections, no matter whether you save 1 or
1000 records in this manner.
One more thing to try out (in addition to Cayenne upgrade)... Instead
of using MySQLAdapter, try switching to a generic JdbcAdapter in the
Modeler. MySQLAdapter has some table locking code for PK generation.
My version of MySQL (3.23.56) works fine with it, but maybe an older
version has some problems.
Andrus
On Monday, September 22, 2003, at 06:40 AM, G.Venu wrote:
> 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 - 18:15:52 EDT