Re: regex in WHERE clause

Use $$ instead. On 6/29/07, Warren <[EMAIL PROTECTED]> wrote: I am trying to get the following to work: It does not work but this will: When I place the $ character in it it breaks. Do I need to be doing some sort of escaping. The top statement works fine when I run it in pgamin. -- Than

regex in WHERE clause

I am trying to get the following to work: It does not work but this will: When I place the $ character in it it breaks. Do I need to be doing some sort of escaping. The top statement works fine when I run it in pgamin. -- Thanks, Warren Bell

Re: I18N best practices with iBatis

So you have a field for each locale? I'd think it would be easier to if that were a compound key instead: SELECT a.activity_id, i.name as name FROM activities a JOIN i18n i ON (a.name_i18n_id = i.i18n_id and i.i18n_locale = #locale#) But.. I guess you'd still have to pass it to each query...

I18N best practices with iBatis

I have some I18N questions and am wondering what others do out there. We have an I18N system setup where there is a database table storing all strings and their translations. There is tags against each i18n string and then they will get written out different files (some .properties for java, som

RE: Define Factory to instantiate Objects?

You can define a ResultObjectFactory in the SqlMapClient. ExtendedSqlMapClient client = (ExtendedSqlMapClient) getObject(); client.getDelegate().setResultObjectFactory(resultObjectFactory); This factory will then be used by iBatis to instantiate all of your ResultMap objects. Take a look at t

Define Factory to instantiate Objects?

Hi, is it possible to teach iBatis to use a Factory-method to instatiate a class? In my case the constructor is protected (or even better the specified type is an interface) and the objects are normally instantiated using a Factory (for those interested I'm working with Objects generated from

RE: Global Transactions or Ibatis's Automatic transactions

Ashok, I had mentioned the JNDI name of the directly in the sqlmapconfig.xml viz, jdbc/exampleDB (I mean not the reference like java:comp/env/jdbc/exampleDB) and transactionmanager type was 'EXTERNAL'. Plus we were starting our transaction in our business layer and not in the DAO layer. We have u

Re: Global Transactions or Ibatis's Automatic transactions

When using EXTERNAL transactions, the startTransaction() method does nothing. So JTA's transaction is not being called either - EXTERNAL means that iBATIS is completely trusting some external source to manage transactions (like an EJB container). If you want to control JTA from withing iBATIS, u

Re: Global Transactions or Ibatis's Automatic transactions

I am trying to add Ibatis persistence to struts , cannot use springs. When daoManager.startTransaction(); how can we ensure that the JTA's transaction is being called and not the Ibatis Automatic transactions. Meindert wrote: Ibatis DAO has been depreciated.. Use spring instead -Origin

RE: Global Transactions or Ibatis's Automatic transactions

Ibatis DAO has been depreciated.. Use spring instead -Original Message- From: ashok [mailto:[EMAIL PROTECTED] Sent: 29 June 2007 09:53 AM To: ibatis Subject: Global Transactions or Ibatis's Automatic transactions Hi Does the daoManger.startTransaction(); created refers to the Global tr

Global Transactions or Ibatis's Automatic transactions

Hi Does the daoManger.startTransaction(); created refers to the Global transactions or Ibatis Automatic transactions? What changes to be made if I need to use global transactions? In my DaoIntializer class I create the daoManager as follows : Reader reader = Resources.getResourceAsReader("