问题描述
我刚刚安装了derby,并且按照此处中的说明进行操作和我告诉我的方法完全一样,只是用我的路径替换了路径.但是由于某些原因,为什么我尝试创建一个连接以连接以创建数据库并运行我的sql脚本来创建表并填充它们,所以它首先给了我一些错误
I just installed derby and I followed the instructions from here the exact same way it told me to but replacing the paths with my paths. But for some reason why i try to create a connection to connect to create a Database and run my sql scripts to create the tables and populate them it gives me a few errors firstly is this one
ERROR 08001: No suitable driver found for jdbc:derby:SuperMarket;create=true
然后,当我的sql脚本运行时,出现此错误
Then when my sql scripts run I get this error
IJ ERROR: Unable to establish connection
我看不出我做错了什么,这是我用来设置类路径的行
I dont see what I did wrong this is the line i used to set the class path
C:\> set CLASSPATH=%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;.
我包括了所需的derby.jar文件,所以我看不到有人知道我做错了什么的问题吗?也是我跑步的时候
I included the derby.jar file that was needed so I can't see the problem does anyone know what I did wrong? Also when I run
connect 'jdbc:derby://localhost:1527/MyDB';
服务器启动正常
C:\Derbs\db-derby-10.10.2.0-bin\bin>startNetworkServer
Thu Jun 26 11:56:38 PDT 2014 : Security manager installed using the Basic server
security policy.
Thu Jun 26 11:56:39 PDT 2014 : Apache Derby Network Server - 10.10.2.0 - (158244
6) started and ready to accept connections on port 1527
推荐答案
当我开始使用DerbyDB时会遇到很多麻烦.练习真的很痛苦.
There are many troubles when I start using DerbyDB. It is really painful to practice.
1. 例如,我从 http://db.apache.org/derby/derby_downloads.html#Latest+Official+Releases
1. For example, I download Derby from http://db.apache.org/derby/derby_downloads.html#Latest+Official+Releases
2..解压缩到C:\tools\db-derby-10.11.1.1-bin
.
3..按Windows键+ ,键入:SystemPropertiesAdvanced
,设置环境变量.
参考: https://db.apache. org/derby/docs/10.0/manuals/getstart/gspr16.html
3. Press Windows key + , type: SystemPropertiesAdvanced
, set up environment variables.
Reference: https://db.apache.org/derby/docs/10.0/manuals/getstart/gspr16.html
4..运行cmd
,我们应该运行其他命令:
4. Run cmd
,We should run additional command:
C:\tools\db-derby-10.11.1.1-bin\bin\NetworkServerControl.bat
然后输入:
C:\tools\db-derby-10.11.1.1-bin\bin\ij.bat
然后按,结果:
5..我们会将内存Derby数据库放入D:\
目录.文件夹vy1
不能退出.我们键入命令以创建名为vy1
的新数据库:
5. We will put in-memory Derby database to D:\
directory. Folder vy1
must doesn't exit. We type command for creating new database named vy1
:
connect 'jdbc:derby:D:\vy1;create=true';
使用Windows资源管理器,转到目录D:\vy1
,您将看到刚刚创建的名为vy1
的新文件夹.
Use Windows Explorer, go to directory D:\vy1
, you will see new folder named vy1
just created.
然后键入命令:
connect 'D:\vy1'
6..请参见SQL命令来创建数据库,表,进行插入,然后读取数据库,如下所示:
6. See SQL command to create database, table, insert, then read database like this:
(在新网页中打开图像更易于查看.注意:这是我几个月前使用旧版本时的旧屏幕截图).
(Open images in new web page is better for view. Note: This is my old screenshot when I use older version few months ago).
回到您的问题,重点关注第3部分,并建议在第4部分致电NetworkServerControl.bat
.
Come back to your question, focus at section 3, and commnand call NetworkServerControl.bat
at section 4.
祝你好运! :)
这篇关于Derby类路径无法连接到数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!