PosgreSQL does not support the NOWAIT option. It is not in the SQL92 spec.
Bill Burke wrote:
> 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
>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
