Site icon Embarcadero RAD Studio, Delphi, & C++Builder Blogs

How to connect to Oracle DB from Ubuntu Linux.

the future of starts demands massive productivity

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.

[crayon-67123b6242ef6808556432/]

 

When executing debugging, the following option is mandatory.

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

 

 

 

[In case of failure.]

[crayon-67123b6242f00491036005/]

Failure Review the environment on the Linux side.

 

[In case of success.]

 

The content saved by JSON of FDQuery1 is displayed.

 

Do you want to try Embarcadero’s Cross-Platform Development Framework? InterBase is an ultrafast, scalable, embeddable SQL database with commercial grade data security, disaster recovery, and change synchronization. Request a free full trial here.

Exit mobile version