-Original Message-
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: 20. elokuuta 2008 16:04
To: user-java@ibatis.apache.org
Subject: Re: Working around MSSQL parameter list length limitation
IMO, ibatis should never, ever handle this sort of thing. :-P
Well, that may be true.
Hi
Since you're only updating a parameter, I think you should use the update
method for the sqlmap client:
sqlMap.update(getAccountEmailViaProcedure, param);
And then get the updated parameter from the parameter map itself:
String email = (String) param.get(email);
And the parameter id should
Hi:
We were having some problems where the time on the Web server and the DB
server are off by a few milliseconds and it was causing some issues, so
rather than rely on getting the times synched perfectly, I thought we
could just always use the time on the Web server by passing in the
Put a proxy on the sql map client interface.
Larry
On Thu, Aug 21, 2008 at 6:57 AM, Jonathan Slate [EMAIL PROTECTED] wrote:
Hi:
We were having some problems where the time on the Web server and the DB
server are off by a few milliseconds and it was causing some issues, so
rather than rely
Hi,
I am using Apache-Common DBCP datasource with SpringIbatis.
So i have followed Juans example(Comment section) for getting
oraclePreparedStatement in the following URL.
http://opensource.atlassian.com/confluence/oss/display/IBATIS/XMLTypeHandlerCallback.java
I modified the setParameter as
Okay, so you mean and AOP proxy, right? Thanks for the suggestion. It
doesn't seem like that's documented much, looking at the mailing list
archives I'm guessing my best bet would be to download the iBATIS source
and see how you guys are doing the logging stuff, right?
I don't know, I'm
Hi ,
I solved the issue XMLType.CreateXML method returns null when i pass
ops.getConnection and (Document)parameter.
Instead of passwing Document arugment i converted document to StringWriter
using Transformer and the passed String object in the XMLType.createXML .
Now the storedProcedure
Hello,
Please suggest the best way to customize a set of queries to use different
tables (but same columns).
For example, let's say that I have a humongous amount of customers and the
DBA decided to split into tables by continent. Let us also assume that
there will be 7 distinct subcomponents
To be honest in the first place I'd ask DBA to use partitioning if your db
engine supports that, and if not, to create union USERS query to run my
queries against.
Hi,
I have to implement TransacationManager in my module using Spring with
Ibatis.
Here is my requirments.
TransacationProcessor -
--Open Transacation
--Call LoopProcessor(process multiple files )
--- Call DatabaseProcessor
-- Call SQLMqpClient
Did you go through the Spring reference pdf. They have these explained. Even
google would direct you the HTML chapter of the PDF.
On Thu, Aug 21, 2008 at 1:10 PM, bala r [EMAIL PROTECTED] wrote:
Hi,
I have to implement TransacationManager in my module using Spring with
Ibatis.
Here is my
I thought you can pass table names dynamically using a $table_name. My best
bet would be to create the table name at your dao layer and pass it as a
param to the query.
On Thu, Aug 21, 2008 at 11:31 AM, Nicholoz Koka Kiknadze [EMAIL PROTECTED]
wrote:
To be honest in the first place I'd ask
Hi,
I am looking some good reference for Spring Declarative transacation with
Ibatis.
Thanks
Bala.
On Thu, Aug 21, 2008 at 4:31 PM, Sundar Sankar [EMAIL PROTECTED] wrote:
Did you go through the Spring reference pdf. They have these explained.
Even google would direct you the HTML chapter of
I need know how send the parameters to query if the query have more than 1
table, for example:
select id=getCar resultClass=co.enti.Car
SELECT
car.COD_CAR as cod,
per.NAME as name
FROM
IPS_CARA car,
IPS_PERSON per
WHERE
car.COD_CAR = #cod# AND
Try adding parameterClass=map in the ibatis mapping.
In the calling code, add:
Map params = new HashMap();
map.put(cod, codeParameterValue );
map.put(name, nameParameterValue );
Car car = (Car) sqlMap.queryForObject(getCar, params );
Let me know how this works out since I'm not at work to test
15 matches
Mail list logo