Basil, Yes, the h2.jar file contains all of the needed classes for Server, Console, Shell, RunScript, JDBC client driver, etc... So if you reference the bin/h2.jar jdbc client applications you're using, it should be able to find the jdbc:h2 driver. (I've used SquirrelSQL and DBVisualizer).
The service directory is used for windows services, but you can run the Server class directly in other OSes like: java -Xmx512m-Dh2.cacheSizeDefault=262144 -cp 'h2.jar' org.h2.tools.Server -tcp -tcpAllowOthers You could then wrap that in a startup / process control script (Not sure if osX uses rc.d scripts or not for that) BTW, to make version upgrades easier, I recommend that you always copy the latest jar file to h2.jar and always reference h2.jar in your apps. I'm not sure if there's a way to selectively pull things out of the .jar file for redistribution of subcomponents - others might have a better idea. On Mar 26, 6:42 pm, Basil Bourque <[email protected]> wrote: > I just tried H2 today. A few questions: > > If I run H2 in Server mode on Mac OS X 10.6.2, I find a process named > "org.h2.tools.Console" listed in Apple's "Activity Monitor". Is that > the only process launched when I double-click "h2-1.2.132.jar"? I > suggest adding a mention of this to the documentation. > > Where is the JDBC driver for me to deploy with my app to connect to an > H2 database running in server-mode? Does "h2-1.2.132.jar" contain both > the database engine and the JDBC driver? Must I distribute that file, > sized 1.2 MB? > > The topic "Adding Database Drivers" found > here:http://www.h2database.com/html/tutorial.html > confused me. Why would I be adding multiple drivers? > > Is /h2/service folder only for running H2 as a Service under Windows > as described here:http://www.h2database.com/html/advanced.html > Can I ignore or delete that folder if not running on Windows? > > Thanks for your work. This was so much fun to find, install, and use > H2 all in one afternoon. > > --Basil Bourque -- 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.
