RE: Resources

2006-01-20 Thread Priyesh Mashelkar
Sorry, I meant, Where is the xml file placed in the jar file?   Priyesh   From: Priyesh Mashelkar Sent: Saturday, January 21, 2006 11:12 AM To: user-java@ibatis.apache.org Subject: RE: Resources   What is the xml file placed in the jar

RE: Resources

2006-01-20 Thread Priyesh Mashelkar
What is the xml file placed in the jar file?   Priyesh   From: Tony Qian [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 10:07 PM To: user-java@ibatis.apache.org Subject: Resources   Can someone tell why Resources.getResourceAsR

RE: Batch not batching!

2005-10-19 Thread Priyesh Mashelkar
Hi Clinton, Just a bit confused. Want to clarify this thing. Do you mean to say that when a EXTERNAL transaction manager is used, the startTransaction will start a new transaction and will not participate in the parent transaction. And if the JTA transaction manager is used, it

RE: the systems cannot load the resource files

2005-09-27 Thread Priyesh Mashelkar
There is one solution. You will need a helper class in the resource package which will read the file using the following code: this.getClass().getResource("daoConfig.xml") The helper class has to exist in the same package as the xml file to be able to find the xml file.   Regards, Priyesh  

RE: Float value at Oracle

2005-08-26 Thread Priyesh Mashelkar
´ll try to use NUMERIC instead of float and number. tks On 8/25/05, Priyesh Mashelkar <[EMAIL PROTECTED]> wrote: > Hi, > Want to just give this a try!!! > Can you use NUMERIC instead or NUMBER or FLOAT. > And yes, What is the type of the column in the d

RE: Float value at Oracle

2005-08-25 Thread Priyesh Mashelkar
Hi, Want to just give this a try!!! Can you use NUMERIC instead or NUMBER or FLOAT. And yes, What is the type of the column in the database? Priyesh -Original Message- From: Renato Silveira [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 12:57 AM To: use

RE: where can I find a simple implementation example

2005-08-18 Thread Priyesh Mashelkar
I agree with Larry. Refactor later would be more tedious as per my experience. The application on which I am working is also small but using iBatis has made the db access simpler. -Original Message- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:21 PM To:

RE: stored procedures/functions

2005-08-11 Thread Priyesh Mashelkar
jdbcType should be VARCHAR and not VARCHAR2 i suppose. -Original Message- From: Denis Vladimirov [mailto:[EMAIL PROTECTED] Sent: Thursday, August 11, 2005 4:58 PM To: user-java@ibatis.apache.org Subject: stored procedures/functions Hi there, I am trying to make a call to a stored Oracle

RE: SQLMaps - Sybase and stored procedures

2005-08-10 Thread Priyesh Mashelkar
OTECTED] <[EMAIL PROTECTED]> wrote: > > Hi there. > > I can only see queryForList() and queryForObject() in the API docs. > > How do you force an executeQuery() instead of the > execute()/getResultset() > > option? > > > > andy > > > > >

RE: SQLMaps - Sybase and stored procedures

2005-08-09 Thread Priyesh Mashelkar
andy "Priyesh Mashelkar"

RE: SQLMaps - Sybase and stored procedures

2005-08-09 Thread Priyesh Mashelkar
--> Output = Ordinateurs thanks, andy "Priyesh Mashelkar" To:

RE: SQLMaps - Sybase and stored procedures

2005-08-09 Thread Priyesh Mashelkar
I hope the '..' in client_reporting..CLT_language_lookup_q1 is not the problem here!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 7:08 PM To: user-java@ibatis.apache.org Subject: Re: SQLMaps - Sybase and stored procedures Thanks.

RE: SQLMaps - Sybase and stored procedures

2005-08-09 Thread Priyesh Mashelkar
09/08/2005 12:01 Please respond to user-java It's true: Without a resultMap or resultClass, your results will be silently discarded. Larry On 8/9/05, Priyesh Mashelkar <[EMAIL PROTECTED]> wrote: > Use a resultMap or resultClass as yo

RE: SQLMaps - Sybase and stored procedures

2005-08-09 Thread Priyesh Mashelkar
It's true: Without a resultMap or resultClass, your results will be silently discarded. Larry On 8/9/05, Priyesh Mashelkar <[EMAIL PROTECTED]> wrote: > Use a resultMap or resultClass as you would do for a normal query. > They have missed mention of procedures re

RE: SQLMaps - Sybase and stored procedures

2005-08-09 Thread Priyesh Mashelkar
Use a resultMap or resultClass as you would do for a normal query. They have missed mention of procedures returning values in their documentation. Your mapping would look like: {call language_lookup @from_text = ?, @language = ?} The call remains the same. i.e., {c

RE: Multiple threads with single transaction

2005-08-08 Thread Priyesh Mashelkar
a new connection. Any ideia ? Regards, On 8/8/05, Paulo Neves <[EMAIL PROTECTED]> wrote: > Priyesh, > > That could be a good ideia. I'll try. > > Thanks, > Paulo > > On 8/8/05, Priyesh Mashelkar <[EMAIL PROTECTED]> wrote: > > Hi Paulo, > &g

RE: Executing a Stored Procedure returning rows from a Temporary table

2005-08-08 Thread Priyesh Mashelkar
Sorry if I forgot to mention, the multiple clients would be concurrently executing. And the problem starts here. And according to the performance measurements we have been carrying out, even a single db interaction counts a lot when performance is one of the deliverables. -Original Messag

RE: Executing a Stored Procedure returning rows from a Temporary table

2005-08-08 Thread Priyesh Mashelkar
I would be more than happy if that helps. But just to tell you if u have missed, that i am selecting on a temporary table. If it does not work in a Stored Procedure, I doubt whether it will work in a function. Moreover, in the executeQuery() of SqlExecutor too, the execute() method is used and

RE: Executing a Stored Procedure returning rows from a Temporary table

2005-08-08 Thread Priyesh Mashelkar
Well, that was one of the alternatives. But going to the database twice is going to shoot up the performance. Furthermore, multiple clients may call this Stored Procedure and we would have to somehow separate the outputs for the various clients. But if the code iBATIS has is perfectly fine, we wo

RE: Multiple threads with single transaction

2005-08-08 Thread Priyesh Mashelkar
Hi Paulo, I know this may not be liked by many, but what about getting the SqlMapSession and sharing it across? That means, iBATIS will not use its internal thread management. Priyesh -Original Message- From: Paulo Neves [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 8

RE: Executing a Stored Procedure returning rows from a Temporary table

2005-08-08 Thread Priyesh Mashelkar
success: http://www.jnetdirect.com/products.php?op=jsqlconnect It has a trial available - maybe you could try it to see if it is indeed the driver. Jeff Butler On 8/8/05, Priyesh Mashelkar <[EMAIL PROTECTED]> wrote: > I buy your point. > But the method in which this occurs is executeQueryProcedure

RE: Executing a Stored Procedure returning rows from a Temporary table

2005-08-08 Thread Priyesh Mashelkar
solution because stored procedures may not always return result sets. So it seems to me that this could be a driver problem, rather than an iBATIS problem. Jeff Butler On 8/8/05, Priyesh Mashelkar <[EMAIL PROTECTED]> wrote: > Hi, >Havent received anybodies mail regarding this. &g

RE: Executing a Stored Procedure returning rows from a Temporary table

2005-08-08 Thread Priyesh Mashelkar
we use the following code instead the result set returned is proper: rs = cs.executeQuery(); Will this change have any repercussions somewhere else? Kindly reply ASAP. Its urgent. Regards, Priyesh -Original Message- From: Priyesh Mashelkar Sent: Friday, August 05, 2005 5

RE: Re: resultMap: jdbcType or dbType?

2005-08-06 Thread Priyesh Mashelkar
- From: dario [mailto:[EMAIL PROTECTED] Sent: Saturday, August 06, 2005 1:27 PM To: user-java@ibatis.apache.org Subject: Re: resultMap: jdbcType or dbType? "Priyesh Mashelkar" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >Please check the documentation of iBATIS

Executing a Stored Procedure returning rows from a Temporary table

2005-08-05 Thread Priyesh Mashelkar
Hi, I have a Stored Procedure which uses the input parameters passed to it and returns rows from a temporary table which it creates. Currently I am getting a NullPointerException executing the Stored Procedure. I am using Microsoft SQL Server 2000 database. And in the pro

RE: resultMap: jdbcType or dbType?

2005-08-05 Thread Priyesh Mashelkar
Hi, Please check the documentation of iBATIS at http://prdownloads.sourceforge.net/ibatisdb/iBATIS-SqlMaps-2.pdf?download . It is enough comprehensive and will answer your question. Regards, Priyesh -Original Message- From: dario [mailto:[EMAIL PROTECTED] Sent: Friday, Aug