[castor-dev] one to many relation between 2 different databases on the same sybase Server

[Andreas . Wier]

Hi!

I try to reference in a mappingfile another database on the same Sybase
server:

<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
                           "http://castor.exolab.org/mapping.dtd";>
<mapping>


  <class name="com.company.a" identity="id" key-generator="MAX">
    <cache-type type="time-limited" capacity="30"/>
    <map-to table="tableA" />
    <field name="id" type="integer">
      <sql name="Id" type="numeric" />
    </field>

    <field name="tsGDBE" type="com.company.b" required="true">
      <sql name="prod_No" />
    </field>

  </class>

<class name="com.company.b" identity="prodNo" access="read-only">
        <map-to table="database2.dbo.tableB" />
          <field name="prodNo" type="string">
      <sql name="prod_No" type="varchar" />
    </field>
          <field name="artist" type="string">
      <sql name="artist" type="varchar" />
    </field>
          <field name="title" type="string">
      <sql name="title" type="varchar" />
    </field>

  </class>

</mapping>




But I get the exception from Sybase:
"com.sybase.jdbc2.jdbc.SybSQLException: "database2"."dbo"."tableB" not
found...."

here the sql castor generated:
SELECT
"database2"."dbo"."tableB"."artist","database2"."dbo"."tableB"."title" FROM
"database2"."dbo"."tableB" WHERE
"database2"."dbo"."tableB"."prod_No"='74321912232         '


The problem is that Castor quots every thing.


Do someone have a idea, how I can solve my problem?


thanxs

Andreas

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev