Upgrading to Yellowfin error: String cannot be cast to Date

Yellowfin FAQ shared this problem ago

Resolved

When upgrading, an error is experienced and the upgrade is unable to be completed.

liquibase.exception.LockException: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Date

What is happening and how do I resolve it?

The same problem 0

Comments (1)

Simon ● 2 years ago

This error occurs when the jTDS Driver is used to connect to a SQL Server Yellowfin Configuration Database.

In order to resolve this upgrade error, you need to change the jTDS Driver to a SQL Server Driver. The ~/ROOT/WEB-INF/web.xml will need to be updated to reference the SQL Driver and Connection string.

Change this:

<init-param>
<param-name>JDBCDriverClass</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>

To this:

<init-param>
<param-name>JDBCDriverClass</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>

And change this:

<init-param>
<param-name>JDBCUrl</param-name>
<param-value>jdbc:jtds:sqlserver://<host>:<port>/<database></param-value>
</init-param>

To this:

<init-param>
<param-name>JDBCUrl</param-name>
<param-value>jdbc:sqlserver://<host>:<port>;databaseNAme=<database></param-value>
</init-param>

If you are still facing issues, please raise a ticket with our Support Team containing a detailed description of your issue, including any relevant screenshots.

Kind regards,

Yellowfin Support Team

Reply URL