How do I make Java & Postgres enums work together for update?
<p>acttype is an enumcs so you can't insert it as a normal string
without casting it to an enumcs <code>INSERT INTO dir_act (actcode,actname,acttype,national_code) VALUES (?,?,?::enumcs,?)</code></p>
<p>Where as for updating I tried with same typecasting as follows, but it does not worked.</p>
<pre><code>update dir_act set actname=?,acttype=?::enumcs,national_code=? where actcode=?
</code></pre>