Stack Overflow
Stack Overflow

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
0
votes
2 answers

rs.next() not returning first value of the table

If I am running the following piece of code rs.next should return values starting from the first row of the table instead its returning the values from second row. String val = "select bl.book_id,bl.branch_id, bl.card_no,bl.date_out,…
user3011373
  • 17
  • 1
  • 5
0
votes
1 answer

JDBC program to create two different connections

Is it possible to select the data from two different database management systems? Suppose I have one table in Oracle Database and other table in mySQL database and If I want to select the data from two different databases is possible? How the JDBC…
Syed
  • 145
  • 1
  • 1
  • 11
0
votes
2 answers

Exception in inserting a record into a table using SQL

public class grantLoan extends HttpServlet { private static final long serialVersionUID = 1L; Connection con; Statement st; public grantLoan() { super(); } public Connection getCon() { try …
user3017098
  • 9
  • 2
0
votes
2 answers

Get the username and user type in the database to the program Java

i made a program that have a database.. Here is my database looked now: I already could retrieve the Username with the User Type when user login with their Username. But i have a problem now, the program run properly, the only thing is the program…
Kaoru
  • 2,853
  • 14
  • 34
  • 68
0
votes
1 answer

Login in Java shows all users and all usertypes

i have a problem, currently my database looked like this: ID Username UserType 1 Nies Administrator 2 Trinity Member When i login with Username: Nies The program respond, but it gave me the dialog box where both Username are displayed. I…
Kaoru
  • 2,853
  • 14
  • 34
  • 68
0
votes
1 answer

JDBC ODBC MS Access 2003 Update query does not update register

Using Ms Access 2003 on Windows Vista Java 1.7.0_45 & NetBeans IDE 7.4 I'm trying to run a simple UPDATE Query on a table named EMPLOYEES stmt.executeUpdate("UPDATE EMPLOYEES SET Name='John' WHERE Code='A07'"); But the name of the employee with…
rodrunner
  • 1,860
  • 4
  • 23
  • 34
0
votes
2 answers

Connect Java application 64bit to ODBC driver 32bits

I am building a Java desktop application that should connect to Sage ERP via ODBC driver. However, I have a 64bit windows7 OS and the ODBC driver is 32bit. The thing that had generated the followingv exception: [Microsoft][ODBC Driver Manager] The…
mahoosh
  • 553
  • 1
  • 7
  • 21
0
votes
2 answers

Resultset getmethod in If condition

I'm working on java JDK7 and Microsoft Access 2007.Basically I want to get the minimum value from the all the columns of row1. But the following code doesn't work. import java.io.*; import java.util.*; import java.net.*; import java.sql.*; public…
Intriguing
  • 125
  • 3
  • 13
0
votes
0 answers

ODBC Driver - Invalid string or buffer length

I upgraded my JDK from 1.5.0 to 1.6.0 and then i got this when i try to connect MS SQL through ODBC driver: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length. Any ideas on this. Thanks in advance.
user1587872
  • 345
  • 1
  • 3
  • 14
0
votes
1 answer

Connecting IOS Device to IBM DB2 using JDBC Bridge

i'm having basic questions about the functionality of JDBC. My IOS App needs a db2 connection. Since the IOS SDK dont have a db2-odbc connectivity i need a bridge to translate db2 commands to JSON/XML and vice versa. Is it possible to realise a java…
BobbelKL
  • 59
  • 8
0
votes
1 answer

Retrieving contents of more than one table in jsp

I have two tables in my database named "branch" and "course". I want to display contents of one column of each table in a select option. I can retrieve one column successfully but when i try to retrieve data from more than one table it gives me an…
Saumyaraj
  • 1,220
  • 3
  • 15
  • 37
0
votes
2 answers

How to find MS Access version number in java code

Is there a way to find version number of MS Access using java code. I am using jdbc-odbc bridge to connect with MS Access. My usecase is to load mdb and accdb driver using JDBC DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access…
Ganesan G
  • 59
  • 7
0
votes
0 answers

JDBC Microsoft access update error

I am receiving this error any time my program is running and I can't figure out what is causing the error. The error is CheckNList data reading error has occurred java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not update;…
user1304731
  • 25
  • 1
  • 6
0
votes
1 answer

How to sort excel using arraylist in java and jdbc

I have an excel spreadsheet with data in just the first 2 columns. I want to sort the data into an array so that I can loop through and perform calculations with the data. So far, I've been able to just output the content of the spreadsheet to the…
user2539273
  • 11
  • 1
  • 2
  • 5
0
votes
1 answer

JDBC ODBC with MS Access issue

I want to store a record but don't know what to do. When i start entering the details of a customer, at that time database connectivity is successfully created but I fail to store the data in the database. The procedure is correct to create the…
Devendra_Ghag
  • 7
  • 3
1 2 3
…
20 21