RE: MySQL Connection Pool?

2002-04-26 Thread 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

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

2002-04-26 Thread 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?

2002-03-04 Thread 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

MySQL Connection Pool?

2002-03-03 Thread 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?

2002-03-03 Thread 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

Re: MySQL Connection Pool?

2002-03-03 Thread 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

Re: Mysql table create errors with ejbsamples

2001-12-20 Thread Morten Wilken
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

Mysql table create errors with ejbsamples

2001-12-19 Thread 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

Mysql table create errors with ejbsamples

2001-12-19 Thread 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

Re: Mysql table create errors with ejbsamples

2001-12-19 Thread Ed Brown
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

MySQL and JDBC

2001-11-22 Thread 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

2001-11-22 Thread 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

Orion and MySQL config

2001-10-15 Thread 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

Re: Problems with CMP/MySQL

2001-10-11 Thread 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

RE: Problems with CMP/MySQL

2001-10-02 Thread Roozbeh Ghaffari
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

Re: Problems with CMP/MySQL

2001-10-01 Thread 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

Problems with CMP/MySQL

2001-09-30 Thread 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

RE: Problems with CMP/MySQL

2001-09-30 Thread Troy Wong
-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

How to use mySQL DB as Datasource?

2001-09-27 Thread 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?

2001-09-27 Thread 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

RE: mySQL

2001-09-26 Thread 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

RE: mySQL

2001-09-26 Thread 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

Re: mySQL

2001-09-22 Thread 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

Re: mySQL

2001-09-22 Thread Emeline Barns
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

Re: mySQL

2001-09-21 Thread Emeline Barns
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

Orion server Configuration for mysql access

2001-08-30 Thread 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?

2001-08-13 Thread 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

Does Orion work fine in MySQL and BSD?

2001-08-12 Thread HyungKee Hwang
Hello Can Orion work with MySQL and FreeBSD? Any comment would be appreciated. Regards, -HK

Re: Support for MySQL

2001-06-21 Thread 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

Re: Support for MySQL

2001-06-21 Thread 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

Re: Support for MySQL

2001-06-20 Thread Scot Weber
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

2001-06-20 Thread 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

Boolean CMP properties in MySQL

2001-05-29 Thread 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

Short Orion/remote MySQL howto

2001-04-06 Thread 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

Re: orion with mysql?

2001-04-05 Thread 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

RE: orion with mysql?

2001-04-05 Thread 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

RE: orion with mysql?

2001-04-05 Thread 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

RE: orion with mysql?

2001-04-05 Thread 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

Re: orion with mysql?

2001-04-05 Thread Rian Schmidt
est. 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 get

Re: orion with mysql?

2001-04-05 Thread 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

orion with mysql?

2001-04-04 Thread 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

Re: orion with mysql?

2001-04-04 Thread Ray Harrison
] 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

Re: orion with mysql?

2001-04-04 Thread 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

RE: orion with mysql?

2001-04-04 Thread 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

RE: orion with mysql?

2001-04-04 Thread 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

Orion and mysql: turning autocommit off?

2001-03-19 Thread 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

RE: Orion and mysql: turning autocommit off?

2001-03-19 Thread 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

RE: NOVICE Question about orion and mysql

2001-02-21 Thread Dvornikov Victor
Check log files of orion and your database -Original Message- From: Andres Garcia Hourcade [SMTP:[EMAIL PROTECTED]] Sent: 20 2001 16:22 To: Orion-Interest Subject: RE: NOVICE Question about orion and mysql Thanks a lot, i did what you tell me,but i am still getting

RE: NOVICE Question about orion and mysql

2001-02-21 Thread Ray Harrison
It appears from the error message that you are pointing to the wrong mysql database: The data-sour xml file snippet you give below refers (in you URL) to defaultdb and your message refers to addressbookdb. In mysql, create a database called addressbookdb (or just change your references

NOVICE Question about orion and mysql

2001-02-20 Thread Andres Garcia Hourcade
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

Re: NOVICE Question about orion and mysql

2001-02-20 Thread Brian Wing Shun Chan
TECTED]]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

RE: NOVICE Question about orion and mysql

2001-02-20 Thread DSmith
Hi Andres, I'm sorry, I didn't get that error. Orion automatically creates tables in MySQL for CMP entity beans on my system, after just doing what I suggested earlier. Your error sounds like the "database" is invalid, like the URL you're using is pointing to the wrong MySQL data

Re: NOVICE Question about orion and mysql

2001-02-19 Thread DSmith
Hi Andres, I have some custom CMP EJBs working with MySQL 3.23. My datasource.xml entry is similar to yours. A couple thoughts: 1. Make sure you have removed the attribute "ejb-location" from the hsql datasource. 2. Make sure you have a schema for mysql in the orion/confi

NOVICE Question about orion and mysql

2001-02-16 Thread 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

Re: orion and mysql?

2001-01-31 Thread Marc Linke
orton" [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

RE: orion and mysql?

2001-01-31 Thread Stanislav Maximov
-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

Re: orion and mysql?

2001-01-31 Thread Dan Winfield
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

Re: orion and mysql?

2001-01-30 Thread David Morton
: 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?

2001-01-30 Thread 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

Re: orion and mysql?

2001-01-30 Thread 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

Re: orion and mysql?

2001-01-30 Thread David Morton
/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

RE: orion and mysql?

2001-01-30 Thread Randahl Fink Isaksen
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

Re: Problems with MySQL and DataSourceUserManager

2000-11-16 Thread Lars Hoss
;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

Problems with MySQL and DataSourceUserManager

2000-11-15 Thread 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

Re: Problems with MySQL and DataSourceUserManager

2000-11-15 Thread 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

Re: Problems with MySQL and DataSourceUserManager

2000-11-15 Thread 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:

Re: CMP Bean in mysql

2000-11-10 Thread 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 ??

2000-10-27 Thread 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

Re: MYSQL, Orion, EJB and transactions ??

2000-10-27 Thread 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

SV: MYSQL, Orion, EJB and transactions ??

2000-10-27 Thread 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

Re: MYSQL, Orion, EJB and transactions ??

2000-10-27 Thread 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. H

RE: MYSQL, Orion, EJB and transactions ??

2000-10-27 Thread 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

Problem deploying EJBs using a MySQL data-source

2000-10-14 Thread 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

Re: Problem deploying EJBs using a MySQL data-source

2000-10-14 Thread Robert Krueger
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 erro

Re: Orion and MySQL

2000-10-10 Thread 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 &q

Orion and MySQL

2000-10-09 Thread 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

MySQL Identity Columns

2000-10-06 Thread 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

RE: MySQL Identity Columns

2000-10-06 Thread Jesse Schoch
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

Orion+MySQL crashes at night

2000-08-18 Thread 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 du

AW: MySql?

2000-08-17 Thread 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

RE: MySql?

2000-08-17 Thread J.T. Wenting
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 o

Re: MySql?

2000-08-16 Thread 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" su

Re: MySql?

2000-08-16 Thread 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

RE: MySql?

2000-08-16 Thread 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

Warnings with MySql database

2000-02-25 Thread 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

2000-01-04 Thread Neal Kaiser
ry 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.0pre