Computer science thoughts

Scripts and tips

Talend : bind variables in SQL query


Problem exposed. On Talend, there is no SQL component allowing to make a select query prepared with the binding of variables, as on dBeaver. It would indeed be interesting to be able to make a request as below, by...

Number of opened/openable files on Linux


On Linux as on Windows, there are thresholds fixing the number of files open simultaneously per process and for the whole system. Here are some commands to display them.

Allow geolocation in HTTP


If you develop a website locally, you do not necessarily use an SSL certificate. Unfortunately, this blocks certain features, such as geolocation. Here's how to work around the problem.

Talend: fix "Plugin X or one of its dependencies could not be resolved"


On Talend, you can have the following exception: "An error occurred (java.lang.Exception: [ERROR] Plugin X or one of its dependencies could not be resolved: Cannot access central (https://repo1.maven.org/maven2/) in...

Talend: avoid modifying context variables during a job


On Talend software, on a job, it's possible to assign the value of a context variable, via a tJava, by writing for example: context.myVariable="abc";There is no error and most of the time it goes very well. Except...

Read and edit ePUB files

Various tips

An overview of some software on Windows to read and modify ePUB files.

Fix "Unknown: failed to open stream: No such file or directory in Unknown on line 0"


While viewing your website, you may have the following two errors displayed: Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0 Fatal error: Unknown: Failed opening required...

Auto-assign the last modification time of a row (PostgreSQL/MySQL)


Depending on the DBMS, the way to automatically assign the date and time on the modified lines differs.

Synchronize a PocketBook eReader with a personal server

Various tips

If you have a "Tea" brand e-reader (Vivlio), Inkpad or Touch HD model, here is a way to synchronize it with a personal server.

Fix Talend when it's not using the right execution context


It may happen that Talend Open Studio does not use the correct execution context. Typically, you run it on the pre-production context, and the variables it uses are NULL or unexpected values. This can cause for...

Page 1/3 Next page →

Search in this website

fr en rss RSS info Informations