search

PHPJasper / phpjasper

A PHP report generator
MIT License
462 stars 162 forks source link

Connect with DB2 #189

Open dean8710 opened 4 years ago

dean8710 commented 4 years ago

I have successfully generated with mysql in laravel 6, but now I have new requirement where I need to integrate with DB2 database. has anyone experienced with DB2? Hope you can share with me, tq

geekcom commented 4 years ago

Hi @dean8710 just download the JDBC driver here and move to path /bin/jasperstarter/jdbc after tis follow the instructions normally.

dean8710 commented 4 years ago

  1. Lots of versions, which 1 should i use (of course my DB2 Version rite) but what does it mean with level?

  2. How bout the $options = [] setting? Rite now: $options = [ 'format' => ['pdf'], 'locale' => 'en', 'params' => [], 'db_connection' => [ 'driver' => 'db2', 'username' => 'root', 'password' => 'password', 'host' => 'localhost', 'database' => 'db', 'port' => '123' ] ];