Hi Alex, sysdatabases seam to be treated different then other tables in sybase. Searching the web I found references where 'master..sysdatabases' has been used. As I never worked with sybase and have no access to one I can not tell you what goes wrong here.
If you'd open a new issue in jira and provide us with a demo app that issues the select with the correct syntax using plain jdbc we can try to fix this problem. But as mentioned above none off the committers have access to sybase at the moment so you will also be requested to check the patch if we are able to prepare one from what you provided with the demo app. Regards Ralf [EMAIL PROTECTED] schrieb: > I am trying to map object with fields in Sybase's sysdatabases. But I > get the following: > _ _ > > _org.exolab.castor.jdo.PersistenceException_: Nested error: > _java.sql.SQLException_: "sysdatabases" not found. Specify > owner.objectname or use sp_help to check whether the object exists > (sp_help may produce lots of output). > > while executing SELECT "sysdatabases"."name","sysdatabases"."suid" FROM > "sysdatabases": "sysdatabases" not found. Specify owner.objectname or > use sp_help to check whether the object exists (sp_help may produce lots > of output). > > I run the same query in DbVisualizer with the same jTDS driver and it > works fine. Mapping to other Sybase tables are fine too. Any idea? > > Thanks! > > -- > Alex -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 D-72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Email: [EMAIL PROTECTED] Web: www.syscon-world.de ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
