Derby数据库ODBC连接 [英] Derby Database ODBC Connection

问题描述

我在Netbeans中有一个带有连接字符串的Derby数据库

I have a Derby Database in Netbeans with connection string

jdbc:derby://localhost:1527/MyDatabase

这可以用于ODBC吗？如果是这样，我如何转换这个或配置我的Derby数据库以符合ODBC

Can this be used with ODBC? If so, how could I transform this or configure my Derby Database to be compliant with ODBC

最终目标是让Derby数据库迁移到MySQL。在MySQL Workbench中使用迁移向导似乎是最简单的方法。

The end goal is to get the Derby Database migrated to MySQL. Using the migrating wizard in MySQL Workbench appears to be the easiest way. However I do need ODBC connectivity.

推荐答案

是否要使用ODBC，因为MySQL Workbench使用ODBC迁移数据库？

Do you want to use ODBC because MySQL Workbench uses it to migrate database?

我在各种引擎之间迁移了一些数据库，我最喜欢的技术是转换DDL模式（ CREATE TABLE ， CREATE VIEW 等）。然后我使用JDBC与 getObject（） / setObject（）方法复制数据。您可以在我对 Blob的迁移数据从Informix到Postgres 。

I migrated some databases between various engines and my favorite technology is to convert DDL schema (CREATE TABLE, CREATE VIEW etc) using specialized Python program. Then I use JDBC with getObject()/setObject() methods to copy data. You can see such copy database Jython program (Jython is a Python language that works using JVM and can use JDBC drivers) in my response to Blob's migration data from Informix to Postgres .

BTW快速搜索显示IBM有ODBC驱动程序到Derby（他们买了早期购买Cloudscape的Informix）： http：// www.ibm.com/developerworks/data/library/techarticle/dm-0409cline2/

BTW Quick search shows that IBM have ODBC driver to Derby (they bought Informix that earlier bought Cloudscape): http://www.ibm.com/developerworks/data/library/techarticle/dm-0409cline2/

这篇关于Derby数据库ODBC连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！