Node.js集成H2数据库：寻找合适的官方npm连接依赖

Hey there! Great question—connecting H2 with Node.js is totally feasible, even though H2 is primarily built for the Java ecosystem and doesn’t have an official Node.js driver. Let’s walk through the reliable community-maintained options you can use:

1. The h2 npm Package #

This is the most straightforward and widely used option for Node.js. It wraps the H2 JDBC driver, so you’ll need a Java runtime environment (JRE) installed on your system to use it.

• Installation:

  npm install h2
  

• Basic Connection Example:

  const H2 = require('h2');
  
  const dbConfig = {
    jdbcUrl: 'jdbc:h2:tcp://localhost:9092/your-database-name', // Adjust for your H2 setup (tcp/embedded/file)
    user: 'sa',
    password: '' // Default password is empty
  };
  
  const db = new H2.Database(dbConfig);
  
  db.connect((err) => {
    if (err) {
      console.error('Connection failed:', err);
      return;
    }
    console.log('Successfully connected to H2 database!');
    
    // Example query
    db.query('SELECT 1 FROM DUAL', (err, results) => {
      if (err) throw err;
      console.log('Query result:', results);
      db.disconnect();
    });
  });
  

2. node-jdbc Package (More Flexible JDBC Approach) #

If you prefer a more hands-on JDBC integration, you can use node-jdbc directly. This lets you manually load the H2 JDBC driver JAR file, giving you full control over the connection pool and configuration.

• Steps to Set Up:
  1. Install the package:

     npm install jdbc
     

  2. Download the latest H2 JDBC driver JAR from the official H2 website, and place it in your project directory (e.g., ./lib/h2-2.2.224.jar).
  3. Configure and connect:

     const JDBC = require('jdbc');
     
     const config = {
       url: 'jdbc:h2:tcp://localhost:9092/your-database-name',
       drivername: 'org.h2.Driver',
       classpath: './lib/h2-*.jar', // Path to your H2 JDBC JAR
       minpoolsize: 1,
       maxpoolsize: 10,
       properties: {
         user: 'sa',
         password: ''
       }
     };
     
     const jdbc = new JDBC(config);
     
     jdbc.initialize((err) => {
       if (err) {
         console.error('Initialization failed:', err);
         return;
       }
       // Reserve a connection from the pool
       jdbc.reserve((err, conn) => {
         if (err) throw err;
         console.log('Connected via JDBC!');
         
         // Execute a sample query
         conn.createStatement((err, stmt) => {
           if (err) throw err;
           stmt.executeQuery('SELECT 1 FROM DUAL', (err, rs) => {
             if (err) throw err;
             rs.toArray((err, rows) => {
               console.log('Query result:', rows);
               // Clean up
               rs.close();
               stmt.close();
               jdbc.release(conn);
               jdbc.shutdown();
             });
           });
         });
       });
     });
     

Important Notes #

• H2 runs on Java, so you’ll need a JRE installed regardless of which package you choose.
• For embedded H2 mode (instead of TCP), adjust the JDBC URL to something like jdbc:h2:./local-db-file (points to a local file-based database).
• Neither of these are official Node.js drivers, but both are actively maintained and used by the community for production and development setups.

Hope these options help you get your H2 + Node.js service up and running smoothly! If you hit specific snags with configuration or queries, feel free to share more details.

内容的提问来源于stack exchange，提问作者Jesse