I am running Orion on Linux.
The 'Product' application runs o.k when I use the
hypersonic database. But I get the following error
when trying to use postgreSQL:
"Error reading application-client descriptor. Error
looking up EJBHome. Disconnected.. Unknown command 7"
The data-source.xml looks as follows:
<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd">
<data-sources>
<!--
An example/default DataSource that uses an ordinary
JDBC-driver (in this case hsql) to create the
connections.
This tag creates all the needed kinds
of data-sources, transactional, pooled and EJB-aware
sources.
The source generally used in application code is the
"EJB"
one - it provides transactional safety and
connection pooling.
-->
<!--
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Hypersonic"
location="jdbc/HypersonicCoreDS"
xa-location="jdbc/xa/HypersonicXADS"
ejb-location="jdbc/HypersonicDS"
connection-driver="org.hsql.jdbcDriver"
username="sa"
password=""
url="jdbc:HypersonicSQL:./database/defaultdb"
inactivity-timeout="30"
/>
-->
<data-source
class="com.evermind.sql.ConnectionDataSource"
name="postgresql"
location="jdbc/postgreDS"
xa-location="jdbc/xa/postgreXADS"
ejb-location="jdbc/postgreEJBDS"
connection-driver="org.postgresql.Driver"
username="postgres"
password="xxxx"
url="jdbc:postgre:./database/postgredb"
inactivity-timeout="30"
schema="database-schemas/postgresql.xml"
/>
</data-sources>
Also, I included "postgres" as a user in the
"administrators" group in principals.xml
Also, I include:
default-data-source="jdbc/postgreEJBDS" in
orion-application.xml under deployment-directory.
Is there anything else I need to do? Do I need to do
any clean-up after I run the application using
hypersonic and before re-running it with postgres?
Thanks for your help
Satish Gupta
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
