Jan,
I didn't explicitly configure anything regarding transactions, as a matter of facts I don't remember to see anything about it in the generated files, so for now I have to things to do,
1.- Try with only session.flush() --> I belief this is been executed as a consequence of the call to session.close() in the SessionBean class
2.- Try to open a transaction and then close it.
I'll try this things out and let you know.
Are transactions somehow configured in the UML model or is it a matter of touching some properties in the project files?
Thanks a lot!
Diego Bendlin
PricewaterhouseCoopers - Advisory
Asunci�n - Paraguay
Phone : +595 21 445-003 ext. 1314
Mobile : +595 991 744-220
| Jan Heise <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 11/04/2005 10:41 a.m.
|
To: [EMAIL PROTECTED] cc: Diego Bendlin/PY/ABAS/[EMAIL PROTECTED], [email protected] Subject: Re: [Andromda-user] AndroMDA + Hibernate problem (Generated ID's) |
Hi Diego,
from my own experience: it sounds as if the transaction is not closed
correctly.
The call to the sequence is no indicator as this happens independent to
the
inserts. The inserts happen the moment, the transation is commited.
In standalone-apps I often have code like:
sess = sf.openSession();
tx = sess.beginTransaction();
...
sess.flush();
tx.commit();
sess.close();
Perhaps your session bean is not configured correctly in regard to
transactions?
hth,
Jan
Am 11.04.2005 um 16:22 schrieb Wouter Zoons:
> hello Diego,
>
> I'm using Hibernate (with Spring) at work, we're using three databases
> (not at the same time though) and they all work fine by just updating
> the properties you speak of
>
> these databases are PostgresQL, Hypersonic and Oracle9i
>
> unfortunately I have no idea what could be causing the problem you and
> Fabrice describe
>
> I would expect the SQL insert to be executed once the session is
> closed or flushed, right after getting the sequence.nextval
>
> perhaps someone else on the list has an idea, I don't think it's
> related to AndroMDA so you might have more luck on the hibernate
> forums
>
> hope you find it soon
>
> -- Wouter
>
> [EMAIL PROTECTED] wrote:
>> Hello Guys,
>> Im having some troubble using AndroMDA's hibernate cartridge, this
>> could also be a problem for spring cartridge since it's usin
>> hibernate to persist objects to a RDBMS.
>> Ok, im using AndroMDA 3.0-RC1 along with maven. So i generated a new
>> project like this : maven andromdapp:generate
>> For persistence I selected hibernate.
>> Well after that I created a new Poseidon project and merged the
>> andromda-profile into it.
>> After that i've modelled a few entities and session, and exceptions,
>> and value objects.
>> Then I modified the project properties to reflect the RDBMS setting
>> for my environment, I've tried this with to RDBMS and the results are
>> the same.
>> 1st) I've configured the project to use MaxDB
>> dataSource=java:/clubEC
>> sql.mappings=SapDB
>> hibernate.db.dialect=net.sf.hibernate.dialect.SAPDBDialect
>> 2nd)I've configured the project to use PostgreSQL
>> dataSource=java:/clubECPg
>> sql.mappings=SapDB
>> hibernate.db.dialect=net.sf.hibernate.dialect.SAPDBDialect
>> After Making the above configurations went to the project main dir
>> and run maven.
>> Well everythisn went just OK.
>> I deployed the app on JBoss. That server have two diferente
>> datasources 1 to connect to MaxDB and the other to use PostgreSQL.
>> I created a client app and tried to persist some data, here is the
>> SessionBean code (part of it)
>> protected boolean handleCrearRubro (net.sf.hibernate.Session
>> session, pwc.ce.vo.RubroVO rubro)
>> throws pwc.ce.ex.RubroEX
>> {
>> boolean ok=false;
>> System.out.println("Session: " + session + " " +
>> session.getSessionFactory());
>> Rubro rubrin = RubroFactory.create(rubro.getNombre());
>> System.out.println("Rubro: " + rubrin.getNombre() + " Id: " +
>> rubrin.getIdRubro());
>> try {
>> session.save(rubrin);
>> ok=true;
>> } catch (HibernateException e) {
>> e.printStackTrace();
>> }
>> return ok;
>> }
>> After invoking this method on the client and passing a Value Object
>> (rubro) I can see that the Deployed app calls a sequence on the
>> databases but no insert statement.
>> Just to try things out I inserted a few records manually on the
>> database and tried to recover the data using the findAll Mathod of
>> the session bean, and it works, I can recover data but can not save
>> it.
>> Skabeat allready found this problem and wrote an email, but nobody
>> answered to his question. I've pasted his mail bellow.
>> I've chaged the RDBMS from MaxDB to PostgreSQL because I've readed
>> that MAXDB isn't well supported by hibernate, but I got the same
>> problem with PostgreSQL, any clues?
>> Do I have to specify some tagged value to make this work???
>> Thanks in advance!
>> I hope that I just missed something thats really easy to fix :-)
>> Kind Regards,
>> Diego Bendlin
>> (Sorry for the extension, but Im triying to explain the issue as
>> clear as possible.)
>> ----- Forwarded by Diego Bendlin/PY/ABAS/PwC on 10/04/2005 05:59 p.m.
>> -----
>> *skabeat <[EMAIL PROTECTED]>*
>> Sent by: [EMAIL PROTECTED]
>> 25/03/2005 11:17 a.m.
>> To: andromda-user
>> <[email protected]>
>> cc: Subject: [Andromda-user] hibernate
>> cartridge problem
>> Hi,
>> I'm facing a strange problem with hibernate cartridge + postgresql :
>> I use the following code in a service method :
>> ...
>> {
>> UserImpl user = new UserImpl();
>> user.setLogin(login);
>> user.setPassword(password);
>> user.setCreatedDate(new Date());
>> user.setLastLoginTime(new Date());
>> try {
>> session.save(user);
>> } catch (HibernateException e) {
>> // TODO Auto-generated catch block
>> e.printStackTrace();
>> throw new OrganizationException(e);
>> }
>> return user;
>> }
>> the user object is not saved in the database. In the logs I can see
>> the :
>> Hibernate: select nextval ('hibernate_sequence')
>> which means that hibernate is getting the Id well. But I can't see a
>> "insert into.." and I don't have any insert in my pg database logs,
>> only
>> the select nextval ('hibernate_sequence').
>> "find" queries work well (ie "from UserImpl")
>> Any idea?
>> Thanks
>> Fabrice
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Andromda-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/andromda-user
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Andromda-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/andromda-user
_________________________________________________________________
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
