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
AIL PROTECTED]> wrote:
I was actually dealing with a similar problem
yesterday; I wanted to write a
tag that called not a stored procedure, but several
SQL statements in a row,
using a dataSource, just like I would use for
tags. After
looking through the source code, I noticed that the
7;s DBTags taglib? - MOD
--- James Smith <[EMAIL PROTECTED]> wrote:
> I was actually dealing with a similar problem
> yesterday; I wanted to write a
> tag that called not a stored procedure, but several
> SQL statements in a row,
> using a dataSource, just like I would use for
&g
I was actually dealing with a similar problem yesterday; I wanted to write a
tag that called not a stored procedure, but several SQL statements in a row,
using a dataSource, just like I would use for tags. After
looking through the source code, I noticed that the abstract classes
> - 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,
> >
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
tored procedure
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.
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
&
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 mig
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
>
Hi,
Are there any taglibs which I can use to call a stored procedure.
Thanks
Kevin
Vaibhav,
The name of the stored procedure for Consolidated Account Summary is
view_asset_acct_summary which is created in INS_D database.
This is how you will be calling the stored procedure:
exec view_asset_acct_summary
@user_id = 'ONLINE_INC',
@user_type
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.
Hy,
I am trying to call some Stored Procedures on an Oracle database. There are
proc. with input/output parameters and I am using the JDBC tag library. How
can I set the input/output parameters and how can I make the call to the
proc.?
Thanks in advance,
Mihai
21 matches
Mail list logo