Hi again - Yes, I was able to get this to work.
I used psqlODBC ( psqlodbc_08_04_0200.zip ) vs. H2 1.3.158 and was able to successfully run functions that return resultsets. Although, I was under the impression that the compiled .class of the function had to reside in the classpath of where the H2 server is started (or is that still true and I just had it configured so by mistake? anyway - I can look at that later) However, my next problem arises when trying to connect to an in-memory H2 datbase using the same PostgreSQL client. My DSN (odbcad32.exe) configuration is as follows: Data Source: H2 Test Database: mem:test;IFEXISTS=TRUE (also tried "test", "mem:test", and other combinations. Also, "IFEXISTS=TRUE" doesn't seem to work in ODBC. It actually creates whatever I enter into my -baseDir folder!) Server: localhost User name: sa Password: 123 SSL Mode: disable Server-side prepare: checked Each time I do this, it creates a fresh new DB and writes a .db file to -baseDir. And when using "mem:test" it reports that no such database exists with that name. Has anyone successfully connected a PostgreSQL ODBC Windows client to an in-memory H2 database, and if so, how did you do it - what were the details of the DSN and server.createPgServer().start() invocations? Thanks - Atul On Fri, Aug 12, 2011 at 9:54 AM, Thomas Mueller < [email protected]> wrote: > Hi, > > I don't see a reason currently why this shouldn't work, however I > never tested it myself. Did you verify it works using the regular JDBC > driver and mode? If not, could you try this first? > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
