Re: A CallableStatement did not return as many output parameters

2007-06-18 Thread Saeed Iqbal
Waheed: I think the error was pretty clear. number of return params you look for in your code is less than what the query is returning? A CallableStatement did not return as many output parameters as the application had registered for it. Can you show the call ? Thanks, -saeed Sybase Inc., Dub

A CallableStatement did not return as many output parameters

2007-06-18 Thread Waheed Rahuman
Hello Crew, Hope you doing well and wish you the same. I am using EAServer 5.3 with jConnect 5.5 *Driver Class: com.sybase.jdbc2.jdbc.SybDriver Version: 5.5* When i invoke a RPC, procedure.I am getting the error as below.I got this below message from Jaguar.log . But,the exception does

RE: Sybase stored procedure 'SET CHAINED OFF' (transaction mode) problem

2007-06-18 Thread Christopher . Mathrusse
If your login has the proper roll you could execute SET CHAINED OFF   just prior to executing your stored procedure. My guess is that you don't. Altering the procedure can be a way around it but you've already stated that you cannot change this in the production system.   You are left with o

Re: Minimum active connections in simple datasource

2007-06-18 Thread Nathan Maves
The DB connection pool you are using is designed to be SIMPLE as the name implies. If you need something a little more robust I would suggest using DBCP from Apache. Very easy to configure and it will have all the options you need. Nathan On 6/18/07, Gaurav Goel <[EMAIL PROTECTED]> wrote: H

Re: Problem with executing a Sybase Stored Procedure: output is null

2007-06-18 Thread SvetlanaR
Hi, Just a gues: try to check your result set mapping. If you have not compatible types, it won't work. Also, I never used columnIndex, but used column instead like: and it worked fine for me. Also, make sure that you pass security of the data base. Try, for example, to create a table (using

Sybase stored procedure 'SET CHAINED OFF' (transaction mode) problem

2007-06-18 Thread SvetlanaR
Hi. I have a problem when call my_sp stored procedure (Sybase). The problem is listed below. --- Check the results (failed to retrieve results). --- Cause: com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'my_sp' may be run only in unchained transaction mode. The 'SET CHAINED OFF' comma

nullable enum columns: valueOf() vs getResult()

2007-06-18 Thread c . zecca
> Re: I have a TypeHandler that converts Y/N to boolean, but sometimes Y/N might be null... http://www.mail-archive.com/user-java@ibatis.apache.org/msg04323.html Hi all My issue here is a bit different I have a TypeHandler that loads some string values (a VARCHAR column with a finite set of stri

Double entries in my log4j output?

2007-06-18 Thread Mark Collins
I got SQL Logging to work from browsing tips here, but I'm now seeing what look like double-entries in my log, like so: 2007-06-15 15:35:53,243 {conn-101049} Connection 2007-06-15 15:35:53,243 {conn-101049} Connection 2007-06-15 15:35:53,243 {conn-101049} Preparing Statement: select

Minimum active connections in simple datasource

2007-06-18 Thread Gaurav Goel
Hello, I am using simple datasource and have set various parameters. But i dont find any parameter related to minimum active connections. How do i set that parameter? Or does it have a default value? This is code in my sqlmap-config.xml file: Any help