Setting up of Port forwarding to PostgreSQL from MATLAB
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi,
I have a MATLAB script that I used to run by connecting to the postgres database that is hosted on the server(Openshift).
I used to do port forwarding using database toolbox and hardcode the port number (see below 60733) in the MATLAB script each time to connect to the database
I'd like to automate this process so that when I open MATLAB I can directly run the script without having to generate the port manually all the timet. Is there any way to automare this DB connection ?
Note : I'm using Openshift PostgreSQL databse server hence I need to port forward from my machine to connect to this server
I have used database toolbox to connect the server DB using below credentials
databasename = 'employeedb';
username = 'user';
password = 'user123';
driver = 'org.postgresql.Driver';
url = 'jdbc:postgresql://localhost:60733/employeedb';
conn = database(databasename,username,password,driver,url);
countSqlquery = "SELECT COUNT(*) as count_pet FROM employees";
rowCount = select(conn,countSqlquery);
2 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!