This is what I searched for in order to find the above article:
- mediawiki mysql socket
Category: relational databases
-
Oracle SQL Developer – how to run it on Windows in English w/o admin rights?
- https://stackoverflow.com/questions/7768313/how-can-i-change-the-language-to-english-in-oracle-sql-developer
- https://stackoverflow.com/a/24532448/3119172
I chose the approach “set language at runtime“:
sqldeveloper.exe --AddVMOption=-Duser.language=enWorks like a charm.
On the Win7 PC at work I have no admin rights, therefore I cannot change the config file mentioned in the thread.
-
Oracle PL/SQL built-in packages: DBMS_OUTPUT, …
- https://www.safaribooksonline.com/library/view/learning-oracle-plsql/9781771375702/ – my PL/SQL course
In my PL/SQL course I came across this built-in package:
DBMS_OUTPUT. Theput_lineprocedure within that package reminded me of Ada, so I got curious to get to know its sister subroutines.My web search led me to this :
…
- http://shop.oreilly.com/product/9781565923751.do – Oracle Built-in Packages – Oracle Development Languages
- https://www.safaribooksonline.com/library/view/oracle-built-in-packages/1565923758/
- https://www.safaribooksonline.com/library/view/oracle-built-in-packages/1565923758/ch06.html – “Generating Output from PL/SQL Programs”, “DBMS_OUTPUT: Displaying Output”
- https://www.safaribooksonline.com/library/view/oracle-built-in-packages/1565923758/ch06s02.html – “UTL_FILE: Reading and Writing Server-side Files”
…
- https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/toc.htm – Database PL/SQL Packages and Types Reference
-
Oracle’s SQL Developer – they give it away for free
- https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html
- http://stackoverflow.com/questions/7768313/how-can-i-change-the-language-to-english-in-oracle-sql-developer – add a few AddVMOption-s in/to ide/bin/ide.conf
In international working environments I personally don’t want to see software developers use “indigenous languages” for software development, and I always go for English. And also: if you “google” for error / warning messages – what sense does it make to search for error messages in e.g. Alemannic?
-
O’Reilly Media video training course: Learning Oracle PL/SQL (by Darryl Hurley)
- http://shop.oreilly.com/product/0636920047087.do – the 2016 Hurley video training course
- http://shop.oreilly.com/product/9780596001803.do – the 2001 Pribyl&Feuerstein book
As I have full access to Safari (as an individual), I don’t pay for individual books and videos – as long as I only access them online (referring to the books) – so I can just start the video training course and see, how it goes. Right, O’Reilly Media let you view 15 lessons for free anyway.
I already knew, that PL/SQL is based on Ada, so the syntax did not surprise me.
The examples used in the course are available for downloading. The README file within the ZIP file explains, where to get updated sample code over time, but the ZIP file I downloaded from www.infiniteskills.com isn’t actually any different at all. The sample code is divided by chapters, but the sample files within the chapters should be sort of numbered (as a filename prefix), so they are easier to relate to the video sessions.
(to be continued)
-
iReport, some Oracle database, JDBC, SQLRunner, …
Your task is to interface a rather remote Oracle database with iReport.
But you are not really sure, whether you are able to successfully connect to the database at all.
And you want to “explore” the database, its tables, its “views” …
No CLI utility like sqlplus available as well.
I am trying SQLRunner.
Says something like “… cannot connect …“.
I search the web for its precise error message.
Leads me to a firewall problem, i.e. some firewall prevents me from accessing the Oracle database. Aha?!! The article (on Stackoverflow) says, I should use “telnet” in order to find out, whether I can access the port in question.
But there is no “telnet” on that Windows PC. Please see my telnet related articles:
But I have putty available, and I can make putty to react like “telnet with a GUI” – and yes, it looks like, I can’t reach the port at all. Let’s talk to the corporate network support team! But how to tell them, that using telnet I found out, I cannot reach that port? No, I can’t, because there is no telnet, and I can’t tell them of putty, because putty has not got installed properly, I “put” it there myself. What a mess! At least I know, what problem I am dealing with.
The colleague next to me had somebody solve the firewall problem for her (last week or so). She runs SQLRunner successfully (I showed her). She can properly look at the Oracle tables. She is happy. And I know, I have to get somebody to solve my firewall / network issue. And I will be happy myself “one day”.
http://Jochen.Hayek.name/wp/blog-en/tag/sqlrunner/ – my SQLRunner related articles
-
how to connect to a PostgreSQL database using JDBC w/o host
- https://en.wikipedia.org/wiki/Java_Database_Connectivity
- http://jan-lolling.de
- https://github.com/jlolling/sqlrunner
- https://github.com/JochenHayek/sqlrunner – my fork
I am giving Jan Lolling’s SQLRunner a try to connect to a local PostgreSQL database. SQLRunner is written in Java, and it uses JDBC to connect to the various databases.
Apparently there are 2 ways to connect to a PostgreSQL database:
- hostname + port + database + …
- socket + database + …
The 2nd way is not just a variant of the 1st (I got told).
It appears to me, that JDBC for PostgreSQL only supports the first way. Is there a way to get this assumption confirmed?
- http://stackoverflow.com/questions/25918416/jdbc-mysql-connection-using-unix-socket :
“Java itself doesn’t support unix domain sockets, but since you’re on windows, you can use named pipes, [..]” (I am not sure, this is true) - http://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html : NamedPipeSocketFactory …
-
Pre-Built Developer VMs for Oracle VM VirtualBox: Oracle DB, Solaris, …
It looks rather, rather intriguing to run a ready-made VM with Oracle DB. Let’s see, how and wether it will work out! A ready-made VM with Oracle DB: That would trueyl be the easiest way to improve my Oracle DB, and SQL, and PL/SQL skills – together with the fine o’Reilly books on the related topics. How often did I only abandon this idea, because it wasn’t that easy to install Oracle DB on Suse Linux…
Amongst the various choices I went for the “Database App Development VM” (still valid and unchanged on 2014-11-12):
- http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html (still valid and unchanged on 2014-11-12, but they say, they updated the document in September, so it may also be reasonable to download the “appliance” again)
Oracle Enterprise Linux 6 account details: Username and password is oracle.
And this very nice software will run on the very nice and fat Mac mini due to arrive tomorrow resp. on Wednesday. The “Oracle DB VM” will have its own and separate IP address on the LAN, that way the Oracle DB server will just be available on the LAN – w/o any restrictions because of its VM environment. This is going to be exciting and … breath-taking … – I will be able to learn Oracle DB and put that on my skill list.
Update 2014-07-16: For starting the Oracle Linux Server you need to have the VirtualBox “Extension Pack” installed as well – they don’t mention that on the page quoted above.
-
O’Reilly Media book: Oracle Essentials
http://shop.oreilly.com/product/0636920027737.do
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume, including a valuable overview of Oracle Database 12c. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. -
O’Reilly Media book: Oracle PL/SQL Programming, 6th Edition
Considered throughout the Oracle technology community to be the best Oracle PL/SQL programming book available, this guide is the definitive reference on Oracle’s powerful procedural language. Like its predecessors, this sixth edition covers language fundamentals, advanced coding techniques, and best practices for using PL/SQL.Thoroughly updated for Oracle Database 12c.