My problem is that I don't understand what is expected in the following section for Sybase or any other db. This is of course taken from mysql-jdbc-system.xconf
<mysql id="keel-dbtype" activation="startup"> <type from="longvarchar" to="text" prefix="'" suffix="'"/> </mysql>
There is somewhat of variation between the RDBMs and JDBC drivers on how types are translated. This is the "equalizer", so to speak. So, the above states that the java.sql type (from) "longvarchar" is to be translated to the "raq" SQL type (to) "text". The prefix and suffix provide the characters used for quoting literals in the SQL statement.
I don't have Sybase. I looked in the Expresso mapping, and changing the syntax from there, try:
<type from="longvarchar" to ="varchar" prefix="'" suffix="'"/> <type from="varchar" to ="varchar" prefix="'" suffix="'"/> <type from="date" to ="datetime" prefix="'" suffix="'"/> <type from="time" to ="time" prefix="'" suffix="'"/> <type from="float" to ="float" prefix="'" suffix="'"/> <type from="decimal" to ="numeric" prefix="'" suffix="'"/> <type from="timestamp" to ="datetime" prefix="'" suffix="'"/>
Start with this, and you'll know if it works or not pretty quickly. Look in WEB-INF/keel/server/logs/svc-persist-default.log and it should tell you what the SQL that it is choking on is.
The typical way for introducing new DB support has been to post each problem as you face it and post here for one of the SQL experts like Mike or Santanu to help you out.
Shash
http://keelframework.org/documentation Keelgroup mailing list [EMAIL PROTECTED] http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
