Originally posted by Frank Carver:
Java is platform-neutral. You can (mostly) upgrade hardware and operating systems with no problems. Stored procedures (whatever their language) are not.
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Originally posted by Frank Carver:
Yes, but not all databases have them, and not all databases implement them in the same way.
We all know that writing some Java code which will only run on Windows is probably a bad idea. How can writing some Java code which will only run on Oracle be seen as a good idea ?
Thank you.<br /> <br />- Jess Sie<br /> <a href="mailto:[email protected]" rel="nofollow">[email protected]</a>
Originally posted by Frank Carver:
Yes, but not all databases have them, and not all databases implement them in the same way.
We all know that writing some Java code which will only run on Windows is probably a bad idea. How can writing some Java code which will only run on Oracle be seen as a good idea ?
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Originally posted by Frank Carver:
Do they force you? I am not sure...
I routinely test my home-written database applications on MySQL, PostgreSQL, Access/Jet, and Hypersonic SQL. Although I usually need a few tens of lines of code per database for optimisation and customisation, the same basic application runs unchanged on all these databases.
Although I often use Oracle for clients, I don't have Oracle set up for my own use. In the past, though, I have encountered stored-procedure code which prevented the application being run on anything except Oracle 7.3.4, though.
SQL, accessed via JDBC, runs on all the above databases. I would be astonished to hear of any stored-procedure solution which will run on all those databases. Please correct me!
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Originally posted by Frank Carver:
Can you imagine Microsoft building a version of their "Jet" database engine which supports Java of any sort ?
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Fire me boy! Cool, soothing, shameless self promotion:
New web page for Paul's Rocket Mass Heaters movies
https://coderanch.com/t/785239/web-page-Paul-Rocket-Mass
|