wp.jochen.hayek.name/blog-en

Category: relational databases

  • DBCP: database connection pooling (service)

    —

    by

    johayek
    in , , ,

    https://en.wikipedia.org/wiki/Apache_Commons http://commons.apache.org/proper/commons-dbcp/ — this one lists (most of) the following links: http://commons.apache.org/proper/commons-dbcp/apidocs/ http://commons.apache.org/proper/commons-dbcp/apidocs/org/apache/commons/dbcp2/package-summary.html#package_description https://git-wip-us.apache.org/repos/asf?p=commons-dbcp.git https://git-wip-us.apache.org/repos/asf?p=commons-dbcp.git;a=tree;f=doc;hb=refs/heads/master — examples Tomcat: https://tomcat.apache.org/tomcat-8.0-doc/jndi-datasource-examples-howto.html http://commons.apache.org/proper/commons-dbcp/configuration.html

  • SQLite vs Oracle SQL Developer – nope?!?

    —

    by

    johayek
    in , ,

    https://en.wikipedia.org/wiki/SQLite https://en.wikipedia.org/wiki/Oracle_SQL_Developer http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html https://stackoverflow.com/questions/1525444/how-to-connect-sqlite-with-java https://bitbucket.org/xerial/sqlite-jdbc/downloads/ (Looks like) SQL Developer is no longer able to interface with as many RDBMSs as explained in its list. https://en.wikipedia.org/wiki/Comparison_of_database_tools

  • Oracle DB as VirtualBox appliance (2017-06-14 update)

    —

    by

    johayek
    in ,

    http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html If you already are VirtualBox-minded, this is a very nice approach to get Oracle DB running.

  • “Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?

    —

    by

    johayek
    in , , , ,

    Why is this: 10.2.0.5 (why not “.so.10.2“?): ./usr/lib/oracle/10.2.0.5/client64/lib/libocci.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libclntsh.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libclntsh.so -> libclntsh.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libocci.so -> libocci.so.10.1 ./usr/lib/oracle/10.2.0.5/client/lib/libsqora.so.10.1 11.2.0.2.0 (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so -> libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libocci.so -> libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 11.2.0.4.0 (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so -> libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libocci.so -> libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 12.2.0.1.0 (why not “.so.12.2“?): ./usr/lib/oracle/12.2/client64/lib/libocci.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntshcore.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntsh.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntshcore.so -> libclntshcore.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntsh.so -> libclntsh.so.12.1…

  • Perl’s DBD::Oracle vs Debian

    —

    by

    johayek
    in ,

    https://metacpan.org/pod/DBD::Oracle https://metacpan.org/release/DBD-Oracle For accessing an Oracle DB server from a client computer (w/o its own Oracle DB server installation) you need “Oracle Instant Client” (a set of packages of installables for various computer architectures, supplied by Oracle for free): http://www.oracle.com/technetwork/database/database-technologies/instant-client/ You won’t find Oracle Instant Client for Debian (outside your organisation or company), but …:…

  • “Oracle Instant Client” vs Debian (resp. Ubuntu)

    —

    by

    johayek
    in , , , , ,

    http://www.oracle.com/technetwork/database/database-technologies/instant-client/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/ Of course “Oracle Instant Client” is closed source, does not comply with Debian rules, and cannot / may not be distributed through Debian channels. Oracle supplies RPM files for “Linux x86-64” but no “.deb” files. And presumably both Oracle and also the “Debian Project” disallow redistribution of “Oracle Instant Client” components as Debian…

  • Oracle Instant Client: “free, light-weight, and easily installed Oracle Database tools, libraries and SDKs for building and connecting applications to an Oracle Database instance”

    —

    by

    johayek
    in , ,

    http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/

  • how to create a Debian package from an RPM package? “rpm2deb”

    —

    by

    johayek
    in , , ,

    I moved the content to a wiki article, so this article is a little obsolete. https://en.wikipedia.org/wiki/Rpm_(software) https://en.wikipedia.org/wiki/Alien_(software) https://www.howtoforge.com/converting_rpm_to_deb_with_alien : alien -k … https://salsa.debian.org/perl-team/modules/packages/libdbd-oracle-perl/blob/master/debian/README Open questions: how to deal with dependencies specified within the RPM package? …

  • Oracle SQL scripts: how to use a variable for the table name

    —

    by

    johayek
    in , ,

    https://stackoverflow.com/questions/1179652/how-to-use-a-variable-in-oracle-script-for-the-table-name There is a “test table” and there is a “serious table” – use a variable name for the table(s) in question!

  • how can I create a copy of an Oracle table without copying the data?

    —

    by

    johayek
    in ,

    https://stackoverflow.com/questions/233870/how-can-i-create-a-copy-of-an-oracle-table-without-copying-the-data#233890 create table xyz_new as select * from xyz where rownum < 0; In Oracle SQL Developer use the menu-function (maybe right-click) on the table you want to operate on (i.e. that you want to copy), “Table“, “Copy…“, w/o checking “Include Data“.