What do I change to link to the H2 database?
This is the datasource "pods" using Access...
<datasource name="pods">
<password></password>
<servername></servername>
<sqldelete>true</sqldelete>
<sqlupdate>true</sqlupdate>
<username></username>
<drivername>sun.jdbc.odbc.JdbcOdbcDriver</drivername>
<sqlstoredprocedures>true</sqlstoredprocedures>
<sqlinsert>true</sqlinsert>
<sqlselect>true</sqlselect>
<connectiontimeout>120</connectiontimeout>
<drivertype>3</drivertype>
<port></port>
<databasename>pods</databasename>
<description>Microsoft Access Driver (*.mdb)</description>
<logintimeout>120</logintimeout>
<hoststring>jdbc:odbc:pods</hoststring>
<maxconnections>24</maxconnections>
<name>pods</name>
</datasource>
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf
Of Alan Williamson
Sent: Tuesday, November 25, 2008 11:44 AM
To: [email protected]
Subject: [OpenBD] Re: Installing and Running OpenBD
On 25/11/2008 16:42, Augusta ENT wrote:
> If I can link H2 to OpenBD today I will re-create my apps tableset in H2
and
> test it "in production".
i think you are being a little hopeful there. If your existing app is
written in SQL Server, then i suspect your SQL isn't going to work
straight out of the box. H2 is a slightly different flavor. Just like
MySQL is for example.
Unless of course you've already tested with H2 ... you can run it up as
a standalone server using the documentation on H2 website; that has
nothing to do with OpenBD at that point.
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official blog @ http://blog.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
