Re: Selling iBatis to the skeptics

Here is some ammo for your brown bag session: - iBatis fits perfectly into the DAO pattern, a "core J2EE pattern". - Copy one page of Rod Johnson's "J2EE development without EJB". The one that describes "The failure of Entity Beans". Let the skeptics read that page and videotape the expression

Re: HOW TO pass List of objects(a DTO) as single IN parameter to Stored Procedure

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 working with Oracle DB and iBatis Can anyone tell me how to passList of objects(a DTO) as single IN parameter to Stored Procedure us

Re: output problem

Hi, The definition of your output parameters is incorrect. The resultMap attribute should not be defined. Please read the documentation or the sql-map.dtd. Greetings, Hans. puneet arya wrote: Hi,    i have made stored procedure in oracle and try to run the output in the store procedure

Re: Can the IBatis Procedure call invoke a function within a Package in on a DB ?

Hi, It should be possible to call a function within a DB package. The error doesn't seem to be related to iBatis. Can you successfully execute the SQL statement from a DB client? If yes, there may be a problem with the configuration of your JDBC connection. Greetings, Hans. Murray, AlanM wrot

Re: Transaction Ibati MySql don't work

Hi Gary, JDBC transactions should work with MySQL. This is not an iBatis problem. - InnoDB is the Table engine type: CREATE TABLE `table` ( ... columns ... ) ENGINE=InnoDB DEFAULT CHARSET=latin1; I have successfully performed transactions with the following environment: - MySQL 5.0.4 - JDK 1.4

Re: Re : Problem with iBatis SQLMap and stored procedure

Hi, As you've already pointed out in the stacktrace, the problem "clearly" comes from DBCP: Caused by: java.lang.NullPointerException at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:132) I haven't met this problem before, but I already had Tomcat working w

Re: Problem with iBatis SQLMap and stored procedure

Hi Cyril, Can you try to configure the Tomcat Datasource without DBCP? For example, here is a configuration for MySQL: username password driverClassName com.mysql.jdbc.Driver url jdbc:mysql:///test?jdbcCompliantTruncatio

Re: Resource Error when using Datasource name

inal Message- From: Beemsterboer Software [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 1:16 PM To: user-java@ibatis.apache.org Subject: Re: Resource Error when using Datasource name Ali, Welcome to WebSphere configuration fun: sql-map-config.xml: web

Re: Resource Error when using Datasource name

Ali, Welcome to WebSphere configuration fun: sql-map-config.xml: web.xml: cams_dev javax.sql.DataSource CONTAINER Shareable ibm-web-bnd.xmi: ibm-web-ext.xmi: connectionManagementPolicy="Default"> Ali, Mohammed (Liquidity

Re: Procedures in iBatis

roperty to specify. Please let me know. Regards, Suman Mishra 203-719-1698 -Original Message----- From: Beemsterboer Software [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:17 PM To: user-java@ibatis.apache.org Subject: Re: Procedures in iBatis

Re: Procedures in iBatis

Try this: {call get_data()} [EMAIL PROTECTED] wrote: Hi, I have a sybase procedure which doesnt take any parameter. Its a combination of few select statements. Can someone please help me with the syntax where parameter property is blank. Can s

Re: iBatis within EAR files

effect on this. This is such a basic configuration and I cna't believe I'm the only one who has ran into this. Has anyone used iBatis from an EAR under JBoss? If so, can you please just give me your package layout? -aps On 4/7/06, *Beemsterboer Software* <[EMAIL PROTECTED] <

Re: iBatis within EAR files

Alexander, When I understand it correctly, you have the iBatis jar files in the EAR project and the iBatis configuration in the EJB project. Can you try to extract these configuration files and add them as a 'shared library' to your application? This is a 'good practice': - You can configure

Re: setup help requested

Have you initialized an SqlMapClient in your code? Driller, Jonathan (MSCIBARRA) wrote: Hi, I am completely new to Ibatis, beans and the whole rationale behind this and am struggling a bit. I can connect to my bean but get nothing from Ibatisno db info gets returned. Any clues as to what,

Re: declarative - db schema

This has been described in the DevGuide, refer to: "Simple Dynamic SQL Elements". In my previous project, I read the schema name from a properties file and passed it to the SqlMap statement via a parameter map. Greetings, Hans. Sven Boden wrote: There's no "defaultSchema=name" in iBatis. So tha

Re: get the statement

Get the iBatis source and look inside the kitchen for the following class: com\ibatis\sqlmap\engine\execution\SqlExecutor As its name suggests, this class executes sql statements, e.g.: public void executeQuery(RequestScope request, Connection conn, String sql, Object[] parameters,

Re: Log 4j prob

You could try to add the appender to your logger: log4j.logger.java.sql.Connection=DEBUG, Appender1 Engel, Gregory A wrote: Not really an Ibatis question per se but I'm sure someone here has seen this   log4j:WARN No appenders could be found for logger (java.sql.Connection).