64 bit windows jdbc_fdw.dll issues

[guanno686]

I have been trying to get jdbc_fdw to work on a 64 bit Windows system to no avail. First I had issues trying to install it using windows sdk getting errors like jdbc_fdw.obj : error LNK2019: unresolved external symbol JNI_CreateJavaVM" so I switched and was able to install it using 64 bit mingw. The server starts up fine bit now when I go to Create extension, I get the error below. I see the dll and have tried changing the path etc and nothing seems to work. Any advice would be much appreciated.

ERROR: could not load library "C:/PostgreSQL/9.3/lib/jdbc_fdw.dll": The specified module could not be found.

[guanno686]

Update to this, I was able to get past the initial error by updating the classpath to point to a specific jvm.dll but now get the following error.

ERROR: incompatible library "C:/PostgreSQL/9.3/lib/jdbc_fdw.dll": magic block mismatch DETAIL: Server has FLOAT8PASSBYVAL = false, library has true.

[atris]

Which PostgreSQL version are you using?

Sent from my iPad

On 30-Sep-2013, at 19:37, guanno686 [email protected] wrote:

Update to this, I was able to get past the initial error by updating the classpath to point to a specific jvm.dll but now get the following error.

ERROR: incompatible library "C:/PostgreSQL/9.3/lib/jdbc_fdw.dll": magic block mismatch DETAIL: Server has FLOAT8PASSBYVAL = false, library has true.

— Reply to this email directly or view it on GitHub.

[guanno686]

The version is 9.3.0

[atris]

I have never tested on 9.3 actually. The last version tested was 9.2

On Mon, Sep 30, 2013 at 8:21 PM, guanno686 [email protected] wrote:

The version is 9.3.0

— Reply to this email directly or view it on GitHubhttps://github.com/atris/JDBC_FDW/issues/13#issuecomment-25369105 .

Regards,

Atri l'apprenant

[guanno686]

So could this error be because it is 9.3.0 on windows x64? My coworkers have it working on MAC OS with 9.3.0.

[theRealZing]

Atris, would you expect the current JDBC_FDW code to work on 9.3 or does it need to be patched first?

[atris]

I dont expect it to work per se. Let me have a look

On Thu, Oct 10, 2013 at 8:02 PM, theRealZing [email protected]:

Atris, would you expect the current JDBC_FDW code to work on 9.3 or does it need to be patched first?

— Reply to this email directly or view it on GitHubhttps://github.com/atris/JDBC_FDW/issues/13#issuecomment-26058502 .

Regards,

Atri l'apprenant