使用derby在auto ut中，No suitable driver found for jdbc:derby://localhost/...

最新推荐文章于 2022-07-08 16:47:42 发布

最新推荐文章于 2022-07-08 16:47:42 发布 · 432 阅读

文章标签：

#java #数据库

本文解决了使用Derby作为JUnit测试案例数据库时遇到的问题。详细介绍了如何正确配置Derby的驱动程序和URL，以实现内嵌数据库的使用。

今天被一个问题折磨好久，主要还是对derby不熟，

项目使用mysql，写junit test case的时候，就打算用derby来代替，这样ut就不用配置环境了，

配置如下：

driver：使用org.apache.derby.jdbc.EmbeddedDriver

url： jdbc:derby://localhost/<database name>;create=true

可是一直报错

Caused by: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost/<database name>;create=true
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)

查看代码，已经加载driver了啊

Class.forName("org.apache.derby.jdbc.EmbeddedDriver")

折腾半天，原因是用的是EmbeddedDriver， url就不能按照client/server格式来，应该是

jdbc:derby:<database name>;create=true

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

iteye_563

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

CDH Sqoop 同步Mysql 数据至hive 报错The specified datastore driver (“org.apache.derby.jdbc.EmbeddedDriver“)

爱摄影的小章同学的博客

05-12

1083

CDH Sqoop 同步Mysql 数据至hive 报错，报错内容为 Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the “BONECP” plugin to create a ConnectionPool gave an error : The specified datastore driver (“org.apache.derby.jdbc.EmbeddedDriver”) was not fou

调试经验-java.sql.SQLException: No suitable driver found for jdbc:derby:iDB

预见未来to50的专栏

04-15

1996

调试一个Derby数据库应用小程序的时候，碰到了这个问题：java.sql.SQLException: No suitable driver found for jdbc:derby:iDB 看了stackoverflow上的一些帖子，依然不知问题出在哪里。回头再看教材，发现会运行%JAVA_HOME%\db文件夹下的setEmbeddedCP.bat文件。运行结果： set CLAS

参与评论您还未登录，请先登录后发表或查看评论

求解：JAVA连接Derby数据库找不到合适的驱动

m0_46148163的博客

07-09

713

代码如下（mess已创建并录入dog表中数据，在cmd中进入ij环境能正常使用） import java.sql.*; public class Day2 { public static void main(String args[]) { try{ Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); } catch(Exception e) { } Connection con;

Derby数据库 Syntax error: Encountered “＜EOF＞“ at line 1, column 8.

kongjinyan0003的专栏

07-08

1989

原mysql数据库迁移derby 配置后运行报错如下： ``` create connection SQLException, url: jdbc:derby:E:/rndmdb;create=true, errorCode 30000, state 42X01 java.sql.SQLSyntaxErrorException: Syntax error: Encountered "" at line 1, column 8. ``` 逐项排查后 validationQuery mysql 默...

jdbc连接derby

敖尔其楞的专栏

12-07

5325

下面的代码在derby中创建了一个sample的数据库，并创建了一个表，做了些测试。 package ForTest; import java.awt.Image; import java.awt.image.RenderedImage; import java.io.OutputStream; import java.sql.Blob; import java.sql.Con

No Suitable Driver Found For Jdbc_我的解决方法

huangxy10的专栏

11-17

1万+

今天出现编码出现了No suitable driver found for jdbc，又是找遍了网上的资料，基本上都说是三个问题：一是：连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX") 二是：驱动字符串出错(com.m

No suitable driver found for jdbc\:dm\://172.16.7.131\:5237

05-27

Class.forName("org.apache.derby.jdbc.ClientDriver"); ``` 对于MySQL数据库，您可以这样加载驱动程序： ```java Class.forName("com.mysql.jdbc.Driver"); ``` 如果您已经正确加载了驱动程序，但仍然遇到这个...

schematool -dbType derby -initSchema Metastore connection URL: jdbc:mysql://hadoop0:3306/hive?useSSL= false Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: root org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver *** schemaTool failed ***

06-12

<value>org.apache.derby.jdbc.EmbeddedDriver</value> </property> EOF # Step 3: 重新初始化Derby schematool -dbType derby -initSchema ``` --- ### 3. **关键验证点** | 问题原因 | 验证方法 | 修复措施 | ...

root@instance-000030cd:/opt/apache-hive-2.3.3-bin/conf# schematool -initSchema -dbType mysql Metastore connection URL: jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. Underlying cause: java.sql.SQLException : Access denied for user 'APP'@'localhost' (using password: YES) SQL Error code: 1045 Use --verbose for detailed stacktrace. *** schemaTool failed *** root@instance-000030cd:/opt/apache-hive-2.3.3-bin/conf# source hive-env.sh root@instance-000030cd:/opt/apache-hive-2.3.3-bin/conf# schematool -initSchema -dbType mysql Metastore connection URL: jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. Underlying cause: java.sql.SQLException : Access denied for user 'APP'@'localhost' (using password: YES) SQL Error code: 1045 Use --verbose for detailed stacktrace. *** schemaTool failed ***

03-08

2. **驱动配置错误**：实际使用的是 Derby 驱动 (`org.apache.derby.jdbc.EmbeddedDriver`)，但你的目标是 MySQL。 3. **密码验证失败**：提供的密码与 MySQL 中 `APP` 用户的密码不匹配。 --- ### 解决方案步骤 ...

[root@master hive]# bin/schematool -dbType derby -initSchema SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/server/hive/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/export/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Initializing the schema to: 4.0.0 Metastore connection URL: jdbc:mysql://192.168.128.130:3306/hive?createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8 Metastore connection Driver : com.mysql.jdbc.Driver Metastore connection User: root Failed to get schema version. Underlying cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException : Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. SQL Error code: 0 Use --verbose for detailed stacktrace. *** schemaTool failed *** [root@master hive]#

最新发布

11-07

只要 `hive-site.xml` 中配置了 `javax.jdo.option.ConnectionURL` 等属性，就会强制使用 MySQL，**忽略 `-dbType derby` 参数**！ --- ### 知识点详解 - **Hive 元数据管理机制**：通过 metastore 服务统一管理...

No suitable driver found for jdbc的三种情况

fantasticqiang的博客

02-26

2万+

今天出现使用jdbc出现了No suitable driver found for jdbc，又是找遍了网上的资料，有一下三种情况：一是：连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX") 二是：驱动字符串出错(com....

springboot配置mysql数据库报错: create connection SQLException

makersy的博客

05-18

7000

配置springboot+druid时，启动时总是报错，错误信息如下; java.sql.SQLException: Unknown system variable 'tx_isolation' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[mysql-connector-java-5.1.43.jar:5....

出现java.sql.SQLException: No suitable driver的几种解决办法

你的代码有灵魂吗？

05-23

7万+

com.mchange.v2.resourcepool.BasicResourcePool 警告: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@5df68463 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying

数据库报错create connection SQLException,............ errorCode 1129, state HY000

weixin_43334878的博客

12-17

1万+

报错com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://mysql:3306/config?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai, errorCode 1129, state HY000 错误：Host is blocked b.

create connection SQLException

嘻哈熊的专栏

09-04

2万+

问题描述如下： 10:51:24.314 [Druid-ConnectionPool-Create-3305495] ERROR c.a.d.p.DruidDataSource - [run,2471] - create connection SQLException, url: jdbc:mysql://localhost:3306/**?useUnicode=true&charact...

create connection SQLException, url: jdbc:mysql:///xxx?....

klklk888的博客

12-03

2万+

错误代码： ERROR 12-03 21:54:15,424 create connection SQLException, url: jdbc:mysql:///oasystem?useSSL=false&serverTimezone=GMT&allowPublicKeyRetrieval=true, errorCode 1193, state HY000 (DruidDataSource.java:2755) java.sql.SQLException: Unknown system

derby数据库基本语法

qq_34928887的博客

01-06

1万+

1表操作语法1.1创建/连接数据库网络服务器模式connect 'jdbc:derby://localhost:1527/MYDB;create=true;user=root;password=123';（1）“jdbc:derby:”derby数据库URL的头部，必须有；（2）“//localhost:1527/MYDB”网络服务器模式必有的主机IP、derby数据库端口号、数据库名（数据库会

连接MySQL错误:create connection SQLException, url: jdbc:mysql://localhost:3306/*****?