Tag Archives: Java

New endeavor

Long time no see! It’s been a long while since I have posted anything on my blog.

Now, however, is a time to come back. I’ve been busy the past three years – here’s what I’ve been doing:

  • I’ve started writing a book for beginners about software development in Java – it is available for free on my other site: https://kursjava.com – up to date there are 9 chapters ready, contributing to over 450 pages, and about 7 more chapters are yet to come. The book is in Polish language.
  • I’ve written a document titled Craftsmanship of Software Development – it is a collection of my thoughts about what it means (and what it takes) to be a successful developer. It is available here (in English): https://craftsmanshipof.software
  • I have successfully taught a person who had no prior experience with software development to do programming in Java, and to use SQL and Git. That person has now been working for almost 2 years as a happy Java developer.

This last item is the most important to me – since the day I’ve proven to myself that I can do it, I wanted to do it on daily basis. I’ve quit my job a few months ago and, step by step, I will by trying to find more people who would like to learn programming and teach them.

I also have many other ideas related to teaching software development and I will try to bring them to life – first of those is a Git training. Stay tunned to learn when the first one will take place (most probably in July).

Returning BLOB From Embedded Java

- Waiter! There's a BLOB in my Java!

Returning a BLOB from a Java Method Embedded in a Database

You’re about to learn your future

Oracle supports embedding Java classes in its database. Different SQL types are mapped to corresponding Java classes to allow us to make the most of this feature. Author of the following question on StackOverflow:

create-java-sql-blob-instance-in-java-stored-procedure

had an issue with returning a BLOB object from Java method back to PL/SQL context. In the beginning, I didn’t even think you could return a new BLOB object from an embedded class. Fortunately, there was a BLOB in my Java, too. Continue reading

Connecting to Oracle Database
Using TNSNAMES.ORA in Java

Knock knock

Utilizing TNSNAMES.ORA in Java

– You have to use TNSNAMES.ORA.
– TNS-what?
– TNSNAMES.
– What-names?
– T N S N A M E S!
– What-what?

In the following thread on StackOverflow:

how-to-connect-jdbc-to-tns-oracle

a question concerning usage of net service names, stored in the TNSNAMES.ORA file, was asked. Let me briefly explain how to connect to Oracle using this approach. Continue reading