Hi Andres,
I have some custom CMP EJBs working with MySQL 3.23.
My datasource.xml entry is similar to yours. A couple thoughts:
1. Make sure you have removed the attribute "ejb-location"
from the hsql datasource.
2. Make sure you have a schema for mysql in the
<orion>/config/database-schemas directory.
Here is the one I use (named mysql.xml):
----------------------
<?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>
----------------------
Good luck,
Doug
"Andres Garcia Hourcade"
<[EMAIL PROTECTED]> To: Orion-Interest
<[EMAIL PROTECTED]>
Sent by: cc:
owner-orion-interest@orion Subject: NOVICE Question
about orion and mysql
server.com
02/16/2001 02:31 PM
Please respond to
Orion-Interest
i changed orion-primer-cmp to use mysql 3.22
the mysql server is up and running, the app. works fine with hsql, but in
mysql i have to create database and tables manually, because it cannot
auto-create them
what else may i config, or where i could find any tips ?
thanks in advanced
attached config/datasource.xml
<data-source
name="mysql"
class
="com.evermind.sql.DriverManagerDataSource"
location ="jdbc/mysqlCore"
pooled-location ="jdbc/mysqlPooled"
xa-location ="jdbc/xa/mysqlXA"
ejb-location ="jdbc/mysql"
username ="sist"
password =""
url
="jdbc:mysql://10.1.1.107:3306/defaultdb"
connection-driver="org.gjt.mm.mysql.Driver" />
