Copy fails with column type nvarchar

chop-dbhi / dataexpress

[NOT MAINTAINED] DataExpress is a simple, Scala-based cross database ETL toolkit supporting Postgres, MySql, Oracle, SQLServer, and Sqlite

http://dataexpress.research.chop.edu

BSD 2-Clause "Simplified" License

72 stars 9 forks source link

Copy fails with column type nvarchar #48

Closed kevintraver closed 9 years ago

kevintraver commented 10 years ago

Copy fails when using Microsoft SQL driver and a column has a type of nvarchar:

java.lang.RuntimeException: Can't map JDBC type to a known DataExpress type -9 for column NAME
    at edu.chop.cbmi.dataExpress.dsl.ETL$.commit_on_success(ETL.scala:74)

mitalia commented 10 years ago

@kevintraver I know it has been a while since you filed this, but if you want to try our latest release candidate here: https://github.com/cbmi/dataexpress/releases/tag/v0.9.1.4-rc1 I believe I've fixed the issue.

kevintraver commented 9 years ago

Thanks!