RE: NOVICE Question about orion and mysql

[Andres Garcia Hourcade]

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" />