Which is why I wanted the NOWAIT flag in type-mappings so that when the bean
deployed an exception would be thrown if nowait was turned on. Agree?
Bill
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Dave
> Smith
> Sent: Friday, August 10, 2001 12:11 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-dev] NOWAIT option
>
>
> 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
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
