急！用jdbc-odbc访问paradox数据库的问题

sojkey 2004-02-05 10:13:19

我在xp professional上建了一个paradox的odbc数据源，在java程序中用jdbc访问时可以读取数据，但是不能修改，也不能删除，该如何解决？

出错信息如下：

java.sql.SQLException: [Microsoft][ODBC Paradox Driver] 无法从指定的数据表中删除
。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at DBTester.main(DBTester.java:20)

odbc数据源确认没有设为只读，有没有不同过odbc直接访问paradox的jdbc驱动？

...全文

78 5 打赏收藏转发到动态举报

写回复

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

软件简介：RazorSQL 是数据库查询工具、SQL的编辑、数据库管理工具,可以通过ＯＤＢＣ，ＪＤＢＣ连接数据库，已经证实可以使用的数据库种类，达到了２９种． RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 29 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases Enhanced Feature Set Standard Feature Set DB2 Ingres Pervasive Cache Mimer SQL Derby InterBase PostgreSQL Daffodil Netezza Firebird JavaDB SQLite DBASE Paradox FrontBase MS SQL Server SQL Anywhere FileMaker PointBase H2 MySQL Sybase (ASE) Mckoi Solid HSQLDB OpenBase Teradata Microsoft Access Informix Oracle Features * A Database Navigator for browsing database objects. * An SQL Editor for creating SQL queries. * Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences * Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers * A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more. * Export Tool - Export data in various formats * Import Tool - Import data from delimited files, Excel files, or fixed width files into tables * Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration * A Generate DDL Tool for generating table, view, and index DDL. * Table / SQL Query Compare tool for comparing tables or queries across multiple connections * Database Data Search tool for searching single or multiple database table and view data. * Database Object Search tool for searching for database objects. * Backup tools such as the Database Backup Tool and Table Backup Tool * Auto column and auto table lookup * SQL Formatter * SQL Query builder tool * SQL Query Scheduler tool * Command Line Interface * PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers * An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers * SQL GUI Tools for generating SQL for various operations * Edit, delete, and insert database data with the Database Editor * Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS * Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata

RazorSQL 是一个非开源的功能非常强大数据库查询工具、SQL的编辑、数据库管理工具。支持通过 JDBC 和 ODBC 连接超过 29 种的数据库。 DB2 H2 Microsoft Access Oracle SQLite DBASE HSQLDB Mimer SQL Paradox SQL Anywhere Derby Informix MongoDB Pervasive SQL Azure Filemaker Ingres MS SQL Server PostgreSQL Sybase (ASE) Firebird Interbase MySQL SimpleDB Sybase IQ Frontbase Int.Sys. Cache Netezza solidDB Teradata Greenplum JavaDB OpenBase

paradox 数据库是borland公司的产品，以.db为扩展名,其中 1）文件目录＝＝数据库 2） .db文件＝＝数据表以下是Jave连接paradox数据库的几种方式： <1> 利用JDBC驱动前提：Paradox_JDBC30.jar包（收费）连接代码如下： String driver = "com.hxtt.sql.paradox.ParadoxDriver...

paradox读取数据库，汉字显示乱码使用workbench连接paradox数据库文件，查到的数据库表中的汉字都是乱码；连接参数：com.hxtt.sql.paradox.ParadoxDriver jdbc:paradox:/C:\Data 使用odbc连接，也是乱码，请问如何才能解决乱码问题，url参数怎么样能调整下编码设置或者别的解决方法？（数据库 编码是BIG5） ...

try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); try { Connection conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=\\192.168.1.108/db/EyeTest.md

62,614

社区成员

307,326

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章