Compiled application - PostreSQL connection with JDBC driver

1 回表示 (過去 30 日間)

Fragkiskos Nikolakis 2021 年 5 月 25 日

0
リンク

この質問への直接リンク

https://jp.mathworks.com/matlabcentral/answers/839330-compiled-application-postresql-connection-with-jdbc-driver

コメント済み: Michaela Konstantinou 2022 年 2 月 1 日

Hello!

I have created a script which creates a jdbc connection to a Postgresql database. In the editor the script runs fine, but when I compile the script it doesn't. I have included the driver into the required files and also the driver full path to static path of javaclasspath. Please help.I am using Matlab 2016b.

You may find below the code:

conn= database('db,'usern','pwd');
scriptfile= ['select "GPS_LON","GPS_LAT","SPEED_LOG_SPEED",'...
'"SHAFT_HORSE_POWER","ME_SHAFT_REVOLUTION",'...
'"ME_FUEL_PUMP_MARK","ME_SCAV_AIR_PRESS","ME_FO_FLOW","ME_FO_IN_TEMP",'...
'"ME_EXH_GAS_MEAN_TEMP","GE_FO_FLOW",'...
'"NO_1_DG_ELECTRIC_LOAD","NO_2_DG_ELECTRIC_LOAD","NO_3_DG_ELECTRIC_LOAD",'...
'"ENGINE_RM_TEMP","ME_TC_REVOLUTION",'...
'"NO_1_DG_EXH_G_TC_1_TO_3_TEMP",'...
'"NO_1_DG_EXH_G_TC_4_TO_6_TEMP",'...
'"NO_2_DG_EXH_G_TC_1_TO_3_TEMP",'...
'"NO_2_DG_EXH_G_TC_4_TO_6_TEMP",'...
'"NO_3_DG_EXH_G_TC_1_TO_3_TEMP",'...
'"NO_3_DG_EXH_G_TC_4_TO_6_TEMP",'...
'"TIMESTAMP_UTC",'...
'"VESSEL_UNIQUEID" from "Aframax_Data" where "TIMESTAMP_UTC">=current_date-2 and "VESSEL_UNIQUEID"=''1625'''];
results = fetch(conn,scriptfile);