oracle SQL Developer - 没有为 SQL 类型错误注册的读者
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10468535/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Developer - No readers registered for SQL type error
提问by kaushik
I am using Oracle 11g. I had exported data using the installed version of SQL Developer to a sql file called "export.sql". Now, I have downloaded the new version which is 3.1.07 and when I try to import data by clicking on the tree view and choosing Tables | Import Data and navigating to "export.sql", I get the following error:
我正在使用 Oracle 11g。我使用已安装的 SQL Developer 版本将数据导出到名为“export.sql”的 sql 文件中。现在，我已经下载了 3.1.07 的新版本，当我尝试通过单击树视图并选择 Tables | 来导入数据时。导入数据并导航到“export.sql”，出现以下错误：
no readers are registered for the sql type
没有为 sql 类型注册读者
When I first started the application it asked for the path to java.exe and I have shown that path and application started. I have the started the application from the path where it was downloaded (C:\users\kaushik\Downloads\sqldeveloper)
当我第一次启动应用程序时，它要求提供 java.exe 的路径，我已经显示该路径和应用程序已启动。我已经从它下载的路径启动了应用程序（C:\users\kaushik\Downloads\sqldeveloper）
回答by Martin Jones
You can call the file directly from sql developer.
您可以直接从 sql developer 调用该文件。
Example: If you saved you file to c:\Oracle\MyBackups\Export.sql Then from within Sql Developer, connect to your database and use the sql command:
示例：如果您将文件保存到 c:\Oracle\MyBackups\Export.sql 然后从 Sql Developer 中，连接到您的数据库并使用 sql 命令：
@C:\Oracle\MyBackups\Export.sql
@C:\Oracle\MyBackups\Export.sql
and that will execute the Export.Sql script.
这将执行 Export.Sql 脚本。
回答by Justin Cave
- If you have a valid SQL file, you simply need to execute the script. Open the file (File | Open and navigate to export.sql), hit the Run Script button (F5 on Windows), and choose the connection you want to use. The Data Import Wizard supports a number of different file formats (Excel, CSV, etc.). It doesn't support SQL files. If you want to ask the developers why they don't support SQL (or why they use the general file navigation dialog rather than using different dialogs for different sorts of files) you can ask them over in the SQL Developer forum on OTN. I assume the problem is that most SQL scripts contain much more than simple
INSERTstatements and it would be challenging to figure out whether any particular script was actually just a bunch ofINSERTstatements that could be used to import data. - Yes, SQL Developer is written in Java so you need to have an appropriate version of the JVM installed. Different SQL Developer download options include a bundled JVM or you can download a smaller file and use an already installed JVM.
- 如果您有一个有效的 SQL 文件，您只需执行该脚本。打开文件（文件 | 打开并导航到 export.sql），点击运行脚本按钮（Windows 上的 F5），然后选择要使用的连接。数据导入向导支持多种不同的文件格式（Excel、CSV 等）。它不支持 SQL 文件。如果您想询问开发人员为什么不支持 SQL（或者为什么他们使用通用文件导航对话框而不是为不同类型的文件使用不同的对话框），您可以在 OTN 上的SQL 开发人员论坛中询问他们。我认为问题在于大多数 SQL 脚本包含的不仅仅是简单的
INSERT语句，而且要弄清楚任何特定的脚本是否实际上只是一堆INSERT可用于导入数据的语句。 - 是的，SQL Developer 是用 Java 编写的，因此您需要安装适当版本的 JVM。不同的 SQL Developer 下载选项包括捆绑的 JVM，或者您可以下载较小的文件并使用已安装的 JVM。
回答by shareef
One of oracle client tools to make session to database is sqlDeveloper and its graphical interface tool Programmed with Java Langand its installed independently from oracle_home its a stand alone product and Of Course it needs SDK Or JDK to work make sure to set the path and check it read this link http://www.ehow.com/how_5127784_set-java-path.html
用于与数据库建立会话的 oracle 客户端工具之一是 sqlDeveloper 及其图形界面工具 用Java Lang编程， 它独立于 oracle_home 安装，它是一个独立的产品，当然它需要 SDK 或 JDK 才能工作，确保设置路径并检查它阅读此链接http://www.ehow.com/how_5127784_set-java-path.html
all of this if sql developer didn't run and other similar problem this to answer
所有这一切，如果 sql 开发人员没有运行和其他类似的问题来回答
Is JDK is needed or what ?Yes
是需要JDK还是什么？是的
