Hi all,
I am developing a software for a small inventory application.I have to
sell it to my customer.
I want to use a free database for my project.For my application to run
at the ustomers office, my customer also needs the database.I am using
java as front end.So is there any database that i can use free of cost
to develop my application and make my customer also get the database
software without any cost so that my application will run at his
office.
If I use hsqldb will I face any license issue.Can anyone please help.
Arto Viitanen - 23 Feb 2006 07:44 GMT
> Hi all,
> I am developing a software for a small inventory application.I have to
[quoted text clipped - 5 lines]
> software without any cost so that my application will run at his
> office.
Oracle, IBM and Microsoft have versions of their databases (Oracle,
DB2 and SQL Server) that are free to use and distribute with your
application. I guess Oracle and DB2 are better choises when using Java.
> If I use hsqldb will I face any license issue.Can anyone please help.
From the FAQ:
May I use HSQLDB in a commercial product?
Yes. HSQLDB is Open Source and free to use in any commercial product so
long as the terms of the Licenses are met. The Licenses of HSQLDB and
Hypersonic SQL (on which HSQLDB is based) are both based on the new BSD
License.
--
Arto Viitanen, CSC Ltd.
Espoo, Finland
raam - 23 Feb 2006 08:22 GMT
Thank you Arto.
Wll i have to give my java code also as open source if i use java and
hsqldb?If anybody knows please help me.
Thomas Kellerer - 23 Feb 2006 08:40 GMT
> Thank you Arto.
> Wll i have to give my java code also as open source if i use java and
> hsqldb?If anybody knows please help me.
I assume you don't have to. This is taken from the hsqldb license:
Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are met:
Redistributions of source code must retain the above copyright notice, this
list of conditions and the following disclaimer.
Redistributions in binary form must reproduce the above copyright notice,
this list of conditions and the following disclaimer in the documentation
and/or other materials provided with the distribution.
Also there was a similar question asked in the forum on sourceforge:
http://sourceforge.net/forum/forum.php?thread_id=1243991&forum_id=94352
where Fred (the maintainer of HSQLDB) clearly answered "Yes, it is free
to use in binary form"
To be sure you might want to ask again describing your situation. Fred
is very helpful in answering questions.
Thomas

Signature
It's not a RootKit - it's a Sony
raam - 23 Feb 2006 09:29 GMT
I thank all the people who have answered the question and google .Thank
you all.
> > Thank you Arto.
> > Wll i have to give my java code also as open source if i use java and
[quoted text clipped - 22 lines]
>
> Thomas
Roedy Green - 23 Feb 2006 15:03 GMT
>Thank you Arto.
>Wll i have to give my java code also as open source if i use java and
>hsqldb?If anybody knows please help me.
well certainly not Java and I strongly doubt a database. Using code
is different from extending it.

Signature
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
jcsnippets.atspace.com - 27 Feb 2006 22:45 GMT
> Thank you Arto.
> Wll i have to give my java code also as open source if i use java and
> hsqldb?If anybody knows please help me.
No, you don't have to give away your code if you use an open source library
or something similar.
You only need to give away your source code if you extend the library or
whatever you are using. That's basically the idea behind open source -
everyone may use it, but everyone must also be able to benefit from the
modifications you made.
And even if you modify an open source library, you don't have to give the
code to your project away - only the modifications you made to the open
source library.
Hope this helps,
JC
--
http://jcsnippets.atspace.com
a collection of source code, tips and tricks
raam - 28 Feb 2006 09:01 GMT
Wonderful,
Clearcut excellent answer.Thank you sir.
Dyreatnews@sun.com - 28 Feb 2006 12:21 GMT
>> Thank you Arto.
>> Wll i have to give my java code also as open source if i use java and
[quoted text clipped - 11 lines]
> code to your project away - only the modifications you made to the open
> source library.
This is not true for all open source licenses. The Apache license
allows you to make modifcations and redistribute without giving it
back (although you are encouraged to do so).
The details can be found here
http://www.apache.org/foundation/licence-FAQ.html

Signature
dt
jcsnippets.atspace.com - 02 Mar 2006 22:27 GMT
<snipped>
> This is not true for all open source licenses. The Apache license
> allows you to make modifcations and redistribute without giving it
[quoted text clipped - 3 lines]
>
> http://www.apache.org/foundation/licence-FAQ.html
Ah - thanks for pointing this out to me, I did not know that. But isn't the
Apache license a separate license on it's own?
I must admit that I do not know all the details of open source, only that I
stumble upon decent OS projects very regularly.
Best regards,
JC
--
http://jcsnippets.atspace.com/
a collection of source code, tips and tricks
Bill Karwin - 02 Mar 2006 23:59 GMT
>> This is not true for all open source licenses.
>
[quoted text clipped - 5 lines]
> I
> stumble upon decent OS projects very regularly.
Here's a starting point for learning more about open source software
licensing.
http://en.wikipedia.org/wiki/Open_source_license
Note the large number of distinct licenses -- and these are just the
licenses approved by the Open Source Initiative!
The GNU Public License is the one most people think of as "viral." That is,
if you distribute some software licensed under the GPL, your own software
you distribute with it automatically becomes licensed under the GPL as well.
There is also a GNU Lesser Public License, which is widely used for software
libraries, to permit use in commercial distributions without causing the
proprietary software to have to adopt the GPL.
Also see http://en.wikipedia.org/wiki/Viral_license.
There are many other specific open-source licenses, some of which may be
"viral," but many of which are not.
Finally, the best policy is that no one should *ever* rely on legal advice
from internet folks like us. Read the licenses for yourself, and consult a
lawyer to double-check.
Regards,
Bill K.
Jeroen Wenting - 01 Mar 2006 19:24 GMT
>> Thank you Arto.
>> Wll i have to give my java code also as open source if i use java and
[quoted text clipped - 12 lines]
> code to your project away - only the modifications you made to the open
> source library.
Unless the library is GPL licensed (which hSQL isn't), in which case any use
requires everything using it to be GPL as well.
tom fredriksen - 23 Feb 2006 11:00 GMT
> Hi all,
> I am developing a software for a small inventory application.I have to
[quoted text clipped - 6 lines]
> office.
> If I use hsqldb will I face any license issue.Can anyone please help.
There are countless other open source database out there: mysql,
firebird, postgress, etc All of the mentioned are used quite a lot in a
business/production environment. ut of course no where near as much as
oracle, db2 or sqlserver.
You can search freshmeat.net or sourceforge.org if you want to find
other open source sql databases.
/tom
Jon Martin Solaas - 23 Feb 2006 12:33 GMT
>> Hi all,
>> I am developing a software for a small inventory application.I have to
[quoted text clipped - 16 lines]
>
> /tom
Yup, lots of alternatives exist. The character of the project should
determine which variant to use. Any small-footprint java-based database,
like hsqldb, mccoy etc. would be very simple and convenient to integrate
into the java project itself. However, many pros and cons should be
considered. What if you have a small project now and want to re-use code
in a larger project later where hsqldb doesn't quite cut it? Could be
better to go for Oracle then, or PostgreSQL/MySQL (I prefer PostgreSQL
for it's mature design and featureset) if opensource is a requirement.
Alexey Shevchenko - 27 Feb 2006 16:46 GMT
My SQL is the free DB which used for most host providers as main DB.
But there are problem with nested "select"
For ex: "select * from select ... "
If I remeber after version 4 it is not a problem any more.
> Hi all,
> I am developing a software for a small inventory application.I have to
[quoted text clipped - 6 lines]
> office.
> If I use hsqldb will I face any license issue.Can anyone please help.
Bill Karwin - 27 Feb 2006 17:47 GMT
> My SQL is the free DB which used for most host providers as main DB.
> But there are problem with nested "select"
> For ex: "select * from select ... "
> If I remeber after version 4 it is not a problem any more.
Correct. MySQL 4.1 was released into production in October 2004, and that
version supports SQL subqueries. However, not all ISP's who support MySQL
have upgraded to 4.1 yet.
MySQL 5.0 was released into production in October 2005.
Regards,
Bill K.
Jeroen Wenting - 01 Mar 2006 19:25 GMT
and tons of licensing issues...
> My SQL is the free DB which used for most host providers as main DB.
> But there are problem with nested "select"
[quoted text clipped - 10 lines]
>> office.
>> If I use hsqldb will I face any license issue.Can anyone please help.
Jacob Barde - 03 Mar 2006 16:04 GMT
Sorry one more thing...
If I recall correctly, if you develop an application based on MySQL then
sell it to a customer, I believe the customer has to have purchased a
license of some sort from MySQL Corporate to be in legal compliance...
Of course, I could be wrong, so check MySQL FAQs or inquire directly.
That said, several of the other free (or free version available)
database that have been mentioned have no strings attached licenses.
> and tons of licensing issues...
>
[quoted text clipped - 12 lines]
>>> office.
>>> If I use hsqldb will I face any license issue.Can anyone please help.
Dyreatnews@sun.com - 27 Feb 2006 19:32 GMT
> Hi all,
> I am developing a software for a small inventory application.I have to
[quoted text clipped - 6 lines]
> office.
> If I use hsqldb will I face any license issue.Can anyone please help.
Derby has the Apache license. And you can embed it in your java app if
that suits your needs
http://db.apache.org/derby/

Signature
dt
jcsnippets.atspace.com - 27 Feb 2006 22:45 GMT
> Hi all,
> I am developing a software for a small inventory application.I have to
[quoted text clipped - 6 lines]
> office.
> If I use hsqldb will I face any license issue.Can anyone please help.
Have a look at either MySql (open source) or Oracle XE.
Personally (coming from a deep Oracle background) I'd choose the XE - you
get the Oracle database for free, you can even use it in production for
free. The only catch is that the database size may not be bigger than 4GB,
but for small applications this is almost never a problem.
Best regards,
JC
--
http://jcsnippets.atspace.com
a collection of source code, tips and tricks