RE: MySQL Connection Pool?

[Koster, K.J.]

Dear All,

 
 what about the database schema?
 
http://kjkoster.org/java/ Hunt around in the menue for MySQL connection for
Orion. It's somewhere near the Tomcat tutorial.

Kees Jan

=
 You can't have everything.  Where would you put it?
 [Steven Wright]

RE: MySQL Connection Pool? (out of office 4/24-4/26)

[Jennifer Goree]

I will be out of the office from the afternoon of Wednesday April 24th  through the 
afternoon of Friday April 26th. 
If you have an emergency problem with the website, please contact Russell Dodds. 

thanks,
Jen

Re: MySQL Connection Pool?

[Clay Mitchell]

what about the database schema?

On Mon, 4 Mar 2002, Joacim J?keborn wrote:



  Can anybody tell me how to set up a connection pool with
 a mysql
  database? Anybody have a guide on how to do this? Is it
 even possible?

 Checkout
 orggjtmmmysqljdbc2optionalMysqlConnectionPoolDataSour
 ce

 Download the lastest driver from:

 http://sourceforgenet/projects/mmmysql/

 // Joacim

MySQL Connection Pool?

[Clay Mitchell]

Can anybody tell me how to set up a connection pool with a mysql
database? Anybody have a guide on how to do this? Is it even possible?

Thanks
-Clay

Re: MySQL Connection Pool?

[Scott Farquhar]

This guide is a good start, although someone else may have a mysql 
specific setup that they would like to share.

 
http://kb.atlassian.com/content/orion/docs/datasource-configuration/datasource-configuration.html

Cheers,
Scott

Clay Mitchell wrote:

 Can anybody tell me how to set up a connection pool with a mysql
 database? Anybody have a guide on how to do this? Is it even possible?
 
 Thanks
 -Clay
 
 
 
 


-- 
Scott Farquhar :: [EMAIL PROTECTED]

Atlassian :: http://www.atlassian.com
  Supporting YOUR J2EE World

Re: MySQL Connection Pool?

[Joacim J?keborn]

 Can anybody tell me how to set up a connection pool with 
a mysql
 database? Anybody have a guide on how to do this? Is it 
even possible?

Checkout 
org.gjt.mm.mysql.jdbc2.optional.MysqlConnectionPoolDataSour
ce

Download the lastest driver from:

http://sourceforge.net/projects/mmmysql/

// Joacim

Re: Mysql table create errors with ejbsamples

[Morten Wilken]

you need to use another schema definition: this example is for sqlserver

 data-source
  class=com.evermind.sql.DriverManagerDataSource
  name=SQLServer

  schema=database-schemas/ms-sql.xml

  location=jdbc/SQLServerCoreDS
  xa-location=jdbc/xa/SQLServerXADS
  ejb-location=jdbc/SQLServerDS
  connection-driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
  username=
  password=
  url=jdbc:microsoft:sqlserver://x:1433
  inactivity-timeout=30
 /

i saw that there is no predefined schema for mysql so you need to make one
yourself... should be easy if you look at the other definitions
hope this helps

morten wilken
- Original Message -
From: John Hogan [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 3:12 PM
Subject: Mysql table create errors with ejbsamples


 All,
 I've gone through the process of configuring Orion and the ejbsamples to
run with a mysql database. Things seem to be nearly correct. Orion connects
to the database ok, but dies trying to create tables. The problem seems to
be related to syntax or type mismatches between hypersonic db and mysql.
Some of the postings on this list seem to suggest that these mismatches can
be addressed by defining type mappings in mysql.xml. I've tried this without
success.
 I've included the error message, data-sources.xml and the mysql.xml I'm
using. If anyone's been through the exercies and can provide any useful
pointers, it would be much appreciated. TIA.

 John Hogan

 ERROR TEXT:
 ===
 [root@dalcassion orion]# java -classpath
/opt/orion/application-deployments/serverclasses/mm.mysql-2.0.8 -jar
orion.jar
 Auto-deploying ejbsamples (New server version detected)...
 Auto-deploying usermanager (No previous deployment found)...
 Auto-creating table: create table com_evermind_ejb_EJBUser (username
SET(255) not null primary key, password SET(255) null, description SET(255)
null, locale SET(5) null, certificateIssuerDN SET(255) null,
certificateSerial SET(100) null)
 Warning: Error creating table: Syntax error or access violation: You have
an error in your SQL syntax near '255) not null primary key, password
SET(255) null, description SET(255) null, lo' at line 1

 Auto-creating table: create table com_evermind_ejb_EJBUser_groups
(username SET(255) not null, value SET(255) not null, primary key (username,
value))
 Warning: Error creating table: Syntax error or access violation: You have
an error in your SQL syntax near '255) not null, value SET(255) not null,
primary key (username, value))' at line 1
 done.
 Auto-deploying product (No previous deployment found)...
 Auto-creating table: create table MyProduct (id BIGINT not null primary
key, name SET(255) null, description SET(255) null, price FLOAT null)
 Warning: Error creating table: Syntax error or access violation: You have
an error in your SQL syntax near '255) null, description SET(255) null,
price FLOAT null)' at line 1
 done.
 Auto-deploying cart (No previous deployment found)... done.
 Orion/1.4.8 initialized
 =


 data-sources.xml
 =
 ?xml version=1.0?
 !DOCTYPE data-sources PUBLIC Orion data-sources 
http://www.orionserver.com/dtds/data-sources.dtd;

 data-sources
 !--
 An example/default DataSource that uses an ordinary
 JDBC-driver (in this case hsql) to create the connections.
 This tag creates all the needed kinds
 of data-sources, transactional, pooled and EJB-aware sources.
 The source generally used in application code is the EJB
 one - it provides transactional safety and connection pooling.
 --
 data-source
 name=mysql
 class=com.evermind.sql.DriverManagerDataSource
 location=jdbc/mysql
 pooled-location =jdbc/mysqlPooled
 xa-location=jdbc/xa/mysql
 ejb-location=jdbc/mysql
 url=jdbc:mysql:/opt/mysql/mysql/data/menagerie
 connection-driver=org.gjt.mm.mysql.Driver
 username=root
 password=sPikeO1
 inactivity-timeout=30
 /
 /data-sources
 =


 database-schemas/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=char(1)/
 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




 --

 ___
 Get your email from http://www.ireland.com

Mysql table create errors with ejbsamples

[John Hogan]

All, 
I've gone through the process of configuring Orion and the ejbsamples to run with a 
mysql database. Things seem to be nearly correct. Orion connects to the database ok, 
but dies trying to create tables. The problem seems to be related to syntax or type 
mismatches between hypersonic db and mysql. Some of the postings on this list seem to 
suggest that these mismatches can be addressed by defining type mappings in mysql.xml. 
I've tried this without success. 

I've included the error message, data-sources.xml and the mysql.xml I'm using. If 
anyone's been through the exercies and can provide any useful pointers, it would be 
much appreciated. TIA. 

John Hogan 

ERROR TEXT: 
=== 
[root@dalcassion orion]# java -classpath 
/opt/orion/application-deployments/serverclasses/mm.mysql-2.0.8 -jar orion.jar 
Auto-deploying ejbsamples (New server version detected)... 
Auto-deploying usermanager (No previous deployment found)... 
Auto-creating table: create table com_evermind_ejb_EJBUser (username SET(255) not null 
primary key, password SET(255) null, description SET(255) null, locale SET(5) null, 
certificateIssuerDN SET(255) null, certificateSerial SET(100) null) 
Warning: Error creating table: Syntax error or access violation: You have an error in 
your SQL syntax near '255) not null primary key, password SET(255) null, description 
SET(255) null, lo' at line 1 

Auto-creating table: create table com_evermind_ejb_EJBUser_groups (username SET(255) 
not null, value SET(255) not null, primary key (username, value)) 
Warning: Error creating table: Syntax error or access violation: You have an error in 
your SQL syntax near '255) not null, value SET(255) not null, primary key (username, 
value))' at line 1 
done. 
Auto-deploying product (No previous deployment found)... 
Auto-creating table: create table MyProduct (id BIGINT not null primary key, name 
SET(255) null, description SET(255) null, price FLOAT null) 
Warning: Error creating table: Syntax error or access violation: You have an error in 
your SQL syntax near '255) null, description SET(255) null, price FLOAT null)' at line 
1 
done. 
Auto-deploying cart (No previous deployment found)... done. 
Orion/1.4.8 initialized 
= 


data-sources.xml 
= 
?xml version=1.0? 
!DOCTYPE data-sources PUBLIC Orion data-sources  
http://www.orionserver.com/dtds/data-sources.dtd; 

data-sources 
!-- 
An example/default DataSource that uses an ordinary 
JDBC-driver (in this case hsql) to create the connections. 
This tag creates all the needed kinds 
of data-sources, transactional, pooled and EJB-aware sources. 
The source generally used in application code is the EJB 
one - it provides transactional safety and connection pooling. 
-- 
data-source 
name=mysql 
class=com.evermind.sql.DriverManagerDataSource 
location=jdbc/mysql 
pooled-location =jdbc/mysqlPooled 
xa-location=jdbc/xa/mysql 
ejb-location=jdbc/mysql 
url=jdbc:mysql:/opt/mysql/mysql/data/menagerie 
connection-driver=org.gjt.mm.mysql.Driver 
username=root 
password=sPikeO1 
inactivity-timeout=30 
/ 
/data-sources 
= 


database-schemas/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=char(1)/ 
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 


-- 

___
Get your email from http://www.ireland.com

Mysql table create errors with ejbsamples

[John Hogan]

All, 
I've gone through the process of configuring Orion and the ejbsamples to run with a 
mysql database. Things seem to be nearly correct. Orion connects to the database ok, 
but dies trying to create tables. The problem seems to be related to syntax or type 
mismatches between hypersonic db and mysql. Some of the postings on this list seem to 
suggest that these mismatches can be addressed by defining type mappings in mysql.xml. 
I've tried this without success. 
I've included the error message, data-sources.xml and the mysql.xml I'm using. If 
anyone's been through the exercies and can provide any useful pointers, it would be 
much appreciated. TIA. 

John Hogan 

ERROR TEXT: 
=== 
[root@dalcassion orion]# java -classpath 
/opt/orion/application-deployments/serverclasses/mm.mysql-2.0.8 -jar orion.jar 
Auto-deploying ejbsamples (New server version detected)... 
Auto-deploying usermanager (No previous deployment found)... 
Auto-creating table: create table com_evermind_ejb_EJBUser (username SET(255) not null 
primary key, password SET(255) null, description SET(255) null, locale SET(5) null, 
certificateIssuerDN SET(255) null, certificateSerial SET(100) null) 
Warning: Error creating table: Syntax error or access violation: You have an error in 
your SQL syntax near '255) not null primary key, password SET(255) null, description 
SET(255) null, lo' at line 1 

Auto-creating table: create table com_evermind_ejb_EJBUser_groups (username SET(255) 
not null, value SET(255) not null, primary key (username, value)) 
Warning: Error creating table: Syntax error or access violation: You have an error in 
your SQL syntax near '255) not null, value SET(255) not null, primary key (username, 
value))' at line 1 
done. 
Auto-deploying product (No previous deployment found)... 
Auto-creating table: create table MyProduct (id BIGINT not null primary key, name 
SET(255) null, description SET(255) null, price FLOAT null) 
Warning: Error creating table: Syntax error or access violation: You have an error in 
your SQL syntax near '255) null, description SET(255) null, price FLOAT null)' at line 
1 
done. 
Auto-deploying cart (No previous deployment found)... done. 
Orion/1.4.8 initialized 
= 


data-sources.xml 
= 
?xml version=1.0? 
!DOCTYPE data-sources PUBLIC Orion data-sources  
http://www.orionserver.com/dtds/data-sources.dtd; 

data-sources 
!-- 
An example/default DataSource that uses an ordinary 
JDBC-driver (in this case hsql) to create the connections. 
This tag creates all the needed kinds 
of data-sources, transactional, pooled and EJB-aware sources. 
The source generally used in application code is the EJB 
one - it provides transactional safety and connection pooling. 
-- 
data-source 
name=mysql 
class=com.evermind.sql.DriverManagerDataSource 
location=jdbc/mysql 
pooled-location =jdbc/mysqlPooled 
xa-location=jdbc/xa/mysql 
ejb-location=jdbc/mysql 
url=jdbc:mysql:/opt/mysql/mysql/data/menagerie 
connection-driver=org.gjt.mm.mysql.Driver 
username=root 
password=sPikeO1 
inactivity-timeout=30 
/ 
/data-sources 
= 


database-schemas/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=char(1)/ 
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 




-- 

___
Get your email from http://www.ireland.com

Re: Mysql table create errors with ejbsamples

[Ed Brown]

You're missing a line in your date sources file:

Quoting John Hogan [EMAIL PROTECTED]:

 
 data-sources.xml 
 = 
 ?xml version=1.0? 
 !DOCTYPE data-sources PUBLIC Orion data-sources 
 http://www.orionserver.com/dtds/data-sources.dtd; 
 
 data-sources 
 !-- 
 An example/default DataSource that uses an ordinary 
 JDBC-driver (in this case hsql) to create the connections. 
 This tag creates all the needed kinds 
 of data-sources, transactional, pooled and EJB-aware sources. 
 The source generally used in application code is the EJB 
 one - it provides transactional safety and connection pooling. 
 -- 
 data-source 
 name=mysql 
 class=com.evermind.sql.DriverManagerDataSource 
 location=jdbc/mysql 
 pooled-location =jdbc/mysqlPooled 
 xa-location=jdbc/xa/mysql 
 ejb-location=jdbc/mysql 
 url=jdbc:mysql:/opt/mysql/mysql/data/menagerie 
 connection-driver=org.gjt.mm.mysql.Driver 
 username=root 
 password=sPikeO1 
 inactivity-timeout=30 
 / 
 /data-sources 

Add

schema=database-schemas/mysql.xml



Ed Brown


_
This mail sent via toadmail.com, web e-mail @ ToadNet - want to go fast?
http://www.toadmail.com

MySQL and JDBC

[Harald Kirschner]

Folks,

I am new to Orion and look for a brief example of an EJB that accesses a 
database table. Who can send me and example like this?

Thanks,
   Harald

Re: MySQL and JDBC

[Scott Farquhar]

Harald,

This link has many examples that you can install on Orion:
   http://kb.atlassian.com/directory/examples

Can I suggest the Orion CMP Primer?

Cheers,
Scott

-- 
Scott Farquhar :: [EMAIL PROTECTED]

Atlassian :: http://www.atlassian.com
  Supporting YOUR J2EE World


Harald Kirschner wrote:

 Folks,
 
 I am new to Orion and look for a brief example of an EJB that accesses a 
 database table. Who can send me and example like this?
 
 Thanks,
Harald
 
 
 

Orion and MySQL config

[Derek Lee]

Dear
All,
 Any document can help me to
understand how to config the Orion connect to MySQL and create the connection
Pool? Or any expert can teach me how to config it?
Thanks
in advance
Derek
__This transmission and the information it contains including any attachment, is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, disclose or copy this transmission. If you have received this transmission (or any copy) in error, please notify us immediately by reply e-mail to [EMAIL PROTECTED] Please delete the original transmission(including any attachment) and its contents and destroy or return to us any hard copy. Please note that any electronically transmitted material that purports to commit Sun Hung Kai & Co. Ltd., or any of its subsidiaries or associates, to any obligation or in any other way whatsoever, unless subsequently confirmed by  fax or letter signed (in either case) by our duly authorized officer(s) may not be relied on. Material transmitted to you should also be checked by reference to the hard copy of the material printed directly by us. 

Re: Problems with CMP/MySQL

[Marcus Ahnve]

I've just (10 minutes ago) been through this. You need to set 
type-mapping type=boolean name=char(1)/.

The MySQL online documentation says that bit and bool gets converted 
to char(1), but in reality they where set to tinyint(1), which Orion for 
some reason could not use. The above solution worked for me.

Regards /Marcus

Roozbeh Ghaffari wrote:
 Dear Michael,
 
 I have set the schema attribute of my datasource to 
 mysql.xml (which I have written myself). In this
 file I can only set datatype mappings. I can't tell
 Orion what are the literals for True or False.
 
 tnx,
 Roozbeh/
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]] On Behalf Of Michael
 Simons
 Sent: Monday, October 01, 2001 11:14 AM
 To: Orion-Interest
 Subject: Re: Problems with CMP/MySQL
 
 
 Roozbeh Ghaffari wrote:
 
 
Hi All,

 

We use Orion CMP features with MySQL. We had problems with boolean and
char fields.

I used P6Spy (www.provision6.com http://www.provision6.com)  to see
SQL commands generated by Orion.

Orion says:

update table_name set boolean_field = 'true'

but MySQL expects

update table_name set boolean_field = '1'

 

How can I ask Orion to generate the expected SQL?

 

But in case of character field we have a bigger problem.

I try to set a character field to 'F' or 'M'

Orion says:

update table_name set char_field = 0

!!!

I don't understand what is happening!

 

Thank you in advance,

Roozbeh/


 
 Sounds like You're missing $ORION_HOME/config/database-schemas/mysql.xml
 
 michael
 
 


-- 
Marcus Ahnve  email: [EMAIL PROTECTED]
Lecando AB   Office: +46-(0)8-634 94 18
Sweden   Mobile: +46-(0)70-462 19 18
www.lecando.comICQ#: 4564879

RE: Problems with CMP/MySQL

[Roozbeh Ghaffari]

Dear Michael,

I have set the schema attribute of my datasource to 
mysql.xml (which I have written myself). In this
file I can only set datatype mappings. I can't tell
Orion what are the literals for True or False.

tnx,
Roozbeh/

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Michael
Simons
Sent: Monday, October 01, 2001 11:14 AM
To: Orion-Interest
Subject: Re: Problems with CMP/MySQL


Roozbeh Ghaffari wrote:

 Hi All,
 
  
 
 We use Orion CMP features with MySQL. We had problems with boolean and
 char fields.
 
 I used P6Spy (www.provision6.com http://www.provision6.com)  to see
 SQL commands generated by Orion.
 
 Orion says:
 
 update table_name set boolean_field = 'true'
 
 but MySQL expects
 
 update table_name set boolean_field = '1'
 
  
 
 How can I ask Orion to generate the expected SQL?
 
  
 
 But in case of character field we have a bigger problem.
 
 I try to set a character field to 'F' or 'M'
 
 Orion says:
 
 update table_name set char_field = 0
 
 !!!
 
 I don't understand what is happening!
 
  
 
 Thank you in advance,
 
 Roozbeh/
 

Sounds like You're missing $ORION_HOME/config/database-schemas/mysql.xml

michael

-- 
Dipl.-Math. (fh) Michael Simons
UNIOPT AG // unique logistic optimization
Maximilianstr. 29; D-93047 Regensburg
phone: ++49(0)941/59578-0
http://www.uniopt.net/


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: Problems with CMP/MySQL

[Michael Simons]

Roozbeh Ghaffari wrote:

 Hi All,
 
  
 
 We use Orion CMP features with MySQL. We had problems with boolean and 
 char fields.
 
 I used P6Spy (www.provision6.com http://www.provision6.com)  to see 
 SQL commands generated by Orion.
 
 Orion says:
 
 update table_name set boolean_field = 'true'
 
 but MySQL expects
 
 update table_name set boolean_field = '1'
 
  
 
 How can I ask Orion to generate the expected SQL?
 
  
 
 But in case of character field we have a bigger problem.
 
 I try to set a character field to 'F' or 'M'
 
 Orion says:
 
 update table_name set char_field = 0
 
 !!!
 
 I don't understand what is happening!
 
  
 
 Thank you in advance,
 
 Roozbeh/
 

Sounds like You're missing
$ORION_HOME/config/database-schemas/mysql.xml

michael

-- 
Dipl.-Math. (fh) Michael Simons
UNIOPT AG // unique logistic optimization
Maximilianstr. 29; D-93047 Regensburg
phone: ++49(0)941/59578-0
http://www.uniopt.net/

Problems with CMP/MySQL

[Roozbeh Ghaffari]

Title: Message



Hi 
All,

We use Orion CMP 
features with MySQL. We had problems with boolean and char 
fields.
I used P6Spy (www.provision6.com) to see SQL 
commands generated by Orion. 
Orion 
says:
update table_name 
set boolean_field = 'true'
but MySQL 
expects
update table_name 
set boolean_field = '1'

How can I ask Orion 
to generate the expected SQL?

But in case of 
character field we have a bigger problem.
I try to set a 
character field to 'F' or 'M'
Orion 
says:
update table_name 
set char_field = 0
!!!
I don't understand 
what is happening!

Thank you in 
advance,
Roozbeh/

RE: Problems with CMP/MySQL

[Troy Wong]

I had a similar problem but found a fix for it. I assume you are using mm.mysql as 
your jdbc driver:

create table Article (
articleId varchar(100) not null primary key,
churchId varchar(100),
userId varchar(100),
title varchar(100),
content longtext,
createDate datetime,
expirationDate datetime,
expirable enum('t', 'f')
);

I had to modify my table to use enum('t', 'f') instead of bit or tinyint as a boolean 
type, and then it works.

- Brian
-Original Message-
From: Roozbeh Ghaffari [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: Problems with CMP/MySQL
Date: Sun Sep 30 08:38:18 GMT 2001

Hi All,
 
We use Orion CMP features with MySQL. We had problems with boolean and
char fields.
I used P6Spy (www.provision6.com)  to see SQL commands generated by
Orion. 
Orion says:
update table_name set boolean_field = 'true'
but MySQL expects
update table_name set boolean_field = '1'
 
How can I ask Orion to generate the expected SQL?
 
But in case of character field we have a bigger problem.
I try to set a character field to 'F' or 'M'
Orion says:
update table_name set char_field = 0
!!!
I don't understand what is happening!
 
Thank you in advance,
Roozbeh/

How to use mySQL DB as Datasource?

[Michael Simons]

I'm aware that's a really newbie question but that's what I am ...

Any docs or anything else on this?

thanks in advance, michael

-- 
Dipl.-Math. (fh) Michael Simons
UNIOPT AG // unique logistic optimization
Maximilianstr. 29; D-93047 Regensburg
phone: ++49(0)941/59578-0
http://www.uniopt.net/

Re: How to use mySQL DB as Datasource?

[Chris Callaghan]

Download the JDBC driver from http://mmmysql.sourceforge.net/ and put 
that into your orion/lib directory, then edit 
orion/config/data-sources.xml to add in the data-source.

Docs on the data-sources.xml can be found here: 
http://www.orionserver.com/docs/data-sources.xml.html

You will need to use connection-driver=org.gjt.mm.mysql.Driver and 
url=jdbc:mysql://[hostname][:port]/dbname[?param1=value1][param2=value2] 
.

If you want to use CMP then you'll have to setup the database-schema.xml 
(http://www.orionserver.com/docs/database-schema.xml.html) as well.

Have fun!
Chris

Michael Simons wrote:

 I'm aware that's a really newbie question but that's what I am ...

 Any docs or anything else on this?

 thanks in advance, michael

RE: mySQL

[Justin Wood]

If you have to rely on how many columns a query returns it is very likely
that your database is not properly normalised so look there first.   

It could be that ODBC does not support the number of columns metadata but I
am not sure.   Your problems should be solved with your move to mySQL; I
recall having used that method on mySQL JDBC with success in the past.  

Justin

-Original Message-
From: Emeline Barns [mailto:[EMAIL PROTECTED]]
Sent: 22 September 2001 08:10
To: Orion-Interest
Subject: Re: mySQL


Hi Ray,
Thank you very much for your help. Yes, I amusing jdbc-odbc bridge, but I am

not sure if put on shared drive it canhold 25 simaltenous connection without

crashing.
Besides, when I am selecting data from first table using
String sqlStatement = Select * from  + first_table+ , +second_table +  
where  + filed_name +  Like '% + keyword + %';
and what to know number of columns selected
col_number = rsmd.getColumnCount();
it gives me number of columns from 2 tables.When I want to find to which 
table this column belongs
table_name = rsmd.getTableName(1);
it gives me empty String.
So still do not know how to find the real number of columns selected.
Elena

From: Ray Harrison [EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: Re: mySQL
Date: Sat, 22 Sep 2001 02:57:41 -0700 (PDT)

Emeline -
Go to http://mmmysql.sourceforge.net/ and you can pick up the latest jdbc 
driver jar file (works
anywhere). You should be able to export your access tables to delimited 
files and then load them
into mysql. With Access, you can use the JDBC-ODBC bridge to get at the 
data if you are interested
in pursuing that avenue.


Cheers
Ray
--- Emeline Barns [EMAIL PROTECTED] wrote:
  Hi gurus,
  I have databases created in MS Access and using JDBC-ODBC for connection
  which is not great.
  My application have to hold under 30 connections. I tested my PC to run 
20
  instances of the program, and it worked. Does this mean that it will be
  working when installed on shared drive?
  I tried to switch to mySQL, butcannot yet find the JDBC driver for
  WindowsNT(only Linux). Also I need to export my databases from Access to
  MySQL which I have not found as well.
  May be there are some free JDBC drivers for Access which I am not aware.

I
  make this program for non=profitable organization which has no money to 
buy
  drivers.
  Any help will be appreciated.
  Emeline
 
 
  From: Michael J. Cannon [EMAIL PROTECTED]
  Reply-To: Orion-Interest [EMAIL PROTECTED]
  To: Orion-Interest [EMAIL PROTECTED]
  CC: [EMAIL PROTECTED]
  Subject: Re: Orion Security (WAS:RE:Questions About Orion)
  Date: Fri, 21 Sep 2001 15:27:42 -0500
  
  Vlad,
  
  As in any App Server environment on the Web, the security 
vulnerabilities
  of
  the Orion App Server are on two fronts:
  
  Server-side:
  Orionserver Security Primer:
  http://www.jollem.com/~ernst/orion-security-primer/
  Java Best Practices for Server-side Security:
  From Sun:
  J2EE:
  The Tutorial:
  http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Security.html
  The Security Blueprint:
  http://java.sun.com/j2ee/blueprints/eis_tier/security/index.html
  Platform Spec for v.1.3 (go to the Security Bookmark in the .pdf)
  http://java.sun.com/j2ee/j2ee-1_3-pfd4-spec.pdf
  
  Additionally, there are potential vulnerabilities in the HTTP server, 
the
  plug-in architecture (especially when using CGI and PHP, Python, Perl 
or
  Jpython scripts/executables - allowed in Orion and rather easy to do, 
as
  well as being very fast).  There was a general discussion about 
Java-based
  HTTP webservers at the WWW Mobile code forum
  

(link:http://www.securityfocus.com/templates/archive.pike?end=2001-09-22ti
d
  =196606start=2001-09-16list=107threads=0), but it didn't resolve
  anything.  Bottom line:  in general, currently both the HTTP and 
Java/J2EE
  functionality of the Orion Server is safe from all known exploits and
  vulnerabilities in the wild, with the possible exception of a DoS due 
to
  transparent proxying on the server (Cisco Routers and Xerox Printers, 
as
  well as most Cable and DSL modems are similarly vulnerable).  Orion is 
no
  more vulnerable than Apache/Tomcat or IIS, and, as recent history has
  proven, is actually far less vulnerable than the Microsoft products for
  similar functionality (as well as being FAR faster and easier to 
develop
  for - Link:  http://www.orionserver.com/benchmarks/benchmark.html , 
sadly,
  the BEAst will not allow Orion to continue to publlish stats, but you 
can
  read about that following the links:).
  
  The second major place that any  J2EE AppServer is in the database.  
'Nuff
  said, separate issue and separate practices.  Use a secured (wrappered 
or
  tunneled with encruyption) HTTP or RMI connection to the database all 
JDBC
  connections.  Secure the JDBC datastream and securew the database 
according
  to the best practices you may choose.
  
  The final place

RE: mySQL

[Emeline Barns]

Thank you,Justin. If you tried to run MySQL on Windows NT?
The problem with the JDBC_ODBC bridge than when you select from 2 tables 
(like join) then getTableName gives you empty string. So you have to select 
at first from first table and then from the second one.
Elena


From: Justin Wood [EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: RE: mySQL
Date: Wed, 26 Sep 2001 12:15:06 +0200

If you have to rely on how many columns a query returns it is very likely
that your database is not properly normalised so look there first.

It could be that ODBC does not support the number of columns metadata but I
am not sure.   Your problems should be solved with your move to mySQL; I
recall having used that method on mySQL JDBC with success in the past.

Justin

-Original Message-
From: Emeline Barns [mailto:[EMAIL PROTECTED]]
Sent: 22 September 2001 08:10
To: Orion-Interest
Subject: Re: mySQL


Hi Ray,
Thank you very much for your help. Yes, I amusing jdbc-odbc bridge, but I 
am

not sure if put on shared drive it canhold 25 simaltenous connection 
without

crashing.
Besides, when I am selecting data from first table using
String sqlStatement = Select * from  + first_table+ , +second_table + 
where  + filed_name +  Like '% + keyword + %';
and what to know number of columns selected
col_number = rsmd.getColumnCount();
it gives me number of columns from 2 tables.When I want to find to which
table this column belongs
table_name = rsmd.getTableName(1);
it gives me empty String.
So still do not know how to find the real number of columns selected.
Elena



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: mySQL

[Ray Harrison]

Emeline -
Go to http://mmmysql.sourceforge.net/ and you can pick up the latest jdbc driver jar 
file (works
anywhere). You should be able to export your access tables to delimited files and then 
load them
into mysql. With Access, you can use the JDBC-ODBC bridge to get at the data if you 
are interested
in pursuing that avenue. 


Cheers
Ray
--- Emeline Barns [EMAIL PROTECTED] wrote:
 Hi gurus,
 I have databases created in MS Access and using JDBC-ODBC for connection 
 which is not great.
 My application have to hold under 30 connections. I tested my PC to run 20 
 instances of the program, and it worked. Does this mean that it will be 
 working when installed on shared drive?
 I tried to switch to mySQL, butcannot yet find the JDBC driver for 
 WindowsNT(only Linux). Also I need to export my databases from Access to 
 MySQL which I have not found as well.
 May be there are some free JDBC drivers for Access which I am not aware. I 
 make this program for non=profitable organization which has no money to buy 
 drivers.
 Any help will be appreciated.
 Emeline
 
 
 From: Michael J. Cannon [EMAIL PROTECTED]
 Reply-To: Orion-Interest [EMAIL PROTECTED]
 To: Orion-Interest [EMAIL PROTECTED]
 CC: [EMAIL PROTECTED]
 Subject: Re: Orion Security (WAS:RE:Questions About Orion)
 Date: Fri, 21 Sep 2001 15:27:42 -0500
 
 Vlad,
 
 As in any App Server environment on the Web, the security vulnerabilities 
 of
 the Orion App Server are on two fronts:
 
 Server-side:
 Orionserver Security Primer:
 http://www.jollem.com/~ernst/orion-security-primer/
 Java Best Practices for Server-side Security:
 From Sun:
 J2EE:
 The Tutorial:
 http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Security.html
 The Security Blueprint:
 http://java.sun.com/j2ee/blueprints/eis_tier/security/index.html
 Platform Spec for v.1.3 (go to the Security Bookmark in the .pdf)
 http://java.sun.com/j2ee/j2ee-1_3-pfd4-spec.pdf
 
 Additionally, there are potential vulnerabilities in the HTTP server, the
 plug-in architecture (especially when using CGI and PHP, Python, Perl or
 Jpython scripts/executables - allowed in Orion and rather easy to do, as
 well as being very fast).  There was a general discussion about Java-based
 HTTP webservers at the WWW Mobile code forum
 (link:http://www.securityfocus.com/templates/archive.pike?end=2001-09-22tid
 =196606start=2001-09-16list=107threads=0), but it didn't resolve
 anything.  Bottom line:  in general, currently both the HTTP and Java/J2EE
 functionality of the Orion Server is safe from all known exploits and
 vulnerabilities in the wild, with the possible exception of a DoS due to
 transparent proxying on the server (Cisco Routers and Xerox Printers, as
 well as most Cable and DSL modems are similarly vulnerable).  Orion is no
 more vulnerable than Apache/Tomcat or IIS, and, as recent history has
 proven, is actually far less vulnerable than the Microsoft products for
 similar functionality (as well as being FAR faster and easier to develop
 for - Link:  http://www.orionserver.com/benchmarks/benchmark.html , sadly,
 the BEAst will not allow Orion to continue to publlish stats, but you can
 read about that following the links:).
 
 The second major place that any  J2EE AppServer is in the database.  'Nuff
 said, separate issue and separate practices.  Use a secured (wrappered or
 tunneled with encruyption) HTTP or RMI connection to the database all JDBC
 connections.  Secure the JDBC datastream and securew the database according
 to the best practices you may choose.
 
 The final place on the server-side that any J2EE or other App server is
 vulnerable is the environment.  Nail down the ACLs for your specific
 environment and pay attention to the OS and the various other sevices and
 apps you are running on the box (including the security services -  just 
 had
 to repair a Symantec-installed hole left when they put their IDS tools on
 the production box!). Pay attention to domain and network issues, and keep
 the network clean and properly configured.  Most Orion or Oracle
 penetrations I've seen/heard of were actually BIND exploits or port53 DNS
 issues.
 
 With the advent of NIMDA, we see another vector for attacks:  the client
 program.  With a few exceptions, Java AppServers are uniquely invulnerable
 to this new vector.
 Sun Client-side Security Note:
 http://java.sun.com/j2se/1.3.0/docs/guide/security/spec/security-specTOC.fm.
 html
 
 So, keep aware of general security threats, code to best practices, test
 developers' code for exploits before putting it into production (85% of all
 losses in the IT enterprise space are inside jobs) and be aware of normal
 security precautions.
 
 For Solaris tools see:
 http://www.solaris4you.dk/sunsolaris.html
 
 and, I'm testing the Astaro Security Linux implementation (and have
 installed it for 3 clients who use Orion or Oracle 9AS with OC4J) so far
 successfully.  I include a few additional patches and configuration 
 changes,
 but, in general it seems to work well

Re: mySQL

[Emeline Barns]

Hi Ray,
Thank you very much for your help. Yes, I amusing jdbc-odbc bridge, but I am 
not sure if put on shared drive it canhold 25 simaltenous connection without 
crashing.
Besides, when I am selecting data from first table using
String sqlStatement = Select * from  + first_table+ , +second_table +  
where  + filed_name +  Like '% + keyword + %';
and what to know number of columns selected
col_number = rsmd.getColumnCount();
it gives me number of columns from 2 tables.When I want to find to which 
table this column belongs
table_name = rsmd.getTableName(1);
it gives me empty String.
So still do not know how to find the real number of columns selected.
Elena

From: Ray Harrison [EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: Re: mySQL
Date: Sat, 22 Sep 2001 02:57:41 -0700 (PDT)

Emeline -
Go to http://mmmysql.sourceforge.net/ and you can pick up the latest jdbc 
driver jar file (works
anywhere). You should be able to export your access tables to delimited 
files and then load them
into mysql. With Access, you can use the JDBC-ODBC bridge to get at the 
data if you are interested
in pursuing that avenue.


Cheers
Ray
--- Emeline Barns [EMAIL PROTECTED] wrote:
  Hi gurus,
  I have databases created in MS Access and using JDBC-ODBC for connection
  which is not great.
  My application have to hold under 30 connections. I tested my PC to run 
20
  instances of the program, and it worked. Does this mean that it will be
  working when installed on shared drive?
  I tried to switch to mySQL, butcannot yet find the JDBC driver for
  WindowsNT(only Linux). Also I need to export my databases from Access to
  MySQL which I have not found as well.
  May be there are some free JDBC drivers for Access which I am not aware. 
I
  make this program for non=profitable organization which has no money to 
buy
  drivers.
  Any help will be appreciated.
  Emeline
 
 
  From: Michael J. Cannon [EMAIL PROTECTED]
  Reply-To: Orion-Interest [EMAIL PROTECTED]
  To: Orion-Interest [EMAIL PROTECTED]
  CC: [EMAIL PROTECTED]
  Subject: Re: Orion Security (WAS:RE:Questions About Orion)
  Date: Fri, 21 Sep 2001 15:27:42 -0500
  
  Vlad,
  
  As in any App Server environment on the Web, the security 
vulnerabilities
  of
  the Orion App Server are on two fronts:
  
  Server-side:
  Orionserver Security Primer:
  http://www.jollem.com/~ernst/orion-security-primer/
  Java Best Practices for Server-side Security:
  From Sun:
  J2EE:
  The Tutorial:
  http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Security.html
  The Security Blueprint:
  http://java.sun.com/j2ee/blueprints/eis_tier/security/index.html
  Platform Spec for v.1.3 (go to the Security Bookmark in the .pdf)
  http://java.sun.com/j2ee/j2ee-1_3-pfd4-spec.pdf
  
  Additionally, there are potential vulnerabilities in the HTTP server, 
the
  plug-in architecture (especially when using CGI and PHP, Python, Perl 
or
  Jpython scripts/executables - allowed in Orion and rather easy to do, 
as
  well as being very fast).  There was a general discussion about 
Java-based
  HTTP webservers at the WWW Mobile code forum
  
 (link:http://www.securityfocus.com/templates/archive.pike?end=2001-09-22tid
  =196606start=2001-09-16list=107threads=0), but it didn't resolve
  anything.  Bottom line:  in general, currently both the HTTP and 
Java/J2EE
  functionality of the Orion Server is safe from all known exploits and
  vulnerabilities in the wild, with the possible exception of a DoS due 
to
  transparent proxying on the server (Cisco Routers and Xerox Printers, 
as
  well as most Cable and DSL modems are similarly vulnerable).  Orion is 
no
  more vulnerable than Apache/Tomcat or IIS, and, as recent history has
  proven, is actually far less vulnerable than the Microsoft products for
  similar functionality (as well as being FAR faster and easier to 
develop
  for - Link:  http://www.orionserver.com/benchmarks/benchmark.html , 
sadly,
  the BEAst will not allow Orion to continue to publlish stats, but you 
can
  read about that following the links:).
  
  The second major place that any  J2EE AppServer is in the database.  
'Nuff
  said, separate issue and separate practices.  Use a secured (wrappered 
or
  tunneled with encruyption) HTTP or RMI connection to the database all 
JDBC
  connections.  Secure the JDBC datastream and securew the database 
according
  to the best practices you may choose.
  
  The final place on the server-side that any J2EE or other App server is
  vulnerable is the environment.  Nail down the ACLs for your specific
  environment and pay attention to the OS and the various other sevices 
and
  apps you are running on the box (including the security services -  
just
  had
  to repair a Symantec-installed hole left when they put their IDS tools 
on
  the production box!). Pay attention to domain and network issues, and 
keep
  the network clean and properly configured.  Most Orion or Oracle
  penetrations I've seen

Re: mySQL

[Emeline Barns]

Hi gurus,
I have databases created in MS Access and using JDBC-ODBC for connection 
which is not great.
My application have to hold under 30 connections. I tested my PC to run 20 
instances of the program, and it worked. Does this mean that it will be 
working when installed on shared drive?
I tried to switch to mySQL, butcannot yet find the JDBC driver for 
WindowsNT(only Linux). Also I need to export my databases from Access to 
MySQL which I have not found as well.
May be there are some free JDBC drivers for Access which I am not aware. I 
make this program for non=profitable organization which has no money to buy 
drivers.
Any help will be appreciated.
Emeline


From: Michael J. Cannon [EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Orion Security (WAS:RE:Questions About Orion)
Date: Fri, 21 Sep 2001 15:27:42 -0500

Vlad,

As in any App Server environment on the Web, the security vulnerabilities 
of
the Orion App Server are on two fronts:

Server-side:
Orionserver Security Primer:
http://www.jollem.com/~ernst/orion-security-primer/
Java Best Practices for Server-side Security:
From Sun:
J2EE:
The Tutorial:
http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Security.html
The Security Blueprint:
http://java.sun.com/j2ee/blueprints/eis_tier/security/index.html
Platform Spec for v.1.3 (go to the Security Bookmark in the .pdf)
http://java.sun.com/j2ee/j2ee-1_3-pfd4-spec.pdf

Additionally, there are potential vulnerabilities in the HTTP server, the
plug-in architecture (especially when using CGI and PHP, Python, Perl or
Jpython scripts/executables - allowed in Orion and rather easy to do, as
well as being very fast).  There was a general discussion about Java-based
HTTP webservers at the WWW Mobile code forum
(link:http://www.securityfocus.com/templates/archive.pike?end=2001-09-22tid
=196606start=2001-09-16list=107threads=0), but it didn't resolve
anything.  Bottom line:  in general, currently both the HTTP and Java/J2EE
functionality of the Orion Server is safe from all known exploits and
vulnerabilities in the wild, with the possible exception of a DoS due to
transparent proxying on the server (Cisco Routers and Xerox Printers, as
well as most Cable and DSL modems are similarly vulnerable).  Orion is no
more vulnerable than Apache/Tomcat or IIS, and, as recent history has
proven, is actually far less vulnerable than the Microsoft products for
similar functionality (as well as being FAR faster and easier to develop
for - Link:  http://www.orionserver.com/benchmarks/benchmark.html , sadly,
the BEAst will not allow Orion to continue to publlish stats, but you can
read about that following the links:).

The second major place that any  J2EE AppServer is in the database.  'Nuff
said, separate issue and separate practices.  Use a secured (wrappered or
tunneled with encruyption) HTTP or RMI connection to the database all JDBC
connections.  Secure the JDBC datastream and securew the database according
to the best practices you may choose.

The final place on the server-side that any J2EE or other App server is
vulnerable is the environment.  Nail down the ACLs for your specific
environment and pay attention to the OS and the various other sevices and
apps you are running on the box (including the security services -  just 
had
to repair a Symantec-installed hole left when they put their IDS tools on
the production box!). Pay attention to domain and network issues, and keep
the network clean and properly configured.  Most Orion or Oracle
penetrations I've seen/heard of were actually BIND exploits or port53 DNS
issues.

With the advent of NIMDA, we see another vector for attacks:  the client
program.  With a few exceptions, Java AppServers are uniquely invulnerable
to this new vector.
Sun Client-side Security Note:
http://java.sun.com/j2se/1.3.0/docs/guide/security/spec/security-specTOC.fm.
html

So, keep aware of general security threats, code to best practices, test
developers' code for exploits before putting it into production (85% of all
losses in the IT enterprise space are inside jobs) and be aware of normal
security precautions.

For Solaris tools see:
http://www.solaris4you.dk/sunsolaris.html

and, I'm testing the Astaro Security Linux implementation (and have
installed it for 3 clients who use Orion or Oracle 9AS with OC4J) so far
successfully.  I include a few additional patches and configuration 
changes,
but, in general it seems to work well. Link:
http://www.astaro.com
and
http://www.astaro.org

Comes with Enterprise VPN and AV support, too.

Also having luck with Net Screen
http://www.netscreen.com/products/index.html

Hope all this was of assistance.  Contact me offline if you have any more
specific questions on Oracle, OAS or Orion Security.  We also test
Enterprise domain-level security and manage PKI infrastructures.

Michael J. Cannon
[EMAIL PROTECTED]
PM/COO-hsqldb.org, Inc.
http://hsqldb.org

President, Ubiquicomm

Orion server Configuration for mysql access

[kanaparthy madhav]

Hi,

  Could anyone tell me how to configure the

orion server to support acccess to mysql DBMS

Thanks in advance,
Krishna

__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

RE: Does Orion work fine in MySQL and BSD?

[steve . d . meacham]

I use it with FreeBSD and PostgreSQL, but I know that it also works 
with MySQL if you configure it for the proper data-source.
 
Steven

-Original Message-
From: hkhwang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 12, 2001 9:05 PM
To: orion-interest
Cc: hkhwang
Subject: Does Orion work fine in MySQL and BSD?





Hello

 

Can Orion work with MySQL and FreeBSD?

 

Any comment would be appreciated.

Regards,

-HK

 

Does Orion work fine in MySQL and BSD?

[HyungKee Hwang]

Hello



Can Orion work with MySQL and FreeBSD?



Any comment would be appreciated.

Regards,

-HK

Re: Support for MySQL

[Brendan McKenna]

Hi Nicolai,

: Thank you for your suggestions everybody :) MySQL has always been very
: limited (no subselect, foreign keys, transaction etc) but I had
: positive experiences with it because of it's simplicity.
: 
: Does PostgreSQL support transactions?  Last time I used it was back in
: 1996, so I'm not up to speed with Stonebraker et Co's baby.
: 

As a matter of fact, it supports subselects, foreign keys, and 
transactions as well.  There's been a -lot- of improvements since 96.


Brendan

-- 
Brendan McKennaEmail: [EMAIL PROTECTED]
Development Strategist Phone: +353-61-338177
Taringold Ltd. Fax:   +353-61-338065

Re: Support for MySQL

[Nicolai P Guba]

 BM == Brendan McKenna [EMAIL PROTECTED] writes:

BM Hi Nicolai, : Thank you for your suggestions everybody :) MySQL
BM has always been very : limited (no subselect, foreign keys,
BM transaction etc) but I had : positive experiences with it
BM because of it's simplicity.
BM : 
BM : Does PostgreSQL support transactions?  Last time I used it was
BM back in : 1996, so I'm not up to speed with Stonebraker et Co's
BM baby.
BM : 

BM As a matter of fact, it supports subselects, foreign keys, and
BM transactions as well.  There's been a -lot- of improvements since
BM 96.

h, interesting.  Back then there were no foreign keys only oids
and that was painful if you wanted to do some examples from your
databases coursework from uni times :)

I'll give it a whirl.
-- 
  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

Re: Support for MySQL

[Scot Weber]

Yup . . . it sure is.  I use it as well as oracle and db2 for cross
compliance testing. As far as it being a 'success story', i personally
wouldn't use it as a production RDBMS. But that's just MNSHO.

peace - scot weber

Nicolai P Guba wrote:

 Hmmm, I've found that PostgreSQL is supported.  Has anybody got any
 success stories with mySQL? (still evaluating).

 --
   Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

Re: Support for MySQL

[Chris Callaghan]

The latest releases (as of 3.23.34a) of MySQL support transactions by 
using Berkley DB.

I'm using MySQL at the moment. The main anoyance I've got is that it 
doesn't have sub-selects, apart from that, works great.

I haven't tried using transactions though as my data is read only.

Ray Harrison wrote:

Mysql doesn't support transactions (or the last time I checked it didn't) - so it can 
be limited -
but yes, orion interacts with the database just fine. I would suggest another 
database to try
would be SAP DB (www.sapdb.org) which is an open source database delivered by SAP AG 
- I love it.
There is a sap database schema in the orion download. 



--- Nicolai P Guba [EMAIL PROTECTED] wrote:

Hmmm, I've found that PostgreSQL is supported.  Has anybody got any
success stories with mySQL? (still evaluating).

-- 
  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708



__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

Boolean CMP properties in MySQL

[Koster, K.J.]

Dear All,

I have a boolean property on an CMP entity bean. In the MySQL database I see
this type mapped to TINYINT(1), which is fine I guess.

Question one: I vaguely remember that the JavaBeans spec says that boolean
properties should have setFoo()/isFoo() instead of the setFOo()/getFoo()
combo. What's EJB's stance on this?

Question two: why does the value of the boolean stay at 0 (not NULL, so the
value is actually written) for either true or false in the database. It's
kind'a hard to distinguish true from false if they both map to 0. :-)

Kees Jan


 You are only young once,
   but you can stay immature all your life.

Short Orion/remote MySQL howto

[Koster, K.J.]

Dear All,

I've written a short howto on setting up Orion with MySQL on FreeBSD,
including some info on how set up privileges to connect to a remote MySQL
database.

http://kjkoster.org/java/index.jsp?page=content/packages.jspid=hd07

Kees Jan


 You are only young once,
   but you can stay immature all your life.

Re: orion with mysql?

[Armin Michel]

 [...] We also tried Hypersonic,
 but it seems that when both Orion and JBuilder communicate with the db the
 db gets confused. At least the changes we make in JBuilder don't get
 updated.

That's propably because Orion caches data of the DB. If you stop Orion, then 
update the DB and then restart Orion, you shouldn't perceive any update 
problems.

Greetings

Armin

RE: orion with mysql?

[Kiss Tibor]

The cause for that could be that MySQL does not support transactions...

 -Original Message-
 From: Aaron Tavistock [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, April 05, 2001 3:28 AM
 To: Orion-Interest
 Subject: RE: orion with mysql?
 
 
 You only need a schema if you intend to do CMP EJBs.  If 
 you're not using
 EJB at all then theres no reason you couldn't use MySQL.
 
 But, while its not to hard to make a schema that complies with MySQL
 somewhere in between MySQL and the mm.mysql driver the EJB transaction
 support falls apart.  My inclination is that its the mm.mysql 
 driver itself,
 and the real problem is just that transaction support is not 
 implimented in
 a way that complies with the EJB spec (e.g. javax.transaction 
 doesn't occur
 anywhere in the source).
 
 So, while you can use MySQL with Orion you can't do EJB 
 unless you switch
 over to SAPdb, PostgresSQL, or db.
 
 -Original Message-
 From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 04, 2001 3:52 PM
 To: Orion-Interest
 Subject: Re: orion with mysql?
 
 
 Am using MySQL with Orion without it's own db-schema.  No 
 problems, yet.
 
 Be sure to get the MM.MySQL driver...
 -- 
 
 -Geoff Marshall, Director of Development
 
 ...
 t e r r a s c o p e  (415) 951-4944
 54 Mint Street, Suite 110 direct (415) 625-0349
 San Francisco, CA  94103 fax (415) 625-0306
 ...
 
  From: Peter Peltonen [EMAIL PROTECTED]
  Organization: Fivetec Solutions Oy
  Reply-To: Orion-Interest [EMAIL PROTECTED]
  Date: Wed, 04 Apr 2001 19:42:44 +0300
  To: Orion-Interest [EMAIL PROTECTED]
  Subject: orion with mysql?
  
  
  Is it possible to use MySQL with Orion? Does it need a 
 db-schema of it's
 own?
  
  We tried to use PostgreSQL but JBuilder4 didn't cope with 
 it very well
  (JBuilder isn't able to show Postgre's tables). We also 
 tried Hypersonic,
 but
  it seems that when both Orion and JBuilder communicate with 
 the db the db
 gets
  confused. At least the changes we make in JBuilder don't 
 get updated.
  
  Any ideas about a good open-source db that would work with 
 both Orion and
  JBuilder would be appreciated!
  
  Regards,
  Peter
  
  
 
 
 

RE: orion with mysql?

[Kemp Randy-W18971]

I believe the latest release of Mysql supports transactions, but I am not sure the 
binaries are set with the Berkeley transaction engine.  You may have to compile both, 
and this is a question for Mysql.

-Original Message-
From: Kiss Tibor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 3:31 AM
To: Orion-Interest
Subject: RE: orion with mysql?


The cause for that could be that MySQL does not support transactions...

 -Original Message-
 From: Aaron Tavistock [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, April 05, 2001 3:28 AM
 To: Orion-Interest
 Subject: RE: orion with mysql?
 
 
 You only need a schema if you intend to do CMP EJBs.  If 
 you're not using
 EJB at all then theres no reason you couldn't use MySQL.
 
 But, while its not to hard to make a schema that complies with MySQL
 somewhere in between MySQL and the mm.mysql driver the EJB transaction
 support falls apart.  My inclination is that its the mm.mysql 
 driver itself,
 and the real problem is just that transaction support is not 
 implimented in
 a way that complies with the EJB spec (e.g. javax.transaction 
 doesn't occur
 anywhere in the source).
 
 So, while you can use MySQL with Orion you can't do EJB 
 unless you switch
 over to SAPdb, PostgresSQL, or db.
 
 -Original Message-
 From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 04, 2001 3:52 PM
 To: Orion-Interest
 Subject: Re: orion with mysql?
 
 
 Am using MySQL with Orion without it's own db-schema.  No 
 problems, yet.
 
 Be sure to get the MM.MySQL driver...
 -- 
 
 -Geoff Marshall, Director of Development
 
 ...
 t e r r a s c o p e  (415) 951-4944
 54 Mint Street, Suite 110 direct (415) 625-0349
 San Francisco, CA  94103 fax (415) 625-0306
 ...
 
  From: Peter Peltonen [EMAIL PROTECTED]
  Organization: Fivetec Solutions Oy
  Reply-To: Orion-Interest [EMAIL PROTECTED]
  Date: Wed, 04 Apr 2001 19:42:44 +0300
  To: Orion-Interest [EMAIL PROTECTED]
  Subject: orion with mysql?
  
  
  Is it possible to use MySQL with Orion? Does it need a 
 db-schema of it's
 own?
  
  We tried to use PostgreSQL but JBuilder4 didn't cope with 
 it very well
  (JBuilder isn't able to show Postgre's tables). We also 
 tried Hypersonic,
 but
  it seems that when both Orion and JBuilder communicate with 
 the db the db
 gets
  confused. At least the changes we make in JBuilder don't 
 get updated.
  
  Any ideas about a good open-source db that would work with 
 both Orion and
  JBuilder would be appreciated!
  
  Regards,
  Peter
  
  
 
 
 

RE: orion with mysql?

[Aaron Tavistock]

Actually MySQL does support transactions.  You just need to use a database
file format that supports transactions (e.g. Berkeley DB, et al).  The
mm.mysql driver also supports transactions, and its easy to setup to work
with transactions.  The real problem is that the driver doesn't handle
transactions the way the specification wants them to.


-Original Message-
From: Kiss Tibor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:31 AM
To: Orion-Interest
Subject: RE: orion with mysql?


The cause for that could be that MySQL does not support transactions...

 -Original Message-
 From: Aaron Tavistock [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, April 05, 2001 3:28 AM
 To: Orion-Interest
 Subject: RE: orion with mysql?
 
 
 You only need a schema if you intend to do CMP EJBs.  If 
 you're not using
 EJB at all then theres no reason you couldn't use MySQL.
 
 But, while its not to hard to make a schema that complies with MySQL
 somewhere in between MySQL and the mm.mysql driver the EJB transaction
 support falls apart.  My inclination is that its the mm.mysql 
 driver itself,
 and the real problem is just that transaction support is not 
 implimented in
 a way that complies with the EJB spec (e.g. javax.transaction 
 doesn't occur
 anywhere in the source).
 
 So, while you can use MySQL with Orion you can't do EJB 
 unless you switch
 over to SAPdb, PostgresSQL, or db.
 
 -Original Message-
 From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 04, 2001 3:52 PM
 To: Orion-Interest
 Subject: Re: orion with mysql?
 
 
 Am using MySQL with Orion without it's own db-schema.  No 
 problems, yet.
 
 Be sure to get the MM.MySQL driver...
 -- 
 
 -Geoff Marshall, Director of Development
 
 ...
 t e r r a s c o p e  (415) 951-4944
 54 Mint Street, Suite 110 direct (415) 625-0349
 San Francisco, CA  94103 fax (415) 625-0306
 ...
 
  From: Peter Peltonen [EMAIL PROTECTED]
  Organization: Fivetec Solutions Oy
  Reply-To: Orion-Interest [EMAIL PROTECTED]
  Date: Wed, 04 Apr 2001 19:42:44 +0300
  To: Orion-Interest [EMAIL PROTECTED]
  Subject: orion with mysql?
  
  
  Is it possible to use MySQL with Orion? Does it need a 
 db-schema of it's
 own?
  
  We tried to use PostgreSQL but JBuilder4 didn't cope with 
 it very well
  (JBuilder isn't able to show Postgre's tables). We also 
 tried Hypersonic,
 but
  it seems that when both Orion and JBuilder communicate with 
 the db the db
 gets
  confused. At least the changes we make in JBuilder don't 
 get updated.
  
  Any ideas about a good open-source db that would work with 
 both Orion and
  JBuilder would be appreciated!
  
  Regards,
  Peter
  
  
 
 
 

Re: orion with mysql?

[Rian Schmidt]

Sounds like you need to turn off exclusive-write-access in orion-ejb-jar.xml
while you're putzing with the database outside of the application.  We're
running with SQL Server 7 (*gasp*) and Orion will try to "fix" any manual
changes we make to the database through the admin console.  Otherwise, we
have to shutdown Orion, make the changes, and restart.

The performance hit is huge, so you wouldn't want to leave it turned off,
but Orion will basically go talk to the database at every accessor to make
sure that it's got the latest data and not assume that Orion knows best.

Rian

- Original Message -
From: Armin Michel [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Sent: Thursday, April 05, 2001 12:25 AM
Subject: Re: orion with mysql?


  [...] We also tried Hypersonic,
  but it seems that when both Orion and JBuilder communicate with the db
the
  db gets confused. At least the changes we make in JBuilder don't get
  updated.

 That's propably because Orion caches data of the DB. If you stop Orion,
then
 update the DB and then restart Orion, you shouldn't perceive any update
 problems.

 Greetings

 Armin

Re: orion with mysql?

[peter kua]

assuming you are setting up mysql version 3.23.33 in a linux box. need to
download both mysql and the berkeley engine.can be found in www.mysql.com
---
first time installing mysql. log in as root

assume mysql install dir = /mysql and berkeley install dir = /db-3.2.9a
cd /mysql
./configure --with-berkeley-db=/db-3.2.9a (to enable transaction tables.
3.2.9a is the patch version for mysql 3.23.xx versions)

this will then start the server for the first time. must set pwd for root
bin/mysqladmin -u root password 'xx'

after that you'll have to option to create transactional tables which can be
used with EJBs



- Original Message -
From: "Kemp Randy-W18971" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Thursday, April 05, 2001 9:09 PM
Subject: RE: orion with mysql?


 I believe the latest release of Mysql supports transactions, but I am not
sure the binaries are set with the Berkeley transaction engine.  You may
have to compile both, and this is a question for Mysql.

 -Original Message-
 From: Kiss Tibor [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, April 05, 2001 3:31 AM
 To: Orion-Interest
 Subject: RE: orion with mysql?


 The cause for that could be that MySQL does not support transactions...

  -Original Message-
  From: Aaron Tavistock [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, April 05, 2001 3:28 AM
  To: Orion-Interest
  Subject: RE: orion with mysql?
 
 
  You only need a schema if you intend to do CMP EJBs.  If
  you're not using
  EJB at all then theres no reason you couldn't use MySQL.
 
  But, while its not to hard to make a schema that complies with MySQL
  somewhere in between MySQL and the mm.mysql driver the EJB transaction
  support falls apart.  My inclination is that its the mm.mysql
  driver itself,
  and the real problem is just that transaction support is not
  implimented in
  a way that complies with the EJB spec (e.g. javax.transaction
  doesn't occur
  anywhere in the source).
 
  So, while you can use MySQL with Orion you can't do EJB
  unless you switch
  over to SAPdb, PostgresSQL, or db.
 
  -Original Message-
  From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, April 04, 2001 3:52 PM
  To: Orion-Interest
  Subject: Re: orion with mysql?
 
 
  Am using MySQL with Orion without it's own db-schema.  No
  problems, yet.
 
  Be sure to get the MM.MySQL driver...
  --
 
  -Geoff Marshall, Director of Development
 
  ...
  t e r r a s c o p e  (415) 951-4944
  54 Mint Street, Suite 110 direct (415) 625-0349
  San Francisco, CA  94103 fax (415) 625-0306
  ...
 
   From: Peter Peltonen [EMAIL PROTECTED]
   Organization: Fivetec Solutions Oy
   Reply-To: Orion-Interest [EMAIL PROTECTED]
   Date: Wed, 04 Apr 2001 19:42:44 +0300
   To: Orion-Interest [EMAIL PROTECTED]
   Subject: orion with mysql?
  
  
   Is it possible to use MySQL with Orion? Does it need a
  db-schema of it's
  own?
  
   We tried to use PostgreSQL but JBuilder4 didn't cope with
  it very well
   (JBuilder isn't able to show Postgre's tables). We also
  tried Hypersonic,
  but
   it seems that when both Orion and JBuilder communicate with
  the db the db
  gets
   confused. At least the changes we make in JBuilder don't
  get updated.
  
   Any ideas about a good open-source db that would work with
  both Orion and
   JBuilder would be appreciated!
  
   Regards,
   Peter
  
  
 
 
 

orion with mysql?

[Peter Peltonen]

Is it possible to use MySQL with Orion? Does it need a db-schema of it's own? 

We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
(JBuilder isn't able to show Postgre's tables). We also tried Hypersonic, but
it seems that when both Orion and JBuilder communicate with the db the db gets
confused. At least the changes we make in JBuilder don't get updated.

Any ideas about a good open-source db that would work with both Orion and
JBuilder would be appreciated!

Regards,
Peter

Re: orion with mysql?

[Ray Harrison]

Try SapDB (www.sapdb.org)as one of your evaluations. I don't use JBuilder, but other 
tools I have
used have been able to see SapDB tables no problem. Although it doesn't really make 
sense that
JBuilder can't see PostgreSQL tables using the jdbc driver. 



--- Peter Peltonen [EMAIL PROTECTED] wrote:
 
 Is it possible to use MySQL with Orion? Does it need a db-schema of it's own? 
 
 We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
 (JBuilder isn't able to show Postgre's tables). We also tried Hypersonic, but
 it seems that when both Orion and JBuilder communicate with the db the db gets
 confused. At least the changes we make in JBuilder don't get updated.
 
 Any ideas about a good open-source db that would work with both Orion and
 JBuilder would be appreciated!
 
 Regards,
 Peter
 


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text

Re: orion with mysql?

[Geoff Marshall]

Am using MySQL with Orion without it's own db-schema.  No problems, yet.

Be sure to get the MM.MySQL driver...
-- 

-Geoff Marshall, Director of Development

...
t e r r a s c o p e  (415) 951-4944
54 Mint Street, Suite 110 direct (415) 625-0349
San Francisco, CA  94103 fax (415) 625-0306
...

 From: Peter Peltonen [EMAIL PROTECTED]
 Organization: Fivetec Solutions Oy
 Reply-To: Orion-Interest [EMAIL PROTECTED]
 Date: Wed, 04 Apr 2001 19:42:44 +0300
 To: Orion-Interest [EMAIL PROTECTED]
 Subject: orion with mysql?
 
 
 Is it possible to use MySQL with Orion? Does it need a db-schema of it's own?
 
 We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
 (JBuilder isn't able to show Postgre's tables). We also tried Hypersonic, but
 it seems that when both Orion and JBuilder communicate with the db the db gets
 confused. At least the changes we make in JBuilder don't get updated.
 
 Any ideas about a good open-source db that would work with both Orion and
 JBuilder would be appreciated!
 
 Regards,
 Peter
 
 

RE: orion with mysql?

[Fernando De Leon]

I am also using Orion with mySql without the Schema no problems here :D
jsut have the jar driver in the lib directory

-Original Message-
From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 8:52 AM
To: Orion-Interest
Subject: Re: orion with mysql?


Am using MySQL with Orion without it's own db-schema.  No problems, yet.

Be sure to get the MM.MySQL driver...
-- 

-Geoff Marshall, Director of Development

...
t e r r a s c o p e  (415) 951-4944
54 Mint Street, Suite 110 direct (415) 625-0349
San Francisco, CA  94103 fax (415) 625-0306
...

 From: Peter Peltonen [EMAIL PROTECTED]
 Organization: Fivetec Solutions Oy
 Reply-To: Orion-Interest [EMAIL PROTECTED]
 Date: Wed, 04 Apr 2001 19:42:44 +0300
 To: Orion-Interest [EMAIL PROTECTED]
 Subject: orion with mysql?
 
 
 Is it possible to use MySQL with Orion? Does it need a db-schema of
it's own?
 
 We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
 (JBuilder isn't able to show Postgre's tables). We also tried
Hypersonic, but
 it seems that when both Orion and JBuilder communicate with the db the
db gets
 confused. At least the changes we make in JBuilder don't get updated.
 
 Any ideas about a good open-source db that would work with both Orion
and
 JBuilder would be appreciated!
 
 Regards,
 Peter
 
 


The contents of this email are confidential. If you are not the intended
recipient, you must not disclose, copy or use the contents in any way. 
If you have received this email in error, please delete it and notify us
immediately by return email. It is the recipient's responsibility to
screen this message and any attachments for computer viruses. 
Any views expressed in this email are not to be taken as the views of 
the company or any related business entity unless expressly stated to 
the contrary. 

RE: orion with mysql?

[Aaron Tavistock]

You only need a schema if you intend to do CMP EJBs.  If you're not using
EJB at all then theres no reason you couldn't use MySQL.

But, while its not to hard to make a schema that complies with MySQL
somewhere in between MySQL and the mm.mysql driver the EJB transaction
support falls apart.  My inclination is that its the mm.mysql driver itself,
and the real problem is just that transaction support is not implimented in
a way that complies with the EJB spec (e.g. javax.transaction doesn't occur
anywhere in the source).

So, while you can use MySQL with Orion you can't do EJB unless you switch
over to SAPdb, PostgresSQL, or db.

-Original Message-
From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 3:52 PM
To: Orion-Interest
Subject: Re: orion with mysql?


Am using MySQL with Orion without it's own db-schema.  No problems, yet.

Be sure to get the MM.MySQL driver...
-- 

-Geoff Marshall, Director of Development

...
t e r r a s c o p e  (415) 951-4944
54 Mint Street, Suite 110 direct (415) 625-0349
San Francisco, CA  94103 fax (415) 625-0306
...

 From: Peter Peltonen [EMAIL PROTECTED]
 Organization: Fivetec Solutions Oy
 Reply-To: Orion-Interest [EMAIL PROTECTED]
 Date: Wed, 04 Apr 2001 19:42:44 +0300
 To: Orion-Interest [EMAIL PROTECTED]
 Subject: orion with mysql?
 
 
 Is it possible to use MySQL with Orion? Does it need a db-schema of it's
own?
 
 We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
 (JBuilder isn't able to show Postgre's tables). We also tried Hypersonic,
but
 it seems that when both Orion and JBuilder communicate with the db the db
gets
 confused. At least the changes we make in JBuilder don't get updated.
 
 Any ideas about a good open-source db that would work with both Orion and
 JBuilder would be appreciated!
 
 Regards,
 Peter
 
 

Orion and mysql: turning autocommit off?

[Henrik Røn (LMD)]

Hi all

In the archive there are several mails describing problems with autocommit when using 
MySQL (3.23.32) and the org.gjt.mm.mysql.Driver (2.0.4)

The Cabin example from Monson-Haefel's book, which uses CMP, fails as autocommit is 
not turned off:

[snip from application.log]
19-03-01 15:56 Error in bean Cabin
java.sql.SQLException: Can't call commit when autocommit=true
at org.gjt.mm.mysql.Connection.commit(Connection.java:520)
at com.evermind.sql.an.commit(JAX)
at com.evermind.sql.aj.commit(JAX)
at com.evermind.server.ejb.DataSourceConnection.commit(JAX)
at CabinHome_EntityHomeWrapper2.create(CabinHome_EntityHomeWrapper2.java:429)
at java.lang.reflect.Method.invoke(Native Method)
at com.evermind.server.rmi.bd.run(JAX)
at com.evermind.server.rmi.bb.hy(JAX)
at com.evermind.server.rmi.bb.run(JAX)
at com.evermind.util.f.run(JAX)
[end snip]

I've tried to use the property:

jdbc.nontx.autocommit=false 

in the orion.properties file, but this does not turn off autocommit. I've also tried 
turning autocommit off in the MySQL DB (SET AUTOCOMMIT=0) itself, but with no effect.

Has any one found out how to turn off autocommit?

Regards
Henrik

-Original Message-
From: Tim Endres [mailto:[EMAIL PROTECTED]]
Sent: 30. januar 2001 22:16
To: Orion-Interest
Subject: Re: orion and mysql?


  I found it very easy...I use:
 http://mmmysql.sourceforge.net/ - jdbc driver
 http://javaexchange.com/ - connection pooling
 
 One variable i had was w/javaexchange's DBBroker, set AutoReconnect=true...
 
 so far so good...been using awhile

Which mysql are you using? Not all versions support transactions.
tim.

RE: Orion and mysql: turning autocommit off?

[Aaron Tavistock]

I have been playing with Orion at home using mySql and have found the same
problem, and I looked into it a bunch.

While mySql has support for transactions, its still a little immature.
Typically the DBD or Gemini libraries need to be obtained and for mySql to
compile against so that the tables can be managed with AUTOCOMMIT off.  But
this is more of an inconvenience than a real showstopper.

But more importantly the JDBC driver itself seems to not quite be ready for
handling CMP transactions.  For example, the class
org.gjt.mm.mysql.MysqlDataSource works if you instantiate it and set the
properties yourself but it doesn't follow the spec so theres no way for
Orion to properly configure it.  Even more important greping through the
source code for the driver reveals that there is nothing from
javax.transaction package anywhere which is required by the EJB 1.1 spec.

So the long and short of it is...  I've tried using mySql, it won't work
yet.  So far as both PostgresSQL and Oracle work very well as alternatives.

-Original Message-
From: Henrik Rn (LMD) [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 7:58 AM
To: Orion-Interest
Subject: Orion and mysql: turning autocommit off?


Hi all

In the archive there are several mails describing problems with autocommit
when using MySQL (3.23.32) and the org.gjt.mm.mysql.Driver (2.0.4)

The Cabin example from Monson-Haefel's book, which uses CMP, fails as
autocommit is not turned off:

[snip from application.log]
19-03-01 15:56 Error in bean Cabin
java.sql.SQLException: Can't call commit when autocommit=true
at org.gjt.mm.mysql.Connection.commit(Connection.java:520)
at com.evermind.sql.an.commit(JAX)
at com.evermind.sql.aj.commit(JAX)
at com.evermind.server.ejb.DataSourceConnection.commit(JAX)
at
CabinHome_EntityHomeWrapper2.create(CabinHome_EntityHomeWrapper2.java:429)
at java.lang.reflect.Method.invoke(Native Method)
at com.evermind.server.rmi.bd.run(JAX)
at com.evermind.server.rmi.bb.hy(JAX)
at com.evermind.server.rmi.bb.run(JAX)
at com.evermind.util.f.run(JAX)
[end snip]

I've tried to use the property:

jdbc.nontx.autocommit=false 

in the orion.properties file, but this does not turn off autocommit. I've
also tried turning autocommit off in the MySQL DB (SET AUTOCOMMIT=0) itself,
but with no effect.

Has any one found out how to turn off autocommit?

Regards
Henrik

-Original Message-
From: Tim Endres [mailto:[EMAIL PROTECTED]]
Sent: 30. januar 2001 22:16
To: Orion-Interest
Subject: Re: orion and mysql?


  I found it very easy...I use:
 http://mmmysql.sourceforge.net/ - jdbc driver
 http://javaexchange.com/ - connection pooling
 
 One variable i had was w/javaexchange's DBBroker, set
AutoReconnect=true...
 
 so far so good...been using awhile

Which mysql are you using? Not all versions support transactions.
tim.

RE: NOVICE Question about orion and mysql

[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

[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.comSubject: 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
 
 
 
 
 
 

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

Re: NOVICE Question about orion and mysql

[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

[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.comSubject: 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

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

NOVICE Question about orion and mysql

[Andres Garcia Hourcade]

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: orion and mysql?

[Marc Linke]

Hi,

well, i'm more in need of some kind of step-by-step
info as i'm new to java, j2ee and orion.
So far i couldnt even setup orion to run plain
servlets with mm.mysql as orion seems to ignore my
classpath setting (or even i guess so).

thanks

- Original Message -
From: "David Morton" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 6:24 PM
Subject: Re: orion and mysql?


  I found it very easy...I use:
 http://mmmysql.sourceforge.net/ - jdbc driver
 http://javaexchange.com/ - connection pooling

 One variable i had was w/javaexchange's DBBroker, set
AutoReconnect=true...

 so far so good...been using awhile

 David


 At 05:20 PM 1/30/01 +0100, you wrote:
 Hi,
 
 is there any simple how-to for setting up mysql with
 orion available? Or can someone explain me how to do it?
 
 thanks

RE: orion and mysql?

[Stanislav Maximov]

If somebody using Interbase successfully, please send your database schema
and data-sources.xml part to this list. TIA

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Randahl
 Fink Isaksen
 Sent: Wednesday, January 31, 2001 10:05 AM
 To: Orion-Interest
 Subject: RE: orion and mysql?


 Well then, is there a simple how-to for setting up Interbase with Orion? -
 Have you got a database schema which works?


 R.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Arno Grbac
 Sent: 30. januar 2001 19:08
 To: Orion-Interest
 Subject: RE: orion and mysql?


 This doesn't answer your question, but take a serious look at InterBase 6
 (IT IS FREE AND OPEN SOURCE!!!).
 mySQL doesn't have a good locking mechanism yet, ..as well as some missing
 data types (last time I checked).
 Good luck,
 -arno


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke
 Sent: Tuesday, January 30, 2001 11:21 AM
 To: Orion-Interest
 Subject: orion and mysql?


 Hi,

 is there any simple how-to for setting up mysql with
 orion available? Or can someone explain me how to do it?

 thanks

Re: orion and mysql?

[Dan Winfield]

Really you should check out the J2EE specification at java.sun.com and in
also grab some further info on JSP and servlets while you are there.

Orion is suprisingly compatible with the J2EE spec. For example you should
be using WAR deployment of your servlets then you will be able to use the
standard classpath detailed in the Java Servlet specification.

dan
- Original Message -
From: "Marc Linke" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Wednesday, January 31, 2001 10:06 AM
Subject: Re: orion and mysql?


 Hi,

 well, i'm more in need of some kind of step-by-step
 info as i'm new to java, j2ee and orion.
 So far i couldnt even setup orion to run plain
 servlets with mm.mysql as orion seems to ignore my
 classpath setting (or even i guess so).

 thanks

 - Original Message -
 From: "David Morton" [EMAIL PROTECTED]
 To: "Orion-Interest" [EMAIL PROTECTED]
 Sent: Tuesday, January 30, 2001 6:24 PM
 Subject: Re: orion and mysql?


   I found it very easy...I use:
  http://mmmysql.sourceforge.net/ - jdbc driver
  http://javaexchange.com/ - connection pooling
 
  One variable i had was w/javaexchange's DBBroker, set
 AutoReconnect=true...
 
  so far so good...been using awhile
 
  David
 
 
  At 05:20 PM 1/30/01 +0100, you wrote:
  Hi,
  
  is there any simple how-to for setting up mysql with
  orion available? Or can someone explain me how to do it?
  
  thanks

Re: orion and mysql?

[David Morton]

 I found it very easy...I use:
http://mmmysql.sourceforge.net/ - jdbc driver
http://javaexchange.com/ - connection pooling

One variable i had was w/javaexchange's DBBroker, set AutoReconnect=true...

so far so good...been using awhile

David


At 05:20 PM 1/30/01 +0100, you wrote:
Hi,

is there any simple how-to for setting up mysql with
orion available? Or can someone explain me how to do it?

thanks

RE: orion and mysql?

[Juan Lorandi (Chile)]

not to mention the total lack of transaction support which makes it
impossible to be used with CMP AFAIK

JP

-Original Message-
From: Arno Grbac [mailto:[EMAIL PROTECTED]]
Sent: Martes, 30 de Enero de 2001 15:08
To: Orion-Interest
Subject: RE: orion and mysql?


This doesn't answer your question, but take a serious look at InterBase 6
(IT IS FREE AND OPEN SOURCE!!!).
mySQL doesn't have a good locking mechanism yet, ..as well as some missing
data types (last time I checked).
Good luck,
-arno


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke
Sent: Tuesday, January 30, 2001 11:21 AM
To: Orion-Interest
Subject: orion and mysql?


Hi,

is there any simple how-to for setting up mysql with
orion available? Or can someone explain me how to do it?

thanks

Re: orion and mysql?

[Tim Endres]

  I found it very easy...I use:
 http://mmmysql.sourceforge.net/ - jdbc driver
 http://javaexchange.com/ - connection pooling
 
 One variable i had was w/javaexchange's DBBroker, set AutoReconnect=true...
 
 so far so good...been using awhile

Which mysql are you using? Not all versions support transactions.
tim.

Re: orion and mysql?

[David Morton]

 I just switched to latest and greatest of 3.23 tree from the 
greatest of the 3.22 tree...so far so goodeven updating the working 
server was easy.  It's fantastic for medium size web sitesI haven't 
played with the Berkeley DB transactions yet.
http://www.mysql.com/doc/B/D/BDB.html

here are some excerpts:

'Berkeley DB (http://www.sleepycat.com) has provided MySQL with a 
transaction-safe table handler. This will survive crashes and also provides 
COMMIT and ROLLBACK on transactions. In order to build MySQL Version 3.23.x 
(BDB support first appeared in Version 3.23.15) with support for BDB 
tables, you will need Berkeley DB Version 3.2.3h or newer which can be 
downloaded from http://www.mysql.com/downloads/mysql-3.23.html. This is a 
patched version of Berkeley DB that is only available from MySQL; the 
standard Berkeley DB will not yet work with MySQL'.

Source for DB stuff is at:
http://www.mysql.com/downloads/mysql-3.23.html
http://www.mysql.com/Downloads/db/db-3.2.3h.tar.gz

David


At 04:15 PM 1/30/01 -0500, you wrote:
   I found it very easy...I use:
  http://mmmysql.sourceforge.net/ - jdbc driver
  http://javaexchange.com/ - connection pooling
 
  One variable i had was w/javaexchange's DBBroker, set AutoReconnect=true...
 
  so far so good...been using awhile

Which mysql are you using? Not all versions support transactions.
tim.

RE: orion and mysql?

[Randahl Fink Isaksen]

Well then, is there a simple how-to for setting up Interbase with Orion? -
Have you got a database schema which works?


R.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Arno Grbac
Sent: 30. januar 2001 19:08
To: Orion-Interest
Subject: RE: orion and mysql?


This doesn't answer your question, but take a serious look at InterBase 6
(IT IS FREE AND OPEN SOURCE!!!).
mySQL doesn't have a good locking mechanism yet, ..as well as some missing
data types (last time I checked).
Good luck,
-arno


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke
Sent: Tuesday, January 30, 2001 11:21 AM
To: Orion-Interest
Subject: orion and mysql?


Hi,

is there any simple how-to for setting up mysql with
orion available? Or can someone explain me how to do it?

thanks

Re: Problems with MySQL and DataSourceUserManager

[Lars Hoss]

hi!

we have used postgresql for some projects and it worked.
the only drawback we had is the fact that the current
version does not handle large row data.
that means a the data length of a row cannot be longer
than 32k. if you need to store large objects you have to
put them onto the filesystem. this limitation is said to be removed
in the next version of postgresql.

yours,
lars

 Hi,
 If I use EJB, can I use postgresql?  I know that postgresql jdbc driver
 is still not jdbc2 complaint.


 Louis
 - Original Message -
 From: "Lars Hoss" [EMAIL PROTECTED]
 To: "Orion-Interest" [EMAIL PROTECTED]
 Sent: Wednesday, November 15, 2000 8:37 AM
 Subject: Re: Problems with MySQL and DataSourceUserManager

  hi!
 
  i had the same problem with the WebLogic Server.
  the problem is that MySQL does not support transactions
  as of version 2.22.x.
  there is beta quality transaction support in the
  current development branch (2.23.x) but
  i had very serious problems with the latest version (lost data).
  personally i advice you not to use mysql until
  it is ready for production use. i would have a look
  at the 7.1 version of postgresql which is currently
  available through cvs as far as i know.
 
  yours,
  lars
 
  Am Mittwoch 15 November 2000 12:22 schrieben Sie:
   Hi
  
   Is anyone using DataSourceUserManager with MySQL database?
   We have been using it with PostgreSQL without any problems,
   but when we switched to MySQL, DataSourceUserManager throws
   an exception
  
   DataSourceUserManager.getUser
  
   8.11.2000 14:29 ANALYYTIKKO-web: Error in UserManager
   java.lang.RuntimeException: SQLException: Can't call commit when
   autocommit=true
   at com.evermind.sql.DataSourceUserManager.getUser(JAX)
   at com.evermind.server.http.EvermindHttpServletRequest.yf(JAX)
   at com.evermind.server.http.HttpApplication.vk(JAX)
   at com.evermind.server.http.HttpApplication.uh(JAX)
   at com.evermind.server.http.ed.sp(JAX)
   at com.evermind.server.http.ed.so(JAX)
   at com.evermind.util.f.run(JAX)
  
  
   Is it possible to use MySQL with DataSourceUserManager since MySQL does

 not

   support transactions?
  
   Regards,
   Juha Lehtonen
   FA Solutions

Problems with MySQL and DataSourceUserManager

[Juha Lehtonen]

Hi

Is anyone using DataSourceUserManager with MySQL database?
We have been using it with PostgreSQL without any problems,
but when we switched to MySQL, DataSourceUserManager throws
an exception

DataSourceUserManager.getUser

8.11.2000 14:29 ANALYYTIKKO-web: Error in UserManager
java.lang.RuntimeException: SQLException: Can't call commit when
autocommit=true
at com.evermind.sql.DataSourceUserManager.getUser(JAX)
at com.evermind.server.http.EvermindHttpServletRequest.yf(JAX)
at com.evermind.server.http.HttpApplication.vk(JAX)
at com.evermind.server.http.HttpApplication.uh(JAX)
at com.evermind.server.http.ed.sp(JAX)
at com.evermind.server.http.ed.so(JAX)
at com.evermind.util.f.run(JAX)


Is it possible to use MySQL with DataSourceUserManager since MySQL does not
support transactions?

Regards,
Juha Lehtonen
FA Solutions

Re: Problems with MySQL and DataSourceUserManager

[Lars Hoss]

hi!

i had the same problem with the WebLogic Server.
the problem is that MySQL does not support transactions
as of version 2.22.x.
there is beta quality transaction support in the
current development branch (2.23.x) but
i had very serious problems with the latest version (lost data).
personally i advice you not to use mysql until
it is ready for production use. i would have a look
at the 7.1 version of postgresql which is currently
available through cvs as far as i know.

yours,
lars

Am Mittwoch 15 November 2000 12:22 schrieben Sie:
 Hi

 Is anyone using DataSourceUserManager with MySQL database?
 We have been using it with PostgreSQL without any problems,
 but when we switched to MySQL, DataSourceUserManager throws
 an exception

 DataSourceUserManager.getUser

 8.11.2000 14:29 ANALYYTIKKO-web: Error in UserManager
 java.lang.RuntimeException: SQLException: Can't call commit when
 autocommit=true
   at com.evermind.sql.DataSourceUserManager.getUser(JAX)
   at com.evermind.server.http.EvermindHttpServletRequest.yf(JAX)
   at com.evermind.server.http.HttpApplication.vk(JAX)
   at com.evermind.server.http.HttpApplication.uh(JAX)
   at com.evermind.server.http.ed.sp(JAX)
   at com.evermind.server.http.ed.so(JAX)
   at com.evermind.util.f.run(JAX)


 Is it possible to use MySQL with DataSourceUserManager since MySQL does not
 support transactions?

 Regards,
 Juha Lehtonen
 FA Solutions

Re: Problems with MySQL and DataSourceUserManager

[Louis]

Hi,
If I use EJB, can I use postgresql?  I know that postgresql jdbc driver
is still not jdbc2 complaint.


Louis
- Original Message -
From: "Lars Hoss" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Wednesday, November 15, 2000 8:37 AM
Subject: Re: Problems with MySQL and DataSourceUserManager


 hi!

 i had the same problem with the WebLogic Server.
 the problem is that MySQL does not support transactions
 as of version 2.22.x.
 there is beta quality transaction support in the
 current development branch (2.23.x) but
 i had very serious problems with the latest version (lost data).
 personally i advice you not to use mysql until
 it is ready for production use. i would have a look
 at the 7.1 version of postgresql which is currently
 available through cvs as far as i know.

 yours,
 lars

 Am Mittwoch 15 November 2000 12:22 schrieben Sie:
  Hi
 
  Is anyone using DataSourceUserManager with MySQL database?
  We have been using it with PostgreSQL without any problems,
  but when we switched to MySQL, DataSourceUserManager throws
  an exception
 
  DataSourceUserManager.getUser
 
  8.11.2000 14:29 ANALYYTIKKO-web: Error in UserManager
  java.lang.RuntimeException: SQLException: Can't call commit when
  autocommit=true
  at com.evermind.sql.DataSourceUserManager.getUser(JAX)
  at com.evermind.server.http.EvermindHttpServletRequest.yf(JAX)
  at com.evermind.server.http.HttpApplication.vk(JAX)
  at com.evermind.server.http.HttpApplication.uh(JAX)
  at com.evermind.server.http.ed.sp(JAX)
  at com.evermind.server.http.ed.so(JAX)
  at com.evermind.util.f.run(JAX)
 
 
  Is it possible to use MySQL with DataSourceUserManager since MySQL does
not
  support transactions?
 
  Regards,
  Juha Lehtonen
  FA Solutions

Re: CMP Bean in mysql

[Dave Ford]

I had the same problem. I could not resolve it. I ended up switching to a
new database. I'd love to here if you were able to get it to work.


Dave Ford
Smart Soft - The Java Training Company
http://www.SmartSoftTraining.com

MYSQL, Orion, EJB and transactions ??

[Laufer, Michael]

Title: MYSQL, Orion, EJB and transactions ??





Hi there,


I know that the question has been discussed here before, but I'm still a little confused about using
MYSQL together with Orion.
I've just downloaded mysql (version 3.23.22 beta) and the manual announces that mysql is now supporting transactions.
If I understood it correctly, that would mean, that it should be possible to use mysql with entity beans. Am I right ??
What's confusing to me is the fact, that I only find news in mailing-list, that mysql is not supporting transactions.


So I don't really now, if I can use mysql for entity beans.
If not, which database would you suggest ??
It should work on NT and not be the most expensive one as I use it 'only' for writing my Master's Thesis.


Thanks in advance,


Michel 

Re: MYSQL, Orion, EJB and transactions ??

[Jonas Larsson]

Title: MYSQL, Orion, EJB and transactions ??



You could always use Interbase which now is 
opensource..
http://www.interbase.com

  - Original Message - 
  From: 
  Laufer, Michael 
  To: Orion-Interest 
  Sent: Friday, October 27, 2000 10:41 
  AM
  Subject: MYSQL, Orion, EJB and 
  transactions ??
  
  Hi there, 
  I know that the question has been discussed here 
  before, but I'm still a little confused about using MYSQL together with Orion. I've just downloaded mysql (version 3.23.22 beta) and the manual 
  announces that mysql is now supporting transactions. If I understood it correctly, that would mean, that it 
  should be possible to use mysql with entity beans. Am I right ?? 
  What's confusing to me is the fact, that I only 
  find news in mailing-list, that mysql is not supporting transactions. 
  
  So I don't really now, if I can use mysql for 
  entity beans. If not, which database would 
  you suggest ?? It should work on NT and not 
  be the most expensive one as I use it 'only' for writing my Master's 
  Thesis. 
  Thanks in advance, 
  Michel 

SV: MYSQL, Orion, EJB and transactions ??

[Klaus . Myrseth]

Title: MYSQL, Orion, EJB and transactions ??



You 
can use the database that comes with Orion Hypersonic SQL. Its a java database 
and works great for things like that. If you want to use an object database 
download forte 2 internat edition (beta), it has the Pointbase database 
enclosed, that one should allso work.

Have 
fun, and good luck :)

Klaus

  -Opprinnelig melding-Fra: Laufer, Michael 
  [mailto:[EMAIL PROTECTED]]Sendt: 27. oktober 2000 
  10:41Til: Orion-InterestEmne: MYSQL, Orion, EJB and 
  transactions ??
  Hi there, 
  I know that the question has been discussed here 
  before, but I'm still a little confused about using MYSQL together with Orion. I've just downloaded mysql (version 3.23.22 beta) and the manual 
  announces that mysql is now supporting transactions. If I understood it correctly, that would mean, that it 
  should be possible to use mysql with entity beans. Am I right ?? 
  What's confusing to me is the fact, that I only 
  find news in mailing-list, that mysql is not supporting transactions. 
  
  So I don't really now, if I can use mysql for 
  entity beans. If not, which database would 
  you suggest ?? It should work on NT and not 
  be the most expensive one as I use it 'only' for writing my Master's 
  Thesis. 
  Thanks in advance, 
  Michel 

Re: MYSQL, Orion, EJB and transactions ??

[Sven van 't Veer]

 "Laufer, Michael" wrote:
 
 Hi there,
 If I understood it correctly, that would mean, that it should be
 possible to use mysql with entity beans. Am I right ??
 What's confusing to me is the fact, that I only find news in
 mailing-list, that mysql is not supporting transactions.
Havent been with mysql for a while, but AFIK, transactions are supported
in version 3.23.27.
 
 So I don't really now, if I can use mysql for entity beans.
You can use mysql for Entity Beans without any problems. You should be
aware however that there will be no trnasactions if the DB does not
support them.

 If not, which database would you suggest ??
 It should work on NT and not be the most expensive one as I use it
 'only' for writing my Master's Thesis.
Unfortunately, you work on NT. Various free databases can be found for
Linux, even sybase has a free version of it's ASE database. However
since you're using Orion take a look at Cloudscape. It runs in process.

sven

-- 
==
Sven E. van 't Veer  
http://www.cachoeiro.net
Java Developer  [EMAIL PROTECTED]
==

RE: MYSQL, Orion, EJB and transactions ??

[Russ White]

Title: MYSQL, Orion, EJB and transactions ??



I 
would use the Hypersonic db that ships with Orion as you have to do nothing to 
set it up, and it works great.
Don't 
bother with MySQL.

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Laufer, 
  MichaelSent: Friday, October 27, 2000 4:41 AMTo: 
  Orion-InterestSubject: MYSQL, Orion, EJB and transactions 
  ??
  Hi there, 
  I know that the question has been discussed here 
  before, but I'm still a little confused about using MYSQL together with Orion. I've just downloaded mysql (version 3.23.22 beta) and the manual 
  announces that mysql is now supporting transactions. If I understood it correctly, that would mean, that it 
  should be possible to use mysql with entity beans. Am I right ?? 
  What's confusing to me is the fact, that I only 
  find news in mailing-list, that mysql is not supporting transactions. 
  
  So I don't really now, if I can use mysql for 
  entity beans. If not, which database would 
  you suggest ?? It should work on NT and not 
  be the most expensive one as I use it 'only' for writing my Master's 
  Thesis. 
  Thanks in advance, 
  Michel 

Problem deploying EJBs using a MySQL data-source

[Nils Frohberg]

Hi,

up to now i always connected to the Hypersonic database. Since i have a mysql database 
running on another box, i tried to connect to it, using Shailesh Joshi's 
data-sources.xml and database-schemas/mysql.xml (cf. msg# 05137 Re: Orion and MySQL).

This is the errormessage i get when orion tries to deploy my EJBs:
Auto-deploying myEJB.jar (No previous deployment found)... Error compiling 
file:/home/wuzzah/myEJB/myEJB.jar: Error finding a suitable DataSource: 
jdbc/DefaultCoreDS did not contain a cmt-dataSource/ejb-datasource

My data-source:
data-source
name="MySQL"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:mysql://hostname/myEJBdatabase"
connection-driver="org.gjt.mm.mysql.Driver"
username="user"
password="passwd"
inactivity-timeout="30"
schema="database-schemas/mysql.xml"
/

My database-schema:
?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


any hints?
thanks,
--nils


-- 
**
* Your mouse has moved. Windows must be restarted for the change to take effect. *
**
*  Nils Frohberg *
*http://www.tako.de/ *
**

Re: Problem deploying EJBs using a MySQL data-source

[Robert Krueger]

the error message is quite explicit. what kind of datasource does 
'jdbc/DefaultCoreDS' point to? is that the location you specified in 
orion-ejb-jar.xml for your entity beans? if so, did you map it to 
"jdbc/DefaultEJBDS"? I don't see it in your datasource declaration.

robert

At 17:13 14.10.00 , you wrote:
Hi,

up to now i always connected to the Hypersonic database. Since i have a 
mysql database running on another box, i tried to connect to it, using 
Shailesh Joshi's data-sources.xml and database-schemas/mysql.xml (cf. msg# 
05137 Re: Orion and MySQL).

This is the errormessage i get when orion tries to deploy my EJBs:
Auto-deploying myEJB.jar (No previous deployment found)... Error compiling 
file:/home/wuzzah/myEJB/myEJB.jar: Error finding a suitable DataSource: 
jdbc/DefaultCoreDS did not contain a cmt-dataSource/ejb-datasource

My data-source:
 data-source
 name="MySQL"
 class="com.evermind.sql.ConnectionDataSource"
 location="jdbc/DefaultDS"
 pooled-location="jdbc/DefaultPooledDS"
 xa-location="jdbc/xa/DefaultXADS"
 ejb-location="jdbc/DefaultEJBDS"
 url="jdbc:mysql://hostname/myEJBdatabase"
 connection-driver="org.gjt.mm.mysql.Driver"
 username="user"
 password="passwd"
 inactivity-timeout="30"
 schema="database-schemas/mysql.xml"
 /

My database-schema:
?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


any hints?
thanks,
--nils


--
*** 
***
* Your mouse has moved. Windows must be restarted for the change to take 
effect. *
*-- 
--*
*  Nils 
Frohberg *
* 
http://www.tako.de/ *
*** 
***

(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de

Re: Orion and MySQL

[Shailesh Joshi]

Title: Orion and MySQL



Hi Dube , Craig .

I have deployedan entity 
bean[CMP] inthe MySQL  database.

I am 
specifyingdatabase-schemas\mysql.xml  modifications in 
data-sources.xml as it is.

1]database-schemas\mysql.xml 

?xml version="1.0"?!DOCTYPE 
database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd"!-- 
Author : Shailesh Joshi --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



2]Part added to 
data-sources.xml

data-source  name="MySQL" 
 class="com.evermind.sql.ConnectionDataSource" 
 location="jdbc/DefaultDS"  
pooled-location="jdbc/DefaultPooledDS"  
xa-location="jdbc/xa/DefaultXADS"  
ejb-location="jdbc/DefaultEJBDS"  
url="jdbc:mysql://IPAddress/Test" 
[Test is my database]  
connection-driver="org.gjt.mm.mysql.Driver"  
username="x"  password="x"  
inactivity-timeout="30"  
schema="database-schemas/mysql.xml"  / 

 

 
Shailesh Joshi
 
 
Java Programmer
 
 
Versaware(India) Ltd.

  - Original Message - 
  From: 
  Dube, Craig 
  
  To: Orion-Interest 
  Sent: Tuesday, October 10, 2000 1:24 
  AM
  Subject: Orion and MySQL
  
  I am trying to set up orion to use MySQL instead of 
  HypersonicSQL. I'm looking for some advice on how to properly setup 
  Orion to use the MySQL database that I have installed.
  So far I have used the MySQL admin tool to creat a database 
  called oriondb. I have also edited the "data-sources.xml" and added a 
  "mysql.xml" file under the database-schemas directory. Here is a piece 
  of the "data-sources.xml" file and a piece of the "mysql.xml":
  data-sources.xml   data-source 
   
  class="com.evermind.sql.DriverManagerDataSource"  name="MySQL"  location="jdbc/DefaultCoreDS"  xa-location="jdbc/xa/DefaultXADS"  ejb-location="jdbc/DefaultDS"  pooled-location="jdbc/DefaultPooledDS" 
   
  connection-driver="org.gjt.mm.mysql.Driver"  username="root"  password="root"  
  url="jdbc:mysql://localhost/mysql/data/oriondb"  inactivity-timeout="30"  schema="database-schemas/mysql.xml"  / 
  mysql.xml -  database-schema name="MySQL" not-null="not null" null="" 
  primary-key="primary key"  
  type-mapping type="java.lang.String" name="char (255)" / 
   type-mapping type="int" name="int" 
  /  type-mapping type="long" 
  name="int" /  type-mapping 
  type="float" name="float" /  
  type-mapping type="double" name="double" /  type-mapping type="byte" name="smallint" 
  /  type-mapping type="char" 
  name="char" /  type-mapping 
  type="short" name="short" /  
  type-mapping type="java.util.Date" name="timestamp" / 
disallowed-field name="password" / 
   disallowed-field name="username" 
  /  disallowed-field 
  name="date" /  
  disallowed-field name="order" /  
  /database-schema 
  I was very unsure as to what I should use for the "location" 
  tags in the data-sources file. Also, with the "mysql.xml" file, I copied 
  the Hypersonic schema file and removed the boolean type-mapping (I thought 
  this might be my problem).
  The error I get when I deply states "SQL error: Communication 
  link failure: Bad handshake". If anyone has successfully deployed MySQL 
  with Orion, I would be very much interested in the contents of their xml 
  files.
  - CJD 

Orion and MySQL

[Dube, Craig]

Title: Orion and MySQL






I am trying to set up orion to use MySQL instead of HypersonicSQL. I'm looking for some advice on how to properly setup Orion to use the MySQL database that I have installed.

So far I have used the MySQL admin tool to creat a database called oriondb. I have also edited the data-sources.xml and added a mysql.xml file under the database-schemas directory. Here is a piece of the data-sources.xml file and a piece of the mysql.xml:

data-sources.xml

 data-source
 class=com.evermind.sql.DriverManagerDataSource
 name=MySQL
 location=jdbc/DefaultCoreDS
 xa-location=jdbc/xa/DefaultXADS
 ejb-location=jdbc/DefaultDS
 pooled-location=jdbc/DefaultPooledDS
 connection-driver=org.gjt.mm.mysql.Driver
 username=root
 password=root
 url=jdbc:mysql://localhost/mysql/data/oriondb
 inactivity-timeout=30
 schema=database-schemas/mysql.xml
 /



mysql.xml
-
 database-schema name=MySQL not-null=not null null= primary-key=primary key
 type-mapping type=java.lang.String name=char (255) /
 type-mapping type=int name=int /
 type-mapping type=long name=int /
 type-mapping type=float name=float /
 type-mapping type=double name=double /
 type-mapping type=byte name=smallint /
 type-mapping type=char name=char /
 type-mapping type=short name=short /
 type-mapping type=java.util.Date name=timestamp /
 
 disallowed-field name=password /
 disallowed-field name=username /
 disallowed-field name=date /
 disallowed-field name=order /
 /database-schema



I was very unsure as to what I should use for the location tags in the data-sources file. Also, with the mysql.xml file, I copied the Hypersonic schema file and removed the boolean type-mapping (I thought this might be my problem).

The error I get when I deply states SQL error: Communication link failure: Bad handshake. If anyone has successfully deployed MySQL with Orion, I would be very much interested in the contents of their xml files.

- CJD

MySQL Identity Columns

[Holmes, George (TWIi London)]

Hi,

Does anyone have any code fragments for retrieving a MySQL identity value
using getLastInsertID() [ org.gjt.mm.mysql drivers ] under Orion?  The
documentation says that you have to cast the bespoke
statement/preparedstatement to a java.sql statement/preparedstatement?
Every time I get a ClassCastException?

Any help would be greatly appreciated.

Thanks

George

GEORGE HOLMES

TWI Interactive
Media House
Burlington Lane
LONDON
W4 2TH
ENGLAND

TEL: +44 208 233 5631
FAX: +44 208 233 7701
CELL: +44 7968 918813

RE: MySQL Identity Columns

[Jesse Schoch]

I have used it in the past, it works fine for me but you have to be aware
that it is per Db session and if you are using connection pooling you may
get the wrong last statement.  I solved the problem by putting my id into a
bean, and then using that as for the where for my updates.

Statement get_last_insert = con.createStatement();
String q = "select last_insert_id();"
ResultSet rs = con.executeQuery(q);


Jesse Schoch

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Holmes, George
(TWIi London)
Sent: Friday, October 06, 2000 9:52 AM
To: Orion-Interest
Subject: MySQL Identity Columns


Hi,

Does anyone have any code fragments for retrieving a MySQL identity value
using getLastInsertID() [ org.gjt.mm.mysql drivers ] under Orion?  The
documentation says that you have to cast the bespoke
statement/preparedstatement to a java.sql statement/preparedstatement?
Every time I get a ClassCastException?

Any help would be greatly appreciated.

Thanks

George

GEORGE HOLMES

TWI Interactive
Media House
Burlington Lane
LONDON
W4 2TH
ENGLAND

TEL: +44 208 233 5631
FAX: +44 208 233 7701
CELL: +44 7968 918813

Orion+MySQL crashes at night

[Aleksi Kallio]

We have Orion 1.1.37 with MySQL (mm.mysql driver). MySQL is used as a non-pooled 
data-source. Everything works fine, but when server is left running for the night, at 
the morning the DB connection has "crashed":

java.sql.SQLException: Lost connection to server during query
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.execute(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)


This happens in both Win NT and Linux. 

Have you had similar problems? Is this a bug in the driver (as it would seem) or in 
Orion, or a configuration issue? 

Here's my datasource config:

data-sources
 data-source 
  name="Project data-source" 
  class="com.evermind.sql.ConnectionDataSource" 
  location="jdbc/ProjectDS" 
  inactivity-timeout="0" 
  max-connections="100" 
  pooled-location="jdbc/ProjectPooledDS" 
  xa-location="jdbc/xa/NProjectXADS" 
  ejb-location="jdbc/ProjectEJBDS" 
  url="jdbc:mysql://info02.infomates.net:3306/project" 
  connection-driver="org.gjt.mm.mysql.Driver" 
 /
/data-sources

AW: MySql?

[Jens Stutte]

Just to drop in a line: We successfully use Interbase 6 as database server
for our entity beans (BMP, so do not ask for a database scheme ;-). It
should fit all the needs the people have that want to use MySQL - first of
all, it's now free... (and, astonishingly, it seems even faster, although i
did no real benchmarking). The JDBC drivers seem stable, but they do not
support long and timestamp values in the database yet (that means, they only
use Interbase dialect 1, not the new one, 3).

Regards

Jens Stutte


 -Ursprüngliche Nachricht-
 Von: Richard Woodward [mailto:[EMAIL PROTECTED]]
 Gesendet am: Donnerstag, 17. August 2000 02:30
 An: Orion-Interest
 Cc: Orion-Interest
 Betreff: RE: MySql?
 
 MySQL can be used with EJB's, but entities will have to be 
 written in such
 a way as to get around the lack of transaction support, ie. 
 using table
 locks (Yuck!). THis however alone does not guarantee data 
 integrity, as a
 connection that is dropped in the middle of a set of queries, 
 will result
 in the locks being dropped, meaning table locks are only 
 useful when two
 concurrect connections are trying to write/ read to the same 
 table, and
 locks will ensure that one connection blocks till the other drops the
 lock. 
 
 So, you can still do session beans, but not standard entity beans.
 
 MaxSQL is MySQL with Berkeley DB support for transactions. 
 THis has been
 announced, but not released yet. I think they are waiting till the
 existing Berkeley DB transactions mod is more stable before 
 they release
 it. You could have a preview by getting the Mod and installing it with
 MySQL and seeing how it goes with EJB's under Orion. 
 
 Have not had too much of a play with EJB support on Orion yet, but i 
 understand you have to create a schema for particular databases to use
 them as EJB datasources ??
 
 cheers,
 
 Richard.
 
 ps. I have been using MySQL for some time on Orion, as a standard
 datasource, but have not tried it with EJB's yet. It is fine 
 as a standard
 datasource, the JDBC drivers ( the mm variety ) even have transaction
 handling routines. (commit, rollback, etc... ) They just dont 
 work, ie.
 The transaction gets fired through query by query without 
 regard for data
 integrity. 
 
 ---
 
 Richard Woodward
 
 G8 Labs Ltd.
 
 Wellington
 New Zealand
 
 Direct Dial (04) 9393414
 ---
 On Wed, 16 Aug 2000, Michael Bushe wrote:
 
  Since MySQL doesn't support transactions (hence IMHO is a toy like
  MSAccess), so I would be surprised if it would work with 
 any EJB server.  If
  you want an open source solution I'd try PostgreSQL or 
 Inprise's Interbase.
  I'm starting with Oracle and moving to one of those.  I did 
 try PostgreSQL
  with the RI and that worked, so I bet Orion would work too. 
  Let us know or
  I'll let y'all know in a couple of months.
  
  Michael
-Original Message-
From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]On Behalf Of 
 Steven Punte
Sent: Wednesday, August 16, 2000 1:01 PM
To: Orion-Interest
Subject: MySql?
  
  
Has anyone ever use the database "mysql" successfully with Orion?
  
Steve
  
  
STeve Punte
e-Business Software Architect
Technologent Inc
[EMAIL PROTECTED]
  
 
 

RE: MySql?

[J.T. Wenting]

Interbase 6 is great, when you don't mind the shortcomings in the JDBC
driver (a fix for it is now in testing, though): it does not support
renaming columns using AS. So "select count(*) AS userCount from users" will
not allow getInt("userCount"), though getInt(1) works fine, so there is a
simple workaround.
I find Interbase stable and fast as well. Maybe not quite as good there as
Oracle, but at the price (and the footprint, full install is under 25MB,
where Oracle has a minimum install of about 250MB).

Jeroen T. Wenting
[EMAIL PROTECTED]

Murphy was wrong, things that can't go wrong will anyway

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Jens Stutte
 Sent: Thursday, August 17, 2000 09:32
 To: Orion-Interest
 Subject: AW: MySql?


 Just to drop in a line: We successfully use Interbase 6 as database server
 for our entity beans (BMP, so do not ask for a database scheme ;-). It
 should fit all the needs the people have that want to use MySQL - first of
 all, it's now free... (and, astonishingly, it seems even faster,
 although i
 did no real benchmarking). The JDBC drivers seem stable, but they do not
 support long and timestamp values in the database yet (that
 means, they only
 use Interbase dialect 1, not the new one, 3).

 Regards

 Jens Stutte


  -Ursprüngliche Nachricht-
  Von: Richard Woodward [mailto:[EMAIL PROTECTED]]
  Gesendet am: Donnerstag, 17. August 2000 02:30
  An: Orion-Interest
  Cc: Orion-Interest
  Betreff: RE: MySql?
 
  MySQL can be used with EJB's, but entities will have to be
  written in such
  a way as to get around the lack of transaction support, ie.
  using table
  locks (Yuck!). THis however alone does not guarantee data
  integrity, as a
  connection that is dropped in the middle of a set of queries,
  will result
  in the locks being dropped, meaning table locks are only
  useful when two
  concurrect connections are trying to write/ read to the same
  table, and
  locks will ensure that one connection blocks till the other drops the
  lock.
 
  So, you can still do session beans, but not standard entity beans.
 
  MaxSQL is MySQL with Berkeley DB support for transactions.
  THis has been
  announced, but not released yet. I think they are waiting till the
  existing Berkeley DB transactions mod is more stable before
  they release
  it. You could have a preview by getting the Mod and installing it with
  MySQL and seeing how it goes with EJB's under Orion.
 
  Have not had too much of a play with EJB support on Orion yet, but i
  understand you have to create a schema for particular databases to use
  them as EJB datasources ??
 
  cheers,
 
  Richard.
 
  ps. I have been using MySQL for some time on Orion, as a standard
  datasource, but have not tried it with EJB's yet. It is fine
  as a standard
  datasource, the JDBC drivers ( the mm variety ) even have transaction
  handling routines. (commit, rollback, etc... ) They just dont
  work, ie.
  The transaction gets fired through query by query without
  regard for data
  integrity.
 
  ---
 
  Richard Woodward
 
  G8 Labs Ltd.
 
  Wellington
  New Zealand
 
  Direct Dial (04) 9393414
  ---
  On Wed, 16 Aug 2000, Michael Bushe wrote:
 
   Since MySQL doesn't support transactions (hence IMHO is a toy like
   MSAccess), so I would be surprised if it would work with
  any EJB server.  If
   you want an open source solution I'd try PostgreSQL or
  Inprise's Interbase.
   I'm starting with Oracle and moving to one of those.  I did
  try PostgreSQL
   with the RI and that worked, so I bet Orion would work too.
   Let us know or
   I'll let y'all know in a couple of months.
  
   Michael
 -Original Message-
 From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]]On Behalf Of
  Steven Punte
 Sent: Wednesday, August 16, 2000 1:01 PM
 To: Orion-Interest
 Subject: MySql?
  
  
 Has anyone ever use the database "mysql" successfully with Orion?
  
 Steve
  
  
 STeve Punte
 e-Business Software Architect
 Technologent Inc
 [EMAIL PROTECTED]
  
 
 

Re: MySql?

[Brian Beaulieu]

From what point of view?  As a datasource? No.  Just through a JDBC
driver as part of an application, yes.

Brian
-- 
Capital Internet
http://www.capital-internet.net
Voice: (414) 291-3500 x1004

On Wed, 16 Aug 2000, Steven Punte wrote:

 Has anyone ever use the database "mysql" successfully with Orion?
 
 Steve
 
 
 STeve Punte
 e-Business Software Architect
 Technologent Inc
 [EMAIL PROTECTED]
 

Re: MySql?

[Steven Punte]

 From what point of view?  As a datasource? No.  Just through a JDBC
 driver as part of an application, yes.

Has it been demonstrated in a production worthy manner that
the facilities of this server, (i.e. db pooling, EJB-CMP) operate
with mysql?

Steve
 
 Brian
 -- 
 Capital Internet
 http://www.capital-internet.net
 Voice: (414) 291-3500 x1004
 
 On Wed, 16 Aug 2000, Steven Punte wrote:
 
  Has anyone ever use the database "mysql" successfully with Orion?
  
  Steve
  
  
  STeve Punte
  e-Business Software Architect
  Technologent Inc
  [EMAIL PROTECTED]
  
 
 

RE: MySql?

[Richard Woodward]

MySQL can be used with EJB's, but entities will have to be written in such
a way as to get around the lack of transaction support, ie. using table
locks (Yuck!). THis however alone does not guarantee data integrity, as a
connection that is dropped in the middle of a set of queries, will result
in the locks being dropped, meaning table locks are only useful when two
concurrect connections are trying to write/ read to the same table, and
locks will ensure that one connection blocks till the other drops the
lock. 

So, you can still do session beans, but not standard entity beans.

MaxSQL is MySQL with Berkeley DB support for transactions. THis has been
announced, but not released yet. I think they are waiting till the
existing Berkeley DB transactions mod is more stable before they release
it. You could have a preview by getting the Mod and installing it with
MySQL and seeing how it goes with EJB's under Orion. 

Have not had too much of a play with EJB support on Orion yet, but i 
understand you have to create a schema for particular databases to use
them as EJB datasources ??

cheers,

Richard.

ps. I have been using MySQL for some time on Orion, as a standard
datasource, but have not tried it with EJB's yet. It is fine as a standard
datasource, the JDBC drivers ( the mm variety ) even have transaction
handling routines. (commit, rollback, etc... ) They just dont work, ie.
The transaction gets fired through query by query without regard for data
integrity. 

---

Richard Woodward

G8 Labs Ltd.

Wellington
New Zealand

Direct Dial (04) 9393414
---
On Wed, 16 Aug 2000, Michael Bushe wrote:

 Since MySQL doesn't support transactions (hence IMHO is a toy like
 MSAccess), so I would be surprised if it would work with any EJB server.  If
 you want an open source solution I'd try PostgreSQL or Inprise's Interbase.
 I'm starting with Oracle and moving to one of those.  I did try PostgreSQL
 with the RI and that worked, so I bet Orion would work too.  Let us know or
 I'll let y'all know in a couple of months.
 
 Michael
   -Original Message-
   From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Steven Punte
   Sent: Wednesday, August 16, 2000 1:01 PM
   To: Orion-Interest
   Subject: MySql?
 
 
   Has anyone ever use the database "mysql" successfully with Orion?
 
   Steve
 
 
   STeve Punte
   e-Business Software Architect
   Technologent Inc
   [EMAIL PROTECTED]
 

Warnings with MySql database

[Juha Lehtonen]

I hava been getting the following warning when using Mysql, OrionServer
and Entity beans. Can I get rid of it?

*** WARNING: DATABASE SET AUTO-COMMIT CALL FAILED, THIS DATABASE IS NOT
TRANSACT
IONAL (AND HENCE UNSECURE): Cannot disable AUTO_COMMIT ***

Juha Lehtonen

data-sources.xml/classpath with mySQL

[Neal Kaiser]

Using build 0.8.2


Here's a sample of what I have:

 data-source 
class="com.evermind.sql.ConnectionDataSource" 
location="jdbc/DefaultDS" 
nameDefault 
data-source/name 
description 
This is a generic data-source that takes it's generates Connections 
with 
ordinary JDBC 2.0 
drivers. 
/description 
urljdbc:mysql://localhost/creative/url 
connection-driverorg.gjt.mm.mysql.Driver/connection-driver 
usernameweb/username 
passwordweb/password 
/data-source

I have the mySQL drivers in my classpath in web-application.xml

classpath/usr/local/jdk/ex/mm.mysql.jdbc-2.0pre3/classpath

However, when I start up Orion, I get:

Error initializing server: ConnectionDataSource driver 
'org.gjt.mm.mysql.Driver' not found

Thanks.