• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
  • Mikalai Zaikin

Sybase support for JForum 2.1.8

Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 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]
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 jforum.net by monroe]
    Bookmark Topic Watch Topic
  • New Topic