I have a problem at work which I have to solve in a hurry due to a deadline.
I wrote a perfectly functioning web application using mySQL (v5), iBatis, and
ABATOR that correctly with no modification needed could insert a BLOB field in
a table and retrieve a BLOB from the table.
Today I con
;
}
--- [EMAIL PROTECTED] wrote:
>
> user-java Digest 30 Apr 2007 02:10:33 - Issue 941
>
> --
> > Date: Fri, 27 Apr 2007 15:05:44 -0700 (PDT)
> From: Robert Glover <[EMAIL PROTECTED]>
&
I am confused over how to use transactions with iBatis and Spring. (I'm
actually using iBatis and Abator and Spring).
The Spring 2.0.6 manual (section 12.5) says,
"...Transaction management can be handled through Spring's standard
facilities. There are no special transaction strategies fo
I'm at my wits end, tearing my hair out over this problem.
I use Abator to generate all my IBatis classes and XML.
When my Spring web app starts up I get this error:
Error parsing XPath '/sqlMap/resultMap/result'.
Cause: com.ibatis.common.beans.ProbeException:
There is no WRITEABLE property named
did not work:
All the above did was change something inside ATADMIN_IAT_HR_EMP_SqlMap.xml.
So my question is, other than renaming the 2nd table, is there any Abator
solution that will solve the problem of duplicate table class names?
......
> From: Robert Glo
n example from the book of using an Oracle regular
expression:
SELECT park_name FROM park
WHERE REGEXP_LIKE(description, '[[:digit:]]{3}-[[:digit:]]{4}');
If there is a way to do that with Abator it would be tremendously helpful
in my current project, in place of "LIKE".
Robert Glover
I am trying to use Abator to do the equivalent of the following SQL
statement, which as you can see is changing the "EMP_ID". "EMP_ID" and
"SERIAL_NUM" together comprise the primary key.
"UPDATEATADMIN.IAT_ASSET
SET EMP_ID = ? ,
BUDGET_UNIT = ? ,
ASSET_COMMENT = ? ,
DECOMM_REQ_FLG =
matical if there are any foreign keys related to the
>table. Also, it's not clear what the intent is when changing a primary key -
>was the record related to the wrong employee, or did the employee id change?
>Jeff Butler
>>On 9/7/07, Robert Glover <[EMAIL PROT
I need a workaround for a problem in Abator with Microsoft Sql Server.
Abator generates the following SQL statment which gives an error (the problem
is that "FUNCTION" is a keyword):
select BUDGET_UNIT, FUNCTION, FUNCTION_NAME from b0maschm.MAT_ORGSTRUCTURE
The error it gives is:
-
The Abator update shown below will not compile because Abator will not
generate the "updateByPrimary" method.
The reason Abator will not generate the "updateByPrimary" method is that the
table has a "unique" constraint on a column but does not define that column as
being a primary key. (The
After so many years in this business I should have tried this instead of
spending over two hours trying to find less straight forward
solution/explanations. I had been doing a lot of ALTER statements in Aqua Data
Studio, changing the VIEW, etc., etc. In addition I had also been re-genning
all t
My abator problem is that the last 5 characters of a field are being chopped
off. In the example I show below, those 5 characters are: "5F:E4". This
chopping off only occurs under the conditions shown below. Note the database is
Oracle 10g.
In my java code I have the following:
IavAssetInfo
Hi,
I am a big fan of Abator and iBatis. Abator is fantastic. I have a
question though. In Oracle the way to limit results to (for example) 20 rows is:
select col from tbl where rownum<=20;
Using the wonderful Abator, is there a way I can do that?
(Second question, much less importan
Hello,
I am a great, great fan of iBatis Abator. I use Abator in all my work.
Today however I must drop down into iBatis for a special situation involving
paging through a large data set. I can do this two different ways. The way I
will probably do because it's easier to code, is to use s
out to more people
about it.
Robert Glover
Disclaimer: I think Ibator is the greatest thing since bread. Ibator rocks!
A programmer who has taken over an Ibatis Ibator program I wrote, asked me
about the behavior of an Ibator generated INSERT statement as regards a column
that allows nulls but has a default value. This developer
Disclaimer: I really, really like Ibator and use it in all my projects.
A programmer has inherited one of my projects that uses Ibator. He needs to
use Ibator to do some name comparisons on people's names. For example, a
database column might contain a value of "John .J. Hancock". He
From:Robert Glover
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2008 5:10 PM
To: user-java@ibatis.apache.org
Subject: Is there a way using Ibator to do a case-insensitive LIKE
compare
Disclaimer: I really, really like Ibator and use it in all my projects.
A programmer has inherited
sample code above the
createCriteriaInternal method should have returned new ExtendedCriteria object.
With that change, I am told by a developer (Ilya) who tried it, it works very
nicely. (Thanks Ilya!).
Robert Glover August 4, 2008
===
19 matches
Mail list logo
