Re: 1:1 with abstract class

2005-11-09 Thread Hongbo HE
Please see my sqlMap file below, I have tried to use a resultmap inside a resultmap, but it returns a list. If entity is a concrete class, I can use the dot.notation , for abstract class, I can include the extra column "type" in the resultSet of the sql, but how to tell the resultMap of orderResult

Re: Reload SqlMap xml file

2005-11-09 Thread Michael Campbell
On 11/9/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > I have the same problem. I've seen this requested before but I don't think > there is a solution. > > --- Ming Xue <[EMAIL PROTECTED]> wrote: > > > Hi > > > > I am using Spring with SqlMap, the sqlMapClient is configured as a Spring > > bean,

Re: Reload SqlMap xml file

2005-11-09 Thread Geoff Chiang
I have an administration page in my site that allows me to reload the whole Spring application context at runtime. I keep it open in another tab in my browser if I need it. The relevant code looks like this: AbstractApplicationContext applicationContext = (AbstractApplicationContext) WebApplicat

Re: oracle hints are treated as comments

2005-11-09 Thread Paul Benedict
I believe the XML spec does not allow the double dash to appear within a body. The -- is reserved for comments. If you're having trouble, wrap a around your statement: --- Guido García Bernardo <[EMAIL PROTECTED]> wrote: > Hi, > > I'm using ibatis sql maps 2.1.5 + Oracle 8, defining the

Re: Reload SqlMap xml file

2005-11-09 Thread Paul Benedict
I have the same problem. I've seen this requested before but I don't think there is a solution. --- Ming Xue <[EMAIL PROTECTED]> wrote: > Hi > > I am using Spring with SqlMap, the sqlMapClient is configured as a Spring > bean, during > development, I need to modify the sqlMap xml file (actual

Reload SqlMap xml file

2005-11-09 Thread Ming Xue
Title: Reload SqlMap xml file Hi I am using Spring with SqlMap, the sqlMapClient is configured as a Spring bean, during development, I need to modify the sqlMap xml file (actual SQLs) very often, but in order to apply the change, I need to restart my Jboss server, so sqlMapClient can reloa

Re: Property starting with 'i' character in Turkish Locale

2005-11-09 Thread Bahri Gencsoy
  Actually I solved the problem. It was a small but very nasty bug. I have reported it among with the fix as IBATIS-218:   http://issues.apache.org/jira/browse/IBATIS-218   I wonder, why previously nobody else noticed the problem. Aren't there anybody using SqlMaps with Turkish locale?  On 11/7/05,

Re: 1:1 with abstract class

2005-11-09 Thread Gilles Bayon
You sould use the discriminator tag On 11/9/05, Gilles Bayon <[EMAIL PROTECTED]> wrote: Yould use the discriminator tag On 11/9/05, Hongbo HE <[EMAIL PROTECTED]> wrote: I have a 1:1 relation of 2 tables. Multiple subClassesis mapped to  one of themOrder(id, entityId,...)Entity(id,type,...)type

Re: 1:1 with abstract class

2005-11-09 Thread Gilles Bayon
Yould use the discriminator tag On 11/9/05, Hongbo HE <[EMAIL PROTECTED]> wrote: I have a 1:1 relation of 2 tables. Multiple subClassesis mapped to  one of themOrder(id, entityId,...)Entity(id,type,...)type is the discriminator.Order {long id;Entity entity;}abstract Entity {long id;}Instructor exte

1:1 with abstract class

2005-11-09 Thread Hongbo HE
I have a 1:1 relation of 2 tables. Multiple subClasses is mapped to one of them Order (id, entityId, ... ) Entity (id, type, ... ) type is the discriminator. Order { long id; Entity entity; } abstract Entity { long id; } Instructor extends Entity { } Student enxteds Entity { } I'd like

Map containing Lists of Maps

2005-11-09 Thread Gary Bradshaw
My compliments on a most useful product. I'm always thinking about ways to improve the signal-to-noise ratio in business software, and SqlMaps seems like a simple way to reuse a wide variety of familiar real-world Java objects by linking them directly to SQL parameters and results. One of the fir

Re: oracle hints are treated as comments

2005-11-09 Thread Guido García Bernardo
Thank you Fabio, it worked. I still think this is an undesired behaviour of ibatis SQL Maps. Fabio Insaccanebbia wrote: Try this.. (as a workaround) SELECT /*+ RULE */ id, name, email from ... 2005/11/9, Guido García Bernardo <[EMAIL PROTECTED]>: Hi, I'm using ibatis sq

Re: oracle hints are treated as comments

2005-11-09 Thread Fabio Insaccanebbia
Try this.. (as a workaround) SELECT /*+ RULE +*/ id, name, email from ... 2005/11/9, Guido García Bernardo <[EMAIL PROTECTED]>: > Hi, > > I'm using ibatis sql maps 2.1.5 + Oracle 8, defining the following query > statement: > > > SELECT --+RULE >id, name, email >

oracle hints are treated as comments

2005-11-09 Thread Guido García Bernardo
Hi, I'm using ibatis sql maps 2.1.5 + Oracle 8, defining the following query statement: SELECT --+RULE id, name, email from ... The SQL that follows the hint is interpreted as a comment. Thus I get: Caused by: java.sql.SQLException: ORA-00936: missing expression It works fine