Put the datasource of the database you want the tables to autodeploy in
first in the datasources-xml. Or remove autocreatetable support and deploy,
then edit orion-ejb.jar.xml to point to the right datasource, then enable
autocreate option and redeploy again.
Should work just fine :)
Klaus Myrseth
Telenor Mobil AS
-----Opprinnelig melding-----
Fra: Sven van 't Veer [mailto:[EMAIL PROTECTED]]
Sendt: 18. september 2000 14:00
Til: Orion-Interest
Emne: Orion & Sybase
I just installed sybase and after updating the data-sources.xml I
redeployed what I'm currently developing. While deployng, orion started
autocreating tables, which is ok with me, except for th fact that it is
autocreating in the wrong database. Here's the relevant part of my
database xml
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="CEP"
location="jdbc/cepDS"
xa-location="jdbc/xa/cepXADS"
ejb-location="jdbc/cepDS"
connection-driver="com.sybase.jdbc2.jdbc.SybDriver"
username="sa"
password=""
url="jdbc:sybase:Tds:brvip.com.br:7100/CEP"
inactivity-timeout="30"
schema="./database-schemas/sybase.xml"
/>
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="BOLETO"
location="jdbc/boletoDS"
xa-location="jdbc/xa/boletoXADS"
ejb-location="jdbc/boletoDS"
connection-driver="com.sybase.jdbc2.jdbc.SybDriver"
username="sa"
password=""
url="jdbc:sybase:Tds:brvip.com.br:7100/BOLETO"
inactivity-timeout="30"
schema="./database-schemas/sybase.xml"
/>
and a part of my orion-ejb-jar.xml:
<entity-deployment name="User" location="User"
wrapper="UserHome_EntityHomeWrapper9" table="Users"
data-source="jdbc/boletoDS">
<primkey-mapping>
<cmp-field-mapping>
<fields>
<cmp-field-mapping
name="cgc_cpf" persistence-name="cgc_cpf" />
</fields>
</cmp-field-mapping>
</primkey-mapping>
<cmp-field-mapping name="_ie_rg"
persistence-name="_ie_rg" />
<cmp-field-mapping name="_nome"
persistence-name="_nome" />
<cmp-field-mapping name="_fantasia"
persistence-name="_fantasia" />
The tables to be autocreated are in the boletoDS. However the tables are
created as if I u used:
url="jdbc:sybase:Tds:brvip.com.br:7100" for an url instead of
url="jdbc:sybase:Tds:brvip.com.br:7100/BOLETO"
Does anyone have any experience with Orion & sybase ? What might it be
that I'm missing here?
Sven
--
============================================================================
==========
Sven E. van 't Veer
http://www.cachoeiro.net
Java Developer
[EMAIL PROTECTED]
============================================================================
==========
