ave to configure the ping quesry in WebSphere - not in iBATIS.
> Here's
> a link to the WebSphere documentation that shows how to do it:
>
> http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/tdat_pretestconn.html
>
t;
> with almost every ConnectionPool to let the pool check whether the
> connection is still valid before it delivers it to you're application. For
> a SimpleDataSource with iBATIS you can setup such thing under a
> Pool.PingQuery. Read the SQL Maps documentation (on page 68).
>
ataSource setup as a
> JDBC
> source. Is this true or are you using a container managed DataSource? If
> you are using something like a JTA provider through WAS, you will need
> something like this:
>
>
>
>
>
>
>
>
> Please see p
Hi,
I am using WAS 6.0 Datasource inside my Ibatis sql mapper. The code in my
sqlmapconfig.xml is as follows.
I am calling the database operations from my EJB which is stateless and Bean
Managed. The code inside my
Hi Chetan,
It is working now. Thanks for your valuable suggesstion. The mistake was,
since I had the two jar files reference
(Ibatis-2.3.0.677.jar,Ibatis-sqlmap-2.jar), I was not able to get the
method(selectLog...) now I am having the reference of Ibatis-2.3.0.677.jar
alone and it is solved now
Hi Chetan,
I would like to correct my previous message.
I am not getting the selectLog4jLogging method from my LogFactory class. I
am currently using the following APIs. Please let me know if I need to
remove or replace someother Jar file.
Currently Used API are
Ibatis-2.3.0.677.jar
Ibatis
Venkat
Chetan Nayak wrote:
>
> Try using this line before you make calls to IBATIS API,
> LogFactory.selectLog4jLoggin() ,I'm just guessing here.
>
> Thanks
> Chetan
>
>
>
> On 1/9/08, IBATIS <[EMAIL PROTECTED]> wrote:
>>
>>
>>
Hello There,
I am unable to log my sql queries used in ibatis sql mapper. Let me narrate
the steps I used.
I have put the following entries into my log4j.properties file.
log4j.logger.com.ibatis=DEBUG,ibatisFile
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG,ibatisFile
bject("retrieveBagTagInfoSP",
> hshBagTag);
>
> and you may also want to try update method as well. iBATIS also makes
> callable statement, so you should debug the last statement and see what
> happens.
> I am sure debugging would help as this is clearly not a problem w
error (register
> output parameters failed) until I change it to VARCHAR instead of
> VARCHAR2. After doing the change, the code is running through iBATIS
> displaying expected results. Which database are you using?
> One more thing, you can remove resultClass from procedure a
Hi Abhigyan,
Thank you very much for your detailed response. Even now there is no luck
for me. I am using the IBatis for the first time. I am calling my DAO from a
stateless session bean of Container managed persistence. This DAO uses
SQLMapper to call the stored procedure.
And I am not using
I am going wrong, I am badly in need of a
help.
My Environment is as below.
Development Environment - RAD 7.0 (Websphere Application server 6.0)
Ibatis jar files - ibatis-common-2.jar / ibatis-sqlmap-2.jar (i got it from
jpetstore example package)
Regards
Venkat
Larry Meadors-2 wrote:
&g
Hi Larry,
Thanks for the response.
Let me tell you my Stored Procedure approach.
1.Parameter Map set in one of my ibatis resource .xml file is as below.
below is the stored procedure calling portion.
{call Bag_Information.BagTag_Inquiry(?,?,?,?,?) }
Using the above
Hi There,
I am facing issues while I invoke a sql / stored procedure in RAD 7.0 using
Ibatis.
Do I need add any .jars or others to make it work with RAD.
Please look into the issues as below.
1. while I invoke a plain sql I am not getting the result.
2. While I invoke a stored procedure, the
Hello,
I have the following problem:
I have a simple object
public class MyObject {
private String id = "";
public String getId() { return id; }
public void setId(String id) { this.id = id; }
}
, a database with a table
CREATE TABLE myobject(id serial NOT NULL)
and a map-file
Hi,I'm getting this error:using userdefined type in procedure. in that type, the datatypes are number(12,2), varchar2, number. In the dto ,i declared BigDecimal for number(12,2),when i read using readBigDecimal . will this creates this problem or any thing else. pls give me solution.
i have used
HI, when i use a Type (userdefined) in oracle as
OUT parmaters in procedure. i have got this problem. can any one tell
me what is the exact cause for these.i have these type defined
outside the package. and procedure is also in outside package. what is
the reason for this error..and how can
HI, when i use a Type (userdefined) in oracle as OUT parmaters in procedure. i have got this problem. can any one tell me what is the exact cause for these.i have these type defined outside the package. and procedure is also in outside package. what is the reason for this error..and how can
Hi,Can anyone tell me what dtd should i use for using the typeHandler tag in sqlMapConfig.xml filecurrently i'm using this which is not supporting typeHandler tag PUBLIC "-//iBATIS.com//DTD SQL Map Config
2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">where do i get the dtd suppo
not possible?with or without ibatisOn 7/11/06, Beemsterboer Software <[EMAIL PROTECTED]
> wrote:
Hi,
Passing a list of objects using a single input parameter?
This is not even possible without iBatis.
Greetings,
Hans.
chaithanya ibatis wrote:
HI,
I've been w
HI,I've been working with Oracle DB and iBatisCan anyone tell me how to passList of objects(a DTO) as single IN parameter to Stored Procedure using iBatis for examplejava.util.List list = new ArrayList();
SampleDTO obj1 = new SampleDTO();SampleDTO obj2 = new SampleDTO();list add(obj1);lis
EjecSh(?)}
Esperanza Echeverría de Miguel
Steria España http://www.steria.es
C/Menéndez y Pelayo,3 bis 46010 Valencia
Tel: + 34 96 393 87 50 Fax: +34 96 393 87 51
[EMAIL PROTECTED]
"chaithanya ibatis" <[EMAIL PROTECTED]
>
11/07/2006 09:14
Please respond to user-jav
HI,I've been working with Oracle DB and iBatisCan anyone tell me how to pass List of objects as IN parameter to Stored Procedure using iBatis (mapping required in SQL map files of ibatis)or any resources on this or code snippet
Thanks,Chaithanya
Problem solved: use and .
Aladin
>
> I have two simple queries which I am trying to combine using
> but it doesn't seem to work as expected.
>
> Query 1: SELECT requestid FROM users WHERE name = 'test'
> Query 2: SELECT count(*) FROM users WHERE name = 'test'
>
> IN XML:
> ===
> cacheMode
Hello,
I have two simple queries which I am trying to combine using
but it doesn't seem to work as expected.
Query 1: SELECT requestid FROM users WHERE name = 'test'
Query 2: SELECT count(*) FROM users WHERE name = 'test'
IN XML:
===
SELECT
count(*)
requestid
FROM users WHERE name = 't
at no other sessions,
users, or clients can even do a read on those database tables. Due to the
trace log messages, IBM is convinced that 'my' code is not closing the database
connections, and says that I should correct my code. Well, I'm using iBatis,
and it's pretty clear t
with skip and count parameters.
>
> Clinton
>
>
> On 6/27/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>> Hello,
>>
>> I seem to be having some problem with the PaginatedList.
>>
>> When I'm on the first page and I do paginatedList
Hello,
I seem to be having some problem with the PaginatedList.
When I'm on the first page and I do paginatedList.getPreviousPage(),
iBatis doesn't wrap to the last page... as specified in the javadoc. I
need this wrapping functionality to compute the total number of pages in
the
28 matches
Mail list logo
