{"action":"created","issue":{"url":"https://api.github.com/repos/slick/slick/issues/1446","repository_url":"https://api.github.com/repos/slick/slick","labels_url":"https://api.github.com/repos/slick/slick/issues/1446/labels{/name}","comments_url":"https://api.github.com/repos/slick/slick/issues/1446/comments","events_url":"https://api.github.com/repos/slick/slick/issues/1446/events","html_url":"https://github.com/slick/slick/issues/1446","id":134917888,"number":1446,"title":"Slick 3.1.0: UUIDJdbcType.sqlType for OracleDriver should be defined as java.sql.Types.BINARY","user":{"login":"skapadia","id":1245595,"avatar_url":"https://avatars.githubusercontent.com/u/1245595?v=3","gravatar_id":"","url":"https://api.github.com/users/skapadia","html_url":"https://github.com/skapadia","followers_url":"https://api.github.com/users/skapadia/followers","following_url":"https://api.github.com/users/skapadia/following{/other_user}","gists_url":"https://api.github.com/users/skapadia/gists{/gist_id}","starred_url":"https://api.github.com/users/skapadia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/skapadia/subscriptions","organizations_url":"https://api.github.com/users/skapadia/orgs","repos_url":"https://api.github.com/users/skapadia/repos","events_url":"https://api.github.com/users/skapadia/events{/privacy}","received_events_url":"https://api.github.com/users/skapadia/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/slick/slick/labels/bug","name":"bug","color":"e11d21"},{"url":"https://api.github.com/repos/slick/slick/labels/effort:%20easy","name":"effort: easy","color":"FF69B4"},{"url":"https://api.github.com/repos/slick/slick/labels/topic:driver","name":"topic:driver","color":"fef2c0"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/slick/slick/milestones/20","html_url":"https://github.com/slick/slick/milestones/3.2.0","labels_url":"https://api.github.com/repos/slick/slick/milestones/20/labels","id":1269007,"number":20,"title":"3.2.0","description":"","creator":{"login":"szeiger","id":54262,"avatar_url":"https://avatars.githubusercontent.com/u/54262?v=3","gravatar_id":"","url":"https://api.github.com/users/szeiger","html_url":"https://github.com/szeiger","followers_url":"https://api.github.com/users/szeiger/followers","following_url":"https://api.github.com/users/szeiger/following{/other_user}","gists_url":"https://api.github.com/users/szeiger/gists{/gist_id}","starred_url":"https://api.github.com/users/szeiger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/szeiger/subscriptions","organizations_url":"https://api.github.com/users/szeiger/orgs","repos_url":"https://api.github.com/users/szeiger/repos","events_url":"https://api.github.com/users/szeiger/events{/privacy}","received_events_url":"https://api.github.com/users/szeiger/received_events","type":"User","site_admin":false},"open_issues":109,"closed_issues":6,"state":"open","created_at":"2015-08-24T09:02:58Z","updated_at":"2016-02-19T21:28:42Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-02-19T17:04:52Z","updated_at":"2016-02-19T22:02:32Z","closed_at":null,"body":"In Slick 3.1.0, `com.typesafe.slick.driver.oracle.OracleDriver` overrides `UUIDJdbcType` and sets `sqlType` to `java.sql.Types.OTHER`.  \r\n\r\nInserting a NULL value into a column defined as `Column[Option[UUID]]` (a nullable RAW(32) column), results in this exception: `java.sql.SQLException: Invalid column type: 1111`.   \r\n1111 = `java.sql.Types.OTHER`.\r\n\r\nInstead setting this to `java.sql.Types.BINARY` resolves the issue.  Please note this only appears to be an issue when attempting to insert NULLs.   Please see the sample workaround below that we are currently using:\r\n\r\n```scala\r\nimport com.typesafe.slick.driver.oracle.OracleDriver\r\n\r\ntrait CustomOracleDriver extends OracleDriver {\r\n\r\n  override val columnTypes = new JdbcTypes\r\n\r\n  class JdbcTypes extends super.JdbcTypes {\r\n\r\n    override val uuidJdbcType = new UUIDJdbcType\r\n\r\n    class UUIDJdbcType extends super.UUIDJdbcType {\r\n      override def sqlType = java.sql.Types.BINARY\r\n    }\r\n  }\r\n}\r\n\r\nobject CustomOracleDriver extends CustomOracleDriver\r\n```\r\n\r\nI do believe `java.sql.Types.BINARY` is the more appropriate JDBC SQL type for Oracle RAW(16) or RAW(32) columns.\r\n\r\nI understand that `slick-extensions` is being contributed back to the core (thus I can see `OracleProfile` on the master branch) so I would assume it could be fixed in the next version of Slick (3.2.0 milestone?)."},"comment":{"url":"https://api.github.com/repos/slick/slick/issues/comments/186428612","html_url":"https://github.com/slick/slick/issues/1446#issuecomment-186428612","issue_url":"https://api.github.com/repos/slick/slick/issues/1446","id":186428612,"user":{"login":"cvogt","id":274947,"avatar_url":"https://avatars.githubusercontent.com/u/274947?v=3","gravatar_id":"","url":"https://api.github.com/users/cvogt","html_url":"https://github.com/cvogt","followers_url":"https://api.github.com/users/cvogt/followers","following_url":"https://api.github.com/users/cvogt/following{/other_user}","gists_url":"https://api.github.com/users/cvogt/gists{/gist_id}","starred_url":"https://api.github.com/users/cvogt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cvogt/subscriptions","organizations_url":"https://api.github.com/users/cvogt/orgs","repos_url":"https://api.github.com/users/cvogt/repos","events_url":"https://api.github.com/users/cvogt/events{/privacy}","received_events_url":"https://api.github.com/users/cvogt/received_events","type":"User","site_admin":false},"created_at":"2016-02-19T22:02:32Z","updated_at":"2016-02-19T22:02:32Z","body":"we may want to target 3.1.x"}}