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

"java.sql.SQLException: Missing IN or OUT parameter at index:: 1" when calling function

While calling SimpleJdbcCall.withFunctionName I get java.sql.SQLException: Missing IN or OUT parameter at index:: 1 SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(myDataSource) .withCatalogName("package_name") .withFunctionName("x"); String res…
user435421
  • 859
  • 2
  • 13
  • 31
4
votes
1 answer

Why my code keep getting java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified?

can someone help me to let my database connected to java. I've been trying this for hours but i still got this exception : "java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified?" public…
Ricky Isher
  • 43
  • 5
4
votes
3 answers

How to specify null value in MS Access through the JDBC-ODBC bridge?

I am not able to call setNull on PreparedStatement using MS Access (sun.jdbc.odbc.JdbcOdbcDriver) preparedStatement.setNull(index, sqltype). Is there a workaround for this? For LONGBINARY data type, I tried the following calls, neither…
Firat
  • 133
  • 1
  • 2
  • 8
4
votes
4 answers

Glassfish admin console's java.lang.RuntimeException

I have tried to create jdbc connection pool on my glassfish with the following properties(as seen on the image below). It connected succesfully makes me think it works right. However after I restarted the glassfish and tried to ping the pool, a…
name me
  • 378
  • 1
  • 2
  • 17
4
votes
5 answers

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path

I have created DSN for Mapped drive like this:- Y:\\192.168.2.5\data\db.accdb Now i am accessing this database from java application using sun jdbc odbc drivers. Application is running on Window 2008 64-bit system and database is running on Window…
Sunil
  • 163
  • 2
  • 2
  • 7
4
votes
1 answer

opensource jdbc driver for foxpro

Does anyone know of a free/opensource JDBC driver for fox pro dbf? because the jdbc-odbc bridge is not working for me ! check my previous question click here
user1912404
  • 386
  • 4
  • 11
  • 26
4
votes
2 answers

connection pooling in jdbc using sql server

I am trying to make connection through SQL Server from web server using java .It is simply opening the connection by sql driver but when multiple users try to connect with the web server of the company the server goes slow down due to the heavy…
adesh singh
  • 1,727
  • 9
  • 38
  • 70
4
votes
1 answer

What I need to Query mysql database from xsl using Saxon java tool (command line)?

I want to query database using java tool SAXON Use an ODBC connection to connect to mysql database Query database ( probably information schema -read schema ) Export the results into xml Is this a licensed feature in saxon ( e.g saxon9ee ) ?…
sakhunzai
  • 13,900
  • 23
  • 98
  • 159
4
votes
3 answers

How to connect to a 32-bit Access Database from 64-bit JVM?

So far, when I had to connect to an 32-bit Access Database, I simply executed the application using 32-bit JVM. However, I am now developing an application that requires 64-bit JVM, but I still need to connect to an 32-bit Access Database. When I am…
Pedro
  • 4,100
  • 10
  • 58
  • 96
3
votes
1 answer

gradle build failed due to dependency lock state

i have newly added a below dependency into my project implementation 'org.jdbi:jdbi3-oracle12:3.29.0' these are the dependencies which i already have in my project. dependencies { implementation…
saravana kumar ramasamy
  • 111
  • 8
3
votes
2 answers

Open Source JDBC driver for Excel, CSV files on a Maven repo

Is there an Open Source Excel/CSV/XML files JDBC driver available on a Maven repository? The JDBC-ODBC bridge mechanism is very cumbersome and does not support DataSource well (Optional feature not implemented exception). Read/write ability is…
Shantanu Kumar
  • 1,240
  • 1
  • 12
  • 14
3
votes
1 answer

How can I check whether a database connection is closed or open using java?

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Signing_Utility.mdb;"; Connection con = DriverManager.getConnection(database, "", ""); Statement s = con.createStatement();
NewBee Developer
  • 432
  • 2
  • 9
  • 26
3
votes
1 answer

JDBC ODBC bridge for Mac OSX

I am having a hard time establishing a connection to my database file using JDBC-ODBC bridge. The driver I am using is sun.jdbc.odbc.JdbcOdbcDriver but I believe it is not present on Mac OSX by default and hence throws an exception for class not…
Saurabh Lalwani
  • 195
  • 1
  • 3
  • 9
3
votes
1 answer

ODBC login is trying to use Windows authentication even though I supply SQL Server credentials

I am having trouble connecting to my Microsoft Server 2008 using the JdbcOdbc driver in Java. I prefer to use the Jdbc driver over the windows driver as the client has multiple options to connect with. The connection string I am using…
anitag95
  • 307
  • 2
  • 16
3
votes
4 answers

ClassNotFoundException when trying to connect to .accdb file via JDBC-ODBC in Java 8

I'm working in a project in Java in Eclipse EE IDE where I have to query a .accdb file. The problem is when I try to load the driver and then connect to the database it gives me an exception error. My code: try{ String filePath =…
Vitz
  • 101
  • 2
  • 12
1
2
3
…
20 21