creating tables and dynamic configiration

2005-06-09 Thread Brandon Goodin
-- Forwarded message -- From: Brandon Goodin <[EMAIL PROTECTED]> Date: Jun 9, 2005 4:26 PM Subject: Re: creating tables and dynamic configiration To: [EMAIL PROTECTED] larry's idea is better. Mine sucks. Brandon On 6/9/05, Larry Meadors <[EMAIL PROTECTED]> w

Re: creating tables and dynamic configiration

2005-06-09 Thread Brandon Goodin
Dmitry, you can still use the ThreadLocal strategy without the connection pool stuff. In a client side app i am assuming you would only need one connection. So, you could write your own datasource factory that implements the DataSourceFactory interface and your own DataSource which implements the

Fwd: creating tables and dynamic configiration

2005-06-09 Thread Brandon Goodin
-- Forwarded message -- From: Dmitry Skavish <[EMAIL PROTECTED]> Date: Jun 9, 2005 3:35 PM Subject: Re: creating tables and dynamic configiration To: Brandon Goodin <[EMAIL PROTECTED]> Let me explain. I am developing a client side app, that is with gui and such, n

Re: using #value[]#

2005-06-09 Thread Brandon Goodin
ange with the mailing > list server or is this just a weird gmail thing? The reply-to on > every message I get is set to the person who sent it, not the list. > So when I hit reply, it puts the person who sent the message in there. > > On 6/9/05, Brandon Goodin <[EMAIL PROTECTED]>

Re: using #value[]#

2005-06-09 Thread Brandon Goodin
okay, post your final statement. I'll test it this evening with jdk1.5 to see if i get the same results. Brandon On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote: > Oops. I did move it inside the iterate tag where it belongs, but that > didn't fix my problem, still same exception as before. > >

Re: using #value[]#

2005-06-09 Thread Brandon Goodin
getting > > the same exception. > > > > I am calling it this way (uses SpringFramework 1.1.5 SqlMapClientDaoSupport) > > > > public Map findCountsBySession(List sessionIds) { > > return > > getSqlMapClientTemplate().queryForMap("event.findCountsB

Re: creating tables and dynamic configiration

2005-06-09 Thread Brandon Goodin
#1 not intentionally #2 I'm not sure what xml generation has to do with this issue. Maybe i am misunderstanding you. If you are developing a web application you will have to do something like what was provided if you want individuals to use their own username and password for database access. Cons

Re: dynamic update -> comma prob

2005-06-09 Thread Brandon Goodin
Zurke <[EMAIL PROTECTED]> wrote: > ok, but what if name is not available and othername is? > > Brandon Goodin wrote: > > > > UPDATE public.master > > SET > > > >name= #name# > > > > > >

Re: using #value[]#

2005-06-09 Thread Brandon Goodin
am calling it this way (uses SpringFramework 1.1.5 SqlMapClientDaoSupport) > > public Map findCountsBySession(List sessionIds) { > return > getSqlMapClientTemplate().queryForMap("event.findCountsBySession",sessionIds,"id","count"); > }

Re: using #value[]#

2005-06-09 Thread Brandon Goodin
SELECT session_id as id, count(*) count FROM events #value[]# GROUP BY session_id Brandon On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote: > I am using iBatis 2.1.0.565 with JDK 1.5.0. I am trying to pass a > List to a sqlmap and then

Re: creating tables and dynamic configiration

2005-06-09 Thread Brandon Goodin
1) iBatis does not support DDL script execution. 2) http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials%3F Brandon On 6/9/05, Dmitry Skavish <[EMAIL PROTECTED]> wrote: > Hello everybody, > > I am pretty new to iBATIS, but already love it!

Re: 32k limitations for clob/blob?

2005-06-09 Thread Brandon Goodin
--- The error occurred while applying a parameter map. > [java] --- Check the insert_long-InlineParameterMap. > [java] --- Check the statement (update failed). > [java] --- Cause: java.sql.SQLException: ORA-01461: can bind a LONG > value o > nly for insert into a LONG c

Re: 32k limitations for clob/blob?

2005-06-09 Thread Brandon Goodin
I'm not aware of this limitation. We have run into similar things before with the oracle driver. But, upgrading has always fixed it. Have you attempted a test using straight JDBC? Brandon On 6/9/05, Henry Lu <[EMAIL PROTECTED]> wrote: > I got the following errors when I insert a large text into a

Re: dynamic update -> comma prob

2005-06-09 Thread Brandon Goodin
UPDATE public.master SET name= #name# othername = #othername# WHERE id = #id# On 6/9/05, Michael Zurke <[EMAIL PROTECTED]> wrote: > hi, > > i got the following statement: > > >UPDATE public.master >

Re: Calling DAO within TypeHandlerCallback

2005-06-09 Thread Brandon Goodin
t are undone." > > Since there are no changes when just reading, this sounds as a complex > solution. Any thoughts on all these questions? > > Thanks, > > Niels > > -Original Message- > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: vrijdag

Re: JNDI , WebSphere Datasource question

2005-06-09 Thread Brandon Goodin
That is not an option because that is not how JNDI works. Are you saying that you need to pass a username/password to your datasource for each individual user or do you simply want to configure it dynamically for the whole application? If it is the latter then you are trying to configure your JNDI

Re: groupBy

2005-06-08 Thread Brandon Goodin
xisting property? > > > > By the last example everything (ofcourse in the context of groupBy :) > > ) became more clear. > > > > And one more question. As I see, you prefer to put a product list to > > category class, but you do not prefer to put a category refere

Re: groupBy

2005-06-08 Thread Brandon Goodin
pulate the Category and this can be accomplished with the groupBy. But, in this approach it is not really resolving a circular. Because the queries are directional and avoid the circular. Brandon On 6/8/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > you could solve it this way depending on th

Re: groupBy

2005-06-08 Thread Brandon Goodin
s this the prefered way to implement this kind of > relationships especially where circular dependencies exist? > > Thanks. > > -- Ersin > > Brandon Goodin wrote: > > >The real issue that is addressed with the groupBy is the ability to > >use a single query for

Re: groupBy

2005-06-08 Thread Brandon Goodin
= v.itemid and c.catid = 'FISH' On 6/8/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Brandon Goodin wrote: > > >This will help you: > >http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F > > >

Re: Circular dependency?

2005-06-08 Thread Brandon Goodin
ucts, and the > Product class has a reference to a Category. How should the xml map > should be? > > Thanks in advance. > > (May I ask a few private mail questions, to not make the list > subscribers bored?) > > --- Ersin > > Brandon Goodin wrote: > > &g

Re: iBatis and multiple databases

2005-06-08 Thread Brandon Goodin
resultMap to extend another resultMap. http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/test/com/ibatis/sqlmap/maps/Documents.xml Brandon On 6/8/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > oops bad advice. Forget option (1). Mapped statements do not have > ex

Re: iBatis and multiple databases

2005-06-08 Thread Brandon Goodin
oops bad advice. Forget option (1). Mapped statements do not have extend... only resultMap. Sorry Brandon On 6/8/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > There is not one way to support multiple databases with ibatis. There > are several options to manage multiple data

Re: iBatis and multiple databases

2005-06-08 Thread Brandon Goodin
There is not one way to support multiple databases with ibatis. There are several options to manage multiple database support. Examples (1) Use the extends functionality to override particular statements that are specific to your database while leaving cross database sql statements alone. (2) sepa

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.

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

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: dynamic sql within an iterate tag

2005-06-06 Thread Brandon Goodin
Sam, Sorry, I meant to respond to you in your prior email. Currently this is not supported. But, we do want it to work. So, please file a JIRA report. I'll work on it this evening and see if i can get the fix in tonight. Brandon On 6/6/05, Abeyratne, Sam <[EMAIL PROTECTED]> wrote: > > > > H

Re: groupBy

2005-06-06 Thread Brandon Goodin
This will help you: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Hi, > > What is the porpose of "groupBy" attribute used in the SQL Mapper doc for > "Complex Collection Properties

Re: Connection leak

2005-06-06 Thread Brandon Goodin
Please provide your full transaction manager configuration. Brandon On 6/6/05, vi am <[EMAIL PROTECTED]> wrote: > Is there a way to limit the maximum number of connections (at any given > time) Apache's DBCP pool? iBATIS does seem to support DBCP. Whenever I > access JSP pages, there is const

Re: Circular dependency?

2005-06-06 Thread Brandon Goodin
Currently a circular dependency would not be possible because of the way configurations are loaded. One sql map must be loaded before the other can. So, if you attempted a circular reference it would fail during intialization because the referenced mapped statement would not be found in the configu

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
excellent! thanks Ersin. On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > > Finally, don't forget... you have the power to help. > > > > Brandon > > OK. I'll try to produce a sample section. > > -- > Ersin >

Re: Connection leak

2005-06-06 Thread Brandon Goodin
The connections are returned to the pool automatically. Your pool implementation determines how to manage the connections. So, you will see connections staying active because they continue to exist in the pool. iBatis merly checks them out and uses them. So, there is no connection leak in iBatis.

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
Let's not start a flame here. Please keep your criticisms constructive and away from the edge of insulting. The bottom line is that we should all appreciate constructive criticism. The documentation is excellent even compared to many commercial products on the market and it can ALWAYS be improved.

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
Ersin, That is true. There are some undocumented features. If there is anything that you see that is not in the documentation, please feel free to submit a patch. We are thrilled to include any valuable contributions into the docs. I do apologize for some of the features that are not documented. B

Re: [iBatis] Documentation

2005-06-06 Thread Brandon Goodin
is there a reason for a major update to the ibatis sql mapper documentation? On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Hi, > > Is there any plan for a major update for iBatis SQL Mapper documentation? > > Thanks. > > -- > Ersin Er >

Re: bug with running sybase stored procedures

2005-06-06 Thread Brandon Goodin
We made that change to accomodate Oracle drivers that use ref cursors. I am so sick of crappy lame companies who don't know how to write freakin code!!! Is this something that can be a configuration change on the transactionManager level? Thoughts anyone? Brandon On 6/6/05, [EMAIL PROTECTED] <[EM

Re: Calling DAO within TypeHandlerCallback

2005-06-03 Thread Brandon Goodin
Sounds more like we need to provide savepoints support for this kind of stuff. Nested Transactions sound yucky. Brandon On 6/3/05, Niels Beekman <[EMAIL PROTECTED]> wrote: > Yes, but they are not separate, I think the following happens: > > MyDao > getObject() > startTran

Re: Oracle XMLType support

2005-06-02 Thread Brandon Goodin
If you can pass the XML Type into a non-oracle specific Java Type/Class then you should have no problem creating a custom type handler. If the XML Type requires a database connection then you will need to stick to straight JDBC. iBatis is JDBC compliant. We provide CustomType Handlers for cases whe

Re: jpg file

2005-05-31 Thread Brandon Goodin
This should help you: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F Brandon On 5/31/05, Sergey Livanov <[EMAIL PROTECTED]> wrote: > > I use Oracle 9i, ojdbc14.jar > > -- > regards > Sergey mailt

Re: jpg file

2005-05-31 Thread Brandon Goodin
Depends on what driver and database you are using. But, if you have written a BLOB before... it wouldn't be any different for a jpg. Brandon On 5/31/05, Sergey Livanov <[EMAIL PROTECTED]> wrote: > > Looking for a piece of advice. > I want to write the jpg file in blob. > What is the best way to

Re: Dynamically add sqlMaps to Config.xml

2005-05-30 Thread Brandon Goodin
None of this functionality is currently possible. It is possible the dynamic sqlmap functionality could be added. Put in a JIRA ticket for it In regards to the space trimming... I think it needs to be discussed. It would be hard to predict what should be trimmed and what should not be trimmed. If

Re: Support for generics

2005-05-29 Thread Brandon Goodin
"If I were to ditch a layer in this 5 layer cake, I'd ditch the DAOs. :-)" Well, i wounldn't say ditch the DAO layer. I'd say make the Mapping interface your DAO layer. "I'm personally not a fan of code generation at all." I believe it would be possible to create a tool that makes the creation

Re: Dynamically add sqlMaps to Config.xml

2005-05-29 Thread Brandon Goodin
I am a bit confused as to what you are asking. Do you just want to add an sql map xml file dynamically? Brandon On 5/27/05, Steffen Legler <[EMAIL PROTECTED]> wrote: > Hi. > > We need to add dynamically sqlMaps to our SqlMapClient. > Please can you implement something like this example in furthe

Re: Struts and iBatis

2005-05-29 Thread Brandon Goodin
I'm not really sure why you need a tutorial on Struts and iBatis. iBatis is it's own product and should not depend on struts whatsoever. I think your best bet is to read the ibatis documentation and the iBatis Tutorial. I believe the Ricks tutorial is based on iBatis 1.x. There is also the JPetstor

Re: Update / subquery

2005-05-28 Thread Brandon Goodin
I'm not sure why you posted the resultMap since you do not reference it nor can you use it with an update statement. Your update statement would function perfectly fine in ibatis assuming your paramters satisfy the database. Your database is complaining that your SQL is borked. Do you have logging

Re: Stored procedures not working?

2005-05-28 Thread Brandon Goodin
Did you execute it against the database using straight JDBC with the JayBird JDBC Driver? Also, did you examine your logging output? If you have done both of these things...please post your logging output here for us to examine. Brandon On 5/28/05, Michael Glitzner <[EMAIL PROTECTED]> wrote: >

Re: Support for generics

2005-05-27 Thread Brandon Goodin
yes, build it from the trunk. On 5/27/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > Of course! > > Do I need to build it from the trunk? > > Nathan > > On May 27, 2005, at 8:32 PM, Clinton Begin wrote: > > > > > I believe the new Mapper binding functionality would resolve this > > > > Na

Re: Querying Based on Date.

2005-05-27 Thread Brandon Goodin
What is the driver and database (include version) are you using? What is the column type in the database? Brandon On 5/27/05, Cruz, Edward J. <[EMAIL PROTECTED]> wrote: > I am having trouble with a query based on a date property. Basically I need > to return data where a Transaction_Date in the

Re: Support for generics

2005-05-27 Thread Brandon Goodin
Possibly the new early binding functionality (in the TRUNK) will allow for you to use generic typing for your lists then you wouldn't need to cast them. But, that is an untested suggestion. Brandon On 5/27/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > I have done that with my DAO layer. > > Sql

Re: Support for generics

2005-05-27 Thread Brandon Goodin
This is definitely on our list to do... sometime :-p. But, it is a matter of compatibility. We have talked about creating a special ibatis version to take advantage of some of the java 5 features. But, we haven't really looked into it real deep and don't know what it would take to accomplish it and

Re: Question on dynamic Select Columns

2005-05-27 Thread Brandon Goodin
Hey Ritu, The dynamic tags examine the parameterMap or parameterClass not the resultMap. Also, since your select results will potentially differ you will need to set the remapResults="true" attribute in the . Brandon On 5/27/05, Ritu Kedia <[EMAIL PROTECTED]> wrote: > > > > Hello All, > >

Re: Cache Objects

2005-05-26 Thread Brandon Goodin
Not currently and we don't plan on supporting OID (Object Identity). There is too much baggage that comes along with it. Brandon On 5/26/05, Eloyi <[EMAIL PROTECTED]> wrote: > Hi, > I understand that the cache is over the statement, but is possible to cache > the objects that the queryforList ret

Re: Slightly off topic - Looking for the author of "Strutting your stuff with struts"

2005-05-26 Thread Brandon Goodin
If you would like to chat with him live... you can use irc and visit the #funkycodemonkey irc channel at irc.darkmyst.org. He is a regular (annoyance?) on the channel :D. But, he will not be back around until Monday. He is on a weekend trip to Tennessee Brandon On 5/26/05, eOk <[EMAIL PROTECTED]>

Re: ClobTypeHandlerCallback For Oracle 9i

2005-05-25 Thread Brandon Goodin
from what i've heard around here. you should be using the 10g driver. It works with 9i and functions better. Brandon On 5/24/05, Ronn <[EMAIL PROTECTED]> wrote: > Hi, > > I am trying to insert clobs into Oracle 9i with Oracle 10g JDBC drivers. > The problems I'm facing are: > > 1) Tried using i

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-25 Thread Brandon Goodin
Nothing you said was menacing at all. I truly look forward to folks innovating against ibatis. I hope that as we progress into the future that ibatis will become more amiable to personal taste. Brandon On 5/25/05, Huy <[EMAIL PROTECTED]> wrote: > Brandon Goodin wrote: > >

Re: Transactions

2005-05-24 Thread Brandon Goodin
ion(); > > > >finally(){doaManager.endTransaction():} > > > >Dao Layer: > >public void insertAccount(Account account) > >{ > >update("insertAccount", account); > >update("insertProfile", account); > >update("insertSig

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-24 Thread Brandon Goodin
"freemarker and velocity macros can create the same tags" The point is simply this... mixing semantics looks like hell. When you start mixing xml with velocity for no good reason your < becomes a minor blip on the radar of messy. The other reason is that you introduce the FULL ability of velocity

Re: transactions

2005-05-24 Thread Brandon Goodin
gt; >public void insertAccount(Account account) > >{ > >update("insertAccount", account); > >update("insertProfile", account); > >update("insertSignon", account); > >} > > > > > > > >-Original Me

Re: transactions

2005-05-24 Thread Brandon Goodin
ndTransaction():} > > > >Dao Layer: > >public void insertAccount(Account account) > >{ > >update("insertAccount", account); > >update("insertProfile", account); > >update("insertSignon", account); > >} > > >

Re: transactions

2005-05-24 Thread Brandon Goodin
; > -Original Message- > From: Lieven De Keyzer [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 24, 2005 3:48 PM > To: [EMAIL PROTECTED]; ibatis-user-java@incubator.apache.org; > [EMAIL PROTECTED] > Subject: Re: transactions > > > > > >From: Clinton Begin <[

Re: transactions

2005-05-24 Thread Brandon Goodin
. Brandon On 5/24/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > Message was sent to me privately... so i am posting it to the list > - > But for example, in the JPetStoreExample, in the AccountSqlMapDao, this is a > method: > > public void insertAccount(Account

transactions

2005-05-24 Thread Brandon Goodin
account); update("insertSignon", account); } Aren't those different update statements better off in a transaction? And why no different calls from the Service layer? I'm just trying to understand the difference. >From: Brandon Goodin <[EMAIL PROTECTED]> >Reply-To:

Re: transactions

2005-05-24 Thread Brandon Goodin
It is not neccessary to call transactions on only one statement. Transactions should be handled on the Service layer and make more fine-grained calls to the DAO layer. Brandon On 5/24/05, Lieven De Keyzer <[EMAIL PROTECTED]> wrote: > At http://www.reumann.net/struts/ibatisLesson1/step6.do > thi

Re: Feature Request

2005-05-24 Thread Brandon Goodin
ould > someone add this for me? > > Thanks > Rob > --- Brandon Goodin <[EMAIL PROTECTED]> wrote: > > > Oh duh. haha. sorry. Read it quick. Should have > > taken a few more seconds. > > > > Follow the second temp file suggestion for now. It > >

Re: Feature Request

2005-05-24 Thread Brandon Goodin
s unnecessary limitation. > > Seeing as I need this capability, and someone else has > resorted to using temp files to accomplish the same > thing, it sounds like it would be a useful feature to > have. > > Thanks for the suggestions though. > Rob > > > --

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-24 Thread Brandon Goodin
ersion (when we aren't XML dependent) folks may have an opportunity to prove me wrong... and that is MORE than okay with me :). Brandon On 5/24/05, Huy <[EMAIL PROTECTED]> wrote: > Brandon Goodin wrote: > > I don't plan on promoting any templating languages. It offloads the

Re: Feature Request

2005-05-23 Thread Brandon Goodin
SqlMapClientBuilder takes a reader. If you have a String in memory then why couldn't you use a StringReader? Brandon On 5/23/05, Rob Butler <[EMAIL PROTECTED]> wrote: > Hello, > > I am building an application that will need to > dynamically build an SQL statement at run time, and > then populate

Re: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Brandon Goodin
IBatis caches the column mappings on results. This is because it needs to determine how to map the jdbc column type with the corresponding java type. Once it has figured out what and how it needs to be translated it caches it. So, the second time you run the query it will be faster. But, make sure

Re: database password

2005-05-23 Thread Brandon Goodin
There are several things you can do here. You could setup a datasource that is configured via JNDI. Your datasource could draw it's credentials from elsewhere. But, the prolbem is that your credentials have to be store somewhere. So, the question really winds up being... where is a safe place to st

Re: Merging multiple sqlmaps configurations

2005-05-23 Thread Brandon Goodin
config files instead of only one. > > Just my 2 cents. > > -----Original Message- > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: Monday, May 23, 2005 10:25 PM > To: ibatis-user-java@incubator.apache.org > Subject: Re: Merging multiple sqlmaps configurations &

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-23 Thread Brandon Goodin
t may be possible for you to contribute something cool with velocity. Personally, I don't think velocity would add value to the process. Brandon On 5/23/05, Huy <[EMAIL PROTECTED]> wrote: > Brandon Goodin wrote: > > This is just plain funny. Can you tell that we love the eas

Re: Merging multiple sqlmaps configurations

2005-05-23 Thread Brandon Goodin
should only know the "main" config file and not the > implementation details of the "submodules". So we have only one entry point. > > What I really want is to combine sets of sql resources. > This case is used in a framework for java. > > Cheers, > Martin >

Re: M:M question

2005-05-23 Thread Brandon Goodin
It's difficult to answer this question because i don't really know the larger context. Usually i handle delete checkboxes and updates by iterating my list of objects returned from the screen. As i iterate through each object of the list i check to see if it is checked to be deleted and place it int

Re: Merging multiple sqlmaps configurations

2005-05-23 Thread Brandon Goodin
I'm really not sure what you are asking here. There is no way to combine two different sqlMapConfig files into one. You would have to create a new sqlMapConfig with all of the sqlMap files configured into it or load two SqlMapClients with their own sqlMapConfig files. Brandon On 5/23/05, Zeltner

Re: Blob

2005-05-22 Thread Brandon Goodin
umm... how dumb do you have to be to do something like that? uurmm... oh yeah... i did that too! Brandon On 5/22/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > One almost unrelated thing on this (that I have screwed up before) is > that you may want to leave out the blob unless you really, really

Re: Blob

2005-05-22 Thread Brandon Goodin
This should help: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F Brandon On 5/22/05, Lieven De Keyzer <[EMAIL PROTECTED]> wrote: > I want to retrieve the values from a table where 1 column is of type Blob. > My Bean to stor

Re: Cache entry invalidation on updates

2005-05-22 Thread Brandon Goodin
The iBatis caching key is based on the SQL query that is sent to the database. The full results are cached under that key in the particular specified CacheModel. It does not retain the individual object dentity (OID) of all the individual objects returned in a query. This means that if you have an

Re: ibatis and global transactions

2005-05-20 Thread Brandon Goodin
gt; > In my project, I am using a JTA transaction manager and have multiple data > sources (using XA-drivers). So far, I have not seen anything unusual. Is > there something I need to be aware of when using JTA and distributed > transactions? > > -----Original Message- > F

Re: sqlmapclients

2005-05-20 Thread Brandon Goodin
ate a seperate thread but i do > access my sqlmapclient for a singleton instance. > > > best regards, > > Steve.. > > -Original Message- > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: Fri 5/20/2005 2:22 PM > To: ibatis-user-java@incubator.apach

Re: iBATIS + Websphere 5.1?

2005-05-20 Thread Brandon Goodin
can you please provide us with your JNDI configuration, dao.xml and sqlmapconfig.xml? That will give us the full context of your configuration. Then we will be more equipped to assist you. Brandon On 5/20/05, Santamaria Franco, Inaki <[EMAIL PROTECTED]> wrote: > > Hello all, > >

Re: sqlmapclients

2005-05-20 Thread Brandon Goodin
Each call that goes into the server is it's own thread. So, there should be no issue. It's the same as though you were accessing via a servlet based front end. With the web you have a bunch of users calling only one sqlmap client. I don't see where this would be a problem. Are you running into some

Re: ibatis and global transactions

2005-05-20 Thread Brandon Goodin
You can manage your transactions with EXTERNAL of JTA. I believe that EXTERNAL is the better route to go in this case. This means that you will need to configure and manually start and stop your transactions outside of ibatis. Search the DAO pdf doc and the SQL Maps pdf doc for external to get more

Re: Iterate problem

2005-05-20 Thread Brandon Goodin
rty, as soon as this Probe encounters '[' it tries to > parse an index instead of checking the position of ']'. > > Hope this helps, > > Niels Beekman > > -Original Message- > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: donderdag 19

Re: Re: Future releases

2005-05-19 Thread Brandon Goodin
Go ahead and post them here. It's better to have some dialog here. Brandon On 5/19/05, Chipomho <[EMAIL PROTECTED]> wrote: > can i have the URL where i can post my ideas. > > > > > From: Brandon Goodin <[EMAIL PROTECTED]> > > Date: 2005/05/20 Fri PM 02

Re: Future releases

2005-05-19 Thread Brandon Goodin
we do not know when the next version will be out. If you have suggestions then post the ideas on the dev list to see if they are workable ideas. If they are good ideas then you would enter them into the JIRA issue tracker and they will be included with a future release. Brandon On 5/19/05, Chipom

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-19 Thread Brandon Goodin
This is just plain funny. Can you tell that we love the easy questions? Brandon On 5/19/05, Ron Grabowski <[EMAIL PROTECTED]> wrote: > You can use: > > < > > Or enclose the text within CDATA: > > > > > > --- Pham Anh Tuan <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I can't not type < sign

Re: Iterate problem

2005-05-19 Thread Brandon Goodin
What version of ibatis are you using? On 5/19/05, Niels Beekman <[EMAIL PROTECTED]> wrote: > Hi, > > I'm using the iterate-tag to loop a list, but I can't find a way to use > the current element in attributes of inner tags, when I try the > following: > > > > $myList[].anotherProperty$ >

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-19 Thread Brandon Goodin
You have two options... 1) Substitute your < > with their entity counterparts < and > Ex. select COUNT(distinct ITEMID) from SALE where SALESTATUS = 0 and MAXPRICE = 1 and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) <= 15 and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) > 0 and BUYERUSERID = #value# 2) Wr

Re: help on com.ibatis.common.beans.ProbeException

2005-05-18 Thread Brandon Goodin
What is the value that is actually getting passed back? Brandon On 5/17/05, Binh Tran <[EMAIL PROTECTED]> wrote: > Hi all, > When I tried to execute a procedure to return type NUMBER, I got this error > message. > > [java] Caused by: com.ibatis.common.beans.ProbeException: Could not set > proper

Re: Very Confused.

2005-05-17 Thread Brandon Goodin
It is difficult to give you advice on this sort of proble. Check your logs and make sure you aren't getting an exception. Also, please post your environment and give more detail on your setup. What Servlet container are you running, what version of ibatis jpetstore, what version of jdk etc... Than

Re: Question on dynamic prepend and using multiple properties

2005-05-17 Thread Brandon Goodin
Don't forget the new functionality available in 2.1.0 count > #countA# count < #countB# Brandon On 5/17/05, Ron Grabowski <[EMAIL PROTECTED]> wrote: > Have you tried this: > > > ( > > count > #countA# > > > count < #countB# > > ) > > > --- Narasimha Prasad <[EMAIL PROTECT

Re: iBatis DAO - How to turn off data connection pool

2005-05-17 Thread Brandon Goodin
There really is no simple answer to what you need. I believe we have discussed your dilemna in the past haven't we? The answer is the same... Bite the bullet and swap out your connection manager with a common connection manager so that both implementations use the same connection manager. This path

Re: Custom funcion si SqlMap

2005-05-16 Thread Brandon Goodin
It is not possible to use java code within attributes (or anywhere else for that matter). You can handle this via SQL function calls ( which may harm preformance) or you can make the alteration to your bean in the DAO class before it is passed in to the mapped statement. Brandon On 5/16/05, Marco

Re: Availability of 2.1.0

2005-05-15 Thread Brandon Goodin
ooops... forgot the link Thought you all might like to see this as well. Scroll to the bottom of the page and you will see the changes that have been made for 2.1.0. http://issues.apache.org/jira/secure/BrowseProject.jspa?id=10601&subset=-1 Brandon On 5/15/05, Brandon Goodin <[EMAIL PR

Re: Availability of 2.1.0

2005-05-15 Thread Brandon Goodin
ut should be > updated as we fix stuff. > > You can also look in JIRA, which is up-to-date with all but two feature > requests that I have yet to add. > > Cheers, > Clinton > > > On 5/13/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: > > - The removeFir

  1   2   3   4   >