RE: NOVICE Question about orion and mysql

2001-02-21 Thread Dvornikov Victor 

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@orionSubject: 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" /

RE: NOVICE Question about orion and mysql

2001-02-21 Thread Ray Harrison 

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@orioncc:
   
   
 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@orionSubject: NOVICE
 Question about orion and mysql
 server.com
 
 
 02/16/2001 02:31 PM
 Please respond to
 Orion-Interest

Re: NOVICE Question about orion and mysql

2001-02-20 Thread Brian Wing Shun Chan 

Orion doesn't create databases automatically.

Orion does create tables automatically.

- Brian

On Tue, 20 Feb 2001, Andres Garcia Hourcade wrote:


 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 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@orionSubject: 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" /

RE: NOVICE Question about orion and mysql

2001-02-20 Thread DSmith 


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@orioncc:  

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@orionSubject: 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 ="j

Re: NOVICE Question about orion and mysql

2001-02-19 Thread DSmith 


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@orionSubject: 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" /