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
1 answer

While installing instantclient_12_1 in Windows 10 it shows the following error

While installing instantclient_12_1 in Windows 10 it shows the following error. I will provide the Image of the error after we select the from instantclient_12_1 from Data Source (ODBC) it was the first error with follwing with next error in next…
Dona Susan Issac
  • 170
  • 1
  • 17
0
votes
0 answers

NETBEANS 8.2 java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver EXCEPTION

Hi i new to develop wes app in JSP I am here using the access database. I have configured the .mdb datasource for the web app. When i am trying to access database i am getting the error java.lang.ClassNotFoundException:…
Pranav MS
  • 2,235
  • 2
  • 23
  • 50
0
votes
1 answer

A Client for IBM DB2 7.2 AIX

I have an old AIX box running IBM DB2 7.2. I need to get some data from some of the instances of some of the databases I tried Quest TOAD for Data Analysts which gives me the driver is not compatible I tried IBM Data Studio 4.1.2 : can connect but…
edelwater
  • 2,650
  • 8
  • 39
  • 67
0
votes
1 answer

Using POJO Datasource and querying Oracle DB

I am a newbie with BIRT. I am trying to use POJO Datasource which essentially uses a stand alone jar which has a code to query to Oracle DB. When I add the POJO Datasource and preview the results, I see the below error. Can anyone suggest if I need…
Anupam
  • 1
  • 1
  • 4
0
votes
0 answers

Java & Excel File Creation

I need to create a program to access data from a database and then create an excel sheet of the data retrieved. But I would further like to store/load this excel sheet on the desktop rather than a directory since I would be creating an .exe file of…
Eterno
  • 1
  • 1
0
votes
1 answer

Error connecting to my database via ODBC when running from a .jar

I can't connect to my data base while I run my .jar,but I can do it if I run my project in NetBeans. I'm using the JDBC-ODBC Bridge for the connection. Here's the function I use for the connection. public Statement connection(Statement st){ try…
A.JO
  • 235
  • 4
  • 14
0
votes
1 answer

Not Able To get selected columns from Statement.executeQuery()

I am new to Java Swing programming, so please bear with me. I have connected my JFrame to MA Access data base using JDBC ODBC driver and here is the erroneous code. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con =…
tedd_selene
  • 395
  • 1
  • 4
  • 9
0
votes
2 answers

when i want to insert data into mysql using JdbcOdbc Bridge driver, i get no database selected error,

i have created dsn correctly and have clear and simple code but i end up getting this error. the table structure is same as the program import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class…
user5921748
0
votes
1 answer

Include Java 7 ODBC classes to Java 8

I'm developing a Java application that needs to communicate with a Microsoft Access Database. Since Java 8, the ODBC-JDBC connection has been removed. For this reason we started looking at a Native driver, JDBC driver. We used UCanAccess and this…
PetK
  • 7
  • 4
0
votes
0 answers

How to integrate part of Java JDK7 as a standalone library in JDK 8 (JDBC-ODBC Bridge)

I am using the JDBC-ODBC bridge to connect to a QuickBooks database. (Intuit has offered sparse support, and does not have their own direct java driver to my knowledge). This was great in JRE/JDK 7. Now in JRE/JDK 8 this feature was removed. That's…
Drifter64
  • 1,103
  • 3
  • 11
  • 30
0
votes
0 answers

jdbc type1 program error

There is no compile time error but runtime error is there. i have assigned the DSN by going to controlPanel->administrative tools->Data sources->Add button->select oracle in XE->finish-> DSN=oradsn id=system ->ok ->ok but it is not still running.…
0
votes
1 answer

Unable to connect through "DB2 for i5/OS" option in Informatica TDM

My requirement here is to Generate data in a DB2/i5 OS (AS400). so when i tried to import from Informatica Test data manager using the " DB2 for i5/OS" option under Admninistrator -> Connections, test connection is not highlighting. So, mention what…
0
votes
0 answers

data is not inserted into Ms-Access

I’m not able to insert data of JTextField into Ms-Access using JDBC Connectivity private void addOperation() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("\n Drivers are Properly Loaded"); …
0
votes
1 answer

table.field notation with SQL Server JDBC?

I have a problem with SQL Server JDBC driver, I tried the Microsoft JDBC driver and also the JTDS driver, but they have both the same problem: in the ResultSet if I look for "table.field" I get the error "invalid column name", but if I look for…
Gaglia88
  • 99
  • 7
0
votes
0 answers

Error: Could not find or load main class during jar file execution in command prompt

I have written a java program in which I am creating a database connection using jdbc-odbc driver. I have created manifest file which looks like : Manifest-Version: 1.0 Main-Class: com.unisys.sql.CasePartitionExtractor Class-Path: . rt.jar rt.jar…
Madhusudan
  • 4,637
  • 12
  • 55
  • 86