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

I am getting "Invalid cursor state" error in my code. I have used next() before accessing resultset still getting same error

I am getting error whenever i try to store value of rsc.getString(2) in valut. ArrayList rowc = new ArrayList<>(); System.out.println("Select timing," + dayname + " from " + classid); rsc =…
Rishabh
  • 29
  • 1
  • 7
0
votes
0 answers

Netbeans 8.0.2 : java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

I am trying to connect it to database but theres aa error message that showing java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver is it because of my netbeans version? I installed it on Windows 7. String var1="sample1"; …
Killue
  • 11
  • 4
0
votes
1 answer

GlassFish JDBC Connection Pooling

I am trying to make a connection pooling for my web application but don't know basics how to setup with sql server with it Main questions: what is resource type (What to write), classname, driverclass name? public static void main(String[] args)…
user3694097
  • 1
  • 1
  • 5
0
votes
2 answers

Exception: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application "

I have 64 bit eclipse and configured this with 64bit jvm when i try to connect MS Access (32 bit MS office) it gives me error Exception: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and…
user2626417
  • 1
  • 1
  • 6
0
votes
1 answer

SQLException caught Invalid column index

Can anyone help me to solve this error: I tried different way to solve this error but could not get success. Here is a package and procedure and a java file from which i am calling the procedure. I am trying to call procedure for the first time. I…
RHN
  • 1
  • 4
0
votes
1 answer

Query in java code is returning null values but its working fine on ODBC query tool

With SELECT field2 FROM table1 in ODBC query tool I get list of required values, but with the same query from java code I get list of "null" values. SELECT field2 FROM table1 WHERE field2 IS NOT NULL didn't help. field2 - VARCHAR(255) part of…
XemyL
  • 3
  • 2
0
votes
1 answer

Clojure JDBC ODBC "Data source name not found and no default driver specified"

I'm attempting to connect clojure to an odbc data source. The datasource is a SQL Server 2014 database, configured with a System DSN "someDatabase". The DB uses windows authentication. The ODBC source is configured properly, and I'm able to…
ZeroEric
  • 371
  • 1
  • 4
  • 7
0
votes
0 answers

Why savepoints are not supported in Netbeans?

I have the following code Savepoint sp1 = conn.setSavepoint("save"); which gives the following exception Exception in thread "main" java.lang.UnsupportedOperationException at…
Implementer
  • 37
  • 6
0
votes
2 answers

How to connect to MySql database which situated in Remote lan network?

I want to connect the MYSQL database which is situaded in my lan home network. I am using JDBC/ODBC connector.
taufik
  • 25
  • 6
0
votes
0 answers

Getting error when creating connection to MySQL server driver

I installed MySQL server and I also test this server by creating user data base userlist table and also check that it is working fine on command line as I previously done. But This time getting error when try to create a user. I already used this…
ParikshitSinghTomar
  • 417
  • 1
  • 4
  • 28
0
votes
1 answer

Accessing an OLEDB source through Java

I have a Java app that needs to access a 3rd party database through OLEDB. Does anyone know of a way to do this? I am looking for an answer from the year 2014 on this question - everything I have seen so far is from a few years ago and basically…
dhalia
  • 401
  • 5
  • 21
0
votes
0 answers

Error in loading MS Access drivers for Java application

I have created a Swing application for company which connects to an Access database locally stored in the computer. The application works just fine in my computer and some other local computers, but when I was asked to deploy it on server I got this…
Prakhar
  • 530
  • 10
  • 24
0
votes
1 answer

Greek Words as Question Marks in java when trying to retrieve field value from MS Access DB

I am working on a project that i need to create a connection with an MS access database. The problem is that when i try to retrieve a valuefrom a field written in Greek , it appears every letter as questionmark . Does anyone have any idea how to…
JohnLaz
  • 1
  • 1
0
votes
2 answers

JDBC-ODBC Connection

I am trying to connect MS Access with Java Below is the error message java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Code- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); …
Ashu
  • 21
  • 1
  • 5
0
votes
2 answers

Error connecting to ODBC data source from JDBC

There is no error while compiling, but I'm getting this error on running my program: java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Here is my code for inserting values in table in SQL Server. import javax. swing.*; import…
Allan
  • 25
  • 2
  • 8
1 2 3
…
20 21