RE: Oracle OC4J and signon

2005-05-12 Thread Daniel H. F. e Silva
Hi David,

 What is this window? A MS Windows window? A basic realm window?
 Have you checked if your webserver has any kind of realm configured?
 Hope that helps.

Cheers,
 Daniel Silva.



--- Trussell David N [EMAIL PROTECTED] wrote:
 It's the same database.properties file that's under Tomcat and that works
 just fine.
 
 I thought maybe the JDBC driver had to be in /WEB-INF/lib under jpetstore so
 I tried both classes12.jar and ojdbc14.jar. Nope. I also put something
 totally bogus for the driver name in database.properties and it didn't even
 complain (at least, anywhere I can see). It's just pops up that window.
 
 Ya know, this is really maddening. I've spent two days trying to get Appfuse
 running on OC4J with no success. Even Matt Raible and company couldn't help
 me. Now it's the same thing with iBATIS. Heavy sigh. I really wish I could
 just use Tomcat.
 
  -Original Message-
  From: Brice Ruth [mailto:[EMAIL PROTECTED] 
  Sent: Wednesday, May 11, 2005 2:38 PM
  To: ibatis-user-java@incubator.apache.org
  Subject: Re: Oracle OC4J and signon
  
  
  Is your DB connection authenticating properly to Oracle? I 
  get this with DB2 if my password has expired or the account 
  has been locked out.
  
  Brice
  
  On 5/11/05, Trussell David N [EMAIL PROTECTED] wrote:

   
   I've just deployed JPetStore to Oracle OC4J 10.1.2 (I've also tried 
   9.0.4) on Win XP and when I click Sign-in or Enter the Store an 
   authentication window pops-up asking for my userid and password. I 
   can't get past it.
   
   Where can I disable this?
   
   Thank you.
  
  
  -- 
  Brice Ruth
  Software Engineer, Madison WI
  
 



__ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 


Custom XML Resultmaps

2005-05-12 Thread Abdullah Kauchali
Is it possible to extend the current XML Resultmap format to a new 
custom one?  Don't ask!, but were are investigating the possibility of 
returning XML in Microsoft's ADO format.

Any general advice on this would be greatly appreciated,
Kind regards
Abdullah


simple question

2005-05-12 Thread Sergey Livanov

Could you, please, help me find an error,
very simple statement, but not work..

  statement id=getPayorders resultMap=payorder_result

select d.payorder
  from fin.payorders d
 where d.partner = #partner#
 dynamic
   isGreaterThan prepend= and  property=owner compareValue=0
   d.owner = #owner#
   /isGreaterThan
 /dynamic
 
  /statement

without dynamic all works,
Log4J text.

2005-05-12 16:26:52,718 INFO main TestIbatis TestIbatis - Executing:
2005-05-12 16:26:53,703 DEBUG main com.ibatis.common.jdbc.SimpleDataSource 
com.ibatis.common.jdbc.SimpleDataSource - Created connection 8002486.
2005-05-12 16:26:53,703 DEBUG main java.sql.Connection 
com.ibatis.common.jdbc.logging.ConnectionLogProxy - {conn-10} Connection
2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement 
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11} 
PreparedStatement:
  select d.payorder from sell.payorders d where d.partner = ?
  dynamicisGreaterThan prepend= and  property=owner
   compareValue=0 d.owner = ? /isGreaterThan/dynamic
2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement 
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11} 
Parameters: [1, 15842]
2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement 
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11} Types: 
[java.lang.Long, java.lang.Long]
2005-05-12 16:26:53,781 DEBUG main com.ibatis.common.jdbc.SimpleDataSource 
com.ibatis.common.jdbc.SimpleDataSource - Returned connection 8002486 to pool.


-- 
regards,
 Sergey  mailto:[EMAIL PROTECTED]



Re: Custom XML Resultmaps

2005-05-12 Thread Larry Meadors
Could you transform it with XSLT?

Larry
On 5/12/05, Abdullah Kauchali [EMAIL PROTECTED] wrote:
Is it possible to extend the current XML Resultmap format to a newcustom one?Don't ask!, but were are investigating the possibility ofreturning XML in Microsoft's ADO format.Any general advice on this would be greatly appreciated,
Kind regardsAbdullah

Re: Oracle OC4J and signon

2005-05-12 Thread Brice Ruth
Aha! This is basic realm authentication. I believe if you read the
docs for jPetstore, there's a default admin or guest user account you
can use to get in ... at least, I remember that from when I setup
jPetstore once upone a time!

Brice

On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
  
 
 My apologies for attaching a screenshot. I understand that's frowned upon in
 a discussion list, but I don't know a better way of answer your question.
 It's the same window in Firefox and MS IE6. I assume it's an MS Windows
 window. Maybe I'll look at it as a Windows configuration problem instead of
 an OC4J trick. I'll check into the realm thing, too. Thank you very much for
 your reply. 
 
  -Original Message- 
  From: Daniel H. F. e Silva [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, May 12, 2005 6:01 AM 
  To: ibatis-user-java@incubator.apache.org 
  Subject: RE: Oracle OC4J and signon 
  
  
  Hi David, 
  
   What is this window? A MS Windows window? A basic realm 
  window?  Have you checked if your webserver has any kind of 
  realm configured?  Hope that helps. 
  
  Cheers, 
   Daniel Silva. 
  
  
  
  --- Trussell David N [EMAIL PROTECTED] wrote: 
   It's the same database.properties file that's under Tomcat and that 
   works just fine. 
   
   I thought maybe the JDBC driver had to be in /WEB-INF/lib under 
   jpetstore so I tried both classes12.jar and ojdbc14.jar. 
  Nope. I also 
   put something totally bogus for the driver name in 
  database.properties 
   and it didn't even complain (at least, anywhere I can see). 
  It's just 
   pops up that window. 
   
   Ya know, this is really maddening. I've spent two days 
  trying to get 
   Appfuse running on OC4J with no success. Even Matt Raible 
  and company 
   couldn't help me. Now it's the same thing with iBATIS. 
  Heavy sigh. I 
   really wish I could just use Tomcat. 
   
-Original Message- 
From: Brice Ruth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 11, 2005 2:38 PM 
To: ibatis-user-java@incubator.apache.org 
Subject: Re: Oracle OC4J and signon 


Is your DB connection authenticating properly to Oracle? I 
get this with DB2 if my password has expired or the account 
has been locked out. 

Brice 

On 5/11/05, Trussell David N [EMAIL PROTECTED] wrote: 
  
 
 I've just deployed JPetStore to Oracle OC4J 10.1.2 (I've also 
 tried 
 9.0.4) on Win XP and when I click Sign-in or Enter the 
  Store an 
 authentication window pops-up asking for my userid and 
  password. I 
 can't get past it. 
 
 Where can I disable this? 
 
 Thank you. 


-- 
Brice Ruth 
Software Engineer, Madison WI 

   
  
  

  __ 
  Yahoo! Mail Mobile 
  Take Yahoo! Mail with you! Check email on your mobile phone. 
  http://mobile.yahoo.com/learn/mail 
  
 
  
 
   
 


-- 
Brice Ruth
Software Engineer, Madison WI


Re: simple question

2005-05-12 Thread Pedro Emanuel Castro Faria Salgado
On 12/05/2005 15:39, Sergey Livanov [EMAIL PROTECTED] wrote:

 
 Could you, please, help me find an error,
 very simple statement, but not work..
 
 statement id=getPayorders resultMap=payorder_result
 
   select d.payorder
 from fin.payorders d
where d.partner = #partner#

Take off the dynamic?

Below a working example that I have:

SELECT *
FROM myTable
WHERE condition_clause AND some_other_condition_clause
isNotNull prepend=AND property=description
description LIKE #description#
/isNotNull

dynamic
  isGreaterThan prepend= and  property=owner compareValue=0
  d.owner = #owner#
  /isGreaterThan
/dynamic

 /statement
 
 without dynamic all works,
 Log4J text.
 
 2005-05-12 16:26:52,718 INFO main TestIbatis TestIbatis - Executing:
 2005-05-12 16:26:53,703 DEBUG main com.ibatis.common.jdbc.SimpleDataSource
 com.ibatis.common.jdbc.SimpleDataSource - Created connection 8002486.
 2005-05-12 16:26:53,703 DEBUG main java.sql.Connection
 com.ibatis.common.jdbc.logging.ConnectionLogProxy - {conn-10} Connection
 2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
 com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
 PreparedStatement:
 select d.payorder from sell.payorders d where d.partner = ?
 dynamicisGreaterThan prepend= and  property=owner
  compareValue=0 d.owner = ? /isGreaterThan/dynamic
 2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
 com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
 Parameters: [1, 15842]
 2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
 com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
 Types: [java.lang.Long, java.lang.Long]
 2005-05-12 16:26:53,781 DEBUG main com.ibatis.common.jdbc.SimpleDataSource
 com.ibatis.common.jdbc.SimpleDataSource - Returned connection 8002486 to pool.
 



RE: Oracle OC4J and signon

2005-05-12 Thread Trussell David N
Title: RE: Oracle OC4J and signon





Yeah, j2ee/j2ee and ACID/ACID. But it doesn't accept either of those two.


-Original Message-
From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 12, 2005 9:09 AM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Oracle OC4J and signon



Aha! This is basic realm authentication. I believe if you read the docs for jPetstore, there's a default admin or guest user account you can use to get in ... at least, I remember that from when I setup jPetstore once upone a time!

Brice


On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
 
 
 My apologies for attaching a screenshot. I understand that's frowned 
 upon in a discussion list, but I don't know a better way of answer 
 your question. It's the same window in Firefox and MS IE6. I assume 
 it's an MS Windows window. Maybe I'll look at it as a Windows 
 configuration problem instead of an OC4J trick. I'll check into the 
 realm thing, too. Thank you very much for your reply.
 
  -Original Message-
  From: Daniel H. F. e Silva [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, May 12, 2005 6:01 AM 
  To: ibatis-user-java@incubator.apache.org 
  Subject: RE: Oracle OC4J and signon 
  
  
  Hi David,
  
  What is this window? A MS Windows window? A basic realm
  window? Have you checked if your webserver has any kind of 
  realm configured? Hope that helps. 
  
  Cheers,
  Daniel Silva. 
  
  
  
  --- Trussell David N [EMAIL PROTECTED] wrote:
   It's the same database.properties file that's under Tomcat and 
   that
   works just fine. 
   
   I thought maybe the JDBC driver had to be in /WEB-INF/lib under
   jpetstore so I tried both classes12.jar and ojdbc14.jar. 
  Nope. I also
   put something totally bogus for the driver name in
  database.properties
   and it didn't even complain (at least, anywhere I can see).
  It's just
   pops up that window.
   
   Ya know, this is really maddening. I've spent two days
  trying to get
   Appfuse running on OC4J with no success. Even Matt Raible
  and company
   couldn't help me. Now it's the same thing with iBATIS.
  Heavy sigh. I
   really wish I could just use Tomcat.
   
-Original Message-
From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 11, 2005 2:38 PM 
To: ibatis-user-java@incubator.apache.org 
Subject: Re: Oracle OC4J and signon 


Is your DB connection authenticating properly to Oracle? I
get this with DB2 if my password has expired or the account 
has been locked out. 

Brice

On 5/11/05, Trussell David N [EMAIL PROTECTED] wrote:
 
 
 I've just deployed JPetStore to Oracle OC4J 10.1.2 (I've also
 tried 
 9.0.4) on Win XP and when I click Sign-in or Enter the 
  Store an
 authentication window pops-up asking for my userid and
  password. I
 can't get past it.
 
 Where can I disable this?
 
 Thank you.


--
Brice Ruth 
Software Engineer, Madison WI 

   
  
  
  
  __
  Yahoo! Mail Mobile 
  Take Yahoo! Mail with you! Check email on your mobile phone. 
  http://mobile.yahoo.com/learn/mail 
  
 
 
 
 
 



-- 
Brice Ruth
Software Engineer, Madison WI





Re: Custom XML Resultmaps

2005-05-12 Thread Ron Grabowski
Do you want to have IBatis generate an xml file that can be loaded by a
DataSet's ReadXml method? Here's an example for the non-.Net people of
one way of saving a DataSet to XML:

 DataSet ds = new DataSet(People);

 DataTable dt = new DataTable(Person);
 dt.Columns.Add(Name, typeof(string));
 dt.Columns.Add(Age, typeof(int));

 DataRow dr = dt.NewRow();
 dr[Name] = Ron;
 dr[Age] = 99;
 dt.Rows.Add(dr);

 ds.Tables.Add(dt);

 ds.WriteXml(output.xml);

 People
   Person
 NameRon/Name
 Age99/Age
   /Person
 /People

Except for the outer People node, I believe IBatis can generate that
already.

--- Abdullah Kauchali [EMAIL PROTECTED] wrote:
 Is it possible to extend the current XML Resultmap format to a new 
 custom one?  Don't ask!, but were are investigating the possibility
 of 
 returning XML in Microsoft's ADO format.
 
 Any general advice on this would be greatly appreciated,
 
 Kind regards
 
 Abdullah
 


RE: Oracle OC4J and signon

2005-05-12 Thread Trussell David N
Title: RE: Oracle OC4J and signon





I can't find a context.xml. As far as I can see, a realm would be configured in jazn-data.xml and there are no entries in that file.

I get one of these entries in my global-applications.log for each time the pop-up window is presented (meaning when I click Sign-in or Enter the Store). I'm not well-versed enough in Java to know what this means:

05/05/12 10:18:04 jpetstore: Servlet error
java.lang.SecurityException
 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2676)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpApplication.getLocalDispatcher(HttpApplication.java:4734)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpSite.getRequestDispatcher(HttpSite.java:341)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:1368)

 at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
 at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)

 at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)

 at java.lang.Thread.run(Thread.java:534)


-Original Message-
From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 12, 2005 9:30 AM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Oracle OC4J and signon



Hmmm ... well, take a look at where the realm is configured. It would have to be in context.xml as well as be referenced in web.xml ...

On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
 
 
 Yeah, j2ee/j2ee and ACID/ACID. But it doesn't accept either of those 
 two.
 
 -Original Message-
 From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, May 12, 2005 9:09 AM 
 To: ibatis-user-java@incubator.apache.org 
 Subject: Re: Oracle OC4J and signon 
 
 
 
 
 Aha! This is basic realm authentication. I believe if you read the 
 docs for jPetstore, there's a default admin or guest user account you 
 can use to get in ... at least, I remember that from when I setup 
 jPetstore once upone a time!
 
 Brice
 
 On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
  
  
  My apologies for attaching a screenshot. I understand that's frowned
  upon in a discussion list, but I don't know a better way of answer 
  your question. It's the same window in Firefox and MS IE6. I assume 
  it's an MS Windows window. Maybe I'll look at it as a Windows 
  configuration problem instead of an OC4J trick. I'll check into the 
  realm thing, too. Thank you very much for your reply. 
  
   -Original Message-
   From: Daniel H. F. e Silva [mailto:[EMAIL PROTECTED]] 
   Sent: Thursday, May 12, 2005 6:01 AM 
   To: ibatis-user-java@incubator.apache.org 
   Subject: RE: Oracle OC4J and signon 
   
   
   Hi David,
   
   What is this window? A MS Windows window? A basic realm
   window? Have you checked if your webserver has any kind of 
   realm configured? Hope that helps. 
   
   Cheers,
   Daniel Silva. 
   
   
   
   --- Trussell David N [EMAIL PROTECTED] wrote:
It's the same database.properties file that's under Tomcat and
that 
works just fine. 

I thought maybe the JDBC driver had to be in /WEB-INF/lib under
jpetstore so I tried both classes12.jar and ojdbc14.jar. 
   Nope. I also
put something totally bogus for the driver name in
   database.properties
and it didn't even complain (at least, anywhere I can see).
   It's just
pops up that window.

Ya know, this is really maddening. I've spent two days
   trying to 

issues upgrading from 1.31 to 2.09B

2005-05-12 Thread Andy Thompson
I'm working on refactoring an existing application.  The environment
being deployed on is weblogic 8.1 and I'd like to use weblogic to
control datasources.

I managed to get the jars updated (still using
the compat jar).  I also got the script to upgrade the sql-map.xml and
sql-map-config.xml files working (documentation that ant 1.54 is
needed would be nice)..

That said, I can't get the generated 2.0 SqlMapConfig.xml script to work.
And unfortunatly the error logs are a little meaningless to me (pasted
below).  Are there mandatory settings in 2.0 that aren't mandatory in
1.3?

Anyway, help would be appreciated.  Thanks for your time,
-Andy
_

com.ibatis.db.sqlmap.SqlMapException: Error while building SqlMap.

Error:
java.io.IOException: The root tag of the SqlMap XML document must be 'sql-map
r 'sql-map-config'.
Caused by: java.io.IOException: The root tag of the SqlMap XML document must
'sql-map' or 'sql-map-config'.
   at com.ibatis.db.sqlmap.XmlSqlMapBuilder.buildSqlMap(Unknown Source)
   at com.ibatis.db.sqlmap.XmlSqlMapBuilder.buildSqlMap(Unknown Source)
_

New script:
?xml version=1.0 encoding=UTF-8 standalone=no?

   !--Converted by iBATIS SQL Map Converter 'A' (1.x to 2.x)--
   !DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL Map Config
2.0//EN http://www.ibatis.com/dtd/sql-map-config-2.dtd;
sqlMapConfig xmlns:fo=http://www.w3.org/1999/XSL/Format;

 settings cacheModelsEnabled=true maxRequests=0/
 sqlMap resource=resource/ObjectMap.xml/

/sqlMapConfig
__

Old script:
?xml version=1.0 encoding=UTF-8?
!DOCTYPE sql-map-config
   PUBLIC -//iBATIS.com//DTD SQL Map Config 1.0//EN
   http://www.ibatis.com/dtd/sql-map-config.dtd;

sql-map-config

 settings cacheModelsEnabled=true
   statementCacheSize=1
   maxExecute=0
   maxExecutePerConnection=0
   driverHintsEnabled=true
   /

 sql-map resource=resource/ObjectMap.xml /

/sql-map-config


Re[2]: simple question

2005-05-12 Thread Sergey Livanov
Thank you a lot, Brandon.
BG it should be okay to use dynamic. What version of iBatis are you using?
2.0.8

When I remove dynamic/dynamic it does'not work too. 
I'd like to ask you to see to Log4j java PreparedStatement:. 
The parameters are correct, but 
dynamicisGreaterThan prepend=and property=owner 
compareValue=0/dynamic 
construction has been kept,
and this SQL operator would not work. 

Sergey.

BG Brandon

BG On 5/12/05, Pedro Emanuel Castro Faria Salgado [EMAIL PROTECTED] wrote:
 On 12/05/2005 15:39, Sergey Livanov [EMAIL PROTECTED] wrote:
 
 
  Could you, please, help me find an error,
  very simple statement, but not work..
 
  statement id=getPayorders resultMap=payorder_result
 
select d.payorder
  from fin.payorders d
 where d.partner = #partner#
 
 Take off the dynamic?
 
 Below a working example that I have:
 
 SELECT *
 FROM myTable
 WHERE condition_clause AND some_other_condition_clause
 isNotNull prepend=AND property=description
 description LIKE #description#
 /isNotNull
 
 dynamic
   isGreaterThan prepend= and  property=owner compareValue=0
   d.owner = #owner#
   /isGreaterThan
 /dynamic
 
  /statement
 
  without dynamic all works,
  Log4J text.
 
  2005-05-12 16:26:52,718 INFO main TestIbatis TestIbatis - Executing:
  2005-05-12 16:26:53,703 DEBUG main com.ibatis.common.jdbc.SimpleDataSource
  com.ibatis.common.jdbc.SimpleDataSource - Created connection 8002486.
  2005-05-12 16:26:53,703 DEBUG main java.sql.Connection
  com.ibatis.common.jdbc.logging.ConnectionLogProxy - {conn-10} 
  Connection
  2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
  com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
  PreparedStatement:
  select d.payorder from sell.payorders d where d.partner = ?
  dynamicisGreaterThan prepend= and  property=owner
   compareValue=0 d.owner = ? /isGreaterThan/dynamic
  2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
  com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
  Parameters: [1, 15842]
  2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
  com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
  Types: [java.lang.Long, java.lang.Long]
  2005-05-12 16:26:53,781 DEBUG main com.ibatis.common.jdbc.SimpleDataSource
  com.ibatis.common.jdbc.SimpleDataSource - Returned connection 8002486 to 
  pool.
 
 




-- 
Ñ óâàæåíèåì,
 Sergey  mailto:[EMAIL PROTECTED]



RE: Oracle OC4J and signon

2005-05-12 Thread Trussell David N
Title: RE: Oracle OC4J and signon





Bingo! I commented out the security-constraint tag and it all works nicely.


I made the assumption that most developers would know what OC4J in the subject meant: Oracle Container for Java. It's based on Orion. My apologies.

Thank you for all your patience and help, Brice! Now, where did I put that hammer


-Original Message-
From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 12, 2005 11:59 AM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Oracle OC4J and signon



can you find web.xml? there should be a security-constraint tag in there ... that ties particular pages to a security restriction.

I wasn't aware that this was running in Oracle's App server as well. If you mentioned that earlier, I apologize.


I've never used Oracle's App server ... so my help may be limited in this area.


On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
 
 
 I can't find a context.xml. As far as I can see, a realm would be 
 configured in jazn-data.xml and there are no entries in that file.
 
 I get one of these entries in my global-applications.log for each time 
 the pop-up window is presented (meaning when I click Sign-in or 
 Enter the Store). I'm not well-versed enough in Java to know what 
 this means:
 
 05/05/12 10:18:04 jpetstore: Servlet error
 java.lang.SecurityException 
 at com.evermind[Oracle Application Server Containers for J2EE 10g
 (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2676)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.HttpApplication.getLocalDispatcher(HttpApplication.java:4734)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.HttpSite.getRequestDispatcher(HttpSite.java:341)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:1368)
 
 at
 org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
 at
 org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
 at
 org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
 at
 org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at
 org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
 at
 javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at
 javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
 
 at com.evermind[Oracle Application Server Containers for J2EE 
 10g
 (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
 
 at java.lang.Thread.run(Thread.java:534)
 
 -Original Message-
 From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, May 12, 2005 9:30 AM 
 To: ibatis-user-java@incubator.apache.org 
 Subject: Re: Oracle OC4J and signon 
 
 
 
 
 Hmmm ... well, take a look at where the realm is configured. It would 
 have to be in context.xml as well as be referenced in web.xml ...
 
 On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
  
  
  Yeah, j2ee/j2ee and ACID/ACID. But it doesn't accept either of those
  two. 
  
  -Original Message-
  From: Brice Ruth [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, May 12, 2005 9:09 AM 
  To: ibatis-user-java@incubator.apache.org 
  Subject: Re: Oracle OC4J and signon 
  
  
  
  
  Aha! This is basic realm authentication. I believe if you read the
  docs for jPetstore, there's a default admin or guest user account you 
  can use to get in ... at least, I remember that from when I setup 
  jPetstore once upone a time! 
  
  Brice
  
  On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
   
   
   My apologies for attaching a screenshot. I understand that's 
   frowned
   upon in a discussion list, but I don't know a better way of answer 
   your question. It's the same window in Firefox and MS IE6. I assume 
   it's an MS Windows window. Maybe I'll look at it as a Windows 
   configuration problem instead of an OC4J trick. I'll check into the 
   realm thing, too. Thank you very much for your reply. 

Re: Oracle OC4J and signon

2005-05-12 Thread Brice Ruth
Glad it works ... sorry, I just figured OC4J was another Oracle DB thingie :)

On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote:
  
 
 Bingo! I commented out the security-constraint tag and it all works
 nicely. 
 
 I made the assumption that most developers would know what OC4J in the
 subject meant: Oracle Container for Java. It's based on Orion. My apologies.
 
 Thank you for all your patience and help, Brice! Now, where did I put that
 hammer 
 
 -Original Message- 
 From: Brice Ruth [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, May 12, 2005 11:59 AM 
 To: ibatis-user-java@incubator.apache.org 
 Subject: Re: Oracle OC4J and signon 
 
  
  
 
 can you find web.xml? there should be a security-constraint tag in there
 ... that ties particular pages to a security restriction. 
 
 I wasn't aware that this was running in Oracle's App server as well. If you
 mentioned that earlier, I apologize. 
 
 I've never used Oracle's App server ... so my help may be limited in this
 area. 
 
 On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote: 
   
  
  I can't find a context.xml. As far as I can see, a realm would be 
  configured in jazn-data.xml and there are no entries in that file. 
  
  I get one of these entries in my global-applications.log for each time 
  the pop-up window is presented (meaning when I click Sign-in or 
  Enter the Store). I'm not well-versed enough in Java to know what 
  this means: 
  
  05/05/12 10:18:04 jpetstore: Servlet error 
  java.lang.SecurityException 
  at com.evermind[Oracle Application Server Containers for J2EE 10g 
 
 (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2676)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.HttpApplication.getLocalDispatcher(HttpApplication.java:4734)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.HttpSite.getRequestDispatcher(HttpSite.java:341)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:1368)
  
  at 
 
 org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
  at 
 
 org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
  at 
 
 org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
  at 
 
 org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
  at 
 
 org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
  at 
 
 javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
  at 
 
 javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
  
  at com.evermind[Oracle Application Server Containers for J2EE 
  10g 
 
 (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
  
  at java.lang.Thread.run(Thread.java:534) 
  
  -Original Message- 
  From: Brice Ruth [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, May 12, 2005 9:30 AM 
  To: ibatis-user-java@incubator.apache.org 
  Subject: Re: Oracle OC4J and signon 
  
   
   
  
  Hmmm ... well, take a look at where the realm is configured. It would 
  have to be in context.xml as well as be referenced in web.xml ... 
  
  On 5/12/05, Trussell David N [EMAIL PROTECTED] wrote: 

   
   Yeah, j2ee/j2ee and ACID/ACID. But it doesn't accept either of those 
   two. 
   
   -Original Message- 
   From: Brice Ruth [mailto:[EMAIL PROTECTED] 
   Sent: Thursday, May 12, 2005 9:09 AM 
   To: ibatis-user-java@incubator.apache.org 
   Subject: Re: Oracle OC4J and signon 
   


   
   Aha! This is basic realm authentication. I believe if you read the 
   docs for jPetstore, there's a default admin or guest user account you 
   can use to get in ... at least, I remember that from when I setup 
   jPetstore once upone a time! 
   
   Brice 
   
   On 5/12/05, Trussell David N [EMAIL PROTECTED] 

Re: Re[2]: simple question

2005-05-12 Thread Brandon Goodin
It looks like your dynamic tags are not being processed. Do you have
anything surrouned with a CDATA tag?

Brandon

On 5/12/05, Sergey Livanov [EMAIL PROTECTED] wrote:
 Thank you a lot, Brandon.
 BG it should be okay to use dynamic. What version of iBatis are you using?
 2.0.8
 
 When I remove dynamic/dynamic it does'not work too.
 I'd like to ask you to see to Log4j java PreparedStatement:.
 The parameters are correct, but
 dynamicisGreaterThan prepend=and property=owner 
 compareValue=0/dynamic
 construction has been kept,
 and this SQL operator would not work.
 
 Sergey.
 
 BG Brandon
 
 BG On 5/12/05, Pedro Emanuel Castro Faria Salgado [EMAIL PROTECTED] wrote:
  On 12/05/2005 15:39, Sergey Livanov [EMAIL PROTECTED] wrote:
 
  
   Could you, please, help me find an error,
   very simple statement, but not work..
  
   statement id=getPayorders resultMap=payorder_result
  
 select d.payorder
   from fin.payorders d
  where d.partner = #partner#
 
  Take off the dynamic?
 
  Below a working example that I have:
 
  SELECT *
  FROM myTable
  WHERE condition_clause AND some_other_condition_clause
  isNotNull prepend=AND property=description
  description LIKE #description#
  /isNotNull
 
  dynamic
isGreaterThan prepend= and  property=owner compareValue=0
d.owner = #owner#
/isGreaterThan
  /dynamic
  
   /statement
  
   without dynamic all works,
   Log4J text.
  
   2005-05-12 16:26:52,718 INFO main TestIbatis TestIbatis - Executing:
   2005-05-12 16:26:53,703 DEBUG main 
   com.ibatis.common.jdbc.SimpleDataSource
   com.ibatis.common.jdbc.SimpleDataSource - Created connection 8002486.
   2005-05-12 16:26:53,703 DEBUG main java.sql.Connection
   com.ibatis.common.jdbc.logging.ConnectionLogProxy - {conn-10} 
   Connection
   2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
   com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
   PreparedStatement:
   select d.payorder from sell.payorders d where d.partner = ?
   dynamicisGreaterThan prepend= and  property=owner
compareValue=0 d.owner = ? /isGreaterThan/dynamic
   2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
   com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
   Parameters: [1, 15842]
   2005-05-12 16:26:53,765 DEBUG main java.sql.PreparedStatement
   com.ibatis.common.jdbc.logging.PreparedStatementLogProxy - {pstm-11}
   Types: [java.lang.Long, java.lang.Long]
   2005-05-12 16:26:53,781 DEBUG main 
   com.ibatis.common.jdbc.SimpleDataSource
   com.ibatis.common.jdbc.SimpleDataSource - Returned connection 8002486 to 
   pool.
  
 
 
 
 --
  ,
  Sergey  mailto:[EMAIL PROTECTED]
 



Custom Tag

2005-05-12 Thread Ming Xue
Title: RE: Oracle OC4J and signon



Hi 


I am 
very much amazed by Ibatis's ability to generate dynamic sql, which 
isblank in Hibernate. There are a couple predefined tags provided by 
default, But, does the framework support Custom Tags? if so, 
how can I attched them to the FrameWork?

thanks

Ming
[Ming 
Xue]

-Original 
Message-From: Trussell David N 
[mailto:[EMAIL PROTECTED]Sent: Thursday, May 12, 2005 2:35 
PMTo: 'ibatis-user-java@incubator.apache.org'Subject: RE: 
Oracle OC4J and signon

  Bingo! I commented out the security-constraint tag and 
  it all works nicely. 
  I made the assumption that most developers would know what 
  OC4J in the subject meant: Oracle Container for Java. It's based on Orion. My 
  apologies.
  Thank you for all your patience and help, Brice! Now, where 
  did I put that hammer 
  -Original Message- From: Brice 
  Ruth [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, May 12, 2005 11:59 AM To: ibatis-user-java@incubator.apache.org Subject: Re: Oracle OC4J and signon 
  can you find web.xml? there should be a 
  security-constraint tag in there ... that ties particular pages to a 
  security restriction.
  I wasn't aware that this was running in Oracle's App server as 
  well. If you mentioned that earlier, I apologize. 
  I've never used Oracle's App server ... so my help may be 
  limited in this area. 
  On 5/12/05, Trussell David N [EMAIL PROTECTED] 
  wrote:   
   I can't find a context.xml. As far as I can see, 
  a realm would be  configured in jazn-data.xml and 
  there are no entries in that file.  
   I get one of these entries in my 
  global-applications.log for each time  the pop-up 
  window is presented (meaning when I click "Sign-in" or  "Enter the Store"). I'm not well-versed enough in Java to know 
  what  this means:  
   05/05/12 10:18:04 jpetstore: Servlet error 
   java.lang.SecurityException  at 
  com.evermind[Oracle Application Server Containers for J2EE 10g 
   
  (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2676) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.HttpApplication.getLocalDispatcher(HttpApplication.java:4734) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.HttpSite.getRequestDispatcher(HttpSite.java:341) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:1368) 
at 
   
  org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062) 
   
  at  
  org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) 
   
  at  
  org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) 
   
  at  
  org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) 
   
  at  
  org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) 
   
  at  
  javax.servlet.http.HttpServlet.service(HttpServlet.java:740)  at 
   
  javax.servlet.http.HttpServlet.service(HttpServlet.java:853)  at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:810) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) 
at 
  com.evermind[Oracle Application Server Containers for J2EE  10g  
  (10.1.2.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) 
at 
  java.lang.Thread.run(Thread.java:534)  
   -Original Message-  From: Brice Ruth [mailto:[EMAIL PROTECTED]]  Sent: Thursday, May 12, 2005 9:30 AM  
  To: ibatis-user-java@incubator.apache.org  
  Subject: Re: Oracle OC4J and signon  

Hmmm ... well, take 
  a look at where the realm is configured. It would  
  have to be in context.xml as well as be referenced in web.xml ... 
On 5/12/05, Trussell David 
  N [EMAIL PROTECTED] wrote:  
   
  Yeah, j2ee/j2ee and ACID/ACID. But it doesn't accept either of those 
two.   
-Original Message-   From: Brice Ruth [mailto:[EMAIL PROTECTED]]   Sent: Thursday, May 12, 2005 9:09 AM   To: ibatis-user-java@incubator.apache.org   Subject: Re: Oracle OC4J and signon   Aha! This is basic realm authentication. I 

Re: Availability of 2.1.0

2005-05-12 Thread Brandon Goodin
i'll put an email out about 2.1.0 on the Dev list. We don't have a
release date specified at this point.

Brandon

On 5/12/05, Karen Koch [EMAIL PROTECTED] wrote:
 Still waiting on any kind of response on this one.  Even if the response is 
 we
 can't give you any real answer, that would be helpful.
 
 Also, just to verify, do I understand correctly that the fix for IBATIS-79 in
 Jira will not be available until version 2.1.0 (presumably not released yet) 
 is
 released?
 
 Thanks in advance, sorry to be a pest.
 
 Karen
 --- Karen Koch [EMAIL PROTECTED] wrote:
  Date: Fri, 6 May 2005 09:46:59 -0700 (PDT)
  From: Karen Koch [EMAIL PROTECTED]
  Subject: Availability of 2.1.0
  To: ibatis-user-java@incubator.apache.org
 
  Hello --
 
  I know one person already asked this in mid-April and didn't receive an
  answer,
  so perhaps you just don't know yet... but I'm going to ask anyway.
 
  I have an iBATIS app that uses nested resultMaps being introduced at a
  customer
  site in the next month or so.  I just spent 7 hours chasing down Jira bug 
  #79
  in my web app (http://issues.apache.org/jira/browse/IBATIS-79), because I 
  had
  primary keys on two tables related in a nested resultMap that just happened
  to
  be in sync.  Such fun.  :-)
 
  Anyway, I see that this problem has been fixed in 2.1.0.  I'd really like to
  have this fix, as the situation that causes the bug is perfectly valid and
  might occur easily in the future, but I don't see us upgrading to a nightly
  build for something we're going to install at a customer site.  Help?
 
  Thank you so much for any info you can give regarding the 2.1.0 release /
  release date.  iBATIS has been wonderful for this project.  Keep up the 
  great
  work.
 
  Karen Koch
  Programmer/Analyst
  iDC Chicago, IL
 
 
 



Re: Custom Tag

2005-05-12 Thread Larry Meadors
A couple?

Check again.

That is an interesting idea though.

Larry

PS: Please do not reply to other posts with new topics.On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote:







Hi 


I am 
very much amazed by Ibatis's ability to generate dynamic sql, which 
isblank in Hibernate. There are a couple predefined tags provided by 
default, But, does the framework support Custom Tags? if so, 
how can I attched them to the FrameWork?
 


Re: Custom Tag

2005-05-12 Thread Brandon Goodin
The functionality does not currently exist. It would be difficult to
implement that functionality in the current iBatis version. It might
be a featuer we'd consider for the next major release of ibatis. What
kind of functionality are you wanting to implement that iBatis does
not deal with?

Also, have you read the dynamic sql whiteboard?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Improved+Dynamic+SQL+Whiteboard

Brandon

On 5/12/05, Larry Meadors [EMAIL PROTECTED] wrote:
 A couple?
  
  Check again.
  
  That is an interesting idea though.
  
  Larry
  
  PS: Please do not reply to other posts with new topics.
 
 
 On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote: 
  
  Hi 

  I am very much amazed by Ibatis's ability to generate dynamic sql, which
 is blank in Hibernate.  There are a couple predefined tags provided by
 default,  But,  does the framework support  Custom Tags? if so, how can I
 attched them to the FrameWork? 
  
  
 



RE: Custom Tag

2005-05-12 Thread Ming Xue



For 
example, for Oracle in list limitation while using 


select 
* from abc
where 
a in ('a', 'b', 'c', ...)

We 
need to use a Custom tag for this.

Thanks


  -Original Message-From: Larry Meadors 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, May 12, 2005 5:21 
  PMTo: ibatis-user-java@incubator.apache.orgSubject: Re: 
  Custom TagA couple?Check again.That is an 
  interesting idea though.LarryPS: Please do not reply to other 
  posts with new topics.
  On 5/12/05, Ming 
  Xue [EMAIL PROTECTED] 
  wrote: 
  
Hi 

I am very much amazed by 
Ibatis's ability to generate dynamic sql, which isblank in 
Hibernate. There are a couple predefined tags provided by 
default, But, does the framework support Custom Tags? if 
so, how can I attched them to the FrameWork?



Re: Custom Tag

2005-05-12 Thread Brandon Goodin
That is not a clear example. I'm not sure what the problem is that you
are presenting. What tag would you write to accomplish a solution to
the problem you are presenting?

If you are referring to the population of an IN statement then you
could use iterate.

Brandon

On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote:
  
 For example,   for Oracle in list limitation while using 
   
 select * from abc 
 where a in ('a', 'b', 'c', ...) 
   
 We need to use a Custom tag for this. 
   
 Thanks 
   
  
 -Original Message-
 From: Larry Meadors [mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 12, 2005 5:21 PM
 To: ibatis-user-java@incubator.apache.org
 Subject: Re: Custom Tag
 
 A couple?
 
 Check again.
 
 That is an interesting idea though.
 
 Larry
 
 PS: Please do not reply to other posts with new topics.
 
  
 On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote: 
  
  Hi 

  I am very much amazed by Ibatis's ability to generate dynamic sql, which
 is blank in Hibernate.  There are a couple predefined tags provided by
 default,  But,  does the framework support  Custom Tags? if so, how can I
 attched them to the FrameWork? 
  
  
 



RE: Custom Tag

2005-05-12 Thread Ming Xue

The Oralce in list limition is 250,  otherwise the sql can not be parsed,
For example:

select * from abc 
where a in ('a', 'b', 'c', ...) 

if there are more than 250 values in the in list, the sql needs to be
rewritten as:

select * from abc
where a in ('a', 'b', 'c'...)
or a in ('x', 'y', 'z'...)
or ...

In this way every inlist is less than 250

The Iterate tag is designed for generating the in-list, for it is not aware
of the Oracle limitation, so is there anyway I can modify the existing
iterate tag or creating a new one?

Thanks



-Original Message-
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 5:40 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Custom Tag


That is not a clear example. I'm not sure what the problem is that you
are presenting. What tag would you write to accomplish a solution to
the problem you are presenting?

If you are referring to the population of an IN statement then you
could use iterate.

Brandon

On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote:
  
 For example,   for Oracle in list limitation while using 
   
 select * from abc 
 where a in ('a', 'b', 'c', ...) 
   
 We need to use a Custom tag for this. 
   
 Thanks 
   
  
 -Original Message-
 From: Larry Meadors [mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 12, 2005 5:21 PM
 To: ibatis-user-java@incubator.apache.org
 Subject: Re: Custom Tag
 
 A couple?
 
 Check again.
 
 That is an interesting idea though.
 
 Larry
 
 PS: Please do not reply to other posts with new topics.
 
  
 On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote: 
  
  Hi 

  I am very much amazed by Ibatis's ability to generate dynamic sql, which
 is blank in Hibernate.  There are a couple predefined tags provided by
 default,  But,  does the framework support  Custom Tags? if so, how can I
 attched them to the FrameWork? 
  
  
 



Re: Custom Tag

2005-05-12 Thread Brandon Goodin
I see. The question here is whether this is a common database issue
and if it should be supported. However, it does not seem to be a
common issue and there are ways to work around this. My other thought
is why do you have over 250+ IN parameters? Maybe you need to
rethink what you are developing. There would seem to be a reson why
there is a 250 cap. Go ahead and drop an enhancement request into
JIRA. We'll consider this in the next major release.

Brandon

On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote:
 
 The Oralce in list limition is 250,  otherwise the sql can not be parsed,
 For example:
 
 select * from abc
 where a in ('a', 'b', 'c', ...)
 
 if there are more than 250 values in the in list, the sql needs to be
 rewritten as:
 
 select * from abc
 where a in ('a', 'b', 'c'...)
 or a in ('x', 'y', 'z'...)
 or ...
 
 In this way every inlist is less than 250
 
 The Iterate tag is designed for generating the in-list, for it is not aware
 of the Oracle limitation, so is there anyway I can modify the existing
 iterate tag or creating a new one?
 
 Thanks
 
 
 -Original Message-
 From: Brandon Goodin [mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 12, 2005 5:40 PM
 To: ibatis-user-java@incubator.apache.org
 Subject: Re: Custom Tag
 
 That is not a clear example. I'm not sure what the problem is that you
 are presenting. What tag would you write to accomplish a solution to
 the problem you are presenting?
 
 If you are referring to the population of an IN statement then you
 could use iterate.
 
 Brandon
 
 On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote:
 
  For example,   for Oracle in list limitation while using
 
  select * from abc
  where a in ('a', 'b', 'c', ...)
 
  We need to use a Custom tag for this.
 
  Thanks
 
 
  -Original Message-
  From: Larry Meadors [mailto:[EMAIL PROTECTED]
  Sent: Thursday, May 12, 2005 5:21 PM
  To: ibatis-user-java@incubator.apache.org
  Subject: Re: Custom Tag
 
  A couple?
 
  Check again.
 
  That is an interesting idea though.
 
  Larry
 
  PS: Please do not reply to other posts with new topics.
 
 
  On 5/12/05, Ming Xue [EMAIL PROTECTED] wrote:
  
   Hi
  
   I am very much amazed by Ibatis's ability to generate dynamic sql, which
  is blank in Hibernate.  There are a couple predefined tags provided by
  default,  But,  does the framework support  Custom Tags? if so, how can I
  attched them to the FrameWork?
  
  
 
 



[OT] JPetStore - BaseBean / BeanAction

2005-05-12 Thread Lieven De Keyzer
I took the lastest JPetStore as a starting point for my application.
The problem I have now: I want to have multiple actions in one form. I have 
a set of objects belonging to a user and this are displayed together with a 
checkbox for each object. I want the users to be able to check a few boxes 
and let them choose to delete those, or edit them all at once, etc...

Normall I think one should implement a class that inherits from the 
DispatchAction Class.

I guess using the BaseBean and BeanAction class, this should even be 
simpler. Should I use the same tactic as the DispatchAction class uses ? 
Something like:

public Class TreeLevel extends BaseBean {
 private String method;
 public String formAction {
   if (method == foo) {
  return foo(); }
   else { return bar(); }
}
 private String foo() {
   //
}
 private String bar() {
 }
}
And then in my jsp page:
  html:form action=/formAction
   html:submit property=method value=foo /
   html:submit property=method value=bar /
 /html:form



Re: [OT] JPetStore - BaseBean / BeanAction

2005-05-12 Thread Brandon Goodin
i'm not sure about your formAction semantic. You should name it
something meaningful like removeFoo. The method names should be
named after the actions that are taking place. But, yes you would
follow the same semantic. You need to realize that JPetstore is NOT
standard struts practice. It is a way to use struts in a more modern
manner (i.e. Action has properties on it rather than sepearate in an
ActionForm.). Otherwise, it sounds like you have the idea down fairly
well.

Brandon

On 5/12/05, Lieven De Keyzer [EMAIL PROTECTED] wrote:
 I took the lastest JPetStore as a starting point for my application.
 
 The problem I have now: I want to have multiple actions in one form. I have
 a set of objects belonging to a user and this are displayed together with a
 checkbox for each object. I want the users to be able to check a few boxes
 and let them choose to delete those, or edit them all at once, etc...
 
 Normall I think one should implement a class that inherits from the
 DispatchAction Class.
 
 I guess using the BaseBean and BeanAction class, this should even be
 simpler. Should I use the same tactic as the DispatchAction class uses ?
 Something like:
 
 public Class TreeLevel extends BaseBean {
 
   private String method;
 
   public String formAction {
 if (method == foo) {
return foo(); }
 else { return bar(); }
 }
 
   private String foo() {
 //
 }
 
   private String bar() {
   }
 }
 
 And then in my jsp page:
 
html:form action=/formAction
 html:submit property=method value=foo /
 html:submit property=method value=bar /
   /html:form
 



Re: [OT] JPetStore - BaseBean / BeanAction

2005-05-12 Thread Lieven De Keyzer

From: Brandon Goodin [EMAIL PROTECTED]
Reply-To: Brandon Goodin [EMAIL PROTECTED]
To: ibatis-user-java@incubator.apache.org
Subject: Re: [OT] JPetStore - BaseBean / BeanAction
Date: Thu, 12 May 2005 19:01:02 -0600
i'm not sure about your formAction semantic. You should name it
something meaningful like removeFoo.  The method names should be
named after the actions that are taking place.
Yes, I should have given my real problem instead of this one. But that would 
mean my action would be called: folderActions. And the methods foo and bar 
would be: remove and edit.

But, yes you would follow the same semantic. You need to realize that 
JPetstore is NOT
standard struts practice. It is a way to use struts in a more modern
manner (i.e. Action has properties on it rather than sepearate in an
ActionForm.).
And I like this modern way better than the old one. :)
Otherwise, it sounds like you have the idea down fairly well.
Brandon
On 5/12/05, Lieven De Keyzer [EMAIL PROTECTED] wrote:
 I took the lastest JPetStore as a starting point for my application.

 The problem I have now: I want to have multiple actions in one form. I 
have
 a set of objects belonging to a user and this are displayed together 
with a
 checkbox for each object. I want the users to be able to check a few 
boxes
 and let them choose to delete those, or edit them all at once, etc...

 Normall I think one should implement a class that inherits from the
 DispatchAction Class.

 I guess using the BaseBean and BeanAction class, this should even be
 simpler. Should I use the same tactic as the DispatchAction class uses ?
 Something like:

 public Class TreeLevel extends BaseBean {

   private String method;

   public String formAction {
 if (method == foo) {
return foo(); }
 else { return bar(); }
 }

   private String foo() {
 //
 }

   private String bar() {
   }
 }

 And then in my jsp page:

html:form action=/formAction
 html:submit property=method value=foo /
 html:submit property=method value=bar /
   /html:form





Re: Availability of 2.1.0

2005-05-12 Thread Clinton Begin
Karen,

A release could be as early as this weekend, but is not guaranteed.

I'm sure if it's not, that we can at least commit to giving you (and everyone else) a date. 

Sorry for the lack of clarity here. 

Cheers,
ClintonOn 5/12/05, Karen Koch [EMAIL PROTECTED] wrote:
Still waiting on any kind of response on this one.Even if the response is wecan't give you any real answer, that would be helpful.Also, just to verify, do I understand correctly that the fix for IBATIS-79 in
Jira will not be available until version 2.1.0 (presumably not released yet) isreleased?Thanks in advance, sorry to be a pest.Karen--- Karen Koch [EMAIL PROTECTED]
 wrote: Date: Fri, 6 May 2005 09:46:59 -0700 (PDT) From: Karen Koch [EMAIL PROTECTED] Subject: Availability of 2.1.0 To: 
ibatis-user-java@incubator.apache.org Hello -- I know one person already asked this in mid-April and didn't receive an answer, so perhaps you just don't know yet... but I'm going to ask anyway.
 I have an iBATIS app that uses nested resultMaps being introduced at a customer site in the next month or so.I just spent 7 hours chasing down Jira bug #79 in my web app (
http://issues.apache.org/jira/browse/IBATIS-79), because I had primary keys on two tables related in a nested resultMap that just happened to be in sync.Such fun.:-) Anyway, I see that this problem has been fixed in 
2.1.0.I'd really like to have this fix, as the situation that causes the bug is perfectly valid and might occur easily in the future, but I don't see us upgrading to a nightly build for something we're going to install at a customer site.Help?
 Thank you so much for any info you can give regarding the 2.1.0 release / release date.iBATIS has been wonderful for this project.Keep up the great work. Karen Koch
 Programmer/Analyst iDC Chicago, IL

Re: Availability of 2.1.0

2005-05-12 Thread Nathan Maves
Now that we are on the topic.

Is this a bug fix release or a feature release?

In the case that it is a feature release what can we expect?

Nathan

On May 12, 2005, at 9:53 PM, Clinton Begin wrote:

Karen,

A release could be as early as this weekend, but is not guaranteed.

I'm sure if it's not, that we can at least commit to giving you (and everyone else) a date.

Sorry for the lack of clarity here. 

Cheers,
Clinton

On 5/12/05, Karen Koch [EMAIL PROTECTED]> wrote:
can't give you any real answer, that would be helpful.

Also, just to verify, do I understand correctly that the fix for IBATIS-79 in 
Jira will not be available until version 2.1.0 (presumably not released yet) is
released?

Thanks in advance, sorry to be a pest.

Karen
--- Karen Koch [EMAIL PROTECTED] > wrote:
> Date: Fri, 6 May 2005 09:46:59 -0700 (PDT)
> From: Karen Koch [EMAIL PROTECTED]>
> Subject: Availability of 2.1.0
> To: ibatis-user-java@incubator.apache.org
>
> Hello --
>
> I know one person already asked this in mid-April and didn't receive an
> answer,
> so perhaps you just don't know yet... but I'm going to ask anyway. 
>
> I have an iBATIS app that uses nested resultMaps being introduced at a
> customer
> site in the next month or so.  I just spent 7 hours chasing down Jira bug #79
> in my web app ( http://issues.apache.org/jira/browse/IBATIS-79), because I had
> primary keys on two tables related in a nested resultMap that just happened
> to
> be in sync.  Such fun.  :-)
>
> Anyway, I see that this problem has been fixed in 2.1.0.  I'd really like to
> have this fix, as the situation that causes the bug is perfectly valid and
> might occur easily in the future, but I don't see us upgrading to a nightly
> build for something we're going to install at a customer site.  Help?
>
> Thank you so much for any info you can give regarding the 2.1.0 release /
> release date.  iBATIS has been wonderful for this project.  Keep up the great
> work.
>
> Karen Koch
> Programmer/Analyst
> iDC Chicago, IL
>
>
>