I'm getting the following exception when i run the below mentioned code.
Can someone please explain why am i getting this exception even though when i i've set relaxAutoCommit=true in Url
java.sql.SQLException: Can't call commit when autocommit=true
Exception in thread "main" javax.sql.rowset.spi.SyncProviderException: Can't call commit when autocommit=true
I think that actually relaxAutoCommit applies only when talking to really, really old MySQL servers. It's designed to get around the fact that for much of its early life MySQL did not support transactions*. You can't have autoCommit without support for commit, and you cannot support commit without support for transactions.
* Which at the time was a major selling point for PostgreSQL, which did support transactions back then.
"privilege" comes from the Latin words for "private" and "law" (legal) and dates to feudal times. To "claim privilege" meant that you were above the laws that applied to the common people.