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

Accessing Excel as a database using groovy.sql

I am trying to access Excel as a database using the groovy.sql package, which is a GDK extension to JDBC. I am aware that Excel is not a database and that for most tasks Apache POI works better. I am using an Excel file named weather.xlsx as a test…
qwerty
  • 810
  • 1
  • 9
  • 26
1
vote
0 answers

c3p0 for 64bit tomcat

We have c3p0 connection pooling for Sybase. It works fine on Tomcat 7.0 on a 32-bit server. Once we run it on a 64-bit server with tomcat and jre both installed under 64-bit , it throws: Caused by:…
kkndbeef
  • 11
  • 2
1
vote
0 answers

What is the newest version of Netbeans that works with Java 2 (j2sdk1.4.2_19)

My company is using WebToGo for managing our Service Requests. I had written a program to extract a list of our service requests in a more faster, more user-friendly way than is otherwise available. But it used the JDBC-ODBC bridge, which went…
David D.
  • 25
  • 5
1
vote
1 answer

ODBC Microsoft Access Error: Syntax error in update, delete statement

I am writing a java program which connects with Ms Access using ODBC-JDBC Driver. The Select and Insert Into Statement are working correctly but delete and update statement are showing syntax error. I have tried all possible solutions but nothing…
Kushagra
  • 89
  • 11
1
vote
0 answers

Is it possible to connect to derby through odbc

Is it possible to connect to the derby database through odbc on a windows 10 machine? I have the jdbc-odbc bridge from Java 7. Found this: Derby network server The Derby network server provides traditional client/server access to the Derby…
DCR
  • 14,737
  • 12
  • 52
  • 115
1
vote
1 answer

Java and MS Access

The JDBC-ODBC driver doesnot support the same charsets that MS Access using for other then latin characters, thus I cannot read hebrew from the database, which is mostly written in hebrew(a bug report is written here ) I tried using Jackcess for…
Swine1973
  • 192
  • 1
  • 3
  • 13
1
vote
1 answer

Can I change the Fetch Mode in a Resultset from a DatabaseMetaData query?

I'm inspecting a Database using an DatabaseMetaData instance. I get all the information of the tables in the DB and I iterate all the Resultset without anyproblem. At the end of the iteration, I want to return to the begin of the ResultSet, so I…
jomaora
  • 1,656
  • 3
  • 17
  • 26
1
vote
0 answers

Connect ODBC Driver that is in remote machine

Usually, we connect ODBC driver using BI applications on our local machine, Just imagine I created an ODBC driver for PostgreSQL in the remote machine at my home (Windows 10), I want to connect that ODBC driver (remotely) from my office workstation…
Mani Kkr
  • 105
  • 4
1
vote
1 answer

Java Application. Undefined function 'replace' in expression

My Java application works well on two of my colleague's computers, however it will not run on mine. The application reads a spreadsheet, creates tables in access from it and then compares them. The application is able to read and create the tables,…
Tourtelot
  • 137
  • 3
  • 15
1
vote
1 answer

Can you connect directly with an "ODBC data source" using Java?

I am tasked with integrating a certain program, Sage 50 / PeachTree, with a third party program. I need to get data from Sage 50 and transfer it to the other program on a regular schedule. Sage 50 only has a .NET API and the third party program has…
user4984149
1
vote
2 answers

Unable to get an Oracle connection

Unable to get an Oracle connection. I am using the following piece of code in order to get an oracle connection in a custom smart service plugin :- public static Connection openNewConnection(String url, String username, String password) throws…
user6276653
  • 140
  • 1
  • 2
  • 11
1
vote
2 answers

SimpleJdbcCall - Error in executing oracle procedure

I am trying to execute procedure from SimpleJdbcCall's execute() method (i.e. executing stored procedure in Spring), but it giving error because I have double quotes in my package name - "_test_package". Error says that, procedure much be declared…
GovindS
  • 143
  • 1
  • 4
  • 13
1
vote
0 answers

Tomcat HTTP Status 500 - java.lang.NullPointerException with SQL JDBC errors

I have an NPE on a Windows 2008 R2 vm guest that seems to be rather annoying and preventing people from using the vm. What's odd is that this wasn't occurring before until I migrated it from Hyper-V to VMware vSphere. It's supposed to load a webapp…
Brian
  • 11
  • 2
1
vote
3 answers

Running a Java app with an Access database from the Windows command prompt

I have developed a Windows MS Access Java app with Netbeans V6.1 Everything works okay in the IDE including loading the MS Access data into a jTable. When I run it from the Windows command line, the app starts but the data is not loaded into the…
user3237316
  • 31
  • 4
1
vote
1 answer

trouble in the database and checking the database in java

I am having trouble in checking the username in the ms access database java.sql.SQLException: No data found here is the database connect public class dbAccess { Connection conn; ResultSet rs; Statement s; PreparedStatement ps; …
rinaldy31
  • 117
  • 2
  • 9
1 2 3
…
20 21