H2-使用SQL语句"SELECT * FROM null T"访问链接表时出错. [英] H2 - Error accessing linked table with SQL statement "SELECT * FROM null T"

问题描述

我尝试在Java应用程序中创建链接表.

I try to created linked table in my Java application.

Statement stmtH2 = DBconnect.connH2.createStatement()
String linkedTable = ("CREATE LINKED TABLE tableName('', 'jdbc:mysql://localhost:3306/DBname', 'root', '', 'tableName');";
stmtH2.execute(linkedTable)

String query = "SELECT * FROM tableName WHERE Sex = 'F' ORDER BY Cod";
stmtH2.executeUpdate(query);

在Java中，我遇到此错误:

In Java I've got this error:

org.h2.jdbc.JdbcSQLException: Column "COD" not found; SQL statement:

当我尝试查看运行 SELECT * FROM tableName 的localhost:8082中的表时，出现错误:

When I try to see the table in localhost:8082 running SELECT * FROM tableName an error comes up:

Error accessing linked table with SQL statement "SELECT * FROM null T", cause: "org.h2.jdbc.JdbcSQLException: Class ""com.mysql.jdbc.Driver"" not found [90086-175]"; SQL statement:
SELECT * FROM tableName [90111-175] 90111/90111 (Help)

为什么找不到"COD"列?

Why column "COD" is not found?

推荐答案

您的应用程序缺少 com.mysql.jdbc.Driver .将其添加到应用程序的类路径中.

Your application is missing com.mysql.jdbc.Driver. Add it to the classpath of your application.

这篇关于H2-使用SQL语句"SELECT * FROM null T"访问链接表时出错.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！