search

opensourcecobol / Open-COBOL-ESQL

Open Cobol ESQL (ocesql) is an open-source Embedded SQL pre-compiler and run-time library designed for COBOL applications which access an open-source database.
https://www.osscons.jp/osscobol/
GNU Lesser General Public License v3.0
50 stars 24 forks source link

What about the issue of execution result on ubuntu22.04 that the result of execution is Cannot find module 'OCESQLConnect'? #110

Closed YUSU189501 closed 10 months ago

YUSU189501 commented 10 months ago

It compiles on ubuntu22.04, but the execution result is Cannot find module 'OCESQLConnect'. export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export COBCPY=/opt/Open-COBOL-ESQL-1.3/copy cobc -x -locesql -lpq -L/usr/lib/postgresql/16/lib dbsample.cob ./dbsample libcob: Cannot find module 'OCESQLConnect' I installed and ran Open COBOL ESQL v1.3. What are the solutions?

YUSU189501 commented 10 months ago

By the way

export COBCPY=/homedir/Open-COBOL-ESQL-1.3/copy

export LD_LIBRARY_PATH=/usr/local/lib

cobc -x -locesql -lpq -L/usr/lib/postgresql/16/lib dbsample.cob

cobcrun dbsample

libcob: Cannot find module 'dbsample'

Do you know what the cause is?

YUSU189501 commented 10 months ago

Self-resolved.

The command is as follows.

export COPY=/opti/Open-COBOL-ESQL-1.3/copy

export SCR=/usr/local/share/opensource-cobol-1.5.2J/copy

export OC_OBJ=/opt/Open-COBOL-ESQL-1.3/dblib

ocesql dbsample.cbl dbsample.cob

cobc -x dbsample.cob $OC_OBJ/ocdb.o $OC_OBJ/ocdblog.o $OC_OBJ/ocdbutil.o $OC_OBJ/ocesql.o $OC_OBJ/ocpgsql.o -I$COPY -I$SCR -locesql -lpq

./dbsample Execution Result. 0001apple

SELECT statement in postgresql. mydb=> select * from test mydb-> where tid='0001'; tid | tname ------+------------ 0001 | apple (1 行)