Java ODBC数据源（未定义的符号：SQLAllocEnv） [英] Java ODBC Data Source ( undefined symbol: SQLAllocEnv )

问题描述

我有以下Java代码。此代码的目的是为远程MySQL数据库ProductionDb（我的/etc/odbc.ini文件中定义的数据源）建立连接
。

I have the following Java code. Purpose of this code is to establish a connection to a remote MySQL database ProductionDb ( a data source defined in my /etc/odbc.ini file ).

import java.sql.*;
import java.util.*;
import java.io.*;

public class Test {

    public static void main(String[] args) {

        try {
            Connection conn = null;
            PreparedStatement s = null;
            String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

            Class.forName(driver).newInstance();
            conn = DriverManager.getConnection("jdbc:odbc:ProductionDb");

        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
    }

}

/ etc / odbc.ini文件是：

The /etc/odbc.ini file is:

$ cat /etc/odbc.ini
[ProductionDb]
Driver = /usr/lib/odbc/libmyodbc.so
Description = Production Database
Server = [ hidden ] 
Port = 3306
User = [ hidden ] 
Password = [ hidden ] 
Database = ProductionDb

顺便说一句 - 我使用的是Java 7和Ubuntu：

By the way - I am using Java 7 and Ubuntu :

 $java -version
    java version "1.7.0_09"
    Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
    Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

 $lsb_release -a
    No LSB modules are available.
    Distributor ID: Ubuntu
    Description:    Ubuntu 11.04
    Release:    11.04
    Codename:   natty

当我尝试运行程序时出现以下错误：

When I try to run my program I get the following error:

$java Test
java: symbol lookup error: /usr/lib/jvm/java-7-oracle/jre/lib/amd64/libJdbcOdbc.so: undefined symbol: SQLAllocEnv

有谁知道我为什么会收到这个错误？
这里有什么问题？

Does anyone know why I get this error ? What is wrong here ?

PS顺便说一下我运行sudo apt-get install unixodbc-dev，sudo apt-get install libmyodbc和sudo apt- get install libmysql-java :-)

P.S By the way I did run sudo apt-get install unixodbc-dev , sudo apt-get install libmyodbc and sudo apt-get install libmysql-java :-)

更新：

我也有尝试了下面的一个回复（Benny Hill）中建议的想法：使用/etc/odbcinst.ini以及/etc/odbc.ini。仍然无法正常工作，我收到相同的错误消息。

I have also tried the idea suggested in one of the replies below ( by Benny Hill ) : to use the /etc/odbcinst.ini as well as /etc/odbc.ini. Still doesn't work and I get the same error message.

$ cat /etc/odbc.ini
    [ProductionDb]
    Driver = MySQL Driver 
    Description = Production Database
    Server = [ hidden ] 
    Port = 3306
    User = [ hidden ] 
    Password = [ hidden ] 
    Database = ProductionDb

$ cat /etc/odbcinst.ini
    [MySQL Driver]
    Driver = /usr/lib/odbc/libmyodbc.so

附加说明：

我可以使用R
编程语言成功使用此ODBC数据源。

I can use this ODBC data source successfully from the R programming language.

> library(odbc)
> con = odbcConnect("ProductionDb") 
> con
RODBC Connection 1
Details:
  case=nochange
  DSN=ProductionDb

推荐答案

听起来像是缺少或不匹配的库。尝试调试ldd处理。

Sounds like a missing or mismatched library. Try to debug the ldd processing.

首先，检查

$ ldd /usr/lib/jvm/java-7-oracle/jre/lib/amd64/libJdbcOdbc.so

说，是否存在所有列出的依赖项？

says, do all listed dependencies exist?

然后，尝试设置LD_DEBUG并再次启动Java程序，以查看加载程序调试。

Then, try setting LD_DEBUG and and start your Java program again, to see the loader debug.

$ export LD_DEBUG=all
$ java Test

这篇关于Java ODBC数据源（未定义的符号：SQLAllocEnv）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！