Tag: Java Stored Procedures

All posts tagged with 'Java Stored Procedures'

Some thoughts about user defined functions (UDF) in databases

06-Jul-24

Last week I came across a Twitter thread about using stored procedures or in other words, user defined functions in databases. Every myth about them has already been debunked like 13 years ago in this excellent post: Mythbusters: Stored Procedures Edition. I can completely get behind it, but also like some personal thoughts and share […]

Read the complete article »

JDBC: Get autogenerated keys on a Oracle DB

09-Oct-07

With the current and latest Oracle JDBC Drivers it’s possible to retrieve one automatically generated key based on a sequence or any other arbitrary value (autogenerated-keys or identity columns in other databases). Certainly it isn’t as simple as just use using Statement.html#getGeneratedKeys() as it simply returns an emtpy resultset. After browsing around, i saw that […]

Read the complete article »