# Facing issue using ENUM

**URL:** <https://forum.confluent.io/t/facing-issue-using-enum/9043>\
**Category:** Self-Managed Connectors\
**Created:** [9 November 2023 11:11 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043 "2023-11-09T11:11:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![suyog](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@suyog](https://forum.confluent.io/u/suyog)\
**Post date:** [9 November 2023 11:11 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043/1 "2023-11-09T11:11:31Z")

</div>

Hi,  
I have one field ‘statusCode’ in my schema with dataType as ENUM.  
When I am trying to publish the event I’m getting “Caused by: org.apache.avro.AvroTypeException: Not an enum: S for schema”.  
I tried by casting dataType into enum in select query but got invalid datatype for it in Oracle. Using transforms also no luck, I can’t use custom transformers in my application, Also don’t have access to change the schema.  
I am using value.converter as Avro & key.converter as String  
Is there any way achieve this?

---

<div class="post-metadata">

**Author:** ![dtroiano](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/dtroiano/32/1961_2.png) [@dtroiano](https://forum.confluent.io/u/dtroiano)\
**Post date:** [9 November 2023 17:09 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043/2 "2023-11-09T17:09:27Z")

</div>

What connector are you using? `JdbcSourceConnector`? Could you please share more details on the Oracle DDL and connector configuration? What do you mean when you say “When I am trying to publish the event”? Do you mean when you add a row to the table in Oracle?

---

<div class="post-metadata">

**Author:** ![suyog](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@suyog](https://forum.confluent.io/u/suyog)\
**Post date:** [9 November 2023 19:06 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043/3 "2023-11-09T19:06:49Z")

</div>

Yes, I am using kafka JDBC source connector.  
I have one event/data in oracle table with 3 fields/columns in it.  
ie AcctKey, statusCode & EventTopic.  
Datatype of statusCode is enum( values {S, R})  
Using source connector I am trying to publish that event/data from oracle table & I am also using Kafka jdbc sink connector to consume same event/data in postgres Table. But dataType enum is not supporting.

---

<div class="post-metadata">

**Author:** ![dtroiano](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/dtroiano/32/1961_2.png) [@dtroiano](https://forum.confluent.io/u/dtroiano)\
**Post date:** [9 November 2023 21:30 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043/4 "2023-11-09T21:30:19Z")

</div>

Try setting `value.converter.enhanced.avro.schema.support=true`. From the [docs](https://docs.confluent.io/platform/current/schema-registry/connect.html#avro):

> When set to `true` , this property preserves Avro schema package information and Enums when going from Avro schema to Connect schema. This information is added back in when going from Connect schema to Avro schema.

---

<div class="post-metadata">

**Author:** ![suyog](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@suyog](https://forum.confluent.io/u/suyog)\
**Post date:** [10 November 2023 06:48 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043/5 "2023-11-10T06:48:27Z")

</div>

Hi Dave, Thanks!  
I tried by setting property “value.converter.enhanced.avro.schema.support”: “true” in my source connector config, but no luck ☹ Still getting same exception

---

<div class="post-metadata">

**Author:** ![JSeng](https://avatars.discourse-cdn.com/v4/letter/j/8dc957/32.png) [@JSeng](https://forum.confluent.io/u/JSeng)\
**Post date:** [13 December 2023 14:17 UTC](https://forum.confluent.io/t/facing-issue-using-enum/9043/6 "2023-12-13T14:17:18Z")

</div>

Hello,  
I have the same issue. Have you been able to find a solution ?  
The property “value.converter.enhanced.avro.schema.support”: “true” also doesn’t work for me.