It appears from the error message that you are pointing to the wrong mysql database:
The data-sour
xml file snippet you give below refers (in you URL) to defaultdb and your message
refers to
addressbookdb. In mysql, create a database called addressbookdb (or just change your
references to
defaultdb). The tables will then be automatically created.
--- [EMAIL PROTECTED] wrote:
>
> 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" />
>
>
>
>
>
>
>
>
>
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
