[ajug-members] Hibernate Insert/Update failing

[Narendra Kharya]

form the logs it looks like hibernate issues insert/update statements in 
batch, even though it has to execute one insert/update statement it will 
execute in batch.

I have not used hibernate a lot with oracle, but one who is using can 
comment on this,
1. is there some settings on oracle which govern whether batch can be issued 
or not?
2. is there some way in hibernate setting where it can be changed from batch 
mode to non batch mode.

thanks,

Narendra B Kharya
617-501-2045(cell)




From: Balu <ttrbalu at yahoo.com>
Reply-To: "General AJUG membership forum (100-200 
messages/month)"<ajug-members at ajug.org>
To: "General AJUG membership forum (100-200 
messages/month)"<ajug-members at ajug.org>
Subject: Re: [ajug-members] Hibernate Insert/Update failing
Date: Fri, 11 Mar 2005 10:50:47 -0800 (PST)

Hi Barry,
Thanks for your reply.

I am using the same *.hbm.xml files on both
environments.The two environments are going to two
different database(s),but both are having same schema.
However both environments have oracle,but different
versions.
My development database is Oracle 9.2.0.4 where
hibernate works fine.
and my test environment database is Oracle 8.1.7.4

As soon as Hibernate issues insert/update statement it
throws a SQL error in my test environment....Do I need
to check init.ora settings?

If you want any further info I can provide..

Thanks
Balu

--- Barry Hawkins <barry at alltc.com> wrote:
 > -----BEGIN PGP SIGNED MESSAGE-----
 > Hash: SHA1
 >
 > Balu wrote:
 > | Hi
 > | I am using Hibernate/Websphere with oracle as
 > | Database.I am having problem with
 > Insert(s)/Update(s).
 > | I am getting the following error once hibernate
 > issues
 > | either insert/update
 > [...]
 > | I am having 2 different environments 1)Development
 > | where everything works fine,even insert and
 > updates
 > | 2)Test environment where hibernate select works
 > but
 > | not insert and updates
 > [...]
 > Balu,
 > ~    Without knowing about your database schema and
 > mapping files, my
 > guess would be an inconsistency with your .hbm.xml
 > files.  Are you sure
 > that the Hibernate mapping files between the two
 > environments are
 > identical?  Are they both going against the same
 > database?  If not, are
 > the schemata identical between the two databases?
 >
 > Regards,
 > - --
 > Barry Hawkins
 > All Things Computed
 > site: www.alltc.com
 > weblog: www.yepthatsme.com
 >
 > Registered Linux User #368650
 > -----BEGIN PGP SIGNATURE-----
 > Version: GnuPG v1.4.0 (GNU/Linux)
 >
 >
iD8DBQFCMcPa7bZ6kUftWZwRAjurAJ99rHJ8VOhIYlG6N5C3DEm93UnJEgCfUtw8
 > 1OnBubyK8xOMtwx2+hp5uEE=
 > =om65
 > -----END PGP SIGNATURE-----
 > _______________________________________________
 > ajug-members mailing list
 > ajug-members at ajug.org
 > http://www.ajug.org/mailman/listinfo/ajug-members
 >



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
_______________________________________________
ajug-members mailing list
ajug-members at ajug.org
http://www.ajug.org/mailman/listinfo/ajug-members