Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
Delphi

How to connect to Oracle DB from Ubuntu Linux.

Author: h.mohri

 

At this point, Instant Client configuration is complete.

Finally, “./PAServer-19.0/paserver” is started up and ready.


 

 

[Create a new project.]

In Delphi IDE side, create a new project. Web Server Application, check Linux.

I chose “stand-alone console application” this time.

Place some components on TWebModule1.

TFDConnection, TFDPhysOracleDriverLink, TFDQuery, TFDStanStorageJSONLink

Return the contents acquired by FDQuery1 with JSON. Write the code.

There is a simple table and some records on DB side.

 

When executing debugging, the following option is mandatory.

“/usr/bin/xterm -e “%debuggee%””

 

 

 

[In case of failure.]

Failure Review the environment on the Linux side.

 

[In case of success.]

 

The content saved by JSON of FDQuery1 is displayed.

 

 

 

 

 


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
CodeDatabaseDelphiNews

Data ETL: Adding Custom LiveBindings To Your Apps

DatabaseDelphiNews

Connecting Databases with FireDAC through SSH

C++Code

2021 Annual C++ Developer Survey "Lite" by ISOCpp.org - Results summary

CodeDatabaseDelphiRAD Studio

Learn How Easy It Is To Map Dataset Columns With A Table Adapter In FireDAC For Delphi

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES