Re: Transaction Rollback not working with iBatis + Spring

2010-07-22 Thread Larry Meadors
Wait - I'm REALLY confused. Can you post a stack trace? Doh, I just noticed - this conversation should be on the new list. Maybe it's time to start this as a new thread and give us the stack trace and the relevant code anew. :) The ibatis project has moved and been renamed. It is no longer being

Re: Transaction Rollback not working with iBatis + Spring

2010-07-21 Thread Larry Meadors
You don't need the batch, and I'm pretty sure it won't ever work with the batch because the inserts don't happen when you call them (they happen when you call executeBatch()) so your ids don't get set when you expect them to. Remove the lines related to the batch, and I think it'll work. Larry

Re: ibatis 3 and calling stored procedure

2010-06-28 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: Passing Oracle Table Types (Is it possible?)

2010-06-19 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user -

Re: Lazy Loading per ResultMap

2010-06-17 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: SQLMap Question - Select Statement

2010-06-15 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user -

Re: Select from View (as opposed to table) using iBatis

2010-06-10 Thread Larry Meadors
Are you connecting as the same use that your code is connecting as? The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining t

Re: iBATIS 3 dynamic sql 'foreach' list got problem.

2010-06-08 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: Cause: java.sql.SQLException: Closed Connection

2010-06-07 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: iBatis 3: dynamic sql and numeric property type problem

2010-06-07 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: Possible to get ibatis to throw an exception if not all params are filled in?

2010-06-03 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: JPetstore5.0+mysql error:XXXX in field list is ambiguous

2010-06-03 Thread Larry Meadors
The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-user L

Re: Mapping an Array of String

2010-06-01 Thread Larry Meadors
FYI: The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining the mailing list here: http://groups.google.com/group/mybatis-us

Re: iBatis 3: dynamic sql and numeric property type problem

2010-05-31 Thread Larry Meadors
I think you can just say , but I haven't done this exact thing yet. Since we're using ognl for expressions, here's where I'd look: http://www.opensymphony.com/ognl/html/LanguageGuide/index.html Also, you should join and post to the new list at google: http://groups.google.com/group/mybatis-user i

Re: iBATIS with Java, SQL Server 2008

2010-05-24 Thread Larry Meadors
It's super easy - I use the freetds jdbc driver and it just works. However, use mybatis instead: http://www.mybatis.org/ The entire ibatis development team has moved there instead of remaining with the ASF due to technological issues and philosophical differences. :) Larry -

Re: resultType="list" contains null values

2010-05-20 Thread Larry Meadors
You want resultType to be a bean or map or maybe even integer - list will give you a list of lists, which is *not* what you want. :) Larry On Thu, May 20, 2010 at 4:57 AM, JohannesK wrote: > > Hello > > I am having the weirdest problem with Ibatis 3. Here is my mapper XML: > >         >        

Re: ibatis3 : multiple parameters in statement without map or bean

2010-05-17 Thread Larry Meadors
Yes, you have to annotate the parameters (because java reflection is kinda weak). It's in the user guide. Larry On Mon, May 17, 2010 at 4:15 AM, Nicolas ANTONIAZZI wrote: > Hi, > Is it possible to pass multiple parameters in iBatis3 without having to pass > a map or a bean ? > example : >

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Larry Meadors
He wants to represent that in the xml config. Larry On Thu, May 13, 2010 at 2:35 PM, Jeff Butler wrote: > It took me a while to figure it out also! > > Create your SqlSessionFactory as normal, then add the interfaces manually: > >     sqlSessionFactory.getConfiguration().addMapper(SomeMapperInt

Re: xml persistence

2010-05-13 Thread Larry Meadors
No. On Thu, May 13, 2010 at 4:30 AM, Zhong Nanhai wrote: > Hi, > > Does iBatis support XML persistence, i.e. take an XML file as a database? > > > Best Regards, > Zhong Nanhai > > - > To unsubscribe, e-mail: user-java-unsubscr...

Re: Injecting an iBatis DAO

2010-05-07 Thread Larry Meadors
On Fri, May 7, 2010 at 8:21 PM, Maciej Radochonski wrote: > From technical point of view it is ok, but I would suggest to keep all the > database related code in DAO class, because what are you doing here is > mixing two layers that should be kept separate, BO and DAO. I couldn't disagree more. :

Re: Injecting an iBatis DAO

2010-05-07 Thread Larry Meadors
Yes. On Fri, May 7, 2010 at 7:29 AM, Giorgio Vespucci wrote: > Hi all > > My question is about if an iBatis Dao can be injected in a non-DAO class to > use its services. > > Can I write so? > > > public SomeThing methodOfNonDaoClass() { > > try { > dao.startTransaction(); > dao.startBatch(); > >

Re: Specify more than one parameter in select statement without using deprecated parameterMap

2010-05-05 Thread Larry Meadors
Pass a bean or Map with those attributes, and you should be good to go. On Wed, May 5, 2010 at 2:17 AM, Thomas Mair wrote: > Hi, > i am just starting to play with iBatis 3 and can not figure out how to > declare more than one parameter in a select statement in XML without > using the parameterMap

Re: date in where clause does not work.

2010-05-04 Thread Larry Meadors
Hm, odd - I've done this hundreds of times with oracle - just passing a Date object. Send the relevant code. Larry On Tue, May 4, 2010 at 9:11 AM, Jeremy Jardin wrote: > > Hi, > > I'm simply trying to build a request with Date comparaisons.. and ibatis > still reply me empty list.. > > My gene

Re: IBatis: boolean mapping misunderstanding

2010-05-03 Thread Larry Meadors
OK, so you have a boolean in your bean, and a tinyint in your database and it's getting mapped to true regardless of the int value. What about insert/update? Are they setting the database to 0 and 1, or always using the same value? Larry --

Re: IBatis: boolean mapping misunderstanding

2010-05-03 Thread Larry Meadors
lock_operations.date) as lastActionDate, >                clock_operations.clock_in as clockedIn >                FROM users, >                clock_operations >                WHERE users.id=clock_operations.user_id AND > users.username=#{username} >                AND u

Re: IBatis: boolean mapping misunderstanding

2010-05-03 Thread Larry Meadors
Maybe with some info. Using ibatis2 or 3? Can you provide your mapped statement? Throw us a bone here. :P Larry On Mon, May 3, 2010 at 3:09 AM, vadboss wrote: > > I have in the table a boolean (tinyint(1)) value. I don't know why, but > ibatis always gets it as true, whether it is 0, or 1 in

Re: iBatis Wiki page down?

2010-04-30 Thread Larry Meadors
Yeah, it's humped. Apparently there was an "upgrade". :/ Larry On Fri, Apr 30, 2010 at 12:39 PM, Jon Webb wrote: > Is it just me, or is the iBatis Wiki/FAQ page always down? Whenever I go to > http://opensource.atlassian.com/confluence/oss/display/IBATIS/Home I get a > blank page. Or is my comp

Re: Select environment using XML

2010-04-28 Thread Larry Meadors
That's not runtime, either. :) I think Alex's solution is adequate for the original question, but if you really want to change it up on the fly, you should be able to easily replace the SSF (assuming you have it as a singleton) the same way - and if you add a function to your app that does it...ba

Using auto-discovery for ibatis3 configuration - works great, less XML

2010-04-26 Thread Larry Meadors
I spent the weekend exploring how to use convention-based configuration with ibatis3 on a new project I'm working on. Open source is great, so I lifted the Stripes ResolverUtil class to assist me in finding classes that I then wired into my ibatis configuration at startup. For example: - I have

Re: Problem with sql map XML files inside jar

2010-04-26 Thread Larry Meadors
Everything everywhere should always be utf-8, IMO. ;-) ISO-8859-1, WIN-1251, and MacRoman are all of the devil. Larry 2010/4/26 Björn Raupach : > Ok, solved my issue. I added the following statement before instantiating > SqlSessionFactory. > > [..] > Resources.setCharset(Charset.forName("UTF-

Re: inserting special characters

2010-04-17 Thread Larry Meadors
...or since you're using ibatis2, #param# instead of $param$. :) On Sat, Apr 17, 2010 at 2:55 AM, Andrius Juozapaitis wrote: > It's likely that you used the ${param} notation that includes the string in > query instead of #{param}, which binds a prepared statement parameter. > regards, > Andrius

Re: Ibatis Mysql Sql error but sql runs fine

2010-04-12 Thread Larry Meadors
Try $tableName$. On Mon, Apr 12, 2010 at 4:17 PM, Corporate Tool wrote: > > I am creating a table dynamically. > > >         CREATE TABLE #tableName# ( >         id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, >         symbol CHAR(3), >         date DATE, >         time TIME, >         INDEX(time),

Re: Insert using a Map

2010-04-08 Thread Larry Meadors
#permission.id# On Thu, Apr 8, 2010 at 1:59 AM, flanagann wrote: > > Hello, hope you can help me with this issue. > > I'm trying to do an INSERT operation as follows: > > "java.util.Map"> >        INSERT INTO FOO_TABLE (ID1, ID2) VALUES >        (#permissionsGroupId#,  #permission#.id) > > > Th

Re: SqlSession.close() without committing

2010-04-07 Thread Larry Meadors
On Wed, Apr 7, 2010 at 11:04 AM, Clinton Begin wrote: > There was once a man named Larry, > Who felt my code was scary, > For the code at which he balked, > He wrote JavaDocs, > And left the community merry. LOL! Should I be worried that you're writing poetry about me? :-D I guess I'll just be g

Re: SqlSession.close() without committing

2010-04-07 Thread Larry Meadors
There never has and most likely never will be an ibatis "specification". Larry On Tuesday, April 6, 2010, cowwoc wrote: > > > Yes, iBATIS will rollback the connection if it deems it necessary.  The only > time you might need to call rollback explicitly is if you have a "select" > that actually

Re: Preferred tool for database modeling and generating SQL / DDL

2010-04-01 Thread Larry Meadors
I use Aqua Data Studio, it's a java app. François: SQL Editor looks pretty nice, I may have to try it. :) Larry 2010/4/1 François Schiettecatte : > Josh > > On the Mac I used an application called SQLEditor which I have found to be > pretty good: > >        http://www.malcolmhardie.com/sqledit

Re: newbie Q: get back generated key with Oracle

2010-03-24 Thread Larry Meadors
It should set the id property on the Business bean passed in as a parameter. Larry On Wed, Mar 24, 2010 at 12:11 PM, Morearty, Brian wrote: > Hi, here’s a newbie question: > > > > I’m using iBATIS, Ibator, and Oracle. I have a “businesses” table. I also > created a “businesses_sequence” sequenc

Re: return simple String[] or List

2010-03-24 Thread Larry Meadors
You want result*Class*="java.util.String" - not result*Map*="java.util.String". Larry - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

Re: Problem with Character Encoding

2010-03-12 Thread Larry Meadors
I just happen to have spent the last month wrestling with Oracle and UTF-8 encoding. I had to deal with BLOBs, but Strings should be easier. Oracle stores VARCHAR2, VARCHAR, and CLOB fields as unicode and when the driver fetches the value, it goes into a String which is just an array of unicode ch

Re: Problem with Character Encoding

2010-03-12 Thread Larry Meadors
t;> 937.830.8242 >> 937.830.6027 >> >> --- @ WiseStamp >> Signature<http://my.wisestamp.com/link?u=2hxhdfd4p76bkhcm&site=www.wisestamp.com/email-install>. >> Get it >> now<http://my.wisestamp.com/link?u=2hxhdfd4p76bkhcm&site=www.wisestamp.

Re: Problem with Character Encoding

2010-03-05 Thread Larry Meadors
I'd look for info on the oracle connection string, it's not really an ibatis thing. I think that it happens that way by default though. Where are you seeing the "?" characters? Larry On Fri, Mar 5, 2010 at 2:44 PM, John Seer wrote: > > Hello, > > We am currently using Oracle DB with default u

Re: java.util.UUID to postgres uuid column

2010-02-28 Thread Larry Meadors
umn > > > > With this approach i tried this in a query - > >     resultMap="fullResult" cacheModel="cache"> >     SELECT users.* >     FROM users >     WHERE id = #id# >     > > > When i call this query as - > >     sql

Re: iBatis 3.0 minimal complete example

2010-02-10 Thread Larry Meadors
On Wed, Feb 10, 2010 at 6:21 PM, Clinton Begin wrote: > Anyone and everyone is welcome (and encouraged) to create a JPetStore > implementation with iBATIS using whichever framework they like. > Rails it is. ;-) Larry - To unsub

Re: iBatis 3.0 minimal complete example

2010-02-10 Thread Larry Meadors
On Wed, Feb 10, 2010 at 2:21 PM, Rick R wrote: > And without leveraging Guice or Spring :) Rick, you pansy. ;-) - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ib

Re: java.util.UUID to postgres uuid column

2010-02-09 Thread Larry Meadors
This might work: public class UUIDTypeHandler implements TypeHandlerCallback { @Override public void setParameter(ParameterSetter setter, Object parameter) throws SQLException { setter.setObject(parameter); } @Override public Object getResult(ResultGetter getter) throw

Re: table name as parameter

2010-02-08 Thread Larry Meadors
Try this: select * from ${value} Larry On Mon, Feb 8, 2010 at 3:57 PM, Tom Carchrae wrote: > > > > nmaves wrote: >> >> I would double check that you are not sending in null as the table name. >> > > I am passing in a non-null string.  But it is definitely a problem caused by > the table name n

Re: Dropping down to JDBC.

2010-01-20 Thread Larry Meadors
> connection object returned by this SimpleDataSource object? or is > there some other way to return the connection back to the pool? > > Regards, > > Wesley Acheson > > On Wed, Jan 20, 2010 at 3:12 PM, Larry Meadors > wrote: >> sqlMapClient.getDataSource(); >>

Re: Dropping down to JDBC.

2010-01-20 Thread Larry Meadors
sqlMapClient.getDataSource(); On Wed, Jan 20, 2010 at 7:05 AM, Wesley Acheson wrote: > Hi all, > > we have a need to drop down to a JDBC query at some point in our application. > > Is it possible to get a connection from the SimpleDataSource pool.  (I > see that this is a method on SimpleDataSour

Re: update without set element

2010-01-20 Thread Larry Meadors
Do this in Java code. Doing it in xml is kinda silly. :) Larry On Wed, Jan 20, 2010 at 12:00 AM, masonka...@libero.it wrote: > Hi, > > I have a write a update statement with condition on every set element. > If > no condition are matched set part are empty, but where part is already created > a

Re: How about a Netbeans integration plugin?

2010-01-02 Thread Larry Meadors
I think that is a great idea - I think google's got better infrastructure than Apache. :-/ Larry On Sat, Jan 2, 2010 at 9:19 PM, Clinton Begin wrote: > What do you guys thing of creating a google code project for iBATIS > plugins?  This would avoid the need to get everyone signing CLAs and woul

Re: working with "raw" maps instead of entities?

2009-12-17 Thread Larry Meadors
17, 2009 at 5:20 AM, Kristian Rink wrote: > Larry Meadors schrieb: >> >> Interesting idea - so you end up with something like this? >> >> myEntity.id >> myEntity.name >> myEntity.attributes.someField >> myEntity.attributes.someOtherField > > Yes,

Re: working with "raw" maps instead of entities?

2009-12-17 Thread Larry Meadors
Interesting idea - so you end up with something like this? myEntity.id myEntity.name myEntity.attributes.someField myEntity.attributes.someOtherField You could do that, but since you're doing "select *" you'd have to do it with a result map or row handler. Larry On Thu, Dec 17, 2009 at 1:32 AM

Re: Ibator and Microsoft Access

2009-12-12 Thread Larry Meadors
Yes, the jdbc-odbc bridge is not really intended for real use, and sucks pretty bad. Without knowing why you are using access, it's hard to recommend a course of action - if you can use a different DB, by all means, do. Access is hands down the crappiest choice you could make. :) If you are using

Re: Search for character '_', '%' wildcard characters using ibatis

2009-12-11 Thread Larry Meadors
You should be able to do it the same way with ibatis...did you try it? Did you get an error? Can you pass the error along? Larry On Fri, Dec 11, 2009 at 1:42 AM, crmanoj wrote: > > I am developing a webapplication using Struts for which oracle is a backend. > For connectivity i am using iBatis.

Re: Issues with Ibatis Configuration File

2009-12-09 Thread Larry Meadors
Move the typeAliases section above environments. Larry On Wed, Dec 9, 2009 at 2:54 PM, Soks86 wrote: > > Hi, > > I have created the following configuration file for my Ibatis > SqlSessionFactoryBuilder. > > >  PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN" >  "http://ibatis.apache.org/dtd

Re: Using iBatis just for generating 'Dynamic SQL'

2009-12-09 Thread Larry Meadors
On Tue, Dec 8, 2009 at 11:44 PM, Prem75 wrote: > 2. Does iBatis have a professional support that we can sign up for? Several of us (Brandon, Nathan, and myself) are full-time contract developers. I'd love to work with you, and I suspect the others would as well. That would be a conversation to h

Re: IBatis 3 Exceptions

2009-12-04 Thread Larry Meadors
Email the server admin? :D Larry On Fri, Dec 4, 2009 at 10:27 AM, Rick.Wellman wrote: > Agreed on both points below… but am curious to the community at large… has > anyone come up with something useful to do on a database exception other > than apologize to the user?  This might be a good forum

Re: Re: Error updating database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

2009-11-25 Thread Larry Meadors
Hm, it seems to have cut off the useful parts - the swing and awt stuff doesn't help at all. :( What driver are you using? Larry On Tue, Nov 24, 2009 at 11:57 PM, masonka...@libero.it wrote: > Here my stack trace: > > org.apache.ibatis.exceptions.IbatisException: > ### Error updating database.

Re: OOM with millions of weakly-referenced Derby objects

2009-11-17 Thread Larry Meadors
The expected behavior is really dependent upon the underlying JDBC driver. Using the maxRows parameter is a last resort option, IMO. Limit the results with the SQL if at all possible, here's an example: http://old.nabble.com/top-N-reporting-with-derby-td17221545.html Larry On Tue, Nov 17, 200

Re: iBATIS policy to JDK 1.6 support

2009-11-11 Thread Larry Meadors
There is no ibatis 'specification', it's just a library. Larry On 11/11/09, i-fujiwara wrote: > Thank you for your reply. > > > iBATIS 2 is also working fine with JDK 6. > > Is it specified in iBATIS specification? > I want to know whether JDK 1.6 is supported by iBATIS specification or not.

Re: static SqlMapClient and transaction isolation problem

2009-10-22 Thread Larry Meadors
On Thu, Oct 22, 2009 at 9:03 AM, User 080701 wrote: > > If I create a static SqlMapClient to service many threads, does ibatis > guarantee transaction isolation ? yes. > e.g. If one thread start the transaction and not commit, >      if another thread start the transaction using the same sqlMapC

Re: iBatis - Connections to PostgreSQL Not Closing

2009-10-19 Thread Larry Meadors
OK, you need to refactor that. :-) The sqlMap should only be created once. I'm not a struts2 user, so I can't say what the appropriate way to do that is. :-/ If you just want to go ghetto style, you could use a static variable to hold it and initialize it when the class is loaded...but I'd really

Re: iBatis - Connections to PostgreSQL Not Closing

2009-10-19 Thread Larry Meadors
On Mon, Oct 19, 2009 at 1:17 PM, Jim Borland wrote: > pool.  I hadn't thought about that before.  I guess the bottom line is I > don't really understand what is happening in a connection pool.  Still, my > situation is so simple, yet the same bad outcome occurs no matter what I > try.  Help! > A

Re: iBatis - Connections to PostgreSQL Not Closing

2009-10-19 Thread Larry Meadors
the purpose of a connection pool.  i.e. You're trying to >>>> explicitly open a connection with code.  The connection pool will >>>> usually expand and contract the number of connections to the database >>>> based on the load and its configuration (which is

Re: iBatis - Connections to PostgreSQL Not Closing

2009-10-19 Thread Larry Meadors
This looks to me like you are *way* overcomplicating this. :-) The method should be more like this: public List getArtistInfo(){ return sqlMap.queryForList("getArtistInfo", list); } Unless you have some really crazy wacky stuff going on, there should never be a need for you to deal with connec

Re: Password Encryption

2009-10-16 Thread Larry Meadors
:) ...and if I can get to one of those files I can get to the other and still own your password in a matter of minutes. Larry On 10/15/09, Ejaz X Mohammed wrote: > Works! > > I just override the initialize method ... > > public void initialize(Map map) { > EventConfig ec = EventCo

Re: Problem when parsing dao.xml

2009-10-07 Thread Larry Meadors
Nah, mockito is cooler than even guice. It's the shiz. If you can't test your code with mockito...go home or become a manager. ;-) Larry - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands,

Re: Problem when parsing dao.xml

2009-10-07 Thread Larry Meadors
If you are creating an app that uses the ibatis dao... Stop. Now. Seriously. It's dead. Look at using Guice (my preference) or Spring (if you love xml). Larry - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org Fo

Re: Database Connection reset on Oracle 10g AS using Oracle 11g database

2009-10-06 Thread Larry Meadors
Use "select 1 from dual" instead. On Tue, Oct 6, 2009 at 10:57 AM, Jasmin Mehta wrote: > I have changed my spring.xml accordingly: > > class="org.apache.commons.dbcp.BasicDataSource" >destroy-method="close"> > > > > > >

Re: connection problem using ibatis2.3+postgresql8.3+glassfish2 ( An I/O error occured while sending to the backend.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException)

2009-09-10 Thread Larry Meadors
Probably a stale connection. Google for "org.postgresql.util.PSQLException: An I/O error occured while sending to the backend" Larry On Thu, Sep 10, 2009 at 8:01 PM, Donmis wrote: > > HELP HELP!!! > :,( > -- > View this message in context: > http://www.nabble.com/connection-problem-using-ibat

Re: Insert statement returns generated key

2009-08-28 Thread Larry Meadors
Couldn't you call it just as a procedure? Larry On Fri, Aug 28, 2009 at 9:02 AM, Clinton Begin wrote: > I don't, but that's pretty awesome that you figured that out and it works... > LOL.  :-) > > Clinton > > On Fri, Aug 28, 2009 at 8:56 AM, Beary, Nick (EHQ) > wrote: >> >> Hello, I looked arou

Re: Why in Application is worked, but in JSP don't worked?

2009-08-24 Thread Larry Meadors
Stripes is awesome. On Mon, Aug 24, 2009 at 8:11 AM, bhaa wrote: > > Thinks, I shall look now it. > > Poitras Christian wrote: >> >> Hi, >> >> You can see JSP as being close to an HTML page. It is better if you never >> put any scripting in a JSP (being <% %>). >> Many frameworks exists to simplif

Re: Why in Application is worked, but in JSP don't worked?

2009-08-24 Thread Larry Meadors
Good heavens, why would you EVER put that in a jsp? If you have to, the error is "Unable to compile class for JSP: An error occurred at line: 1 in the generated java file The type com.ibatis.sqlmap.client.SqlMapClient cannot be resolved. It is indirectly referenced from required .class files" Loo

Re: Newbie question: Update table that has no key / id

2009-08-23 Thread Larry Meadors
You can do it a few ways, I think I'd put the old values and new values in a bean, then put those beans in a map and call them "old" and "new". Pass that map to the update and change it to this: update user_approvers set region_name = #new.region:VARCHAR#, division_na

Re: Separate iBATIS3 mailing list

2009-08-21 Thread Larry Meadors
f "me too" replies on the initial post, a separate list wasn't on the top of anyone else's list. ;-) Larry On Fri, Aug 21, 2009 at 5:40 AM, Nicholoz Koka Kiknadze wrote: > No. > > Lol > > On Fri, Aug 21, 2009 at 3:23 PM, Larry Meadors > wrote: >>

Re: Separate iBATIS3 mailing list

2009-08-21 Thread Larry Meadors
Because it's a bad idea. Happy? Larry On Fri, Aug 21, 2009 at 12:47 AM, Nicholoz Koka Kiknadze wrote: > No reply... > > Seems separate list idea is soo absurd that no one bothers to explain why ;) > > On Tue, Aug 18, 2009 at 10:00 PM, Nicholoz Koka Kiknadze > wrote: >> >> I've enjoyed much usi

Re: Feature for iBatis

2009-08-19 Thread Larry Meadors
...or you could turn on logging. :) On Wed, Aug 19, 2009 at 12:25 PM, Trenton D. Adams wrote: > Hi Guys, > > I thought of a feature that may be useful.  iBatis, upon an SQLException, > could put the entire SQL, with the parameters that were passed, into the new > NestedSQLException that it throw

Re: Request for input on porting iBatis XML from 2.x to 3.0

2009-08-18 Thread Larry Meadors
Thanks for sharing! You rock. Larry On Tue, Aug 18, 2009 at 3:20 PM, Joel Barciauskas wrote: > Hey everyone, > > > > I just posted the notes that I took as I worked on porting my 2.x XML > mapping and configuration files to the wiki: > http://opensource.atlassian.com/confluence/oss/display/IBAT

Re: updated iBatis In Action book?

2009-08-18 Thread Larry Meadors
On Mon, Aug 17, 2009 at 10:39 PM, Nathan Maves wrote: > on a serious note I have some ibatis in action books for sale, get them > before they get outdated Ha, I have a spare one in Korean. ;-) Free to a good home. Just swing by and pick it up, because I'm *so* not shipping it to Korea... Larry

Re: Who wants to write JPetStore 6 (or any other example)?

2009-08-13 Thread Larry Meadors
Mark? On 8/13/09, Steven A wrote: > well now that you've nixed the requirements, I'll get started on > JCallGirlStore tonight fukkes! > > > spring + springmvc + freemarker + prototype + boobies = goodness > > On Thu, Aug 13, 2009 at 2:37 PM, Larry Meadors >

Re: Who wants to write JPetStore 6 (or any other example)?

2009-08-13 Thread Larry Meadors
"Even if.."? I'd say "ESPECIALLY IF ..." We'd never have to answer "How do you ibatis with _?" again! :D Larry On Thu, Aug 13, 2009 at 3:35 PM, Brandon Goodin wrote: > LOL... I'm mostly playing. I hope we can all have fun with this. Spring is > certainly a fine enough solution. In then end

Re: Who wants to write JPetStore 6 (or any other example)?

2009-08-13 Thread Larry Meadors
That is a great idea! I wish i had more time to do it :) Larry On Thu, Aug 13, 2009 at 3:32 PM, Clinton Begin wrote: > Why don't you all implement it however you like, then we'll have a vote on > the best implementation.  That would be awesome. > > iBATIS PetStore 6 Competition -- Go! > > Clint

Re: updated iBatis In Action book?

2009-08-12 Thread Larry Meadors
Not it. On Wed, Aug 12, 2009 at 5:45 PM, tomasz brymora wrote: > Greetings! > Should we expect an updated version of the iBatis In Action book anytime > soon? > Thanks, t > - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.a

Re: Confirming on parameterMap versus ParameterClass

2009-08-06 Thread Larry Meadors
I think I wrote that part and that it is wrong. :-/ A better description of the performance is this: If you define a parameter map, the time to build the parameter map is taken at startup. If you don't define a parameter map, the time to build the parameter map is taken on the *first call* to the

Re: PL/SQL package level variables

2009-08-04 Thread Larry Meadors
You can use an anonymous pl/sql block in ibatis, too. Larry On Mon, Aug 3, 2009 at 11:59 PM, Nicholoz Koka Kiknadze wrote: > Hm, but I have used package variables at Oracle 9 times (with JDBC though, > but iBatis just wraps JDBC) and it worked fine. > > May I ask how do you handle transactions,

Re: how to do error handling?

2009-07-30 Thread Larry Meadors
Put all the code you don't want to execute in the try block. Larry On Thu, Jul 30, 2009 at 4:06 PM, Bhaarat Sharma wrote: > Hi guys, > I have a few questions on how to handle errors that are thrown when iBatis > calls the Stored Procedures. > Assuming i have the following code: > results_list =

Re: Pagination by objects

2009-07-27 Thread Larry Meadors
I'll put this as nicely as I can: What the heck are you talking about? Larry - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

Re: LazyLoading and CGLIB return wrong types

2009-07-23 Thread Larry Meadors
es will > create problems when deserializing because maybe the application that will > deserialize is not using iBatis. Can't I just disable lazy loading and CGLIB > for performing serialization ? > > Regards > > > Larry Meadors wrote: >> >> They are still Addres

Re: weird behavior

2009-07-22 Thread Larry Meadors
On Wed, Jul 22, 2009 at 12:29 PM, David McReynolds wrote: > There are only two kinds of programming errors: "stupid programmer > mistakes and stupid programmer mistakes". > > Brandon Goodin wrote: >> perhaps you haven't specified a resultClass/resultMap? I've never spent a day trying to figure tha

Re: LazyLoading and CGLIB return wrong types

2009-07-22 Thread Larry Meadors
They are still Address objects, just enhanced ones. Larry On Wed, Jul 22, 2009 at 7:58 AM, Dawson Lewis wrote: > > Hi , > > I have an object with a List property - List addresses, after > iBatis populates this object  the addresses fields will not contain a list > of address objects but a List$$

Re: problem with insert

2009-07-15 Thread Larry Meadors
It's early but those look identical to me. Larry On 7/15/09, Odelya YomTov wrote: > Thank you > > The problem was that I had: > > useUnicode=yes&characterEncoding=utf8 > > > > instead of: > > > > useUnicode=yes&characterEncoding=utf8 > > > > in the url > > > > From: Nicholoz Koka Kiknadze [mai

Re: R: SqlMapClient multithread applications

2009-07-14 Thread Larry Meadors
re any best practice? == speed up application end avoid loading every >> time the same config files > > -Messaggio originale- > Da: larry.mead...@gmail.com [mailto:larry.mead...@gmail.com] Per conto di > Larry Meadors > Inviato: venerdì 5 gennaio 2007 16.19 >

Re: JUnit DAO queries test OK but JUnit DAO non-queries are a mystery?

2009-07-05 Thread Larry Meadors
Transactions? That's my guess. Larry On Sun, Jul 5, 2009 at 7:51 PM, David Brown wrote: > Hello iBatis dev, gurus, users and mortals, I have a very curious situation > with 6 testcase methods: 4 queries and 2 non-query. The 4 queries are some > form of select against a where clause and an Inte

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-03 Thread Larry Meadors
ervices. Is there > a specific reason for taking it out? > > Fred > > On Thu, Jul 2, 2009 at 21:34, Larry Meadors wrote: >> >> FYI: XML parameters and results are on the way out with ibatis 3. >> >> Larry >> >> >> On Thu, Jul 2, 2009 at 2:06 AM,

Re: queryForObject/queryForList where is the documentation for the "Object parameter"?

2009-07-02 Thread Larry Meadors
FYI: XML parameters and results are on the way out with ibatis 3. Larry On Thu, Jul 2, 2009 at 2:06 AM, meindert wrote: > Hi Fred, > > > > The XML parameter object is quite interesting, it doesn’t look like ibatis > can handle a ‘XML object’ the same way as it can return a XML string object; > >

Re: Ibator plugin use and future plans

2009-06-23 Thread Larry Meadors
On Tue, Jun 23, 2009 at 8:54 AM, Jeff Butler wrote: > Warning - heavy Eclipse acronyms follow! Why does the theme song to the Mickey Mouse show keep running through my head after reading this? ;-) Larry

Re: unsubscribe

2009-06-23 Thread Larry Meadors
http://ibatis.apache.org/mailinglists.html

Re: unsubscribe

2009-06-21 Thread Larry Meadors
http://ibatis.apache.org/mailinglists.html On Sun, Jun 21, 2009 at 9:00 AM, Sameeh Harfoush wrote: > unsubscribe

Re: Suggest that "resultMap" add a "ignoreNotExists" attribute.

2009-06-18 Thread Larry Meadors
Easy route: select a, b, null as c from x If you feel really, really strongly that it is added, get the source from svn and do so. :-) Larry On Thu, Jun 18, 2009 at 5:41 AM, joson yu wrote: > hi liangfei: >  i meet a situation,just like your example,i need to use the same resultmap

Re: Please HELP - IBatis not throwing Unique constraint exception

2009-06-17 Thread Larry Meadors
Are you using ibatis dao? It rethrows them as a DaoException which is a RuntimeException, IIRC. Larry On Wed, Jun 17, 2009 at 10:59 AM, Ivan Bojer wrote: > Hi, > > I have a problem where IBatis never throws any of the constaint > exceptions. My set-up is: > - postgresql 8.3.5 > - postgres JDBC

  1   2   3   4   5   6   7   8   9   10   >