My name is Marcelo, I am a systems analyst at SANEAGO, and I am responsible for technical support for the IBM i operating system with DB2/400 database.
In our company, we work with tools that use georeference/geospatial data, and we are working to implement the Geoserver tool, but when we searched for an extension that communicates with our DB2/400 database, we did not find it. We tried to use the extension developed by Mr. David Adler, but it did not work.
The extension developed by Mr. David Adler uses the “Universal JDBC Driver - DB2 Connect” present in the db2jcc.jar package and accesses the DB2GSE tabschema. Now, in our IBM i environment, we use the jt400.jar package to connect to DB2/400 and the georeference/geospatial views are in the QSYS2 tabschema.
I would like to know if it is possible to create an extension for connecting to DB2/400 for IBM i, using the georeferential/geospatial view structure in the QSYS2 tabschema?
It should be very much possible, especially if you have java developer handy.
GeoServer uses the GeoTools library for most GIS activities. In this case it uses the “DataStore API” for reading and writing feature data. There are some helpful base classes for those implementing an extension - with “JDBCDataStore” being the base class you would need to implement.
One challenge is that not many other developers have access to a DB2/400 environment so you are somewhat lonely in this activity (hard to ask for help testing).
Thank you for your information, I will study the tutorials. Initially, I extracted the Java classes from the current DB2 extension package (developed by Mr. David Adler), and converted them to Java dot files, but I don’t have the experience to set up a Geoserver project and try to compile/interpret the classes with the necessary modifications.