Hi Andres,
I'm sorry, I didn't get that error. Orion automatically creates tables
in MySQL for CMP entity beans on my system, after just doing what
I suggested earlier. Your error sounds like the "database" is invalid,
like the URL you're using is pointing to the wrong MySQL database?
Just a thought, but I'm not sure. Maybe someone else has more insight.
Doug
"Andres Garcia Hourcade"
<[EMAIL PROTECTED]> To: Orion-Interest
Sent by: <[EMAIL PROTECTED]>
owner-orion-interest@orion cc:
server.com Subject: RE: NOVICE Question
about orion and
mysql
02/20/2001 06:52 AM
Please respond to
Orion-Interest
Thanks a lot, i did what you tell me,but i am still getting this msg.
Warning: Unable to create new entry, caught: "javax.ejb.CreateException",
message is: "Error creating EntityBean: General error: Unknown database
'addressbookdb'".
obviusly i do not know how tell to orion server that it must create de
addresbookdb, not search it
any ideas ?
-----Mensaje original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: lunes, 19 de febrero de 2001 13:48
Para: Orion-Interest
Asunto: Re: NOVICE Question about orion and mysql
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" />