{"action":"created","issue":{"url":"https://api.github.com/repos/javalite/activejdbc/issues/729","repository_url":"https://api.github.com/repos/javalite/activejdbc","labels_url":"https://api.github.com/repos/javalite/activejdbc/issues/729/labels{/name}","comments_url":"https://api.github.com/repos/javalite/activejdbc/issues/729/comments","events_url":"https://api.github.com/repos/javalite/activejdbc/issues/729/events","html_url":"https://github.com/javalite/activejdbc/issues/729","id":326186417,"node_id":"MDU6SXNzdWUzMjYxODY0MTc=","number":729,"title":"MSSQL tests failures","user":{"login":"ipolevoy","id":500941,"node_id":"MDQ6VXNlcjUwMDk0MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/500941?v=4","gravatar_id":"","url":"https://api.github.com/users/ipolevoy","html_url":"https://github.com/ipolevoy","followers_url":"https://api.github.com/users/ipolevoy/followers","following_url":"https://api.github.com/users/ipolevoy/following{/other_user}","gists_url":"https://api.github.com/users/ipolevoy/gists{/gist_id}","starred_url":"https://api.github.com/users/ipolevoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ipolevoy/subscriptions","organizations_url":"https://api.github.com/users/ipolevoy/orgs","repos_url":"https://api.github.com/users/ipolevoy/repos","events_url":"https://api.github.com/users/ipolevoy/events{/privacy}","received_events_url":"https://api.github.com/users/ipolevoy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2018-05-24T15:56:44Z","updated_at":"2018-06-14T19:01:41Z","closed_at":null,"author_association":"MEMBER","body":"## MSSQL driver:\r\n\r\nhttp://ci.javalite.io/view/ActiveJDBC/job/activejdbc-mssql/127/consoleFull\r\n\r\n\r\n```\r\nshouldIncludeMultipleMany2ManyOverridesOnOneModel(org.javalite.activejdbc.IncludesTest)  Time elapsed: 0.014 sec  <<< ERROR!\r\norg.javalite.activejdbc.DBException: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated., query: INSERT INTO genres (name) VALUES (?), params: Garage rock\r\n\tat org.javalite.activejdbc.IncludesTest.shouldIncludeMultipleMany2ManyOverridesOnOneModel(IncludesTest.java:179)\r\nCaused by: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.\r\n\tat org.javalite.activejdbc.IncludesTest.shouldIncludeMultipleMany2ManyOverridesOnOneModel(IncludesTest.java:179)\r\n```\r\n\r\n## TDS driver:\r\n\r\nhttp://ci.javalite.io/view/ActiveJDBC/job/activejdbc-tds/50/console\r\n\r\n```\r\nTests in error: \r\n  FreemarkerSpec.shouldRenderRowProcessor:99 » Test Test object:\r\njava.lang.Strin...\r\n  IncludesTest.shouldIncludeMultipleMany2ManyOverridesOnOneModel:179 » DB java.s...\r\n  ModelTest.shouldGenerateCorrectInsertSQL:535 » Test Test object:\r\njava.lang.Str...\r\n  ModelTest.shouldGenerateCorrectInsertSQLWithReplacements:552 » Test Test objec...\r\n  JsonLog4jLayoutSpec.shouldPrintJsonLogValuesAndParams:101 » Test tested value ...\r\n\r\n```\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/javalite/activejdbc/issues/comments/397404021","html_url":"https://github.com/javalite/activejdbc/issues/729#issuecomment-397404021","issue_url":"https://api.github.com/repos/javalite/activejdbc/issues/729","id":397404021,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NzQwNDAyMQ==","user":{"login":"jfcabral","id":1048422,"node_id":"MDQ6VXNlcjEwNDg0MjI=","avatar_url":"https://avatars2.githubusercontent.com/u/1048422?v=4","gravatar_id":"","url":"https://api.github.com/users/jfcabral","html_url":"https://github.com/jfcabral","followers_url":"https://api.github.com/users/jfcabral/followers","following_url":"https://api.github.com/users/jfcabral/following{/other_user}","gists_url":"https://api.github.com/users/jfcabral/gists{/gist_id}","starred_url":"https://api.github.com/users/jfcabral/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfcabral/subscriptions","organizations_url":"https://api.github.com/users/jfcabral/orgs","repos_url":"https://api.github.com/users/jfcabral/repos","events_url":"https://api.github.com/users/jfcabral/events{/privacy}","received_events_url":"https://api.github.com/users/jfcabral/received_events","type":"User","site_admin":false},"created_at":"2018-06-14T19:01:41Z","updated_at":"2018-06-14T19:01:41Z","author_association":"CONTRIBUTOR","body":"> @jfcabral that would be just amazing! I have been slammed with work for a while, so if you can help this way, that'd be great! Consistency is what we want here, totally \r\n\r\nSure thing 😄 I've been pretty slammed with work myself, but I shall do it soon.\r\n\r\n> @jfcabral here is the sad truth about Oracle: https://stackoverflow.com/questions/1799128/oracle-if-table-exists\r\n\r\nI was expecting better from one of the supposedly best DBMSs out there (at least so our DBA keeps saying) 😄\r\nIf that's so, I'll try to find some solution similar to what we already do in [IBM DB2 schema](https://github.com/javalite/activejdbc/blob/master/activejdbc/src/test/resources/db2_schema.sql) which uses a stored procedure that's created here [Db2DBReset.java](https://github.com/javalite/activejdbc/blob/master/activejdbc/src/test/java/org/javalite/activejdbc/test/Db2DBReset.java) that acts like a `quiet_drop` or `drop if exists` in order to circumvent this limitation."}}
{"actor":{"display_login":"jfcabral"}}