Message Title

I digged into the code and there is something strange.

In both cases, for the Entity#conlusion and Entity_audit#conclusion no Column#setSqlTypeName is set (the setter is called with NULL).
When the Column#getSqlTypeName getter is called, the sql type is detected using the ddlTypeRegistry.
There are different results.

For the Entity class:

                              getSqlTypeCode( mapping ) = 2005
getColumnSize( dialect, mapping ) = Size(length = 255, scale = 2)
ddlTypeRegistry.getTypeName( getSqlTypeCode( mapping ), getColumnSize( dialect, mapping ) ) = "oid"
                              

But for the Entity_audit class, the ddlTypeRegistry returns varchar:

                              getSqlTypeCode( mapping ) = 12
getColumnSize( dialect, mapping ) = Size(length = 255, scale = 2)
ddlTypeRegistry.getTypeName( getSqlTypeCode( mapping ), getColumnSize( dialect, mapping ) ) = "varchar(255)"
                              

But the issue is not here, the sqlTypeCode was set before.

When BasicValue#resolveColumn is called, the resolution differs.

For the Entity class, the resolution is:

                              InferredBasicValueResolution(
  jdbcType = ClobTypeDescriptor(CLOB_BINDING)
  jdbcMapping = basicType(java.lang.String, 2005)
  legacyType = basicType(java.lang.String, 2005)
)
                              

And for the Entity_audit class, the resolution is:

                              NamedBasicTypeResolution(
  basicType = basicType(java.lang.String, 12)
)
                              

I’m still searching why the NamedBasicTypeResolution has the wrong type.

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira