How do you know if appending NOWAIT to the select statement is correct
syntax for all DBMS? What's wrong with my old suggestion? Have templates
for specific DB queries like select-for-update.
>From my old post:
What do you think of these ideas? What I wanted to do was extend the
database typemappings in standardjaws.xml.
<type-mappings>
<type-mapping-definition>
<name>Oracle8</name>
<select-for-update-supported>true</select-for-update-supported>
<select-for-update-format>![CDATA[SELECT %i FROM %t WHERE %w
FOR
UPDATE]]</select-for-update-format>
<select-for-update-no-wait-supported>true</select-for-update-supported>
<select-for-update-no-wait-format>![CDATA[SELECT %i FROM %t
WHERE %w
FOR
UPDATE NOWAIT ]]</select-for-update-format> <mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>SMALLINT</sql-type>
</mapping>
where "%i" is the items to be select, "%t" is the tablename, and "%w" is the
where clause. If a bean turns on select-for-update and it is not supported
by the type-mapping, then an exception should be thrown on deployment.
Maybe your rowid thingy should be put in there as well in the same manner.
And then in jaws.xml
<select-for-update wait="true">true</select-for-update>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Vinay
> Menon
> Sent: Friday, August 10, 2001 4:18 AM
> To: JBossDev
> Subject: [JBoss-dev] NOWAIT option
>
>
> Hello,
> Had made a little change to JawsEntityMetaData and the
> JDBCLoad thingey
> to support the NOWAIT, select for update option. Worthwhile if I post the
> change here? The idea is simple
>
> 1. Have a field in jaws.xml called <wait-option>
> 2. Don't specify it if you don't need anything special. If you want a no
> wait option specify it as <wait-option>NOWAIT<wait-option> or any other
> option that is dbms specific
> 3. In the LoadEntityCommand append this text to the select for
> update sql if
> <select-for-update> has been specified to be true.
>
>
> Vinay
>
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-development
>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
