Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Client_Multi_Result F

Show all headers | View raw

  To: comp.lang.java.databases
On Dec 7, 2:23=A0am, "John B. Matthews" <nos...@nospam.com> wrote:
> In article
> <5ff20a9f-3622-4734-b1fd-a0682d532...@c36g2000prc.googlegroups.com>,
>
> =A0Zhane <zhan...@gmail.com> wrote:
> > On Dec 7, 12:48=A0am, Zhane <zhan...@gmail.com> wrote:
> > > I tried to port my procedures to a web mysql server.
>
> > > it was running well when it is on my pc. but when i port it to the
> > > server, it does not allow me to output the result set.
>
> > > i checked it online, it seem to be related to the client_multi_result
> > > flag. i'm using mysql-connector... how can I set this flag?
>
> > can't return a result set in the given context
>
> What ResultSet would you expect from a SQL UPDATE statement?
>
> > this is the error i get when I try to execute the procedure in
> > phpmyadmin
>
> What procedure? Should you be using prepareCall()?
>
> <http://java.sun.com/javase/6/docs/api/java/sql/Connection.html#prepareCa
> ll(java.lang.String)>
>
> --
> John B. Matthews
> trashgod at gmail dot comhttp://home.roadrunner.com/~jbmatthews/


I changed it to prepareCall... but it doesnt make any difference

---
 * 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