File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JForum and the fly likes Sybase support for JForum 2.1.8 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Sybase support for JForum 2.1.8" Watch "Sybase support for JForum 2.1.8" New topic

Sybase support for JForum 2.1.8

Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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...

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
* 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 by bsalis]
Migrated From
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
FYI - You might want to look at the existing MS SQL Server support. Sybase and MS SQL have the same roots and generally MS SQL queries, etc are compatible.

Also, jForum 3 is being built using Hibernate. This should make it work with any server that Hibernate supports. I believe that include Sybase.
[originally posted on by monroe]
I agree. Here's the link:
subject: Sybase support for JForum 2.1.8
jQuery in Action, 3rd edition