Heh,
Always nice to see a discussion like this, instead of having it turn into a stupid
flamewar. I have to agree with James Mitchell that it is very true that not everybody
has the opportunity nor the time to really LEARN j2ee programming. In that aspect the
sql-tags do indeed make for a lower
I agree with Mr. Smith that dumping a working tool because it doesn't fit
the current (albeit valid) programming model. I personally would have
replace (steal) the sql: tags if they were abandoned because I am happily
banging away on a flat two tiered model.
All of my pages that derive from the
>
> > -Original Message-
> > From: Vic Cekvenich [mailto:[EMAIL PROTECTED]
> > Sent: zaterdag 12 juli 2003 1:21
> > To: [EMAIL PROTECTED]
> > Subject: Re: Stored procedure (RFI proposal)
> >
> >
> > Of course... data access in a presentation view
" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 9:36 AM
Subject: RE: Stored procedure (RFI proposal)
>
> I agree with Henri and Tim.
>
> Rather than seeing dogmatic rules about "never" and
> "always", I prefer to hear the reasons for doing
> things
I
> used it this way.
> >
> > -Tim
> >
> > -Original Message-
> > From: Martin van Dijken
> [mailto:[EMAIL PROTECTED]
> > Sent: Monday, July 14, 2003 6:02 AM
> > To: Tag Libraries Users List
> > Subject: RE: Stored procedure (RFI propos
day, July 14, 2003 6:02 AM
> To: Tag Libraries Users List
> Subject: RE: Stored procedure (RFI proposal)
>
>
> Agreed,
>
> I think it a horrific thing to do data manipulation in a JSP tag in the
> first place. Personally I think the whole SQL-taglib is something that neve
amounts of time on a small project
that I worked on just because of the fact that I used it this way.
-Tim
-Original Message-
From: Martin van Dijken [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 6:02 AM
To: Tag Libraries Users List
Subject: RE: Stored procedure (RFI proposal
> Sent: zaterdag 12 juli 2003 1:21
> To: [EMAIL PROTECTED]
> Subject: Re: Stored procedure (RFI proposal)
>
>
> Of course... data access in a presentation view is bad practice, much
> better to unit test a bean (with DAO, such as iBatis.com) in
> an MVC way.
> Then you
uld be useful.
Just an idea! Thanks,
James Smith
Application Systems Analyst, Treistman Center
College of Fine Arts, University of Arizona
- Original Message -
From: "Michael Duffy" <[EMAIL PROTECTED]>
To: "Tag Libraries Users List"
<[EMAIL PROTECTED]>
n Center
> College of Fine Arts, University of Arizona
>
> - Original Message -
> From: "Michael Duffy" <[EMAIL PROTECTED]>
> To: "Tag Libraries Users List"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, July 02, 2003 4:40 AM
> Subjec
Thanks,
James Smith
Application Systems Analyst, Treistman Center
College of Fine Arts, University of Arizona
- Original Message -
From: "Michael Duffy" <[EMAIL PROTECTED]>
To: "Tag Libraries Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 4:40 AM
Subje
Not if the underlying implementation isn't using
CallableStatement. Stored procs can have in, out, and
inout parameters. They can also return multiple
ResultSets.
When I look at the java.sql.CallableStatement
javadocs, it seems clear to me that it's a very
different animal from Statement and
sql taglib does not support Stored Procedure.
You should write your own custom tags.
Here is a link for Stored procedure manipulation in Java
http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html
/Xavier
Daniel Montero a écrit:
I believe you can just do something like
just like any othe
You are correct there(CallableStatement) - looks like I'm going to write my
own.
I had a scan thru the taglibs as well.
Thanks anyway
Kevin
-Original Message-
From: Michael Duffy [mailto:[EMAIL PROTECTED]
Sent: 01 July 2003 19:25
To: Tag Libraries Users List
Subject: Re: S
I believe you can just do something like
just like any other sql statement.
- Original Message -
From: "Kevin Passey" <[EMAIL PROTECTED]>
To: "Taglibs (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2003 9:40 AM
Subject: Stored procedure
> Hi,
>
> Are there any taglibs which
Uh, I don't think so.
A stored procedure is SQL code that's executed by the
SQL engine. In Java, the pertinent class is
java.sql.CallableStatement.
I just looked in the Jakara DBTags docs - no mention
of CallableStatement that I could see, but I only took
a quick glance.
You might have to wr
stored procedure? is that same as stored sql statement? if so:
nick
On Tue, 1 Jul 2003, Kevin Passey wrote:
> Hi,
>
> Are there any taglibs which I can use to call a stored procedure.
>
> Thanks
>
> Kevin
>
-
To unsubscrib
Try to do this. I hope this ca help you.
CallableStatement callStmt=m_conn.prepareCall("{call ?:=test1(3) }");
callStmt.registerOutParameter(1,java.sql.Types.DOUBLE);
ResultSet Rs=callStmt.executeQuery();
System.out.println("OUT "+callStmt.getDouble(1));
Omar Vera.
18 matches
Mail list logo
