Hi Ralf,
Thanks for the response. I found the problem was that I forgot to put
the database name in the JDBC URL.
Even the database name is in JDOConfFactory.createDatabase and
jdoManager.createInstance calls.
Alex
Ralf Joachim wrote:
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
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
