{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/mssql-jdbc/issues/683","repository_url":"https://api.github.com/repos/Microsoft/mssql-jdbc","labels_url":"https://api.github.com/repos/Microsoft/mssql-jdbc/issues/683/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/mssql-jdbc/issues/683/comments","events_url":"https://api.github.com/repos/Microsoft/mssql-jdbc/issues/683/events","html_url":"https://github.com/Microsoft/mssql-jdbc/issues/683","id":316492924,"number":683,"title":"BigDecimal Bug","user":{"login":"amirmf","id":14369144,"avatar_url":"https://avatars1.githubusercontent.com/u/14369144?v=4","gravatar_id":"","url":"https://api.github.com/users/amirmf","html_url":"https://github.com/amirmf","followers_url":"https://api.github.com/users/amirmf/followers","following_url":"https://api.github.com/users/amirmf/following{/other_user}","gists_url":"https://api.github.com/users/amirmf/gists{/gist_id}","starred_url":"https://api.github.com/users/amirmf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amirmf/subscriptions","organizations_url":"https://api.github.com/users/amirmf/orgs","repos_url":"https://api.github.com/users/amirmf/repos","events_url":"https://api.github.com/users/amirmf/events{/privacy}","received_events_url":"https://api.github.com/users/amirmf/received_events","type":"User","site_admin":false},"labels":[{"id":429137236,"url":"https://api.github.com/repos/Microsoft/mssql-jdbc/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-21T13:43:18Z","updated_at":"2018-04-23T20:47:57Z","closed_at":null,"author_association":"NONE","body":"## Driver version or jar name\r\n mssql-jdbc-6.4.0.jre8.jar\r\n\r\n## SQL Server version\r\nmssql 2016 \r\n\r\n## Client operating system\r\ni used ubuntu and windows ....both same response\r\n\r\n## Java/JVM version\r\njava version \"1.8.0\",\r\n\r\n## Table schema\r\ndefault(dbo | public)\r\n\r\n## Problem description\r\ni've used BigDecimal() in allover my application and i cant change it to use manual scale method:\r\nand when i want to insert BigDecimal() i got this erroe:\r\nCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type nvarchar to decimal.\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479)\r\n\tat com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:426)\r\n\tat bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java)\r\n\r\n## Expected behavior and actual behavior\r\nAs jdbc standard api this your driver should support BigDecimal()\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Microsoft/mssql-jdbc/issues/comments/383717565","html_url":"https://github.com/Microsoft/mssql-jdbc/issues/683#issuecomment-383717565","issue_url":"https://api.github.com/repos/Microsoft/mssql-jdbc/issues/683","id":383717565,"user":{"login":"cheenamalhotra","id":13396919,"avatar_url":"https://avatars2.githubusercontent.com/u/13396919?v=4","gravatar_id":"","url":"https://api.github.com/users/cheenamalhotra","html_url":"https://github.com/cheenamalhotra","followers_url":"https://api.github.com/users/cheenamalhotra/followers","following_url":"https://api.github.com/users/cheenamalhotra/following{/other_user}","gists_url":"https://api.github.com/users/cheenamalhotra/gists{/gist_id}","starred_url":"https://api.github.com/users/cheenamalhotra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cheenamalhotra/subscriptions","organizations_url":"https://api.github.com/users/cheenamalhotra/orgs","repos_url":"https://api.github.com/users/cheenamalhotra/repos","events_url":"https://api.github.com/users/cheenamalhotra/events{/privacy}","received_events_url":"https://api.github.com/users/cheenamalhotra/received_events","type":"User","site_admin":false},"created_at":"2018-04-23T20:47:57Z","updated_at":"2018-04-23T20:47:57Z","author_association":"MEMBER","body":"Hi @amirmf \r\n\r\nI've created a fix for the issue reported above, request you to test and confirm if your application gets fixed with PR #684 . Attached Jars for testing as well.\r\n\r\n[mssql-jdbc-PR684.zip](https://github.com/Microsoft/mssql-jdbc/files/1939965/mssql-jdbc-PR684.zip)\r\n"}}
{"actor":{"display_login":"cheenamalhotra"}}