Questions tagged [jdbc-odbc]

The JDBC-ODBC Bridge enables Java applications to access ODBC data sources through the JDBC interface.

The JDBC-ODBC Bridge enables Java applications to access ODBC data sources through the JDBC interface. It was created to allow access to data sources that had an ODBC driver but did not have a native JDBC driver.

Important note (from Oracle's Java SE documentation):

The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8.

307 questions
2
votes
1 answer

How to connect Java 8 with MS Access?

I am facing some issue to making a login page in java using ms access database. its not getting username and password from ms access database. try { String user=t.getText().trim(); String…
AmanKumar
  • 1,333
  • 2
  • 20
  • 33
2
votes
1 answer

ResultSet row count via .getRow() giving wrong answer with JDBC-ODBC and MS Access

I have a HAM radio database and I'm trying to count the number of countries contacted per band for a given month (March 2014 in this example). My SQL statement works perfectly well in the MS Access Database tool, but from my Java program I get only…
mljm
  • 327
  • 3
  • 13
2
votes
1 answer

Getting Invalid cursor state exception in java

i ran select command and printed the result in system.out using below code. was getting expected result with invalid cursor error. could you please any one tell, why this error was occurred after printing the expected result and how to fix…
sathish kumar
  • 255
  • 1
  • 3
  • 13
2
votes
1 answer

How can you connect to a password protected MS Access Database from a Spring JdbcTemplate?

I need to connect to a password protected MS Access 2003 DB using the JDBC-ODBC bridge. I can't find out how to specify the password in the connect string, or even if that is the correct method of connecting. It would probably be relevant to…
Tim Visher
  • 12,786
  • 16
  • 58
  • 66
2
votes
4 answers

java.sql.SQLException : "Driver does not support this function"

I am doing a project on Hotel Management whose GUI is being designed using Swings and SQl Server Management Studio,2008 to store the data.But the problem I am facing is,i am getting an exception as "Driver does not support this function"...I am not…
user3801050
  • 21
  • 1
  • 5
2
votes
0 answers

Occasional "General error" Occurs on INSERT into POSTGRES Database from Java

I'm trying to insert a collection of data from Java into a Postgres database. Both the JVM and the database are 64-bit. Querying the database and viewing the output showed that the code correctly inserted 54 rows into the database before the JVM…
Collin
  • 21
  • 3
2
votes
2 answers

SQL Exception error

i am trying to Update my MS Access database. I want to know why do i get Syntax error [java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.] even when the syntax is correct class modify implements…
Tejal N
  • 25
  • 5
2
votes
1 answer

JDBC-ODBC Bridge Removed in Java 8, what is the best alternative?

Seeing as Oracle has removed the JDBC-ODBC Bridge driver in the latest release of Java (version 8), is there a good alternative that will enable us developers to access ODBC databases in Java 8? Oracle is apparently recommending that we use…
djmordigal
  • 549
  • 1
  • 5
  • 16
2
votes
0 answers

No.of Inactive session increased while connection made using BoneCP - for every run

I have connected Oracle db with Application. For each and every run, no.of inactive sessions are increased and that means the old sessions are not reused and new three connection s are created for every insert/update operation. Only after shut…
sivaspon
  • 31
  • 6
2
votes
0 answers

JavaFX TextField can't set Text from a ResultSet

I am developing a JavaFX Application which has access to a Database through JDBC/ODBC. When I click on a button, I want some TextFields to update their texts according to a ResultSet, showing the First Name and Last Name of a certain user. When I…
chanklor
  • 487
  • 5
  • 11
2
votes
3 answers

Java connection to MS Access Database

Just wondering if anyone cane help me, I'm trying to connect to an MS Access Database. I have done it on other projects and used exactly the same code. Can anyone see if I have done anything wrong? try { System.out.println("Attempting…
user3365117
  • 21
  • 1
  • 4
2
votes
1 answer

"undefined symbol: SQLAllocEnv" error in Java

I am using java to build an application which requires to use MS Access. I am geting the following error when I run the project: /usr/lib/jvm/jdk1.7.0/bin/java: symbol lookup error: /usr/lib/jvm/jdk1.7.0/jre/lib/i386/libJdbcOdbc.so: undefined…
user2822187
  • 307
  • 2
  • 11
  • 26
2
votes
2 answers

Build Failed: unable to find ojdbc .jar file

When I run the project I get an error: C:\Users\admin\Documents\NetBeansProjects\project\nbproject\build-impl.xml:1007: Warning: Could not find file C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar to copy. BUILD FAILED…
user1223530
2
votes
1 answer

Insert data to ms access from java

I'm new to JDBC. I want to insert data into Access from Java, but I can't get it. It shows the following error: Connection Established Successfully java.sql.SQLException: General error Could Not Connect to Database at…
Hazim Ali
  • 1,077
  • 4
  • 17
  • 28
2
votes
1 answer

The specified DSN contains an architecture mismatch Error

i got this error: The specified DSN contains an architecture mismatch between the Driver and Application while trying to connect to the database using NetBeans and Java Programming Language I am using Microsoft Access 2010 and my system running…
Kaoru
  • 2,853
  • 14
  • 34
  • 68