Member Avatar for joaodias

Hi,

I've been trying to install OpenCms 6 (an open source CMS) on Sybase ASE, but with n o success so far.

Can anyone tell me if what I'm attempting is possible (if someone has done it, or there is a patch/driver), and if not can you suggest an Open Source CMS that is known to work with Sybase?

Thanks all,
Joao

  • 2 Contributors
  • 2 Replies
  • 72 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by Esopo

Dani AI

Generated

As is attempting OpenCms on Sybase ASE (and, per , the requirement is Java), the realistic path is to treat OpenCms like any JDBC Java app: provide a Sybase JDBC driver and adapt any shipped SQL/DDL that assumes MySQL/Oracle/Postgres syntax. The open-source jTDS driver is a convenient way to test connectivity before using a vendor driver; typical jTDS settings are net.sourceforge.jtds.jdbc.Driver and jdbc:jtds:sybase://host:port/database. See the jTDS project page jTDS on SourceForge and OpenCms documentation OpenCms home for baseline configuration notes.

Practical checklist:

  • Add the Sybase JDBC jar to WEB-INF/lib and configure the OpenCms datasource.
  • Run the installer and watch server logs for SQLExceptions during schema creation — syntax errors point to dialect mismatches.
  • Compare OpenCms DDL/scripts with Sybase syntax and adjust identity/sequence statements, data types (BLOB/CLOB/TEXT), quoting, and pagination (LIMIT/TOP/row-number).
  • If an ORM/dialect layer is present, select or implement a Sybase dialect rather than patching every SQL statement.
  • If schema edits become large, assess using a supported DB for OpenCms and replicate data, or seek a community patch.

OpenCms community threads and the issue tracker are the best places to find existing Sybase patches or reports; vendor JDBC drivers (jConnect) can resolve edge-case behavior but testing with jTDS first is a low-cost way to discover the exact incompatibilities to fix.

Recommended Answers

All 2 Replies

Member Avatar for joaodias

By the way, forgot to mencion that any other alternative, also has to be Java Based like OpenCms.

Thanks again,
Joao

Member Avatar for Esopo

Java or PHP?

Either. Both are powerful tools for the web. I use PHP. I am also formally trainned in Java and have used ASP commercially.

BTW, don't buy on the silly argument that JSP is more powerful or more professional. PHP5's power + extensibility + HUGE! library of functions makes it IMO the best language for the web; but in general, at the very least, an acceptable contender.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.