Re: Connection leak

2005-06-07 Thread vi am
Brandon: I will re-read the documentation. The JSP code I posted was written purely to evaluate iBATIS. But, that is not the point. I couldn't find in the documentation if/when the connections are closed. Can anyone clarify regarding connections please. erlend.bjorge: I got the tip to gen

Re: trouble mapping sybase stored procedure to object

2005-06-07 Thread Brandon Goodin
We currently have a JIRA issue to provide support for multiple result sets. http://issues.apache.org/jira/browse/IBATIS-28 In regards to the execute/executeQuery choice. The choice was made to help support the use of oracle ref cursors. I'm not sure we would want to change this in order to accomod

Re: Problem with inlineParameterMap using DB2-Database

2005-06-07 Thread Brandon Goodin
yes it should be possible. try simplifying the statement by removing the to see if it works. If it still fails you may want to see what type the db field is and what type your java object property is. The other thing it could be is a JDBC bug. So, you can simplify, examine your fields to make sure

Re: Connection leak

2005-06-07 Thread Brandon Goodin
I hope coding in the JSP is purely for quick and dirty evaluation and not your common pattern. That's a pretty nasty approach to development if it is. Also, you are loading up the sqlmap each time you access the page... another NoNo. Have you read the tutorial yet? I think you may need to read it.

Re: Connection leak

2005-06-07 Thread Brandon Goodin
this looks like a repost of some sort. On 6/6/05, vi am <[EMAIL PROTECTED]> wrote: > I am evaluating iBATIS. How can we close connections to avoid connection > leak? Does documentation mention anywhere that "connections are > automatically closed"? > > The following SQL statement shows conne

Re: License

2005-06-07 Thread Brandon Goodin
it Open Source Apache License as in free beer and i'd have to say that we quite enjoy using and developing it ;-) Following are several links about ibatis: http://ibatis.apache.org/ http://opensource.atlassian.com/confluence/oss/display/IBATIS/Feedback+and+Experiences http://opensource.atlassian.

trouble mapping sybase stored procedure to object

2005-06-07 Thread
Hi, This is regarding the issue that occurs when a sybase stored procedure is mapped to an object. At first I thought this was an Ibatis issue because our stored procedure had an input parameter and no output parameter and I thought Ibatis was getting confused. This is not the case.

Problem with inlineParameterMap using DB2-Database

2005-06-07 Thread Legler, Steffen
Hi. I am using iBATIS for mapping java objects to a DB2 database and a PostgreSQL-Database. My sqlMap looks like this: where instance=#instanceId# select #instanceId# as

Re: bug with running sybase stored procedures

2005-06-07 Thread Sven Boden
Not that I know of... crappy programming on database provider side which they're very reluctant to change because of fear of breaking code specific to their database. One possible solution would be to refactor parts of iBatis so that you have a class structure per type of database, but this will

[ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-07 Thread Ted Husted
Recently, the Apache Software Foundation Board of Directors approved our application to become an official top-level ASF project. This is great news, and, even better news is that the disruption to our resources will be minimal. Soon, we will be moving the website and mailing lists to use the ibat

Connection leak

2005-06-07 Thread vi am
I am evaluating iBATIS. How can we close connections to avoid connection leak? Does documentation mention anywhere that "connections are automatically closed"? The following SQL statement shows connections getting incremented for every JSP page access. **

License

2005-06-07 Thread LUIS RIESGO MARTINEZ
I would like to know if ibatios is free or not. What is the license? How is your experience?

RE: Connection leak

2005-06-07 Thread vi am
Here is the JSP page I was using to test the connections: <%@ page import="com.ibatis.sqlmap.client.*" %> <%@ page import="com.ibatis.common.resources.*" %> <%@ page import="java.io.Reader" %> <%@ page import="java.util.*" %> <%@ page import="vj.i

RE: Connection leak

2005-06-07 Thread vi am
By mistake, there are two threads for this topic... I will try to use only this thread now. I turned on the DEBUG feature... and the seemingly inconsistent behavior is causing confusion. If I use "SIMPLE", on one try the connections were getting created and closed. I could verify this usin

Re: Connection leak

2005-06-07 Thread Clinton Begin
Can you try SIMPLE instead of DBCP, just to confirm that the behaviour is the same? Cheers, ClintonOn 6/7/05, vi am <[EMAIL PROTECTED]> wrote: Here is the full transaction manager configuration:     cacheModelsEnabled="true"enhanceme

Re: [ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-07 Thread Clinton Begin
Haha.I don't think we alone are worthy of a convention. But now we can crash ApacheCon!  Maybe it could be hosted in Canada in the near future. :-) Maybe in Kananaskis or Banff. Clinton On 6/7/05, Stuart Piltch <[EMAIL PROTECTED]> wrote: Ted Husted gmail.com> writes:>> Recently, the Apach

Re: SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Jeff Butler
+1 on smarter entity resolver. That would fix it for everyone, whether they remember to fix the config files or not. Also, will the public ID change too since it has "iBATIS.com" in it? Argh - Changing domains is a real hassle! Jeff Butler >>> [EMAIL PROTECTED] 06/07/05 3:59 PM >>> I only want

Re: SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Clinton Begin
PS: The DTD issue was all my fault.  I meant to first move .net and .org as a test, but I slipped (working too early in the morning).  :-) In any case, it didn't seem to cause too many (or any?) issues, and it was fixed a few hours later.  ibatis.net/.org are both still pointing to apache.org, li

Re: SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Clinton Begin
I only want to maintain one website for ibatis, both to avoid confusion and simplify deployment of the new site.  One problem is that nobody will ever have access to the current ibatis.com hosting facilities except me.  Unfortunately I found out (after I made the change) that apache.org doesn't

Re: SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Brandon Goodin
crappy, guess we'll have to fix that. Clinton: why did we have to move the ibatis.com website to redirect to ibatis.apache.org? Why can't we keep it the way it was for now and simply provide a simple link to the new site from ibatis.com. We could have at least avoided the dtd stuff for a while unt

SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Jeff Butler
Per the change in the web site, I changed the system ids of all my config files to ibatis.apache.org/ However, iBatis is still looking for www.ibatis.com/... in the class com.ibatis.sqlmap.engine.builder.xml.SqlMapClasspathEntityResolver, so the entity resolution fails at run time. It seems t

Re: Connection leak

2005-06-07 Thread vi am
Here is the full transaction manager configuration: Thank you. From: Brandon Goodin <[EMAIL PRO

Re: [ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-07 Thread Stuart Piltch
Ted Husted gmail.com> writes: > > Recently, the Apache Software Foundation Board of Directors approved > our application to become an official top-level ASF project. > [...] > I don't think we have an official beer yet, so for now I'll crack open > a Molson Canadian, and offer a toast to the hard

Re: [iBatis] Documentation

2005-06-07 Thread John Fereira
At 03:41 PM 6/6/2005, Brandon Goodin wrote: If you want to help out, then you have the power to do so. The responsibility is not solely on the committers. We definitely want to be more user friendly. Let's all pitch in and help it to be better. "I appreciate the current condition of the docume

RE: Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-07 Thread Wulf, Andrew
I'm thinking it might be another version of the oracle jdbc driver lurking in the bowels of weblogic which is incompatible with our 10g database. -Original Message- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 7:24 AM To: ibatis-user-java@incubator.apache.org

Re: Using constants in SQL statements

2005-06-07 Thread Brandon Goodin
currently everything is setter/getter based. So, you would need to provide a getter at minimum for your constant. We could discuss direct access to public properties. I don't think that would be too difficult. It might even be a cool idea to use an alias like daniel discussed. However, it would req

Re: Using constants in SQL statements

2005-06-07 Thread Daniel Henrique Ferreira e Silva
Hi, I may be saying something really stupid but, well, progress comes along with a lot of stupid questions :) Let's suppose you have a class or interface loaded with plenty of constants. If i create a type alias for that, can i use it in my sql maps using the dot notation? For instance: public

Any advice on using iBatis in a web service architecture

2005-06-07 Thread Abdullah Kauchali
I'm aware that iBatis supports both input and output maps in the form of XML documents, but has anyone here used output result maps directly as web service "object maps"? How does this compare with the use of JDBC's WebRowSet - any comments are welcome. Kind regards Abdullah

RE: Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-07 Thread Niels Beekman
Hi, You are definitely not the only one :( http://www.orafaq.com/forum/t/28158/0/ http://ora-00600.ora-code.com/ They vary from all kinds of serverside errors (memory/hardware-related) to classpath-problems, so I don't think it will be easy... Good luck! Niels ___

Re: Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-07 Thread Daniel Henrique Ferreira e Silva
Andrew, Honestly, i wish you the best luck as you probably just met an Oracle bug! Usually, these internal exceptions are the first signal of a bug in Oracle internal code. If you find a fix and/or workaround for this issue, let me know. Cheers, Daniel Silva. On 6/6/05, Clinton Begin <[EMAIL

Re: Using constants in SQL statements

2005-06-07 Thread Clinton Begin
It's not supported at this time.  But feel free to add a JIRA request.  It probably wouldn't be hard. Clinton On 6/7/05, ONeill, Niall <[EMAIL PROTECTED]> wrote: Hi,Is there a way in iBATIS to use static Java fields within SQL statements? Currently I am having to hard-code static values in the st

Using constants in SQL statements

2005-06-07 Thread ONeill, Niall
Hi, Is there a way in iBATIS to use static Java fields within SQL statements? Currently I am having to hard-code static values in the statements, but this presents problems if those values ever change and make it difficult to understand the SQL. Regards, Niall O'Neill ***

SV: Connection leak

2005-06-07 Thread erlend.bjorge
Hi there! >Is there a way to limit the maximum number of connections (at any given >time) Apache's DBCP pool? We haven't used that one, but have you tried the simple datasource ? Is it the same behaviour ? Our config look like this: