Quote of the Day

more Quotes

Categories

Recent Posts

Top Posts

Get notified of new posts

Buy me coffee

Tag Archives for " sqljdbc "

Migrating from Oracle to Azure SQL caveat – prepared statement set string causes implicit conversion

Published June 1, 2022 in Azure , Azure SQL database - 0 Comments

In the previous post, I discuss the issue we face with storing date and time after migrating to azure SQL and the solution. If interested, you can check it out here. In this post, I talk about an issue we encountered with regards to implicit conversion, causing high CPU usage and performance degradation.

Continue reading
Tags: implicit conversion , nvarchar , sendStringParametersAsUnicode , sqljdbc , varchar

Migrating from Oracle to Azure SQL caveat – java.sql.Date does not represent time.

Published May 28, 2022 in Azure , Azure SQL database , Java , Oracle , Oracle database - 0 Comments

My team recently migrated one of our main database from Oracle to Azure SQL database. In this and upcoming posts, I’m going to share a few things I have learned during the process. Specifically, in this post, I share an issue we ran into with storing date and time, after migrating the schema and data from our Oracle into azure SQL database.

Continue reading
Tags: ojdbc , sql-date , sql-timestamp , sqljdbc