Re: JDBC vs Hibernate
- From: "Sandy" <a@xxxxx>
- Date: Fri, 9 Sep 2005 11:59:57 +0530
"Luke Webber" <luke@xxxxxxxxxxxxx> wrote in message
news:43212a1c$1_3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Sandy wrote:
> > "Luke Webber" <luke@xxxxxxxxxxxxx> wrote in message
> > news:4320df5f$1_3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> >>It really depends on a number of factors. Do you really want database
> >>indepence, or are you happy to stick with one DBMS? How complex is the
> >>SQL going to get? Do you need automatic dirty checking and optimistic
> >>locking?
> >
> > My application is fairly simple, its using one database only that will
never
> > change.
> > I just need to put the data in tables, thats all, no further SQL
queries.
> > and there are no objects which are mapping to two different tables (so i
> > don't need complex SQL logics)
> >
> > I feel JDBC is better (performance and development time wise) than
hibernate
> > in my case.
> >
> > Is there any other thing that i should consider before making the
> > decision.......
>
> I think you've answered your own question. JDBC is fine for your needs.
> No point in adding extra layers and increasing complexity.
>
> Luke
How about using OPENXML vs JDBC (performance wise)
I read somewhere that OPENXML is faster, (I have the XML file in memory
already, my application is generating an XML file)
Is it a better option than writing data Row by Row in tables.
So I can use it likle this
String exec =
"DECLARE @_hDoc int "+
"EXEC sp_xml_preparedocument @_hDoc OUTPUT, "+
"N'<ROOT> "+
" <DataSource Device=\"D1\" Community=\"PUBLIC\" > "+
" </DataSource> "+
"</ROOT>'" +
"INSERT DataSource SELECT * FROM OPENXML(@_hDoc,
N'/ROOT/DataSource') WITH DataSource "+
"EXEC sp_xml_removedocument @_hDoc";
Statement s = connection.createStatement();
.
- Follow-Ups:
- Re: JDBC vs Hibernate
- From: Luke Webber
- Re: JDBC vs Hibernate
- References:
- JDBC vs Hibernate
- From: Sandy
- Re: JDBC vs Hibernate
- From: Luke Webber
- Re: JDBC vs Hibernate
- From: Sandy
- Re: JDBC vs Hibernate
- From: Luke Webber
- JDBC vs Hibernate
- Prev by Date: Re: JDBC vs Hibernate
- Next by Date: Convert Japanese UTF8 to SJIS for Sybase
- Previous by thread: Re: JDBC vs Hibernate
- Next by thread: Re: JDBC vs Hibernate
- Index(es):
Relevant Pages
|
|
