Hello, I receive this error when I try to export a standalone runtime of my solution:
2018-04-11 18:55:26,587 WARN [Worker-4] com.servoy.j2db.util.Debug - Couldn’t get db connection schema Driver com.hxtt.sql.dbf.DBFDriver is not a JDBC4.1 (java 1.7) driver, please upgrade
2018-04-11 18:56:16,097 ERROR [Worker-1] com.servoy.j2db.util.Debug - Error creating table servoy_columninfo
2018-04-11 18:59:02,946 WARN [Worker-5] com.servoy.j2db.util.Debug - Couldn’t get db connection schema Driver com.hxtt.sql.dbf.DBFDriver is not a JDBC4.1 (java 1.7) driver, please upgrade
The driver that is complained about is distributed as part of the Servoy installation. Is this an oversight on the part of Servoy? Is their an easy resolution? My database is vfp which the IDE seems to support ok with this Servoy supplied driver. Thanks.
Hi,
Servoy does ship various drivers to work with databases of different vendors.
This doesn’t automatically mean that it is the correct driver-version for all the different databases that ‘we’ as developers use on our systems.
Basically it’s up to you to have the correct JDBC driver installed on your IDE as well as on any deployed version. (the latter doesn’t matter if you deploy using a full war-file)
If you think there’s a better/more recent driver that will work with different versions of VFP, you can always create a support-request at support.servoy.com.
When approved, Servoy can include this in future versions.
Hope this helps
Servoy is being advertised and promoted to Visual FoxPro developers as an IDE to move to. There is paid google advertising on this and servoy web content on this. If the Visual FoxPro database connectivity blows up, why the heck are they marketing this to me? It leaves a really bad taste in my mouth if I download the product based on their advertising and documentation and then it explodes when I try to connect to a VFP database and then I am told that I have to solve the problem on my own! Are you kidding, this is a very expensive and annoying product LOL.
hi,
this sounds like a bug, created a case for this at support.servoy.com
fyi most of our users no longer create runtime solutions, but run their application in a server 3 tier environment. i presume creating a run time in combination with java 7 and the vfp jdbc driver broke due to an upgrade. we will fix this.
in the mean time you can continue developing and running your application while we correct the error.
this warning
2018-04-11 18:55:26,587 WARN [Worker-4] com.servoy.j2db.util.Debug - Couldn’t get db connection schema Driver com.hxtt.sql.dbf.DBFDriver is not a JDBC4.1 (java 1.7) driver, please upgrade
can be ignored, it is better to upgrade the driver but i think the upgraded driver had other issues again…
But this one:
2018-04-11 18:56:16,097 ERROR [Worker-1] com.servoy.j2db.util.Debug - Error creating table servoy_columninfo
That is a repository table, are you also having the repository server on VFP database?
Then that doesn’t allow use to create columns, i think it is better to just use postgress database for that
What does your log files really say? Do you have a full stack trace for that error? Because it could be just a permissions issue.