Hi, There are multiple problem. First, you can't connect with a browser to the TCP server. You need to start a "web" server (H2 Console). See http://h2database.com/html/tutorial.html#tutorial_starting_h2_console and http://h2database.com/html/tutorial.html#using_server - the documentation is not very clear about that, I will try to improve it.
> Tried Solution: Used Spring to create the DBCP Pool for H2 db. Here is > the spring config. I suggest to *not* try Spring or a connection pool until you have understood using the database with the JDBC API, and using the H2 API. Once you have done that, it's relatively simple to "add" Spring and to "add" a connection pool. I'm not saying Spring or connection pools are bad, but it's added complexity (more possibilities for bugs) you should avoid until the basics work. > jdbc:h2:mem:tcp://localhost:9092/tcpTest;MODE=Oracle;DB_CLOSE_DELAY=-1;AUTO_SERVER=TRUE There are two bugs here. First, AUTO_SERVER with memory database are not supported. Second, you have the "mem:" at the wrong place. You probably want: jdbc:h2:tcp://localhost:9092/mem:tcpTest;MODE=Oracle;DB_CLOSE_DELAY=-1 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.
