sqlwrite() not working

4 次查看（过去 30 天）

Luis Davila 2022-1-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1623100-sqlwrite-not-working

评论： Kojiro Saito 2022-1-12

I am working on a database project, and am trying to create a JDBC datasource in matlab using code instead of the Database toolbox.

I use the following code to create a database connection.

vendor = "PostgreSQL";
opts = databaseConnectionOptions("native",vendor);
opts = setoptions(opts, ...
    'DataSourceName',"second_test", ...
    'DatabaseName',"postgres",'Server',"localhost", ...
    'PortNumber',5432);
%test the connection, this should return a 1 if the test is passed
status = testConnection(opts,username,password);
%saves the datasource
saveAsDataSource(opts)
%data1 should be a row of data 
data1 = table("a","b","c",'VariableNames',["one","two","three"]);
%should create a connection to the database, and seemingly does
conn = postgresql('second_test',username,password);
%should write the row data1 to the table, this is where it fails, the table
%is not actually written to
sqlwrite(conn,table,data1)

The data source is successfully saved, but sqlwrite(conn,tablename,data1) fails, because no new rows are written to the table. I believe the problem is I'm setting the wrong options, but I don't know what the right options are. If someone could please shed some light I would be very appreciative.