jdbc-odbc Questions
7
Solved
at work we have to deal with several MS Access mdb files, so we use the default JdbcOdbcBridge Driver which comes with the Sun JVM and, for most cases, it works great.
The problem is that when we ...
1
My database path name has an ampersand in it. "...\mthly calcs & projections...".
Unfortunately, the path name cannot be changed. How do I deal with this case? Is there a way to speci...
9
I have very simple code:
pstat=con.prepareStatement("select typeid from users where username=? and password=?");
pstat.setString(1, username);
pstat.setString(2, password);
rs=pstat.executeQuery(...
5
I have created an MS Access database and assigned a DSN to it. I want to access it through my Java application.
This is what I am doing:
public class AccessDbConnection {
public static void mai...
7
Solved
I tried the following:
private String password = "";
private String dbName = "dataHC.accdb";
private String bd = dbName + ";PWD=" + password;
String url = "jdbc:odbc:Driver={Microsoft Access Drive...
3
In my application I use 20 threads for a job. Each thread calls a remote web service and updates the Oracle DB. After Jboss restart , the job fails in updating the db, with the exception that I fin...
Louvenialouver asked 9/11, 2017 at 13:38
4
I have some non-standard characters in my Access 2010 database. When I read them via
Connection con = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.util.Properties prop = new j...
2
I'm trying to create a custom ODBC driver using C++ for a Windows environment (like PostgreSQL, Simba, Firebird, etc.) since the ODBC API has multiple ODBC API methods by default.
I established co...
5
Starting with Java 8, the JDBC-ODBC Bridge will no longer be included with the JDK.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // classNotFoundException is thrown
Is there any other solution...
2
Solved
The JDBC-ODBC bridge is no longer supported with Java 8. Is there a way to access legacy MDB files without the bridge in Java 8? By legacy, I mean Access 2.0. Such old version is not supported by U...
2
Solved
In Java 8 the JDBC-ODBC-Bridge will be removed. The typical error is:
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
Do you know of a possible replacement? I found Easysoft. But t...
1
Solved
I am using the below code to get Connection. I have used the c3p0 library for connection pooling.
package com.dataSource.c3p0;
import java.beans.PropertyVetoException;
import java.io.IOException;...
Underestimate asked 29/5, 2015 at 4:26
8
Solved
package sqlselection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Sqlselection
{
public static void main(String...
3
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 nee...
Budgie asked 23/4, 2012 at 23:23
2
Solved
3
Solved
i have DB where some names are written with Lithuanian letters, but when I try to get them using java it ignores Lithuanian letters
DbConnection();
zadanie=connect.createStatement(ResultSet.TYPE...
Hadwin asked 28/8, 2011 at 17:10
2
Solved
I am trying to make an application that connects to an Access database. I have made it through making the ODBC connection of my Java program with an .mdb file but I have this problem with Unicode c...
2
I'm sending a query through the JDBC-ODBC Bridge to an Access database from Java, like this:
"SELECT * FROM localities WHERE locName='" + cityName + "'"
When cityName is a normal string with no ...
3
Solved
I'm trying to study for a basic SQL test at school but unfortunately I copied the class that we are supposed to use into a project on my pc and I am getting the following error:
java.sql.SQLExc...
1
Solved
WrappedConnectionJDK6 wrapped = (WrappedConnectionJDK6) dbStrategy.getConnection();
Connection underlyingConn = wrapped.getUnderlyingConnection();
OracleConnection oracleConn = (OracleConnection)...
3
Solved
Can anybody please mention the best available opensource odbc:jdbc driver to read / write dbf.?
I have a dbf file which I would like to query (select/update) via a web application (Tomcat app...
1
© 2022 - 2025 — McMap. All rights reserved.