Thomas replied... and this does work. The problem was that I was
using a JDBC url of the form:
jdbc:h2:~/DB_NAME_HERE
instead of
jdbc:h2:tcp://localhost/DB_NAME_HERE
I don't understand why this works the way it does, but if you want to
connect to a DB with a base dir you need to use the full URL; One
question I have is... does this hurt performance for embedded H2
database servers? It seems unnecessary to make communication with the
DB travel up and down the TCP stack just to be able to use the baseDir
option.
Thanks for the help Thomas,
milly
On Sep 29, 12:09 pm, milly <[EMAIL PROTECTED]> wrote:
> Bringing up an old topic...
>
> Was there ever any resolution for using the baseDir parameter with
> embedded databases?
>
> String baseDir = "C:/mydocuments/h2db";
> String[] args = new String[]{"-baseDir", baseDir};
> server = new Server();
> int exitCode = server.run(args, System.out);1
>
> This code seems to drop the baseDir argument on the floor as none of
> the data files ever make it into the C:/mydocuments/h2db directory.
>
> thanks,
>
> milly
>
> Hi,
> Sorry, I think that -baseDir simply does not work for the H2 Console
> (when using embedded databases, that is database URL of the form
> jdbc:h2:test) , it only works for the server mode (database URL
> jdbc:h2:tcp://localhost/test). I will think about a way to make the
> -baseDir parameter work with embedded databases as well. As a
> workaround (not a good one I know) you could use the Console to
> connect to a database in server mode (you would need to start the
> server as well of course, using the -baseDir parameter).
> Thomas
>
> On 4/26/07, 簡建勝 <[EMAIL PROTECTED]> wrote:
>
> - Hide quoted text -
> - Show quoted text -
>
> > import java.io.File;
> > import javax.servlet.*;
> > import java.sql.*;
> > import org.h2.tools.Server;
> > public class DBStart implements ServletContextListener {
> > private Server server;
> > public void contextInitialized(ServletContextEvent servletContextEvent)
> > {
> > try {
> > File file = new File("DB");
> > if(!file.exists()){
> > file.mkdir();
> > }
> > System.out.println("DB
> > Starting..........................................................................................................");
> > String[] DBArgs = new
> > String[]{"-webPort","8082","-webAllowOthers","true","-baseDir",
> > file.getAbsolutePath()};
> > for(int i = 0;i<DBArgs.length;i++){
> > System.out.println(DBArgs[i]);
> > }
> > server = Server.createWebServer(DBArgs);
> > server.start();
> > } catch (Exception e) {
> > e.printStackTrace();
> > }
> > }
> > public void contextDestroyed(ServletContextEvent servletContextEvent) {
> > try {
> > server.stop();
> > System.out.println("DB Shutdown
> > ..........................................................................................................");
> > } catch (Exception e) {
> > e.printStackTrace();
> > }
> > }
> > }
> > Every time,When I start the tomcat service,the database(if db not exists)
> > always create in tomcat 'root' folder just like 'C:\Program Files\Apache
> > Software Foundation\Tomcat 5.5' !!!!
> > but my '-baseDir' is assign 'C:\Program Files\Apache Software
> > Foundation\Tomcat 5.5\DB', How to use '-baseDir'??
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
