Problem with log4j

Hi! My application using ibatis 2.1.5.582 Ibatis NOT WRITE LOG INFORMATIONS!! PLEASE HELP ME Marco Berri Using: log4j 1.2.11 log4j.xml : ?xml version=1.0 encoding=UTF-8 ? !DOCTYPE log4j:configuration SYSTEM log4j.dtd log4j:configuration

Getting connection from ibatis

Hi Iam using ibatis in my project, with JBoss application server. I have some taglibs from oracle which uploads ORDImages (Oracle specific objects) to the database ord:storeMedia These tags either need a connection or datasource, passed as one of its argument to perform its task.

RE: Problem with log4j

Change your xml as shown below and try logger name=com.ibatis additivity=true level value=debug/ appender-ref ref=com-ibatis / /logger root level value=debug/ appender-ref ref=tnes-fat-mail / /root

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

If you are seriously worried about 220ms of time in an enterprise aplication, then iBATIS (and all other frameworks) are not for you. Stick with JDBC. Performance testing enterprise applications is very complex, and you should avoid drawing conclusions based on simple tests of 10 executions of a

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

PS: We cannot acknowledge performance test results, nor can we answer questions or do anything about them -- unless you post your test code including database scripts and platform details. Cheers, ClintonOn 10/6/05, Clinton Begin [EMAIL PROTECTED] wrote: If you are seriously worried about 220ms

Re: Getting connection from ibatis

The simplest way is to use JNDI for your datasource / transaction manager. Larry On 10/6/05, Agilan Palani [EMAIL PROTECTED] wrote: Hi Iam using ibatis in my project, with JBoss application server. I have some taglibs from oracle which uploads ORDImages (Oracle specific objects) to

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

If it's on Oracle using inline parameters will be slower. Regards, Sven - Oorspronkelijk bericht - Van: Clinton Begin [mailto:[EMAIL PROTECTED] Verzonden: donderdag, oktober 6, 2005 01:18 PM Aan: user-java@ibatis.apache.org Onderwerp: Re: why does SqlMap ibatis is slower that

RE: Getting connection from ibatis

Iam already using a datasource for IBATIS, do you mean I need to lookup that datasource again by-passing IBATIS and pass it to the taglib? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Thursday, October 06, 2005 8:12 PM To:

Re: Getting connection from ibatis

That is what I would do, yes. Larry On 10/6/05, Agilan Palani [EMAIL PROTECTED] wrote: Iam already using a datasource for IBATIS, do you mean I need to lookup that datasource again by-passing IBATIS and pass it to the taglib? -Original Message- From: [EMAIL PROTECTED]

Changing a sqlMap dynamically?

Using iBATIS you normally create an XML file with a sqlMap element that defines SQL queries that can be referenced by name. Is it also possible to create these queries dynamically, through Java, instead of hard-coding them all in XML? I'm hoping to build some framework code that will

Re: Changing a sqlMap dynamically?

select id=getWhatever resultClass=java.util.HashMap remapResults=true $whateverSqlYouWant$ /select Larry On 10/6/05, Dan Bradley [EMAIL PROTECTED] wrote: Using iBATIS you normally create an XML file with a sqlMap element that defines SQL queries that can be referenced by name. Is it also

RE: Getting connection from ibatis

Thanks, but, do you have any answer to get the connection directly? Another project is running on a web-server which doesn't have a datasource, but uses IBATIS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Thursday, October 06,

Re: iBATIS strange behaviour

Hmm, this seems really odd. The code that is in SVN now supports properties named like sProperty with mutators like getsProperty and setsProperty. According to the beans specification, getters named getSProperty and setSProperty define a property named SProperty, not sProperty as you might

Re: Changing a sqlMap dynamically?

Hi Larry - Thanks for the reply, but I think you misunderstood the question. I understand that I can put arbitrary SQL into a named select element within a sqlMap file. That then gets called, by name, from SqlMapExecutor/Session. What I'm wondering is if there's either: - a way to (essentially)

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

Hi Sven, Like to hear from you, how you came to that conclusion. -J Sven.Boden wrote: If it's on Oracle using inline parameters will be slower. Regards, Sven - Oorspronkelijk bericht - Van: Clinton Begin [mailto:[EMAIL PROTECTED] Verzonden: donderdag, oktober 6, 2005 01:18 PM

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

Thanks for sharing, I was always under the impression that inline parameters didn't mean hard parses. I'm quite aware of the fact that this might hurt Oracle. Checking... Sven Boden wrote: Simple... the SQL code executed by the JDBC example and the iBATIS version is not the same. The JDBC

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

I may be mixing up things... let me check as well ;-) $/#/... Sven On Fri, 07 Oct 2005 00:20:47 +0200, you wrote: Thanks for sharing, I was always under the impression that inline parameters didn't mean hard parses. I'm quite aware of the fact that this might hurt Oracle. Checking... Sven

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

Point of interest is InlineParameterMapParser. mappingList.add(mapping); newSqlBuffer.append(?); ... ... newSql = newSqlBuffer.toString(); ParameterMapping[] mappingArray = (ParameterMapping[]) mappingList.toArray(new ParameterMapping[mappingList.size()]); SqlText

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

I may be mixing up things... let me check as well ;-) Sven On Fri, 07 Oct 2005 00:20:47 +0200, you wrote: Thanks for sharing, I was always under the impression that inline parameters didn't mean hard parses. I'm quite aware of the fact that this might hurt Oracle. Checking... Sven Boden

Re: why does SqlMap ibatis is slower that JdbcDaoTemplate

I also checked with the single point of truth - the database. For those interested... Mapping: select id=getRegisteredAction resultClass=registeredAction SELECT REAC_ID as id , REAC_NAME as name , REAC_DESCRIPTION as description , REAC_IND_ACTIVE as active FROM

Re: Sybase selectKey problem

BTW, this *does* work: insert id=createDeployment parameterClass=deployment selectKey resultClass=int keyProperty=deploymentId SELECT MAX(deploymentId) + 1 FROM Deployment /selectKey INSERT INTO Deployment (deploymentId, environmentId, deploymentTypeId,

RE: Getting connection from ibatis

I hope that iam not clear in stating why I need a direct connection from IBATIS, will correctly state is now. My project runs in JBoss in one location and in tomcat in other places. Code base is same. There are some java EOD programs which will also run as separate process using IBATIS. Tomcat

Re: Sybase selectKey problem

Try this as the selectKey query. I think you have to select the column as value. I'm assuming your deployment class has a deploymentId property. selectKey resultClass=int keyProperty=deploymentId SELECT @@IDENTITY AS value /selectKey Zarar - Original Message - From:

Re: Sybase selectKey problem

Hmm, what happens when you do the insert from a plain-jane sql client? In this case, the exception is coming *BEFORE* the selectKey element gets executed: Caused by: com.sybase.jdbc3.jdbc.SybSQLException: The column deploymentId in table Deployment does not allow null values. The column does