SQL Anywhere databases (Sybase) config for middlegen

Jose Luis Sánchez <[email protected]>
Newsgroups gmane.comp.java.ejb.middlegen.user
Message-ID <001301c468a6$2a3913a0$9b02a8c0@GEOXDESKTOP>
Hello,
I have been trying to use middlegen with an ASA database (Sybase) but it doesn't find the tables.
This is my configuration in sybase.xml
 
<property name="database.script.file"           value="${src.dir}/sql/${name}-sybase.sql"/>
   <property name="database.driver.file"           value="${lib.dir}/jconn2.jar"/>
   <property name="database.driver.classpath"      value="${database.driver.file}"/>
   <property name="database.driver"                value="com.sybase.jdbc2.jdbc.SybDriver"/>
   <property name="database.url"                   value="jdbc:sybase:Tds:localhost:2638/geox"/>
   <property name="database.userid"                value="DBA"/>
   <property name="database.password"              value="SQL"/>
   <property name="database.schema"                value=""/>
   <property name="database.catalog"               value=""/>
   <property name="jboss.datasource.mapping"       value="Sybase"/>
 
The error is about:
middlegen connected to the database but couldn't find any tables. Perhaps the specified schema or catalog is wrong
or maybe there aren't any tables in the database at all?
 
There are tables, it is sure. I had the same error trying with a Pointbase database. What i did to fix it was assign a
correct database.schema property and then it worked.
Because of that i suppose that i haven't got a valid configuration at sybase.xml.
Does anyone knows which is the correct configuration for an ASA database (sybase)?
Thanks and kind regards
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.