I'm glad you've had some success!
Yes - you can control exactly what gets generated by Abator. The XML <table> element supports these attributes:
enableInsert
enableSelectByPrimaryKey
enableSelectByExample
enableUpdateByPrimaryKey
enableDeleteByPrimaryKey
enableDeleteByExample
enableSelectByExample
enableUpdateByPrimaryKey
enableDeleteByPrimaryKey
enableDeleteByExample
They all default to true. It sounds like you should set the attributes as follows:
enableSelectByExample="false"
enableDeleteByExample="false"
enableDeleteByExample="false"
Lastly, Abator does not support stored procedures or arbitrary queries at this point. I think arbitrary queries would be a good addition, but I'm not so sure about stored procedures.
Jeff Butler
On 1/10/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
Hi
I did configure Aator and ran to create sql mapping
for 1 table (PODATA),
it worked but then created on more java class called
(PodataExample) and also in
CXASHTEST_PODATA_SqlMap.xml (CXASHTEST is schema name)
there is a xml tags for
<resultMap id="abatorgenerated_PodataResult"
class="com.ashishk.testpe.data.Podata ">
<result column="SYSTEM" property="system"
jdbcType="CHAR" />
<!-- and a lot more -->
then
<sql id="abatorgenerated_Example_Where_Clause">
<isPropertyAvailable prepend="or"
property="OR_PDBLRF_LIKE">
PDBLRF like #pdblrf#
</isPropertyAvailable>
</dynamic>
</sql>
and then some other things
Is it possible to get only 4 querries as
select column1, column2 from table1 where key =
#value# (where key is the primary key)
and then querry to insert, update and delete.
Also is there a utility which will create a java class
by running a stored procedure or sql statement, and
required setMethods class
Ashish
www.shriayurveda.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
