I decided to add support for Sybase ASE to JForum, since that is what my employer uses.
Sybase doesn't have a big market share, but it's popular with banks, which are not switching DBMSes anytime soon.
Anyhow, you can find my spike here...
http://www.filefactory.com/file/9d94da/n/jforum-2_1_8-sybasease-spike_zip
Notes on my changes...
* Doing a diff (in say, Eclipse
IDE) with the released 2.1.8 version and this spike should show all my changes. I have deleted the install artifacts from my dev/testing, so it should work out of the box like the original jforum-2.1.8-src.zip.
* I have not done extensive
testing. If you have an automated (eg. JWebUnit) or manual test suite that tests the application end-to-end, I'd be happy to run through it to fix any problems identified.
* I did the development and testing against the Developer Edition of Sybase ASE v15.0.2, though any recent version should work. I used the jconn3.jar packaged (I copied it to the jforum lib dir). You may want to check licencing before distributing jconn3.jar with jforum.
* Sybase doesn't support LIMIT in the sense that you can skip rows, you can only get the first X number of rows. I worked around this at the ResultSet level.
* Sybase stores empty strings ('') as a space (' '). I don't know an easy way around handling this. It may cause some small bugs.
* Sybase had a problem with conn.setAutoCommit() where the new value was the same as the current. I fixed this with DbUtils.setAutoCommit() which only changes it if needed.
If possible I would like to see Sybase supported in a future JForum release.
I should also be able to help add Sybase ASE support to JForum v3... though if your going to use an ORM tool like Hibernate,
you should be able to support any DBMS without much work of your own.
[originally posted on jforum.net by bsalis]