I’ve been trying to access a Visual Fox Pro database from Java for a week now. I’m getting desperate because my project is in a very tied budget and timeframe. (As any other project, I guess, hahaha) I have a .dbf, a .cdx and a .fpt files. I need to be able to look for a record, extract data, and
Tag: jdbc
What is the difference between OCI and THIN driver connection with data source connection between java and oracle XE?
I’m writing the below codes for connection between the java and Oracle 10g XE using 3 way(OCI, THIN and data source), the code is running successfully but don’t know difference between the THIN and OCI with data source connection. 1- 2- 3- Answer Oracle provides four types of drivers for their dat…
How to configure UCanAccess JDBC driver with Spring?
Whenever I tried to use an ODBC driver to access MDB files, it gave me an error: So I decided to use the UCanAccess JDBC driver instead. Does anyone have experience configuring UCanAccess JDBC driver with Spring? I’ve put the UCanAccess.jar into my lib folder and configured it like below, but that doesn…
Unable to load jdbc driver eclipse
I get the following error while trying to load MySQL Driver: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java….
Can not issue data manipulation statements with executeQuery
I’m getting an error when im trying to run my gui to inset data into a table, the error being Can not issue data manipulation statements with executeQuery(). The goal of this gui is to get the user to input information into the text area and then click submit and this information is uploaded to the data…
org.postgresql.util.PSQLException: ERROR: syntax error near «,» in Java
The below is the query generate by a prepareStatement in Java: The Java code is: The query is executed int the try statement and insert the values properly in the DB, BUT it also throws the below exception, at line 192: here ‘val’: The error trace relate to postgres is here: By the way, the table …
How to implement a JDBC database into a Gui program to authenticate a user and password for logging into the program
I’m currently making a gui program and I’m clueless to how I am meant to set up my program so when the user inputs a username and password, and then clicks the login button it checks the database for the username and password, and if the username and password is in the database, they accepted, if …
Invalid operation for read only resultset: updateString
Following is my code(Re-constructed) which select & update STATUS field depending upon the conditions. (Using Servlets, Oracle as Backend and JDBC driver) I am getting the error while updating: Any suggestions will be appreciated. Update 1: The same code was working when select statement was selecting dat…
ODBC connection to Access database in 64-bit Windows
I am using this tutorial to create a database connection from a java application to a Microsoft Access 2010 database. The tutorial creates a system dsn in windows, and then connects to that system dsn using the following line of java code: The problem is that, when I click the link to add a new system dsn at:…
Getting id after insert within a transaction (Oracle)
Let’s say I have three tables: team, player, team_player. Table team_player is a bridge table allowing a “many to many” relationship. When someone wants to create a new team, they specify the initial players on that team. How do I insert both the team and team_player rows in the same transac…