Hello,
I'm working in an app to connecting to db2.
I was trying with SQLServer JDBC and linked server to DB2 and it works fine, here is my config.properties file:
#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://XX.XX.XX.XX/DB
User=sa
Password=xxxxxxxx
ServerPort=10500
Debug=true
#commands
sql.select_boleta=select * from openquery(as400,'SELECT * FROM M62BPCSUSF.BASMAST order by numbolet')
I want to change to direct connection to DB2.
Where can I get the JDBC driver for DB2?
How to setup the config.properties for JDBC DB2 driver?
Thanks for your help!!
I'm working in an app to connecting to db2.
I was trying with SQLServer JDBC and linked server to DB2 and it works fine, here is my config.properties file:
#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://XX.XX.XX.XX/DB
User=sa
Password=xxxxxxxx
ServerPort=10500
Debug=true
#commands
sql.select_boleta=select * from openquery(as400,'SELECT * FROM M62BPCSUSF.BASMAST order by numbolet')
I want to change to direct connection to DB2.
Where can I get the JDBC driver for DB2?
How to setup the config.properties for JDBC DB2 driver?
Thanks for your help!!