Check log files of orion and your database
> -----Original Message-----
> From: Andres Garcia Hourcade [SMTP:[EMAIL PROTECTED]]
> Sent: â ôáøåàø 20 2001 16:22
> To: Orion-Interest
> Subject: RE: NOVICE Question about orion and mysql
>
> 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" />
>
>
>
>
>
>
>
>
