RE: What database are you using??
For serious (i.e. mission critical, large) projects, use Oracle, DB2 or Sybase. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mikko Kurki-Suonio Sent: Monday, October 02, 2000 07:51 To: Orion-Interest Subject: Re: What database are you using?? On Fri, 29 Sep 2000, Jim Archer wrote: I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Actually, we're right now in the process of evaluating DB products for a "serious" production environment. HyperSonic works fine for quick tests, but I don't feel like using it for really important stuff. So far: InterBase 6.0 for Linux. Trouble mapping the "long" datatype. Prone to spurious crashes/deadlocks. SOLID: Again, Orion refuses to map "long" correctly. Otherwise it seems to work fine. //Mikko
RE: What database are you using??
PostgreSQL is quite reliable and scalable too. It's not in the same category as, say, oracle or DB2, but it's on par with Sybase/SQLServer. -c -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of J.T. Wenting Sent: Monday, October 02, 2000 3:27 AM To: Orion-Interest Subject: RE: What database are you using?? For serious (i.e. mission critical, large) projects, use Oracle, DB2 or Sybase. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mikko Kurki-Suonio Sent: Monday, October 02, 2000 07:51 To: Orion-Interest Subject: Re: What database are you using?? On Fri, 29 Sep 2000, Jim Archer wrote: I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Actually, we're right now in the process of evaluating DB products for a "serious" production environment. HyperSonic works fine for quick tests, but I don't feel like using it for really important stuff. So far: InterBase 6.0 for Linux. Trouble mapping the "long" datatype. Prone to spurious crashes/deadlocks. SOLID: Again, Orion refuses to map "long" correctly. Otherwise it seems to work fine. //Mikko
RE: What database are you using??
SybaseASE11.9.2forLinuxworksfine.(UsingJConnect5.2) /David "The Las Vegas of Online Gaming" David EkholmSystem ArchitectHammarby Kajväg 14, 120 30 Stockholmtel: +46 (0)8 55 69 67 11Mob: +46 (0)70 486 77 38fax: +46 (0)8 55 69 67 07
Re: What database are you using??
On Fri, 29 Sep 2000, Jim Archer wrote: I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Actually, we're right now in the process of evaluating DB products for a "serious" production environment. HyperSonic works fine for quick tests, but I don't feel like using it for really important stuff. So far: InterBase 6.0 for Linux. Trouble mapping the "long" datatype. Prone to spurious crashes/deadlocks. SOLID: Again, Orion refuses to map "long" correctly. Otherwise it seems to work fine. //Mikko
RE: What database are you using??
Using Orion with Interbase and Oracle for development, iPlanet and Oracle for deployment (corporate choice, I'm a lowly developer). Problem with Interbase is that several column names used in the autocreated tables Orion makes during deployment are actually reserved words (like password). As we don't use EJB (another corporate choice, having to do with yet another corporate choice to switch to Websphere which has very poor EJB support in the future) that's not really a problem (yet). Jeroen T Wenting [EMAIL PROTECTED] ICQ UIN #9191966 It's the end of the world as we know it and I feel fine (Michael Stipe) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jim Archer Sent: 30 September 2000 02:44 To: Orion-Interest Subject: What database are you using?? Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim
Re: What database are you using??
At 20:44 29.09.00 , you wrote: Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim Oracle 8, Adabas D both in development and production without any problems related to their use with orion. robert (-) 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: What database are you using??
We are using MS SQL Server 7.0 with I-Net Software's Opta 2000 JDBC Drivers. Setting up the datasources is straight forward. Performace wise we are smoking the current implementation (IIS/ASP/ODBC). Not a real surprise, even though we are adding two extra layers of abstraction, converting the JDBC results to XML and then using XSLT to build the pages to display. -Original Message- From: Jim Archer [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 8:44 PM To: Orion-Interest Subject: What database are you using?? Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim
Re: What database are you using??
MYSQL very successfully. David SkyLabs Corporation At 08:44 PM 9/29/00 -0400, you wrote: Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim
Re: What database are you using??
Can you please give me more information regarding your use of MySQL with Orion? Any problems at all? Does it support Transactions now? Is it still as blazingly fast as it was without transactions? Any difficulties getting it to work with Orion, or is it a standard installation? Thank you! -- Joel Shellman Chief Software Architect http://www.ants.com/90589781 David Morton wrote: MYSQL very successfully. David SkyLabs Corporation At 08:44 PM 9/29/00 -0400, you wrote: Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim
Re: What database are you using??
Mysql is very Good! - Original Message - From: "Jim Archer" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Saturday, September 30, 2000 8:44 AM Subject: What database are you using?? Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim
Re: What database are you using??
It depends on your solutionif you are building the next Etrade, I may not recommend itif you are building a web site that does what 95% of the population is doing...then it is great. At 07:08 PM 9/29/00 -0700, you wrote: Can you please give me more information regarding your use of MySQL with Orion? I am using a connection pool...currently one from javaexchange.com, just because I've used it for years and it has worked for me.I don't have mission critical data, however, I am still pretty confident with my setup. I'm sure orion's connection pooling is good..for javaexchange's, I had to reconnect=true and all is well. Any problems at all? None yet, except sometimes I think that some of this code is too forgiving, I'm always forgetting to close resultsets and statements and there never seems to be a problem... :) Does it support Transactions now? I've heard yes, but haven't tested..see for yourself: http://www.mysql.com/downloads/mysql-3.23.html It is in late beta...I think. Is it still as blazingly fast as it was without transactions? not sure...but mysql is fast in general Any difficulties getting it to work with Orion, or is it a standard installation? not at all, just make sure you have drivers (http://www.worldserver.com/mm.mysql/) in orion's classpath. I recommend using MYSQL or Oracle, why settle for anything else? And the only reason I say Oracle is that it is a valuable skillI'll switch to oracle if I have a terabyte DB I need to distribute, but my data is not like that at all.currently handling about 100k selects/updates daily David
Re: What database are you using??
We're using Postgres 7.01 So far the major problems are: 1. Large Object support is a pain 2. getDate has a tendency to throw NumberFormatExceptions 3. JDBC Drivers generally kind of weak -Lkb At 08:44 PM 9/29/00 -0400, Jim Archer wrote: Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim /** * @author: Lorin Kobashigawa-Bates [EMAIL PROTECTED] * @title: CodeMonkey / COO - Robot6 Inc. * @phone: 415.345.8872 * @addr: 1177 Polk St. San Francisco, CA 94109 */
Re: What database are you using??
Hi David... If Orion server is used in conjunction with a database that does not support transactions, then are transactions lost to the EJB server, or does Orion somehoe provide that capability? Thanks... Jim --On Friday, September 29, 2000 9:12 PM -0400 David Morton [EMAIL PROTECTED] wrote: MYSQL very successfully. David SkyLabs Corporation At 08:44 PM 9/29/00 -0400, you wrote: Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim
RE: What database are you using??
Orion uses the database transaction facilities. When using EJBs with Mysql you have no transactions. M -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jim Archer Sent: Saturday, September 30, 2000 3:20 PM To: Orion-Interest Subject: Re: What database are you using?? Hi David... If Orion server is used in conjunction with a database that does not support transactions, then are transactions lost to the EJB server, or does Orion somehoe provide that capability? Thanks... Jim --On Friday, September 29, 2000 9:12 PM -0400 David Morton [EMAIL PROTECTED] wrote: MYSQL very successfully. David SkyLabs Corporation At 08:44 PM 9/29/00 -0400, you wrote: Hi All... I'm currious to know what database products people are using with Orion, open source or commerical. Also, please include any comments about problems if you have had any, or anything thats really great. Thanks! Jim