|EclipseLink + Foxpro [message #894863]
||Tue, 10 July 2012 16:21
|| Chad Curtis
Registered: July 2012
I am having some issues using eclipselink with a foxpro database. Connecting and using the database isn't the problem. The problem is that we use another foxpro application on the same database and there are times when the other app can't update a record. The java app that uses eclipselink doesn't have a problem updating. But the only way to fix the problem in the foxpro app is to actually close the java app. So the question is, is there something that might not be obvious that I am missing that either eclipselink or jdbc:odbc does that would cause a lock on a table?|
Here is the persistance.xml
<property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.DatabasePlatform"/>
<property name="javax.persistence.jdbc.url" value="jdbc:odbc:MyODBC"/>
<property name="javax.persistence.jdbc.password" value=""/>
<property name="javax.persistence.jdbc.driver" value="sun.jdbc.odbc.JdbcOdbcDriver"/>
<property name="javax.persistence.jdbc.user" value=""/>
The frustrating part is that we are not able to reproduce any of the errors our client is getting in-house.
Our clients are running on Java 1.7, Windows Server 2008R2 running on a Virtual Server.
Any help would be appreciated. Thanks.
[Updated on: Tue, 10 July 2012 16:22]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.10074 seconds