It is possible to connect a WMS layer to a SQL database or other type of database?
Example: I have created an application with GeoServer and OpenLayers. Now I can see the data from attribute table. But can I make the SHP layer to connect to a SQL database by a custom ID? I want to use this to update some data directly from SQL. After the update was made, I can see in GeoServer the data updated.