Re: [OT] free Database with Transaction (Sorry for the noise)
chomp On Wed, Feb 19, 2003 at 08:16:25PM -0500, Jake Robb wrote: Internal and External refer to whether you compile the mySQL source into your program and distribute that (internal), or you just distribute mySQL along with your software (external). Really? Do they define that somewhere? My interpretation of the page was that internal and external referred to your organization (say, one division of your company providing software for another vs distributing to a separate company). I don't see how they would enforce that (restriction on internal distribution), though. The only important part is that you have to *distribute* the mySQL software in order to incur charges. As I said before, you can use it to drive your web application free of charge. True. Although they clearly *want* you to buy a commercial license (unless the web application is itself free software). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Thanks for the clarification, my point was that unless you're the Licensing Coordinator for MySQL AB, a developer or organization might choose another option in the interest of moving quickly with a guaranteed unencumbered solution without having to wait for clarification from MySQL AB or involve lawyers. John -Original Message- From: Jake Robb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 8:16 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Internal and External refer to whether you compile the mySQL source into your program and distribute that (internal), or you just distribute mySQL along with your software (external). The only important part is that you have to *distribute* the mySQL software in order to incur charges. As I said before, you can use it to drive your web application free of charge. -Jake Erik Price wrote: Turner, John wrote: I guess MySQL AB should remove the phrase internal or external from the statement, then. ;) I agree, it is confusing, and doesn't even say what context internal or external refers to. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Michael Micek wrote: chomp On Wed, Feb 19, 2003 at 08:16:25PM -0500, Jake Robb wrote: Internal and External refer to whether you compile the mySQL source into your program and distribute that (internal), or you just distribute mySQL along with your software (external). Really? Do they define that somewhere? My interpretation of the page was that internal and external referred to your organization (say, one division of your company providing software for another vs distributing to a separate company). I don't see how they would enforce that (restriction on internal distribution), though. Nor would it matter, in most cases. If dept A wants to use the budget system from dept B, and the budget system is not written for deployment outside of the company (external), then I would think that [most of the time], if dept A says Hey can we get the source code?, then dept B would probably say sure. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I don't know what you exacly mean with 'lively project' but the last time I had to deal with the postgres driver the development was very active. (The result of the activity was not always optimal) Each time I found a bug, it was resolved by the time I got enough information to file a bug report. If you feel that the driver is not good enough you also may checkout jxDBCon: http://jxdbcon.sourceforge.net/ Some intresting information can be found in http://www.google.de/search?q=cache:WKaB0FnR2iQC:lab.applinet.nl/postgresql-jdbc/+hl=deie=UTF-8 (Only Archive is currently not online) -Original Message- From: Schnitzer, Jeff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:22 PM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) PostgreSQL may be a lively project, but the JDBC driver is not :-( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Actually, the patches are a little too much behind the schedule lately, but it's an good driver. I sent some patches to the list, and I would say if I started that driver from scratch I would make some different implementations (like the double-synchronized string buffer in PreparedStatement code), but it's good. On Wed, 2003-02-19 at 05:20, Ralph Einfeldt wrote: I don't know what you exacly mean with 'lively project' but the last time I had to deal with the postgres driver the development was very active. (The result of the activity was not always optimal) Each time I found a bug, it was resolved by the time I got enough information to file a bug report. If you feel that the driver is not good enough you also may checkout jxDBCon: http://jxdbcon.sourceforge.net/ Some intresting information can be found in http://www.google.de/search?q=cache:WKaB0FnR2iQC:lab.applinet.nl/postgresql-jdbc/+hl=deie=UTF-8 (Only Archive is currently not online) -Original Message- From: Schnitzer, Jeff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:22 PM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) PostgreSQL may be a lively project, but the JDBC driver is not :-( - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Felipe Schnack Analista de Sistemas [EMAIL PROTECTED] Cel.: (51)91287530 Linux Counter #281893 Centro Universitário Ritter dos Reis http://www.ritterdosreis.br [EMAIL PROTECTED] Fone/Fax.: (51)32303341 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I am posting a email to ther server an it always get bounced. I need to set the maximun number of connections for my-sql. Do you think this will improve performance? Gustavo. Mike Jackson [EMAIL PROTECTED] wrote:Also the clob and blob support is closer to the standard jdbc implementation than under postgresql. Admitably I haven't looked lately to be sure of that statement, and oracle isn't quite standard, but it's alot closer that what I saw in postgresql. For a home project I'd consider postgresql, but for work it's going to be oracle. Besides most of our customers explicitly require oracle, or MS SQL, so it's not like I have a big choice. The next most likey contentors usually end up being informix or db2. And for really small stuff I can get away with something like hypersonic, but only if they don't know (it's not that I'm trying to hide things, it's just that they don't care). Oracle also has some really nice xml/xsl tools, which I haven't see for the other databases. Their XSQL servlet is really really nice for implementing pre-filled in forms and other types of pages when your sql is static. And their implmentation of the XSL transform is about 2-2.5 times faster than xalan. All in all I'm a fairly happy oracle customer (although indirectly as I don't purchase oracle, the customer does). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:13 PM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) I have an oracle administrator. It's no problem. I also have an oracle support contract, if it's beyond the admin I have additional resources. And not to start a flame war, but postgresql isn't quite to the level that I need professionally yet. It's getting there, but its not quite there yet. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:35 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. There is no comparison. PostgreSQL is very simple to install and run. Oracle requires an Oracle administrator ($$$) to install. I don't think a database can be much easier to install than PostgreSQL, especially if you're on windows. Just install Cygwin and it has postgresql installed automatically (if you select the database option). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day
RE: [OT] free Database with Transaction (Sorry for the noise)
Seems pretty straightforward to me: If your application is not licensed under GPL or compatible OSI license approved by MySQL AB and you intend to distribute MySQL software (be that internally or externally), you must first obtain a commercial license to the MySQL software in question. Many companies have problems with doing work under the GPL, internally or externally. I'm not saying they're right, and I'm not saying I agree with them, merely pointing out that MySQL AB's restrictions might prove prohibitive if the intent is to use MySQL without a commercial license. I guess the lawyers could argue for a couple of years on the exact definition of distribute internally (does that mean use once? use more than once? use more than once but download a complete copy of the software and do a full installation each time instead of creating an application installer package? etc.) but sometimes it's much quicker and less cumbersome to simply choose another solution. John -Original Message- From: Joel Rees [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:28 PM To: Jens Skripczynski Cc: [EMAIL PROTECTED] Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Just thinking out loud -- ... - yes, i did check the mysql website, but rely on (maybe outdated) information of computer magazines, that labeled the transaction support very limited. ... almost free (for non-commercial use): - Mysql (http://www.mysql.com/) connectors: - MySQL Connector/J (http://www.sapdb.org/7.4/sap_db_jdbc.htm) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver That almost free (for non-commercial use) makes me wonder if your information might be old, or perhaps inaccurate. It's GPL, so it's free in the GPL sense, and has been several years. If you have concerns about restrictions on your license to your customer, contact them and describe what you're doing. Last I recall, querying the database through a driver was not considered linking directly to the API, so the so-called viral aspects of the GPL would not be invoked. You might want to ask. As an opinion without experience, giving the customer their source code under a GPL compatible license does not seem all that unreasonable to me. And, if I'm making much money on a project, it would not seem unreasonable to buy a license for MySQL that would allow the use of a license on my code not compatible with the GPL. MySQL version 4, which is the version said to have full transaction support, has now passed the beta stage. Some people say MySQL beta is better than Microsoft final, but I don't have enough experience to say. Like I say, just thinking out loud. -- Joel Rees [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I'm surprised that no-one has mentioned SAPDB ( www.sapdb.org ). If this will support a production SAP R3 system then it shoud be able to give Oracle a run for its money. Regards Roger - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
There are some great installation guides for Oracle on Linux and Solaris found at http://www.dbspecialists.com/ -Original Message- From: Felipe Schnack [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:47 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Oracle is expensive to buy, expensive to hire a DBA... and well, in windows the installation is okay, but in linux is a real nightmare... I took almost a week the first time (I wasn't a very experienced linux user too) I'm using postgresql with Java and I'm very satisfied, much more serious than MySQL, just as free and have a good comunity. I heard Hypersonic is very nice, but you shouldn't use it if you get lots of data. You know, it's java... it eats memory :-))) On Tue, 2003-02-18 at 16:45, Jens Skripczynski wrote: Hi, thx for all the replies. I will give Hypersonic a try. (Because native java sounds good, and i do not have the money nor the time to learn oracle (a friend of mine told me an adventure about installing oracle on a windows system 'use that installer, swap cd's, because the default cd won't do the job, ' took him a month)). If Hypersonic does not work, i will try postgres. Thx for all the replies. Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com Computers are like airconditioners: They stop working properly if you open windows. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Felipe Schnack Analista de Sistemas [EMAIL PROTECTED] Cel.: (51)91287530 Linux Counter #281893 Centro Universitário Ritter dos Reis http://www.ritterdosreis.br [EMAIL PROTECTED] Fone/Fax.: (51)32303341 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Yes... until something weird happen, it complains about a library and no-one knows why :-) On Wed, 2003-02-19 at 11:08, Kemp Randy-W18971 wrote: There are some great installation guides for Oracle on Linux and Solaris found at http://www.dbspecialists.com/ -Original Message- From: Felipe Schnack [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:47 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Oracle is expensive to buy, expensive to hire a DBA... and well, in windows the installation is okay, but in linux is a real nightmare... I took almost a week the first time (I wasn't a very experienced linux user too) I'm using postgresql with Java and I'm very satisfied, much more serious than MySQL, just as free and have a good comunity. I heard Hypersonic is very nice, but you shouldn't use it if you get lots of data. You know, it's java... it eats memory :-))) On Tue, 2003-02-18 at 16:45, Jens Skripczynski wrote: Hi, thx for all the replies. I will give Hypersonic a try. (Because native java sounds good, and i do not have the money nor the time to learn oracle (a friend of mine told me an adventure about installing oracle on a windows system 'use that installer, swap cd's, because the default cd won't do the job, ' took him a month)). If Hypersonic does not work, i will try postgres. Thx for all the replies. Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com Computers are like airconditioners: They stop working properly if you open windows. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Felipe Schnack Analista de Sistemas [EMAIL PROTECTED] Cel.: (51)91287530 Linux Counter #281893 Centro Universitário Ritter dos Reis http://www.ritterdosreis.br [EMAIL PROTECTED] Fone/Fax.: (51)32303341 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Felipe Schnack Analista de Sistemas [EMAIL PROTECTED] Cel.: (51)91287530 Linux Counter #281893 Centro Universitário Ritter dos Reis http://www.ritterdosreis.br [EMAIL PROTECTED] Fone/Fax.: (51)32303341 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
That's a very strange database. Once it's setup it's not too bad, but I've had no fun setting it up. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Varley, Roger [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 5:38 AM To: 'Tomcat Users List' Subject: RE: [OT] free Database with Transaction (Sorry for the noise) I'm surprised that no-one has mentioned SAPDB ( www.sapdb.org ). If this will support a production SAP R3 system then it shoud be able to give Oracle a run for its money. Regards Roger - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Hypersonic ? I've had some problems running it in standalone server mode. Can't seem to be able to connect. But two non-commercial (i.e. free) databases I like are : 1. McKoi (http://www.mckoi.com/database/) 2. InstantDB - no, it's not dead, just frozen. (http://www.simpledb.org/) IBM's DB2 is excellent for database newbies and casual database users and administrators.I particularly like the one-click install and the stable GUI admin tool. The installation process is a LOT more painless than Oracle, and the database tunes itself more effectively. I didn't like the number of pre-install tasks when installing Oracle 8i, and I thought the installer was not as seamless as it should be. Just my 2 cents Regards, pascal chong Kemp Randy-W18971 wrote: There are some great installation guides for Oracle on Linux and Solaris found at http://www.dbspecialists.com/ -Original Message- From: Felipe Schnack [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:47 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Oracle is expensive to buy, expensive to hire a DBA... and well, in windows the installation is okay, but in linux is a real nightmare... I took almost a week the first time (I wasn't a very experienced linux user too) I'm using postgresql with Java and I'm very satisfied, much more serious than MySQL, just as free and have a good comunity. I heard Hypersonic is very nice, but you shouldn't use it if you get lots of data. You know, it's java... it eats memory :-))) On Tue, 2003-02-18 at 16:45, Jens Skripczynski wrote: - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Turner, John wrote: Without going into a whole argument...technically MySQL is not free for commercial use. If you use MySQL in a commercial setting, internal or external, without purchasing a commercial license, you may do so only if the application that uses MySQL is also GPL (http://www.mysql.com/products/licensing.html). This is something that many companies (and developers) would prefer to avoid, for various reasons. PostgreSQL has no such requirement as it is distributed under the BSD license. Sorry, this is incorrect. You may use it in a commercial setting without a commercial license in a non-GPL'd application if you do not redistribute the MySQL software. In other words, if the customer of your application downloads and installs MySQL herself, then she is able to use MySQL to power the application regardless, without a commercial license and without requiring the application to be GPL'd. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I guess MySQL AB should remove the phrase internal or external from the statement, then. ;) John -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 2:53 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Turner, John wrote: Without going into a whole argument...technically MySQL is not free for commercial use. If you use MySQL in a commercial setting, internal or external, without purchasing a commercial license, you may do so only if the application that uses MySQL is also GPL (http://www.mysql.com/products/licensing.html). This is something that many companies (and developers) would prefer to avoid, for various reasons. PostgreSQL has no such requirement as it is distributed under the BSD license. Sorry, this is incorrect. You may use it in a commercial setting without a commercial license in a non-GPL'd application if you do not redistribute the MySQL software. In other words, if the customer of your application downloads and installs MySQL herself, then she is able to use MySQL to power the application regardless, without a commercial license and without requiring the application to be GPL'd. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Turner, John wrote: I guess MySQL AB should remove the phrase internal or external from the statement, then. ;) I agree, it is confusing, and doesn't even say what context internal or external refers to. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Internal and External refer to whether you compile the mySQL source into your program and distribute that (internal), or you just distribute mySQL along with your software (external). The only important part is that you have to *distribute* the mySQL software in order to incur charges. As I said before, you can use it to drive your web application free of charge. -Jake Erik Price wrote: Turner, John wrote: I guess MySQL AB should remove the phrase internal or external from the statement, then. ;) I agree, it is confusing, and doesn't even say what context internal or external refers to. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
NNOT Red Herrings (Re: [OT] free Database with Transaction (Sorry for the noise))
This thread brought to mind something in Perl's Artistic License. It also reminded me that the arguments against the GPL are all red herrings. Anyway -- Seems pretty straightforward to me: If your application is not licensed under GPL or compatible OSI license approved by MySQL AB and you intend to distribute MySQL software (be that internally or externally), you must first obtain a commercial license to the MySQL software in question. http://www.mysql.com/products/licensing.html Yeah, that does sound confusing. However, applying internal/external to the verb distribute would almost seem to be an attempt to extend the GPL. The GPL does not talk about internal distributions, nor does it distinguish between commercial and non-commercial uses. While MySQL does emphasize the benefit to the customer in buying licenses and support, they aren't trying to weasel around the GPL. Deployment is specifically described by the FSF as being a seperate issue from distribution, and is not restricted under the GPL unless a particular deployment requires distribution. (Do you have to install GPLed software X on all the workstations for your app to run? That sort of deployment would be a distribution, even if it were internal only. However, if the deployment does not involve modifying or incorporating said GPLed software X, the GPL would place no restrictions on it. And if deployment only requires said GPLed software X to run on the server, and all access is via some other means, then there has been no distribution in the deployment.) IIRC, the Artistic License talks about linking as a determinant of whether one program incorporates another or not. I seem to recall the FSF trying to talk about linking in some of their previous licenses or FAQs, but the present license and FAQ do not seem to do so explicitly. http://www.fsf.org/licenses/gpl-faq.html#MereAggregation MySQL AB seems to be waving their corporate hands at the issue in item 3B on the page you referenced. (If you talk to un-altered MySQL only through a third-party, non-GPLed, driver, your software should be clear of GPL requirements.) And then we get into the fuzziness of interpreters. Perl, being under the Artistic License, can link to the driver without License conflicts, even when distributed. Source code is considered through the Artistic License to be input to Perl, rather than some sort of means of incorporating Perl's library. So, if your program is entirely in Perl and only talks to MySQL through any driver, that also clears you of the GPL requirements. The Apache license does not appear, at first glance, to provide the same sort of buffer, if that's relevant. I think it isn't. Avoiding the payment of money is not the point. Even if you're using the stripped-down free-means-free-or-else! license that openBSD advocates, you really should know what you're using where and under what terms. If you don't, you don't really know where to turn when things fail. Free software should not be used as an excuse to abdicate responsibility. It's exactly the opposite, and if you understand that, you understand the GPL. -- Joel Rees [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
mysql does have transactions, just go through the docs Filip -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Postgre sql? Regards, PQ This Guy Thinks He Knows Everything This Guy Thinks He Knows What He Is Doing -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: February 18, 2003 1:20 PM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=postgresql John -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:20 PM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Check out Postgresql at www.postgresql.org HTH /mde/ just my two cents . . . . --- Jens Skripczynski [EMAIL PROTECTED] wrote: hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Filip, Firebird is the opensource version of Borland Interbase. Has a lot of docs and is a full-up database. Works well on W2K (posgress does not). http://firebird.sourceforge.net/ It is worth cheking out. Chuck -Original Message- From: Filip Hanik [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:03 AM To: Tomcat Users List; Jens Skripczynski Subject: RE: [OT] free Database with Transaction (Sorry for the noise) mysql does have transactions, just go through the docs Filip -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Hypersonic, best thing is that it's written in java, and can be embedded into your applications. Also, you can setup the tables to be in memory, or on disk... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
For an industrial strength open-source DB, try http://postgresql.org -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:14 AM To: Tomcat Users List; Jens Skripczynski Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Hypersonic, best thing is that it's written in java, and can be embedded into your applications. Also, you can setup the tables to be in memory, or on disk... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Ryan Chambers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:26 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) For an industrial strength open-source DB, try http://postgresql.org -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:14 AM To: Tomcat Users List; Jens Skripczynski Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Hypersonic, best thing is that it's written in java, and can be embedded into your applications. Also, you can setup the tables to be in memory, or on disk... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
At 19:20 18.2.2003 +0100, you wrote: hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. MySQL has transactions with InnoDB tables if I remember correctly. Kaarle - Kaarle Kaila http://www.iki.fi/kaila mailto:[EMAIL PROTECTED] tel: +358 50 3725844 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I love postgresql. It's free, very robust, and very fast. It has GUI admin programs available for it too which is nice. And it's an industrial strength database. Hypersonic or cloudscape are good for small projects, PostgreSQL is great for any project. Michael -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 8:14 PM To: Tomcat Users List; Jens Skripczynski Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Hypersonic, best thing is that it's written in java, and can be embedded into your applications. Also, you can setup the tables to be in memory, or on disk... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. There is no comparison. PostgreSQL is very simple to install and run. Oracle requires an Oracle administrator ($$$) to install. I don't think a database can be much easier to install than PostgreSQL, especially if you're on windows. Just install Cygwin and it has postgresql installed automatically (if you select the database option). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I can't argue with Oracle. But not all of us have $100,000 lying around to buy an Oracle license. :) -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:29 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Ryan Chambers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:26 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) For an industrial strength open-source DB, try http://postgresql.org -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:14 AM To: Tomcat Users List; Jens Skripczynski Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Hypersonic, best thing is that it's written in java, and can be embedded into your applications. Also, you can setup the tables to be in memory, or on disk... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Since I don't use Postgresql in production, I don't know how well it works (or doesn't) on Win/2K. However, for development work Postgresql on Win/2K works fine. I'm currently running Postgresql on my Win/2K Pro machine. I suspect that since Postgresql has to go through Cygwin to access a filesystem, performance on a Windows platform may not be as good as Mysql (without transactions) or a database engine with native file access. I have not done benchmarks, so the above performance comments express only my opinion. Interestingly enough, Postgresql's second biggest installation base (at 21.4%) is on the Windows/Cygwin combination. /mde/ just my two cents . . . . __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Hi, thx for all the replies. I will give Hypersonic a try. (Because native java sounds good, and i do not have the money nor the time to learn oracle (a friend of mine told me an adventure about installing oracle on a windows system 'use that installer, swap cd's, because the default cd won't do the job, ' took him a month)). If Hypersonic does not work, i will try postgres. Thx for all the replies. Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com Computers are like airconditioners: They stop working properly if you open windows. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
MySQL does support transaction and it has JDBC Driver. If you have read a bit more in depth on MySQL website, you would have found what you are looking for. -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Oracle is expensive to buy, expensive to hire a DBA... and well, in windows the installation is okay, but in linux is a real nightmare... I took almost a week the first time (I wasn't a very experienced linux user too) I'm using postgresql with Java and I'm very satisfied, much more serious than MySQL, just as free and have a good comunity. I heard Hypersonic is very nice, but you shouldn't use it if you get lots of data. You know, it's java... it eats memory :-))) On Tue, 2003-02-18 at 16:45, Jens Skripczynski wrote: Hi, thx for all the replies. I will give Hypersonic a try. (Because native java sounds good, and i do not have the money nor the time to learn oracle (a friend of mine told me an adventure about installing oracle on a windows system 'use that installer, swap cd's, because the default cd won't do the job, ' took him a month)). If Hypersonic does not work, i will try postgres. Thx for all the replies. Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com Computers are like airconditioners: They stop working properly if you open windows. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Felipe Schnack Analista de Sistemas [EMAIL PROTECTED] Cel.: (51)91287530 Linux Counter #281893 Centro Universitário Ritter dos Reis http://www.ritterdosreis.br [EMAIL PROTECTED] Fone/Fax.: (51)32303341 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Without going into a whole argument...technically MySQL is not free for commercial use. If you use MySQL in a commercial setting, internal or external, without purchasing a commercial license, you may do so only if the application that uses MySQL is also GPL (http://www.mysql.com/products/licensing.html). This is something that many companies (and developers) would prefer to avoid, for various reasons. PostgreSQL has no such requirement as it is distributed under the BSD license. John -Original Message- From: Tam, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 2:13 PM To: 'Tomcat Users List' Subject: RE: [OT] free Database with Transaction (Sorry for the noise) MySQL does support transaction and it has JDBC Driver. If you have read a bit more in depth on MySQL website, you would have found what you are looking for. -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
If you use MySQL MAX you'll have transactions. Another choice is PostgreSQL Regards, Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus S.A. www.equiplus.com - Original Message - From: Jens Skripczynski [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 3:20 PM Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I have an oracle administrator. It's no problem. I also have an oracle support contract, if it's beyond the admin I have additional resources. And not to start a flame war, but postgresql isn't quite to the level that I need professionally yet. It's getting there, but its not quite there yet. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:35 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. There is no comparison. PostgreSQL is very simple to install and run. Oracle requires an Oracle administrator ($$$) to install. I don't think a database can be much easier to install than PostgreSQL, especially if you're on windows. Just install Cygwin and it has postgresql installed automatically (if you select the database option). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Sorry to add to the noise, but I feel the need to add: On the next version of NetWare (6.5), there will be a commercially-licensed copy of MySQL that an application can use without the restrictions John listed. In case that helps anybody decide for or against using it. Jeff Tulley ([EMAIL PROTECTED]) (801)861-5322 Novell, Inc., the leading provider of Net business solutions http://www.novell.com [EMAIL PROTECTED] 2/18/03 12:57:34 PM Without going into a whole argument...technically MySQL is not free for commercial use. If you use MySQL in a commercial setting, internal or external, without purchasing a commercial license, you may do so only if the application that uses MySQL is also GPL (http://www.mysql.com/products/licensing.html). This is something that many companies (and developers) would prefer to avoid, for various reasons. PostgreSQL has no such requirement as it is distributed under the BSD license. John - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Also the clob and blob support is closer to the standard jdbc implementation than under postgresql. Admitably I haven't looked lately to be sure of that statement, and oracle isn't quite standard, but it's alot closer that what I saw in postgresql. For a home project I'd consider postgresql, but for work it's going to be oracle. Besides most of our customers explicitly require oracle, or MS SQL, so it's not like I have a big choice. The next most likey contentors usually end up being informix or db2. And for really small stuff I can get away with something like hypersonic, but only if they don't know (it's not that I'm trying to hide things, it's just that they don't care). Oracle also has some really nice xml/xsl tools, which I haven't see for the other databases. Their XSQL servlet is really really nice for implementing pre-filled in forms and other types of pages when your sql is static. And their implmentation of the XSL transform is about 2-2.5 times faster than xalan. All in all I'm a fairly happy oracle customer (although indirectly as I don't purchase oracle, the customer does). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:13 PM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) I have an oracle administrator. It's no problem. I also have an oracle support contract, if it's beyond the admin I have additional resources. And not to start a flame war, but postgresql isn't quite to the level that I need professionally yet. It's getting there, but its not quite there yet. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:35 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. There is no comparison. PostgreSQL is very simple to install and run. Oracle requires an Oracle administrator ($$$) to install. I don't think a database can be much easier to install than PostgreSQL, especially if you're on windows. Just install Cygwin and it has postgresql installed automatically (if you select the database option). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
I wholeheartedly recommend postgresql. It gives you a lot of room to grow, if you need more performance, etc. If you are at the point of considering transactions, then I personally think you're better off with postgresql. Mysql has only recently added transaction support compared to Postgresql. And if you make oodles (sp?) of money, then you can afford whatever Oracle software/support staff you want. If you are using Linux, I explain most of the setup at: http://daydream.stanford.edu/tomcat/install_web_services.html Between apache/tomcat/mod_jk/postgresql/, the easiest one to setup was postgresql. My 2 cents, Oscar On Tue, 18 Feb 2003, Michael wrote: I love postgresql. It's free, very robust, and very fast. It has GUI admin programs available for it too which is nice. And it's an industrial strength database. Hypersonic or cloudscape are good for small projects, PostgreSQL is great for any project. Michael -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 8:14 PM To: Tomcat Users List; Jens Skripczynski Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Hypersonic, best thing is that it's written in java, and can be embedded into your applications. Also, you can setup the tables to be in memory, or on disk... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:20 AM Cc: [EMAIL PROTECTED] Subject: [OT] free Database with Transaction (Sorry for the noise) hi, I'm looking for a Database, that can do - sql transactions, (or anything similiar to sql - if it works with a xml database, xml is fine) - has a java 1.4.1 jdbc driver - is free (even better if for commercial use) 'Mysql' was my first option, but it does not have transactions. In an _old_ computer magazine i found 'instantdb' but this one seems to be discontinued. The database tables i want to create, are only for one application. So a client server system or connection pooling are not neccessary. If someone knows what 'instantdb' is, its features seem to be enough. Anything additional is good. But i think the 'free' statement reduces the return results to '0'. :( Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com In this world there are only two tragedies; one is not getting what one wants, the other is getting it. -- Oscar Wild - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
According to MySQL's licensing page, you only need to worry about the software license at all if you are distributing MySQL code. If you are only using it (for instance, to serve data to your web application), you do not have to license MySQL, even if your web application's code is not distributed under the GPL. http://www.mysql.com/products/licensing.html -Jake - Original Message - From: Jeff Tulley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 3:16 PM Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Sorry to add to the noise, but I feel the need to add: On the next version of NetWare (6.5), there will be a commercially-licensed copy of MySQL that an application can use without the restrictions John listed. In case that helps anybody decide for or against using it. Jeff Tulley ([EMAIL PROTECTED]) (801)861-5322 Novell, Inc., the leading provider of Net business solutions http://www.novell.com [EMAIL PROTECTED] 2/18/03 12:57:34 PM Without going into a whole argument...technically MySQL is not free for commercial use. If you use MySQL in a commercial setting, internal or external, without purchasing a commercial license, you may do so only if the application that uses MySQL is also GPL (http://www.mysql.com/products/licensing.html). This is something that many companies (and developers) would prefer to avoid, for various reasons. PostgreSQL has no such requirement as it is distributed under the BSD license. John - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
That's not the way I read it at all. But, that's a topic for another place. John -Original Message- From: Jake Robb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 3:52 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) According to MySQL's licensing page, you only need to worry about the software license at all if you are distributing MySQL code. If you are only using it (for instance, to serve data to your web application), you do not have to license MySQL, even if your web application's code is not distributed under the GPL. http://www.mysql.com/products/licensing.html -Jake - Original Message - From: Jeff Tulley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 3:16 PM Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Sorry to add to the noise, but I feel the need to add: On the next version of NetWare (6.5), there will be a commercially-licensed copy of MySQL that an application can use without the restrictions John listed. In case that helps anybody decide for or against using it. Jeff Tulley ([EMAIL PROTECTED]) (801)861-5322 Novell, Inc., the leading provider of Net business solutions http://www.novell.com [EMAIL PROTECTED] 2/18/03 12:57:34 PM Without going into a whole argument...technically MySQL is not free for commercial use. If you use MySQL in a commercial setting, internal or external, without purchasing a commercial license, you may do so only if the application that uses MySQL is also GPL (http://www.mysql.com/products/licensing.html). This is something that many companies (and developers) would prefer to avoid, for various reasons. PostgreSQL has no such requirement as it is distributed under the BSD license. John - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
closer? Ummm, maybe, but still hideously broken. If you're using BLOBs from Java, forget both Oracle and PostgreSQL - their JDBC drivers are horrible. And if you want to lie awake at nights shivering, desperately trying to clear your mind of a gastly, horrible vision - take a look at the timestamp handling code in the PostgreSQL JDBC driver... PostgreSQL may be a lively project, but the JDBC driver is not :-( I'm surprised that Firebird doesn't get more press. It's a full-featured database with a *good* JDBC driver. In fact, it's one of the few databases (commercial or otherwise) that provide a JCA driver so it seamlessly plugs into JBoss. BLOB support is great. Runs with production-level stability on just about any platform. *Fantastic* GUI tools (the IBOConsole is almost as nice as Microsoft's tools). I've spent a lot of time developing with PostgreSQL, MySQL, Firebird, and all of the big commercial RDBMS'. Firebird is in my opinion not only the most pleasant free offering to work with, but also better than most of the commercial offerings (don't get me started on Oracle). Jeff Schnitzer [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:26 PM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) Also the clob and blob support is closer to the standard jdbc implementation than under postgresql. Admitably I haven't looked lately to be sure of that statement, and oracle isn't quite standard, but it's alot closer that what I saw in postgresql. For a home project I'd consider postgresql, but for work it's going to be oracle. Besides most of our customers explicitly require oracle, or MS SQL, so it's not like I have a big choice. The next most likey contentors usually end up being informix or db2. And for really small stuff I can get away with something like hypersonic, but only if they don't know (it's not that I'm trying to hide things, it's just that they don't care). Oracle also has some really nice xml/xsl tools, which I haven't see for the other databases. Their XSQL servlet is really really nice for implementing pre-filled in forms and other types of pages when your sql is static. And their implmentation of the XSL transform is about 2-2.5 times faster than xalan. All in all I'm a fairly happy oracle customer (although indirectly as I don't purchase oracle, the customer does). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:13 PM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) I have an oracle administrator. It's no problem. I also have an oracle support contract, if it's beyond the admin I have additional resources. And not to start a flame war, but postgresql isn't quite to the level that I need professionally yet. It's getting there, but its not quite there yet. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:35 AM To: Tomcat Users List Subject: RE: [OT] free Database with Transaction (Sorry for the noise) If I'm going to go to that size I'd rather run Oracle. But if it's something small hypersonic is great. There is no comparison. PostgreSQL is very simple to install and run. Oracle requires an Oracle administrator ($$$) to install. I don't think a database can be much easier to install than PostgreSQL, especially if you're on windows. Just install Cygwin and it has postgresql installed automatically (if you select the database option). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Hi, I would like to stop this thread, i started. I would like to thank everybody for contributions. Many things i forgot to write. - I'm not the administrator of the final tomcat box, so needing any other database than mysql, needs a lot of talk with the admin. - yes, i did check the mysql website, but rely on (maybe outdated) information of computer magazines, that labeled the transaction support very limited. So for me Hypersonic is fine, since (i hope) i can copy the files in a war to my isp and i do not have to keep two databases up2date. As a summary (for the archive) (and as a homework for me) databases with jdk / jdbc support (highest version listed) - free: - Hypersonic now hsqldb (http://hsqldb.sourceforge.net/index.html) - pure java - supports jdk 1.4 - supports jdbc ?.? - JDBC Type ? Driver (4 since it is pure java ?) - postgresql (http://www.postgresql.org/) connectors: - PostgreSQL JDBC Drivers (http://jdbc.postgresql.org/) - supports jdk ?.? - supports jdbc 2.2 - JDBC Type ? Driver - sapdb (http://www.sapdb.org/) connectors: - SAP DB JDBC (http://www.sapdb.org/7.4/sap_db_jdbc.htm) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver - firebird (http://firebird.sourceforge.net/) connectors: - jbird (no homepage) (http://prdownloads.sourceforge.net/firebird/FirebirdSQL-1.0.0RC3.zip?download) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver almost free (for non-commercial use): - Mysql (http://www.mysql.com/) connectors: - MySQL Connector/J (http://www.sapdb.org/7.4/sap_db_jdbc.htm) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver $$$: - cloudscape (http://www-3.ibm.com/software/data/cloudscape/) - pure java - supports jdk 1.4 - supports jdbc 2.0 - JDBC Type ? Driver (4 since it is pure java ?) high-end $$$: - db2 (http://www-3.ibm.com/software/data/db2/) connectors: - ? - Oracle (http://www.oracle.com/ip/deploy/database/oracle9i/index.html) connectors: - ? --- Hope the informations i found now are correct. If some people that have proper information can fill the '??'. for the JDBC Type deffinition see: http://java.sun.com/products/jdbc/driverdesc.html P.S.: I did not belief this thread to grow so much. Again thx for the great help and for the others: _sorry_ for the noise. Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com Tollef Fog Heen Unix _IS_ user friendly... It's just selective about who its friends are. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OT] free Database with Transaction (Sorry for the noise)
Hypersonic does have a jdbc driver, it's a type 4. I think it's jdbc 2, but I'm not sure. Oracle supports jdbc version 2 at least, 3 I think, not sure. They're kind of funny, they don't always support all parts of the version that they're nearest too. They have a type 4 as well as the type that uses native libraries. They additionally have different types of type 4's, which you use depends on the application. DB2 also has a JDBC driver, but other than that I don't know. Also, cloudscape used to be part of the j2ee development kit, that version was free as I recall. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:37 PM To: Tomcat Users List Subject: Re: [OT] free Database with Transaction (Sorry for the noise) Hi, I would like to stop this thread, i started. I would like to thank everybody for contributions. Many things i forgot to write. - I'm not the administrator of the final tomcat box, so needing any other database than mysql, needs a lot of talk with the admin. - yes, i did check the mysql website, but rely on (maybe outdated) information of computer magazines, that labeled the transaction support very limited. So for me Hypersonic is fine, since (i hope) i can copy the files in a war to my isp and i do not have to keep two databases up2date. As a summary (for the archive) (and as a homework for me) databases with jdk / jdbc support (highest version listed) - free: - Hypersonic now hsqldb (http://hsqldb.sourceforge.net/index.html) - pure java - supports jdk 1.4 - supports jdbc ?.? - JDBC Type ? Driver (4 since it is pure java ?) - postgresql (http://www.postgresql.org/) connectors: - PostgreSQL JDBC Drivers (http://jdbc.postgresql.org/) - supports jdk ?.? - supports jdbc 2.2 - JDBC Type ? Driver - sapdb (http://www.sapdb.org/) connectors: - SAP DB JDBC (http://www.sapdb.org/7.4/sap_db_jdbc.htm) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver - firebird (http://firebird.sourceforge.net/) connectors: - jbird (no homepage) (http://prdownloads.sourceforge.net/firebird/FirebirdSQL-1.0.0RC3. zip?download) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver almost free (for non-commercial use): - Mysql (http://www.mysql.com/) connectors: - MySQL Connector/J (http://www.sapdb.org/7.4/sap_db_jdbc.htm) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver $$$: - cloudscape (http://www-3.ibm.com/software/data/cloudscape/) - pure java - supports jdk 1.4 - supports jdbc 2.0 - JDBC Type ? Driver (4 since it is pure java ?) high-end $$$: - db2 (http://www-3.ibm.com/software/data/db2/) connectors: - ? - Oracle (http://www.oracle.com/ip/deploy/database/oracle9i/index.html) connectors: - ? --- Hope the informations i found now are correct. If some people that have proper information can fill the '??'. for the JDBC Type deffinition see: http://java.sun.com/products/jdbc/driverdesc.html P.S.: I did not belief this thread to grow so much. Again thx for the great help and for the others: _sorry_ for the noise. Ciao Jens Skripczynski -- E-Mail: skripi(at)myrealbox(dot)com Tollef Fog Heen Unix _IS_ user friendly... It's just selective about who its friends are. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
On Tuesday 18 February 2003 18:20, Jens Skripczynski wrote: Hi, I'm looking for a Database, Firebird (www.firebirdsql.org) . Been using it, and its predicessors for about 10 years in major production Excellent Type 4 JDBC driver with built in support for JCA (lead developer is one of the Jboss people), small install, next to zero admin, large, active communitee, etc. etc. Phil -- Linux 2.4.4-4GB 8:36pm up 36 days, 2:25, 1 user, load average: 0.37, 0.18, 0.11 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] free Database with Transaction (Sorry for the noise)
Just thinking out loud -- ... - yes, i did check the mysql website, but rely on (maybe outdated) information of computer magazines, that labeled the transaction support very limited. ... almost free (for non-commercial use): - Mysql (http://www.mysql.com/) connectors: - MySQL Connector/J (http://www.sapdb.org/7.4/sap_db_jdbc.htm) - supports jdk 1.4 - supports jdbc 3.0 - JDBC Type 4 Driver That almost free (for non-commercial use) makes me wonder if your information might be old, or perhaps inaccurate. It's GPL, so it's free in the GPL sense, and has been several years. If you have concerns about restrictions on your license to your customer, contact them and describe what you're doing. Last I recall, querying the database through a driver was not considered linking directly to the API, so the so-called viral aspects of the GPL would not be invoked. You might want to ask. As an opinion without experience, giving the customer their source code under a GPL compatible license does not seem all that unreasonable to me. And, if I'm making much money on a project, it would not seem unreasonable to buy a license for MySQL that would allow the use of a license on my code not compatible with the GPL. MySQL version 4, which is the version said to have full transaction support, has now passed the beta stage. Some people say MySQL beta is better than Microsoft final, but I don't have enough experience to say. Like I say, just thinking out loud. -- Joel Rees [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
