search

LSIR / gsn

Global Sensor Networks
GNU General Public License v3.0
58 stars 43 forks source link

database table #82

Closed mvishnuprathap closed 7 years ago

mvishnuprathap commented 7 years ago

I get so many table with numbers as names when simulating virtual sensors in GSN middleware. Is there any way to overcome this ? I just want the tables of sensors. Is there a way out ?

ebiiii commented 7 years ago

Those are the temporary tables used for the wrappers input before they get into the processing class of the virtual sensor. Normally they should be cleaned up when stopping GSN. To avoid having them persisted in the same database as the virtual sensors' output, you can add this to your gsn.xml configuration file:

<sliding>
      <storage user="sa" password="" driver="org.h2.Driver" url="jdbc:h2:mem:sliding;DB_CLOSE_DELAY=-1" />
</sliding>