Hi,
up to now i always connected to the Hypersonic database. Since i have a mysql database
running on another box, i tried to connect to it, using Shailesh Joshi's
data-sources.xml and database-schemas/mysql.xml (cf. msg# 05137 Re: Orion and MySQL).
This is the errormessage i get when orion tries to deploy my EJBs:
Auto-deploying myEJB.jar (No previous deployment found)... Error compiling
file:/home/wuzzah/myEJB/myEJB.jar: Error finding a suitable DataSource:
jdbc/DefaultCoreDS did not contain a cmt-dataSource/ejb-datasource
My data-source:
<data-source
name="MySQL"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:mysql://<hostname>/myEJBdatabase"
connection-driver="org.gjt.mm.mysql.Driver"
username="<user>"
password="<passwd>"
inactivity-timeout="30"
schema="database-schemas/mysql.xml"
/>
My database-schema:
<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
"http://www.orionserver.com/dtds/database-schemas.dtd">
<database-schema name="Mysql" not-null="not null" null="" primary-key="primary key">
<type-mapping type="java.lang.String" name="varchar(255)" />
<type-mapping type="int" name="integer" />
<type-mapping type="float" name="float" />
<type-mapping type="double" name="double" />
<type-mapping type="byte" name="smallint" />
<type-mapping type="char" name="char(1)" />
<type-mapping type="short" name="integer" />
<type-mapping type="boolean" name="bit" />
<type-mapping type="java.util.Date" name="datetime" />
<disallowed-field name="password" />
<disallowed-field name="username" />
<disallowed-field name="date" />
<disallowed-field name="text" />
</database-schema>
any hints?
thanks,
--nils
--
**********************************************************************************
* Your mouse has moved. Windows must be restarted for the change to take effect. *
*--------------------------------------------------------------------------------*
* Nils Frohberg *
* http://www.tako.de/ *
**********************************************************************************