Re: JDBC in PostgreSql for Linux

Kallol Nandi schrieb:
> I am running a Java application on Linux which connects to the Postgresql on Linux using jdbcodbc bridge.
> But this is the error I am getting :
>
> I have also tried running a Java application using the Native JDBC Driver.
> I get the following error :
> Driver not found for URL: jdbc:postgresql(at)10(dot)100(dot)102(dot)31:5432:notes
> java.sql.SQLException: Driver not found for URL: jdbc:postgresql(at)10(dot)100(dot)102(dot)31:5432:notes
> at 0x4028115f: java.lang.Throwable.Throwable(java.lang.String) (/usr/lib/libgcj.so.3)
> at 0x402740d2: java.lang.Exception.Exception(java.lang.String) (/usr/lib/libgcj.so.3)
> at 0x40316294: java.sql.SQLException.SQLException(java.lang.String, java.lang.String, int) (/usr/lib/libgcj.so.3)
> at 0x40316244: java.sql.SQLException.SQLException(java.lang.String) (/usr/lib/libgcj.so.3)
> at 0x40316102: java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.3)
> at 0x4031603a: java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.3)
> at 0x4039d347: ffi_call_SYSV (/usr/lib/libgcj.so.3)
> at 0x4039d307: ffi_raw_call (/usr/lib/libgcj.so.3)
> at 0x40248528: _Jv_InterpMethod.continue1(_Jv_InterpMethodInvocation) (/usr/lib/libgcj.so.3)
> at 0x40248e34: _Jv_InterpMethod.run(ffi_cif, void, ffi_raw, _Jv_InterpMethodInvocation) (/usr/lib/libgcj.so.3)
> at 0x40246424: _Jv_InterpMethod.run_normal(ffi_cif, void, ffi_raw, void) (/usr/lib/libgcj.so.3)
> at 0x4039d1bc: ?? (??:0)
> at 0x4025b308: gnu.gcj.runtime.FirstThread.call_main() (/usr/lib/libgcj.so.3)
> at 0x402c60b1: gnu.gcj.runtime.FirstThread.run() (/usr/lib/libgcj.so.3)
> at 0x40267fdc: _Jv_ThreadRun(java.lang.Thread) (/usr/lib/libgcj.so.3)
> at 0x4023478c: _Jv_RunMain(java.lang.Class, byte const, int, byte const, boolean) (/usr/lib/libgcj.so.3)
> at 0x08048900: ?? (??:0)
> at 0x420158d4: ?? (??:0)
> at 0x080486c1: ?? (??:0)
>
> Please do reply me asap.
>
I have no real experience with Linux but as far as I know the JdbcOdbc
bridge is only distributed with the JDK for windows.

I'd suggest you stick with the native JDBC driver.
The second error indicates an error with your classpath. Is there a
reason why you don't use the SUN JDK for development? Does the GNU
compiler support Class.forName() (which is the usual way of registering
the drive) in the meantime?

Without your code, it's really hard to tell where your error is.

Thomas