Re: WO Equivalent of prepared statement
Re: WO Equivalent of prepared statement
- Subject: Re: WO Equivalent of prepared statement
- From: "Cheong Hee (Datasonic)" <email@hidden>
- Date: Tue, 28 Oct 2008 11:02:49 +0800
You should be able to obtain JDBC connection directly and do prepared
statement.
From what I know and may not be the right way, prepared statement needs
quite a bit works as compared to EOF.
You need to map the data to the column name properly, generate primay keys
etc. I probably did it the wrong way,
and I need to generate my own primary key for each raw data to insert into
db.
In EOF, the eo primary key table is created to primary keys. What you need
is much easier, as appreciate EOF more
when I did the prepared statement.
Message: 9
Date: Mon, 27 Oct 2008 19:16:45 -0700
From: Randy Wigginton <email@hidden>
Subject: Re: WO Equivalent of prepared statement
To: Kieran Kelleher <email@hidden>
Cc: WebObjects Mailing List <email@hidden>
Message-ID: <email@hidden>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Actually, these methods will not be as fast as a prepared statement;
they will require parsing, then preparation of an execution plan on
the part of the database. A prepared statement will allow the
database to only do the work it needs to, as values are passed to the
already prepared execution plan.
In a high volume environment, use of non-prepared statements is a very
bad idea. I have witnessed such usage take down a major site.
It looks like I can obtain a JDBC Context, and from that a JDBC
connection. From there I can create a prepared statement and do what
needs to be done.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden