Groups > comp.lang.java.databases > #396

Re: Client_Multi_Result F

Path	csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From	"Zhane" <zhane@THRWHITE.remove-dii-this>
Subject	Re: Client_Multi_Result F
Message-ID	<96edcb85-5838-4564-a026-77c4aefd5873@t26g2000prh.googlegroups.com> (permalink)
X-Comment-To	comp.lang.java.databases
Newsgroups	comp.lang.java.databases
In-Reply-To	<nospam-9926B4.21002106122008@nntp.motzarell
References	<nospam-9926B4.21002106122008@nntp.motzarell
Content-Type	text/plain; charset=IBM437
Content-Transfer-Encoding	8bit
X-Gateway	time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines	50
Date	Wed, 27 Apr 2011 15:23:28 GMT
NNTP-Posting-Host	96.60.20.240
X-Complaints-To	news@tds.net
X-Trace	newsreading01.news.tds.net 1303917808 96.60.20.240 (Wed, 27 Apr 2011 10:23:28 CDT)
NNTP-Posting-Date	Wed, 27 Apr 2011 10:23:28 CDT
Organization	TDS.net
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:396

Show key headers only | View raw

  To: comp.lang.java.databases
On Dec 7, 10:00 am, "John B. Matthews" <nos...@nospam.com> wrote:
> In article
> <ed1abb86-b172-4422-912a-7f500f759...@g17g2000prg.googlegroups.com>,
>
>
>
>  Zhane <zhan...@gmail.com> wrote:
> > On Dec 7, 2:23 am, "John B. Matthews" <nos...@nospam.com> wrote:
> > > In article
> > > <5ff20a9f-3622-4734-b1fd-a0682d532...@c36g2000prc.googlegroups.com>,
>
> > >  Zhane <zhan...@gmail.com> wrote:
> [...]
> > > > this is the error i get when I try to execute the procedure in
> > > > phpmyadmin
>
> > > What procedure? Should you be using prepareCall()?
>
> [please trim sigs]
>
> > I changed it to prepareCall... but it doesnt make any difference
>
> What code did you try? What result did you get?
>
> Elsewhere, you suggest that you intend to call a stored procedure:
>
> > findFoodCode = connection.prepareStatement("CALL getFoodCode(?,?)");
>
> You should use prepareCall(), set up the procedure's parameters, invoke
> execute() on the CallableStatement, and get the return value:
>
> <http://java.sun.com/javase/6/docs/api/java/sql/Connection.html>
> <http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html>
> See also: Oracle Database JDBC Developer's Guide and Reference, Ch. 13.
>
> --
> John B. Matthews
> trashgod at gmail dot comhttp://home.roadrunner.com/~jbmatthews/

what sort of setup you mean?
I did setString( ) for both my ?

I tried e same code, but with the previously preparedstatement type to
now the callablestatement type

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: Client_Multi_Result F "Zhane" <zhane@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000

csiph-web