Oracle 10G for 64bit JDBC连接问题.

服务:
系统:AIX 5.3 64bit
JDK:1.5.12 64bit
oracle 10G 64bit

客户:
系统:win xp 32bit
JDK:1.5.12 32bit
oracle 10G 32bit

客户用JDBC方式 访问不了 服务器上的 Oracle 数据库.

该如何解决.

贴图看看:mad

大哥,  JDBC只是个规范~~~

能不能把详细的错误信息贴出来~

JDBC的包用10g提供的,
连接URL写对了就没有问题, 实在不行看看java的异常信息是什么. 贴出来看看

感谢大家的回复.这个问题是我们部门的同事经历的,后来换成32位的了,所有Java的抛异常现在也没有贴的了.现在我这边的Java项目也要上线了,客户的应用环境也是如上所说,现在我这边的这个Java项目的应用环境的操作系统是Red Hat Enterprise Linux AS4 32bit,JDK是1.5.12 32bit,数据库是Oracle 10G 32bit,所以我现在想问3个问题.
1,我的这个Java项目移植过去,需要改动代码后才能在上面的环境上运行,还是移植过去就能直接运行吗?
2,目前Java项目用到的 Oracle数据库的 ojdbc14.jar 包需要换成 10G 64bit 的包 才能正常运行?
3,在我的机器(操作系统:Win XP 32bit,数据库客户端:Oracle 10G 32bit)上用 PlSqlDev7.1.3.1378 连接到 Oracle 10G 64bit 需要注意什么,要安装Oracle 10G 32bit的客户端吗?还是可以替换 oci.dll 文件就可以了?


下面的信息是 PlSqlDev7.1.3.1378 上看到的.

信息:
PL/SQL Developer
  Version 7.1.3.1378
  00.0 - 0 user license
  Windows XP Professional 5.1 Build 2600 (Service Pack 2)
  Language: 简体中文  (姜华东)
  
  Physical memory : 1,964,528 kB  (963,100 available)
  Paging file     : 2,071,880 kB  (1,154,888 available)
  Virtual memory  : 2,097,024 kB  (1,973,620 available)

Parameters
  D:\Program Files\plsql\PlSqlDev.exe

Preferences
  Session mode: Multi
  OCI Library:
  Use OCI7: False

Preference Files
  D:\Program Files\plsql\Preferences\Default\Default.ini
  D:\Program Files\plsql\Preferences\Zsjlover\default.ini

Plug-Ins
  *CnPlugin v1.5 (D:\Program Files\plsql\PlugIns\CnPlugin.dll)
   (* is Active)

Aliases
  134
  135
  252
  LOCALHOST

Homes
  OraDb10g_home1  (D:\oracle)

DLLs
  D:\oracle\bin\oci.dll

TNS File
  D:\oracle\Network\Admin\tnsnames.ora

Using
  Home: OraDb10g_home1
  DLL: D:\oracle\bin\oci.dll
  OCI: version 9.2
  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

Character Sets
  Character size: 2 byte(s)
  CharSetID: 852
  NCharSetID: 2000
  Unicode Support: True
  NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
  NLS_CHARACTERSET: ZHS16GBK
  NLS_NCHAR_CHARACTERSET: AL16UTF16

注册:
SOFTWARE\ORACLE
  inst_loc = C:\Program Files\Oracle\Inventory

  SOFTWARE\ORACLE\KEY_OraDb10g_home1
    ORACLE_HOME = D:\oracle
    ORACLE_HOME_NAME = OraDb10g_home1
    ORACLE_GROUP_NAME = Oracle - OraDb10g_home1
    NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
    ORACLE_BUNDLE_NAME = Enterprise
    OLEDB = D:\oracle\oledb\mesg
    StmtCacheSize = 0
    StatementCacheSize = 0
    OO4O = D:\oracle\oo4o\mesg
    SQLPATH = D:\oracle\dbs
    ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb10g_home1
    MSHELP_TOOLS = D:\oracle\MSHELP
    ORACLE_BASE = D:
    RDBMS_CONTROL = D:\oracle\DATABASE
    RDBMS_ARCHIVE = D:\oracle\DATABASE\ARCHIVE
    ORA_ORCL_AUTOSTART = FALSE
    ORA_ORCL_SHUTDOWN = TRUE
    ORA_ORCL_SHUTDOWNTYPE = immediate
    ORA_ORCL_SHUTDOWN_TIMEOUT = 90
    ORACLE_SID = orcl

    SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET
      TraceFileName = C:\ODPNET.trc
      TraceLevel = 0
      TraceOption = 0
      StatementCacheSize = 0

    SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB
      CacheType = Memory
      ChunkSize = 100
      DistribTX = 1
      FetchSize = 100
      OSAuthent = 0
      PLSQLRset = 0
      PwdChgDlg = 1
      SchRstLng = 10000
      UserDefFn = 0
      DisableRetClause = 1
      VCharNull = 1
      TraceCategory = 0
      TraceFileName = c:\OraOLEDB.trc
      TraceLevel = 0
      TraceOption = 0
      SPPrmDefVal = 0
      StmtCacheSize = 0

    SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O
      CacheBlocks = 20
      FetchLimit = 100
      FetchSize = 4096
      HelpFile = D:\oracle\oo4o\doc\oracleo.hlp
      PerBlock = 16
      SliceSize = 256
      TempFileDirectory = c:\temp
      OO4O_HOME = D:\oracle\oo4o

  SOFTWARE\ORACLE\SYSMAN

    SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleorcl
      EMDROOT = D:\oracle
      ORACLE_HOME = D:\oracle
      EMSTATE = D:\oracle\周绍军_orcl
      CONSOLE_CFG = dbconsole
      ORACLE_SID = orcl
      TIMEOUT = 15
      TRACE_LEVEL = 16

路径:
D:\oracle\bin
D:\Program Files\Java\jdk1.5.0_09\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\ATI Technologies\ATI 控制面板
C:\Program Files\Microsoft SQL Server\80\Tools\BINN
d:\Program Files\SSH Communications Security\SSH Secure Shell

TNS名:
# tnsnames.ora Network Configuration File: D:\oracle\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

LOCALHOST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = orcl)
    )
  )

135 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.182.12.135)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

134 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.182.12.134)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

252 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.252)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

继续顶起./