Another great article can be found on Developer.com. They explain how to use Oracle’s ADF in JDeveloper, to create a conference-room reservation webapplication, with the data stored in a MySQL database (Oracle would do as well 😉 ). The article takes you further one step at a time, and at the end you have a working system.
Via the Oracle blogs I came across this excellent article about the alternatives to Point-in-time Recovery.
I especially like the way the redo-logs-files are read (it’s called logminer, introduced in 8i), to generate undo-information in the form of DML-statements.
Yeah right. Let’s migrate from Oracle to SQL Server. Of course a SQL Server DBA does know nothing about Oracle, so let’s do the migration automated. Thanks for pointing there, Eric.
Now I don’t want to start another Oracle vs. MS SQL Server war, but if your database (schema’s) can be ported to SQL Server, than you deserve SQL Server. Period.
What about:
– Multiple master replication?
– More than 8GByte of memory without needing another OS?
– Flashback queries?
– Virtual Private Database?
– Stored java-procedures/functions (.NET is on it’s way, earlier than SQL Server2005)
– External tables?
– More that 4GByte LOB’s? (Let’s store a SQL Server database in a BLOB!)
– Run on any OS besides Windows?
Shall I continue? Whatever! An Oracle database convertable to SQL Server should have been just that in the first place.
Excuse me for posting that JDeveloper contains a bug in the hyperlink component: it does not. It’s a bug in the tutorial, which I followed without thinking myself. The tutorial says: “press Hyperlink on the component palette”, whereas you need to press the hyperlink-button on the toolbar. That’s all.
I think there’s a bug in JDeveloper 10.1.3. On OTN there is a tutorial to create a simple JSP page, and one of the steps is to select some text, and turn in into a hyperlink. No matter how I try, the hyperlink appears AFTER the selected text, but being 0 characters wide, it’s unselectable/unclickable.
View what I did here.
An hour less of sleeping time. Or…another day an hour sooner?
With JDeveloper 10.1.3 I created my first “application”. The only thing it does right now is not printing “Hello World!” in some sort of language specific way, but…setting up a connection to the Oracle database on my server. It switches the “disconnect” menuitem on, and the “connect” menuitem off, so you can disconnect. When you do, the original state of the menuitems is restored.
When choosing Exit, Disconnect is called whenever a connection is still open.
Also, a successful connection will update the statusbar with the name of the DBMS producer (Oracle in this case).
I’ve learned:
– How to work with the IDE
– Java is case-sensitive
– The IDE helps you very much, which results in higher productivity. Especially the hints in the margin (lightbulbs) are quite usefull.
– Help is very good, but a bit on the slow side (reads from the internet)
– The number of components on the palette (as compared to Delphi) is very low
Oracle released a extension for JDeveloper, so you can write PHP-code. It’s available for both 9.0.5 and 10.1.2. Just download the extension, and extract the php-addin.jar to the {jdev_root}/jev/lib/ext directory and start JDeveloper (or restart it). In Tools->Preferences you can configure where your PHP-installation is, etc.
Note: the add-in does not seem to work in the 10.1.3 preview of JDeveloper.
Go here. Not just for the MSDN-subscribers anymore, but public availability. The download is about 450Mbytes.
About two months ago, I mentioned Oracle’s JDeveloper 10.1.3 preview.
I decided to get my hands dirty. Although I’m not the best Java developer (I have to learn the language first!) I’ve had my share of working with different IDE’s and development environments. What struck me as extremely usefull, were two things.
1) Refactoring
Almost with the click of your mouse you can rename (or something else) a part of your project, and JDeveloper will do the nasty work for you.
2) Import-suggestions
I don’t know if other versions of JDeveloper have this feature, but whenever using a function for which the library (don’t know the Java jargon yet) is not included yet, a hint suggesting “import javax.swing.UIManager; alt-Enter” comes up. If you do press alt-Enter, the suggestion is added to your import-list. Major feature! No more remembering in what library (sorry folks) that function (give me some slack) resides, just type it in, and JDeveloper will take care of it.
What annoys me, are the close-buttons on the tabs. They appear when you hover your mouse over the tab, say, to activate another tabsheet. But it’s big (on my screen) and within 10 minutes of playing with JDev I accidentally pressed it quite a few times. It’s no problem when you have outstanding changes, since JDev will ask you to save the file and at that moment you can press cancel. But unaltered files are closed in a jiffy.
Update: my point 2 is called “import assistance” as you can read on this page.