Unable to find the requested .Net Framework Data Provider – SQLite

had to add: <system.data> <DbProviderFactories> <remove invariant=”System.Data.SQLite”/> <add name=”SQLite Data Provider” invariant=”System.Data.SQLite” description=”.Net Framework Data Provider for SQLite” type=”System.Data.SQLite.SQLiteFactory, System.Data.SQLite” /> </DbProviderFactories> </system.data> to my app config file. and it now looks like: <?xml version=”1.0″ encoding=”utf-8″ ?> <configuration> <startup useLegacyV2RuntimeActivationPolicy=”true”> <supportedRuntime version=”v4.0.30319″ sku=”.NETFramework,Version=v4.0,Profile=Client” /> </startup> <system.data> <DbProviderFactories> <remove invariant=”System.Data.SQLite”/> <add name=”SQLite Data Provider” invariant=”System.Data.SQLite” description=”.Net … Read more

Using Maven for deployment

Ok, I think the following might do what you need. The drawback of this approach is that there will be an interval between each deployment as the subsequent build is executed. Is this acceptable? Define a profile in each project with the same name (say “publish”). Within that profile you can define a configuration to … Read more

Configure Tomcat to use properties file to load DB connection information

We often distribute webapps by providing a WAR, and a Context XML file, which gets placed into your tomcat/conf/Catalina/localhost directory, and can load the webapp from any path. There is a reference document here. This provides the following advantages: Context parameters can be configured here and read by the webapp DataSources can be defined and … Read more

Make MSDeploy (Visual Studio) not delete App_Data folder but delete everything else

It can be done when you invoke msdeploy manually – just add the following parameter: -skip:Directory=\\App_Data See Web Deploy Operation Settings. The path is a regular expression, so it is quite flexible. If you deploy using the VS-generated ProjectName.deploy.cmd script, you can also pass this parameter in the _MsDeployAdditionalFlags environment variable (when running that script). … Read more