Hi Folks,
I am battling Database.HSQL to get it to work on GHC-6.8.3 running Cygwin/XP
and I seem to have found a worthy opponent.
I have got the following to work:
import Database.HSQL
import Database.HSQL.MySQL
main :: IO ()
main =
do c <- cnct
tbs <- tables c
putStr $ unlines $ "Tables:":[" "++tnm|tnm<-tbs]
cnct :: IO Connection
cnct = connect "host" "database" "user" "password"
To work on *ghci* that is, but I can't get it to work with *ghc*.
For ghci I use:
ghci test.hs -llibmySQL
with libmySQL.dll copied into the same directory.
If I try the same with ghc:
ghc test.hs -package hsql-1.7 -package hsql-mysql-1.7 -L.
-llibmysql
with libmysql.lib copied into the same directory I get:
C:\Program Files\Haskell\hsql-mysql-1.7\ghc-6.8.3/libHShsql-mysql-
1.7.a(MySQL.o)(.text+0x748):fake: undefined reference to [EMAIL PROTECTED]'
C:\Program Files\Haskell\hsql-mysql-1.7\ghc-6.8.3/libHShsql-mysql-
1.7.a(MySQL.o)(.text+0x83f):fake: undefined reference to
[EMAIL PROTECTED]'
[...]
C:\Program Files\Haskell\hsql-mysql-1.7\ghc-6.8.3/libHShsql-mysql-
1.7.a(MySQL.o)(.text+0x216c):fake: undefined reference to
[EMAIL PROTECTED]'
collect2: ld returned 1 exit status
If I try substituting -llibmySQL (to select the dll) I get the same results.
GHC is clearly not resolving the links between Database.HSQL.MySQL and the
native libmysql.lib/libmySQL.dll in the way that ghci does with the dll.
I must be doing something silly. If someone can tell me I would be
grateful.
I would also like to know what I need to do to package this up inside CABAL;
all my attempts so far have failed.
It seems that there has been no maintainer for HSQL for some time, which is
a shame, as folks seem to be repeatedly cracking their heads against these
problems and re-solving them. I may be able to take on hsql and hsq-mysql
myself, but not the other backends. Perhaps it is the prospect of
maintaining them all may be stopping folks from stepping forward. (If it is
being maintained and I am just making a hash of it then please accept my
apologies.)
Cheers,
Chris
_______________________________________________
Haskell-Cafe mailing list
[email protected]
http://www.haskell.org/mailman/listinfo/haskell-cafe
