Re: [Henplus-user] henplus vs. filemaker

[Roy M. <mcm...@md...>]

Thanks for the reply Ole.

Yes, I have been able to successfully execute queries from an alternate 
application (Atlassian Confluence with SQL plugin running under Tomcat 
which uses JDBC).

I haven't found a way to log at the level of the JDBC driver.  I've also 
tried using wireshark between my machine and the FileMaker server to 
monitor the transactions, but unfortunately the communication is binary 
and/or encrypted.  Logs on the server side show nothing of value.

Your other 2 suggestions may be a bit beyond me, as I'm not proficient 
in Java programming, but I will look into it.

Thanks,
Roy

On 11/14/10 11:36 AM, Ole Langbehn wrote:
> Hi Roy,
>
> the describe and tables commands in henplus are internal, they use jdbc
> meta information to show the table description/information. So the
> connection is good.
>
> I don't know anything about filemaker, but I have some common suggestions:
>
> * make sure you can execute the sql against the database some other way,
> * see if you can somehow log the sql received via jdbc by filemaker and
> see if it's any different from the sql you entered in henplus,
> * try to code a minimal jdbc client connecting to your filemaker database
> and see if you get the same error,
> * if the error still seems to be on henplus' side, then check out the
> sources and debug, e.g. with eclipse.
>
> If you haven't done so, maybe reading this document will help:
>
> http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf
>
> If I can help with anything, let me know.
>
> Regards,
>


-- 
Roy McMorran
Systems Administrator
MDI Biological Laboratory
mcm...@md...