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

jdbc odbc connectivity without dsn creation

I am trying to make jdbc-Odbc connection without making the DSN but is throwing the exception. I am using the following code and it is throwing data source name not found no default driver specified exception. try { …
adesh
  • 1,157
  • 3
  • 18
  • 28
0
votes
1 answer

tomcat7 jdbc issues

I have a problem in my application post moving to tomcat7. I am seeing the below issue when my app tries to connect to the "Oracle 11.2 DB". org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception…
benki_at_bangalore
  • 1
  • 1
0
votes
1 answer

Oracle 10 g to 11 g migration.. Connection string

I have one query. We are migrating from Oracle 10g to Oracle 11g. In java code we have used jdbc:oracle:oci8:@XYZ for oracle 10g. But after 11g upgrade, we kept the above code as is. Now i am "NOT" facing any issue while connecting to DB during the…
Rogger296
  • 147
  • 3
  • 15
0
votes
0 answers

What is the only One open statement per connection limitation in JDBC-ODBC Bridge?

Can someone explain/elaborate the following limitation mentioned on the JDBC ODBC FAQs list -Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection? No. You can open only one Statement object per connection when you…
akjain
  • 1,787
  • 3
  • 20
  • 35
0
votes
2 answers

resultset is closed error in java

In my stand-alone application using Java Swing, I am traversing the Excel sheet (backend data) using ResultSet. But after executing the insert query, when I try to traverse the records using ResultSet again it shows 'ResultSet is closed'. No…
user1616277
  • 35
  • 1
  • 7
0
votes
2 answers

JDBC Type 3 Driver

Today I was learning different JDBC drivers. I found in below site http://www.javaworld.com/javaworld/jw-07-2000/jw-0707-jdbc.html?page=4 that JDBC-ODBC Bridge takes more time than the other drivers including Type - 3. But when I was looking at the…
Lolly
  • 34,250
  • 42
  • 115
  • 150
0
votes
1 answer

jdbc odbc DSN not found?

I developed a project using jsp-servlet, tomcat. I am trying to connect to database but it keeps on giving error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Backend is MS-Access mdb. I have created…
Nitin Kabra
  • 3,146
  • 10
  • 43
  • 62
0
votes
3 answers

how to retrieve column value from result set

when i run this program i got this in the output screen.I don't know what is the problem is there any thing i am missing. import org.apache.cassandra.cql.jdbc.*; import java.sql.Connection; import java.sql.PreparedStatement; import…
Sunil Kumar
  • 1,349
  • 3
  • 14
  • 25
0
votes
1 answer

calling VBA function in Access from Java

I have a database designed using MS Access with a VBA function written in the database When I try to call this function from a java program using JdbcOdbc Bridge I get SQLException with the message meaning "function is not found" the function…
Ossama Nasser
  • 71
  • 4
0
votes
1 answer

[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition

I am accessing an Access database inside a java program, however I get an error when I execute the sql command: static String SQLCreate = "CREATE TABLE CONTACT_INFO (" + "Contact_ID INTERGER NOT NULL PRIMARY KEY," + "First_Name…
RandellK02
  • 167
  • 1
  • 4
  • 17
-1
votes
5 answers

"java.lang.ClassNotFoundException" when executing Java code

I get a java.lang.ClassNotFoundException, when I execute the below code. Could someone explain me why I am facing this? All I need to do is to connect to the db and fetch some values from it. Is it a problem with the eclipse that I use? import…
Winz
  • 237
  • 3
  • 6
  • 14
-1
votes
1 answer

Class.forName("oracle.jdbc.OracleDriver"); generates exception: java.lang.ClassNotFoundException

I'm trying to make a program that connects to an Oracle database for the ultimate purpose of creating a few tables and running commands on them for a course I am taking. I'm currently trying to make the example given in class work but I can't get…
Sulfurous1980
  • 11
  • 1
-1
votes
1 answer

MY JDBC program compiles successfully but does not runs with exception

My Program runs successfully but gives an exception at the runtime. I have followed all the 8 steps to make a JDBC program. The code and image showing the exception are given. I have also created my own DSN(data source name) in the admin settings in…
Ali Akbar
  • 23
  • 1
  • 8
-1
votes
1 answer

Incompatible data types(hypersql)

Why should I get incompatible data types error? int blockSize = 100; String city="London"; " select * from"+ "(" + " select l.* from lottotable as l where l.city='"+city+"' and l.date< cast('"+date+"' as date) order by l.date desc " + ")" + " order…
Micky
  • 29
  • 5
-1
votes
1 answer

JDK7 runtime error: Data source name not found and no default driver specified

I'm getting run time error java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified when I tried to login using the code given. Below is the code. I'm using Java JRE 7 to compile it. Can…
Ashish Kumar
  • 29
  • 3
1 2 3
…
20 21