Oracle Database 10g Release 2 available (only on Linux right now)
Oracle just released (or at least I just saw) the availability of the Oracle 10gR2 database, for Linux. I assume that in a few days time we will also …
Category: Databases
Oracle Database 10g Release 2 – SQL and PL/SQL Features
![Oracle Database 10g Release 2 – SQL and PL/SQL Features]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Oracle Database 10g Release 2 – SQL and PL/SQL Features")
Arup Nanda writes about new features for the upcoming Oracle 10gR2 release, targeted at the end of June 2005. In this article, he discussues new SQL and PL/SQL features. …
Executing PL/SQL from ANT – how to keep the format straight
Just read the post Executing Oracle PL/SQL from Ant on how to use Ant for executing PL/SQL tasks, such as creating Packages and Stored Procedures. I have used Ant …
DB utilities – Oracle JPublisher enables you to easily access PL/SQL from Java
The tool JPublisher is a little bit unknown. But it is a very handy tool for accessing PL/SQL stored procedures, packages, functions as well as object, collection or reference …
Mastering XML DB – COUNT and SUM
May 20, 2005
AMIS, Announce / Events, Database, Databases, DBA Oracle, IT, Web HTML5 CSS3, XML
5 Comments
Working for years with Oracle’s relational environment, XML DB is a completely different kind of beast. You’re confronted with all the languages and techniques the XML environment has to …
Old undocumented stuff – Recompiling with timestamp.
Yesterday i was reading nice discussions on Asktom about the dual table. Afterwards somehow a "undocumented" Oracle feature popped into my mind again. Last time I used is at …
Customizing ORA, JBO and JHS error messages in JDeveloper with ADF
Recently I encountered the problem of overriding error messages in my project created in JDeveloper using ADF/JHeadstart. I wanted to get rid of messages containing codes like JHS-00106 and …
Oracle 10g's Finest – The Top 3 SQL and PL/SQL Features new in 10g – paper for ODTUG 2005
Papers for the ODTUG 2005 conference are limited to 10 pages. That is not enough. It never is, by the way. This time, I restricted myself to only three …
Refreshing a ViewObject on view in JHeadstart
Imagine this situation: you have created several tables and a view that queries several columns in these tables. Using BC4J you’d create a ViewObject on the view. The ViewObject …
Oracle10g Lite, scratching the surface
Over the last few days I scanned trough documentation about Oracle10g (Oracle 9i) Lite the get a overview of the possibilities. Furthermore I tried to install the product on …
Creating your own advanced search engine for any website – using Oracle Text – Searching the AMIS Technology Weblog
The Oracle 7Up workshop that I teach every few months introduces many Oracle 8i, 9i and some 10g features to experienced SQL and PL/SQL developers with a firm footing …
Registering non-default XMLDB HTTP/WebDAV and FTP ports on a non-default Oracle Listener port
Yesterday, I had to install XMLDB on an already very heavy used system. On this UNIX system, an old Oracle IAS is installed, OAS 10g (version 9.0.4) and an …
Migration from MySQL to Oracle – using Oracle Migration Workbench
All statistics on the visits to the posts in the AMIS Technology Weblog are gathered in a MySQL database that sist underneath WordPress. We would like to do some …
Oracle 10gR2: .Net stored procedures (C#, Visual Basic .Net, Visual C++)
This weekend I read a small article in a local Dutch IT-magazine that took me by surprise. I suppose I should have seen it before, but for some reason …
Discussion on The Server Side: Comparing Microsoft Yukon (SQL Server 2005, Beta release) with Oracle 10g
I ran into an interesting discussion on The Server Side: Comparing Oracle 10g and SQL Server Yukon. It contains a link to a white paper: Features, strengths, and weaknesses …
Tom Kyte part II. Using what we have learned
In this post we will tune a query from being hopelessly slow to fast. We will use “explain plan” to analyze the query plan. We will see how Oracle …
Stored Java to run an OS command, copy a file and get a directory listing in Oracle
Oracle 8.1.5 introduced the ability to choose Java as a language to implement a stored procedure. One of our customers required the following functionalities from within an Oracle database: …
Combine Oracle Toplink and the Spring Framework – Rod Johnson & Jim Clark
An interesting article Of Persistence and POJOs: Bridging the Object and Relational Worlds, by Rod Johnson and Jim Clark in Mastering J2EE Application Development Series on OTN (the Oracle …
Missed MySQL New Toolset
I apparently completely missed the new MySQL toolset, which was announced on December the 8th 2004. The MySQL database ships now with easy-to-use visual database tools: MySQL Query Browser …
Consuming Web Services from PL/SQL – Part II: A pure PL/SQL solution using UTL_HTTP (Oracle 9i or 10g)
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of the UTL_HTTP supplied package. In this article we will …
Voor de liefhebbers – Postgres SQL 8.0.0 voor Windows
Er is lang op gewacht, maar hij is er nu ook voor Windows – Postgres SQL 8.0.0. Volg de volgende link voor meer informatie: http://www.postgresql.org/about/news.277
Starting with JasperReports
January 20, 2005
AMIS, Databases, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
81 Comments
My first days at AMIS I examined JasperReports (v. 0.6.3), an open source report-generating library. This tool is entirely written in Java and uses XML report templates to generate …
Paper on JDeveloper as tool for PL/SQL Development
Tonight I completed a paper on using JDeveloper as a tool for Database Design and Generation as well as PL/SQL Development. This paper is in Dutch and will be …
MERGE!
When I was confronted with the challenge to import about 260 tables from two different Rdb’s into a single Oracle database (9.0.1.x) on a daily basis via a database …
Just before X-mas
On the 7th of December, I, a database administrator, had a seminar from Mr. Chris Date about “Relational Remodeled” (into the 21st century with the relational model: a technical …
XSL Transforming XML generated from SQL results using JSTL tags in JSP pages – putting JSTL to the test
While working on more advanced Statistics Reporting for our weblog, I did some investigations into JSTL and more specifically the XML and SQL tags. Yes, I know I have …
JDBC database copy of table contents
For one of our projects, we wanted to copy the contents of our production database to the test database. Both databases are accessible via JDBC. After an investigation of …
Toplink’s Object to XML mapping
November 25, 2004
Databases, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
No Comments
On OTN there is an excellent online seminar (replay) on the TopLink Object-to-XML support. This feature, which will be available in the upcoming 10.1.3 release, allows converting XML files …
Setting up Oracle JNDI Datasource on Tomcat
In one of the projects I’m involved in we have to make use of specific Oracle JDBC features. The application runs on Tomcat 5.0.27 and connects to the database …
Talk on Open Source Databases
Thursday the 7th of October a presentation was given on Open Source databases during an Amis (Server Development and Programming Languages) Knowledge Center meeting. The aim was to present …
A single POJO persistence model to replace JDO and take over much of EJB??
Java and persistence are hot. And continue to be hot. If I read things correctly, Sun – through Linda DeMichiel and Craig Russell Specification Leads, JSR-220 and JSR-243 – …
New Oracle JDBC driver
After getting a weird NullPointerException using Transaction.commit() in Hibernate during an insert (eventually calling PreparedStatement.clearParameters() which was the source of the exception), it turned out that the JDBC driver …
Hibernate kickstart
A quick’n dirty tutorial-by-example for Hibernate: (Using one table, an Oracle9+ database and Hibernate2) 1) download the Hibernate distribution 2) put these jarfiles in /WEB-INF/lib: hibernate2.jar (hibernate core) cglib-full-2.0.2.jar …
Some Hibernate links to get started
Some links to get started with Hibernate: Quickstart with Tomcat "Hibernate Your Data" – ONJava Quickstart Configuration Properties Hibern8IDE
New open source databases: Cloudscape (Apache Derby) and Ingres
Recently, IBM announced the open-sourcing of their Cloudscape database. a lightweight, Java-based relational database with a footprint of just 2MB. It’s significantly less resource-intensive than enterprise databases like IBM’s …
Expert Session on Persistency Framework: Toplink
Yesterday we had an excellent meeting on Java persistency frameworks, in particular Toplink. Oracle Consultant and Java expert Peter Ebell presented on his experiences with Toplink on a very …
MySQL, stored procedures and callable statements
The stable 3.x versions of MySQL don’t support stored procedures. Consequently the associated JDBC driver can’t support callable statements. The alpha 4.x versions don’t support stored procedures either, but …
Oracle Data Cartridge – Extending the Database
Oracle Data Cartridge is a technology component, part of the Oracle RDBMS (ever since the 8i release), that allows developers to extend the functionality of the database. One area …
Comparison Oracle, PostgreSQL and MySQL
A research team of the Alice project from the Dutch Institute for Nuclear and High Engery Physics (NIKHEF) wrote a very elaborate comparison on Oracle, PostgreSQL and MySQL. This …
Getting started with MySQL
If you have just installed the MySQL RPMs and wonder what to do next, check out Getting Started with MySQL. This is a wonderful concise to-the-point comprehensible “getting started”, …