Category Archives: Uncategorized

by

dbeaver error when connecting to postgresql

so i happened to experience error when trying to connect to postgresql via dbeaver.

after lurking on the internet there are three steps need to do:

  • install jdbc driver for postgresql here https://jdbc.postgresql.org/
  • check if java already installed:
    by opening command prompt and type this:

where java

if error then java is not installed, you need to install java.

  • after that then you need to copy the ca sertificate from java to dbeaver installation directory.
    from java installation go to lib/security folder, there you’ll see cacert file, copy and paste it to the same lib/security inside dbeaver installation folder, just overwrite the current cacerts file.
  • then go to dbeaver installation folder llok for dbeaver.ini file, erase this line:

-Djavax.net.ssl.trustStoreType=WINDOWS-ROOT

try closing the dbeaver apps if open, the try opening the app again and try to connect to progresql db, it should be working right now and auto download necesary files.

by

Network Error (tcp_error)

Network Error (tcp_error)

A communication error occurred: “Operation timed out”
The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

For assistance, contact your network support team.

by

Installing BI Publisher in windows 64 bit with office 32 bit

Now with the new program we are upgrading our system to a new one, from oracle 8i+dev 6i to the latest oracle db 12c + dev 11g/10g.

in my system: 64bit windows 8.1, office 2013 32 bit.

**Installing BI Publisher.

there are some notes in regard of program installations:
– the bit version of java must be the same with the bit version of BI publisher, if it is 32bit then all 32bit.

– the BI bit version must be the same with the office version, if office is 32 bit then the BI publisher must also a 32bit version, even though the system is 64bit.

– since BI somehow unable to detect the java installation, since they check in wrong registry folder -duh-… so you must export and import the registry setting.
1) first open registry, look for HKLM\SOFTWARE\WOW6432\JavaSoft\Java Runtime Environment 2) export the registry.
3) open the exported registry using a notepad.
4) remove WOW6432\ so the lines should be: HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime Environment. 5) save the file and import it back to the registry.
6) start installing BI Publisher.

– now is that enough? not yet, since when you open the office program, it will only show the manual, but not the BI tab. Now the step is for you to enter the installation folder of the BI Publisher.
if you not change anything, the default installation folder is: Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\DotnetInstallfiles. – there you just need to run the setup file.
– now open the the office program, the BI tabs should be there.

Featured

Hello world!

hallo, this is supposedly my technical blog. probably a junk for you, but i put it necessarily for me since i’m bad at remembering things…

so i write this just as sort of my journal of the technical problem i’ve experienced, in case i stumble upon the same problem in the future.