• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: WO Equivalent of prepared statement
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: WO Equivalent of prepared statement
      • From: Guido Neitzer <email@hidden>
  • Prev by Date: Re: WO Equivalent of prepared statement
  • Next by Date: Re: WO Equivalent of prepared statement
  • Previous by thread: Re: WO Equivalent of prepared statement
  • Next by thread: Re: WO Equivalent of prepared statement
  • Index(es):
    • Date
    • Thread