JetBrains / Exposed

Kotlin SQL Framework
http://jetbrains.github.io/Exposed/
Apache License 2.0
8.25k stars 689 forks source link

support db2 #1106

Open wuwensen007 opened 3 years ago

wuwensen007 commented 3 years ago

please support db2,thanks

V3lop5 commented 3 years ago

Hello,

I already opend a pull request a few month ago. But I don't find time to write tests. https://github.com/JetBrains/Exposed/pull/930

If you want to support db2 LUW you might search for an jdbc driver and register it here: https://github.com/JetBrains/Exposed/pull/930/commits/d4645b07ca21b3fd017dd661712ca0e254869634#diff-d1d90a14d7a8d99179c656e0cf90d4df9485011caa8974bb055f6a1adf8bd858

I started this PR for my company and we are using Exposed with DB2 on iSeries in some basic example applications.

V3lop5 commented 3 years ago

@wuwensen007 if you are still searching for this. You might checkout my PR #930.

Today i added support for db2 LUW but i couldn't complete the tests. Something went wrong with the jdbc driver. Maybe you already used db2 LUW in Java or Kotlin? What dependency you use for jdbc driver?

You can checkout my repo and follow this guide to run database tests. After a few minutes you should see many errors like com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][4.25.13] Beim Laden der nativen Bibliothek db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path