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

an issue occured when database restart with C3p0 configuration

My application has a timer that execute every 60 seconds. Each execution will access the oracle database with C3p0 connection pool. The existing configuration for C3p0 of my application is as following(there are other tasks to access db): *
Evan
  • 21
  • 2
0
votes
1 answer

ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver, how to fix it

it gives exception of java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver int row=0; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Con=DriverManager.getConnection("jdbc:odbc:MSDB"); …
Sana ullah
  • 29
  • 1
  • 8
0
votes
1 answer

Nothing happening when reading .accdb database

I am trying to create a program that will read a database and output it. I have followed the tutorial at http://www.codeproject.com/Articles/35018/Access-MS-Access-Databases-from-Java. But when I run my program, nothing happens. Not even errors...…
ikhebgeenaccount
  • 353
  • 6
  • 20
0
votes
1 answer

Windows 8.1. - Java - ODBC Driver - NetBeans

I am trying to connect Java app to MSAccess in NetBeans IDE (pls don't tell me not to use Access, because we are using it in classes, and that's just it for now :)). I didn't have this problem on Windows 7, and I couldn't find answer using Google,…
j3ca
  • 5
  • 1
  • 1
  • 7
0
votes
1 answer

Unable to run an Eclipse project in a local web browser, access the database, and run the project

I am currently doing a web application project in Eclipse. I understand that the project done in eclipse runs on a local web browser (i.e. in my eclipse web browser). What I don't understand, if how we can execute or run that project in my local…
user3453010
  • 1
  • 1
0
votes
1 answer

Connectivity with MS Access in java

When I execute my java code, it give following error? databasejava.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Can you help me for the solution?
user3505425
  • 1
0
votes
1 answer

ODBC - Multiple Issues with Connections

I am trying to create an ODBC link within the control panel, administative tools, ODBC connections... "I will say before I go any further that I have tried using the ODBCad.exe in both system32 and SysWOW64 to resolve this issue to no avail." Under…
Mr Deans
  • 269
  • 1
  • 4
  • 21
0
votes
1 answer

Is there a way to select only a few columns from Excel to pull into a ODBC-JDBC connection?

I am writing a program to provide stock data to a GUI, which will update real time. When I use the Smart Tags in Excel, it updates with 13 columns: Last, Previous, Close, High, Low, Volume, Change, % Change, 52 Wk High, 52 Wk Low, Market Cap, EPS,…
Vincent Giuliana
  • 113
  • 1
  • 2
  • 8
0
votes
3 answers

java sql exception syntax error in from clause

I have an access database and trying to use it in java. I want to select it and wrote a statement as String sql="SELECT * from numeric;"; try { rs=s.executeQuery(sql); while(rs.next()) { …
Mani
  • 1,364
  • 14
  • 33
0
votes
2 answers

Is SQuirreL SQL Client compatible with QODBC?

Does anyone know if the SQuirreL SQL Client is compatible with QODBC? If not is there a plugin for SQuirreL to enable so? Any insight would be appreciated as I have never used either.
James
  • 70
  • 1
  • 9
0
votes
0 answers

Enabling entire column of database as options in dropdown list

The code I have written gives me the output of only a single data in the drop down list. I want my drop down list to retrieve and hold all the data of the fname and userid column of the table. I am using struts concept and JSP. Kindly help as to how…
sam
  • 83
  • 1
  • 7
0
votes
1 answer

[Microsoft][ODBC Driver Manager] Invalid cursor state

Guys Here's what I am having. The current error is javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state and this is the piece of work thats causing the error String query3 = "SELECT…
kenlz
  • 461
  • 7
  • 22
0
votes
1 answer

How to create a new field in access through JDBC

I am looking for a way to insert a field/column into a record in MS-Access through Java. I believe that I need to use executeUpdate(INSERT...), however I cannot seem to get my program to add new fields/columns. Any help would be appreciated, and an…
Hughes
  • 339
  • 3
  • 15
0
votes
1 answer

Proper way to handle ResultSet retrieved by JDBC (Converted to XML vs Validated Online)

My Java application is processing a lot of information parsed from XML. For some methods, I need to validate some info in an SQL Database on another machine. I am using JDBC, currently for each validation, I call a DB Handling method that opens a…
mowienay
  • 1,264
  • 4
  • 19
  • 32
0
votes
0 answers

Not able to create MS Access DB Connection with Java Code?

I am able to create a connection with 64 bit office but I want to connect with 32 bit office. Still after reading so many articles regarding this, I still am unable to create a DB connection with MS Access using Java I have: 64 Bit JDK 64 Bit…
Rahul Gupta
  • 5,275
  • 8
  • 35
  • 66
1 2 3
…
20 21