Stored procedures being called as Prepared Statements??
- From: narsiman@xxxxxxxxx
- Date: 22 Aug 2006 08:53:07 -0700
We are switching from DataDirect to Microsoft's JDBC driver and the
application code has not changed. the JDBC driver is making a prepared
statement call to the SQL Server and unpreparing the statement after
procedure execution. The target is a SQL Server 2005 SP1 database on
Windows 2003 Enterprise. the app server is bea web logic 8.1 on a linux
box. we have a connection pool of 40 threads.
Is this prepare and unprepare normal and expected behavior? Are we not
setting any configurable items correctly? (this happens on the same
SPID)
We see a RPC starting and RPC Complete events in the trace, but no SP
start and SP Complete events in the trace.
Any help on this is appreciated.
Thanks.
this info is from the SQL trace
declare @p1 int
set @p1=0
declare @p4 int
set @p4=NULL
exec sp_prepexec @p1 output,N'@P0 int OUTPUT,@P1 varchar(8000),@P2
varchar(8000)',N'EXEC @P0 = sp_get_list @P1,@P2
',@p4
output,'SC','I'
select @p1, @p4
EXEC @P0 = sp_get_list @P1,@P2
exec sp_unprepare 8689
.
- Follow-Ups:
- Re: Stored procedures being called as Prepared Statements??
- From: Joe Weinstein
- Re: Stored procedures being called as Prepared Statements??
- Prev by Date: Re: Implicit conversion from data type text to nvarchar is not allowed.
- Next by Date: Re: Stored procedures being called as Prepared Statements??
- Previous by thread: Implicit conversion from data type text to nvarchar is not allowed.
- Next by thread: Re: Stored procedures being called as Prepared Statements??
- Index(es):
Relevant Pages
|
Loading
