Re: Request to change access modifiers

2005-10-19 Thread Larry Meadors
Please attach the changed code to the JIRA issue. As far as changing the access modifiers, I am all for it - I have had to do similar things, and protected still provides an adequate layer of idiot-proofing while (as you said) not changing any existing behavior. IMO, protected means "use at your o

Re: Request to change access modifiers

2005-10-19 Thread Jeff Butler
Hi Jeff!   The Cards forgot how to bat AGAIN in the post series :-(   Your request sounds reasonable to me.  Please make a JIRA enhancement request with the details of what should change from private to protected, then we'll remember to get to it (maybe someone should take a look at this in general

Re: Performance issue with CustomTypeHandler

2005-10-19 Thread Mike Fagan
Satish, I am using the same and suspect that the problem you are experiencing is with the proc. try this is sqlplus set timing on var results refcursor; exec your_procedure( your_params, :results ); -- for a procedure exec :results := your_function( your_params ); -- for a function print :res

Re: Lazy loader throwing NPE

2005-10-19 Thread Geoff Chiang
Sorry Reuben, but I'm not quite clear on how you're loading your SqlMaps classes within Spring. The reason that I'm wondering about your Spring configuration is because I came across the same issue a while back and fixed it by explicitly setting the dataSource property of Spring's SqlMapClientFact

Re: Lazy loader throwing NPE

2005-10-19 Thread reuben
Sure. I can't do this via the BeanFactory (this is a standalone jar) so I've been doing it in code as either one of the following to wrap the DAO in transactions: Configuration 1: Code:             Properties p = new Properties();             p.setProperty("cr

Request to change access modifiers

2005-10-19 Thread Jeff Roberts
I have recently added and extension to the iBatis framework. In order for my extension to work effectively, I had to subclass several of the iBatis classes. In doing so, I found that some of the methods and variables in the iBatis classes were declared as private, preventing me access to them fro

RE: Performance issue with CustomTypeHandler

2005-10-19 Thread Rao, Satish
Title: Message Hi Mike   We are using Oracle 9i and I am using ojdbc14.jar. But my classpath also has classes12.jar. I removed classes12.jar, but that did not make any difference. What Oracle version and driver are you using?   Also I am using "oracle.jdbc.OracleDriver" as my driver classn

Re: Performance issue with CustomTypeHandler

2005-10-19 Thread Mike Fagan
Rao, Satish wrote: Message Hi Mike,   Thanks for the prompt response.   If we run the PL/SQL via SQL Plus, we don't experience the same delay (there are about a million records in the database) As far as the database is concerned, we don't have much insight into the configu

Re: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread neilhenry
The delete needs a close node. Quoting David Moss <[EMAIL PROTECTED]>: > I'm getting this exception when trying to start my web app in Tomcat5. > > my sql-map-config.xml file contains: > > > 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> > > > >

RE: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread Niels Beekman
You should use a closing delete-tag instead of a new one :) delete from maps where id = #id# Perhaps you should consider to edit your SQLMaps in an DTD-aware application... Grtz, Niels -Original Message- From: David Moss [mailto:[EMAIL PROTECTED] Sent: woensdag 19 oktober 2005 16:

Re: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread David Moss
Sorry, I've found it. Hadn't closed a tag correctly. What a stupid mistake, and I'd spent ages looking for it too. David Moss wrote: I'm getting this exception when trying to start my web app in Tomcat5. my sql-map-config.xml file contains: http://www.ibatis.com/dtd/sql-map-config-2

org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread David Moss
I'm getting this exception when trying to start my web app in Tomcat5. my sql-map-config.xml file contains: http://www.ibatis.com/dtd/sql-map-config-2.dtd";> and Map.xml contains... http://www.ibatis.com/dtd/sql-map-2.dtd";>

Re: Lazy loader throwing NPE

2005-10-19 Thread Geoff Chiang
Can you post your Spring configuration for the relevant beans? Geoff --- [EMAIL PROTECTED] wrote: > If I turn lazy loading on, it is throwing an NPE from one specific > sqlmaps > query. The other queries & inserts work correctly. > > When I posted this problem last week, I misdirected attention

Re: Batch not batching!

2005-10-19 Thread Larry Meadors
Gary is correct. The EXTERNAL transaction manager does nothing. Larry On 10/19/05, Gary Barlow <[EMAIL PROTECTED]> wrote: > My understanding is that when an external transaction manager is used that > startTransaction call does NOT start a new transaction. I have tested this > in a weblogic EJB

Re: Inserting null into SQLServer DATETIME field

2005-10-19 Thread Larry Meadors
Those should be one of the constants from the java.sql.Types class. Larry On 10/19/05, Matthew Hegarty <[EMAIL PROTECTED]> wrote: > > Thanks - that seems to have sorted it. > For some reason I thought you specified the DB field type in the mapping, > not the java type. >

RE: Inserting null into SQLServer DATETIME field

2005-10-19 Thread Matthew Hegarty
Title: Inserting null into SQLServer DATETIME field Thanks - that seems to have sorted it. For some reason I thought you specified the DB field type in the mapping, not the java type. From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: 19 October 2005 10:06To: user-java@ibatis.ap

RE: Batch not batching!

2005-10-19 Thread Gary Barlow
My understanding is that when an external transaction manager is used that startTransaction call does NOT start a new transaction. I have tested this in a weblogic EJB container and it works as expected. The container still has controll over the transaction. Gary Hi Clinton, Just a bi

using result maps within result maps

2005-10-19 Thread neilhenry
I have a situation where I have several tables with one-to-one relationships. Each of which has 20 + columns. As each of them requires to be queried individually I have created result maps for each one. We also need to get all the data related to the central table and I would like to do this in o

RE: Inserting null into SQLServer DATETIME field

2005-10-19 Thread Niels Beekman
Title: Inserting null into SQLServer DATETIME field Hi,   java.sql.Types.DATETIME does not exist in Java 1.4, we use TIMESTAMP, see the API of your Java-version…   Niels   From: Matthew Hegarty [mailto:[EMAIL PROTECTED] Sent: woensdag 19 oktober 2005 11:01 To: user-java@ibati

Inserting null into SQLServer DATETIME field

2005-10-19 Thread Matthew Hegarty
Title: Inserting null into SQLServer DATETIME field All I am having trouble inserting null values into a SQL Server DATETIME field. I have specified the following mapping:     insert into TASK_INSTANCES (START_DATETIME, END_DATETIME, ID_TASK_TYPE, ID_TASK_STATE)     values (#startDateTi

RE: Batch not batching!

2005-10-19 Thread Priyesh Mashelkar
Hi Clinton, Just a bit confused. Want to clarify this thing. Do you mean to say that when a EXTERNAL transaction manager is used, the startTransaction will start a new transaction and will not participate in the parent transaction. And if the JTA transaction manager is used, it