数据库问题一问 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

数据库问题一问

数据库问题一问# Database - 数据库

r*d2004-02-01 08:02

1 楼

偶现在帮忙做一个网站，用户每天都要上传一些MS Access 文件。完了以后每天
DBA会把这些文件中的数据load 到Oracle database里面。现在想写一个程序，
每天到了一个时间会自动运行做这件事情。请问具体怎么实现？偶比较熟悉java,
JDBC等。Thanks,

e*s2004-02-01 08:02

2 楼

DTS :)

【在 r*******d 的大作中提到】

: 偶现在帮忙做一个网站，用户每天都要上传一些MS Access 文件。完了以后每天
: DBA会把这些文件中的数据load 到Oracle database里面。现在想写一个程序，
: 每天到了一个时间会自动运行做这件事情。请问具体怎么实现？偶比较熟悉java,
: JDBC等。Thanks,

n*a2004-02-01 08:02

3 楼

First, you need JDBC driver for MS Access or
ODBC driver combined with ODBC-JDBC bridge.
With JDBC, you can write a java program that
would extract data from Access files.
And then, you have two options:
1. Use Oracle JDBC driver to write a java
program that would dump the data into Oracle.
Use java.util.Timer to schedule to your two
java programs to run.
2. Load your previous extraction java program
into Oracle as stored procedure. Write a PL/SQL
store procedure inside Oracle that would dump
th

【在 r*******d 的大作中提到】

e*s2004-02-01 08:02

4 楼

sigh.... 如果用 DTS 的话...5 分钟就全部搞定了呀 :)

【在 n********a 的大作中提到】

: First, you need JDBC driver for MS Access or
: ODBC driver combined with ODBC-JDBC bridge.
: With JDBC, you can write a java program that
: would extract data from Access files.
: And then, you have two options:
: 1. Use Oracle JDBC driver to write a java
: program that would dump the data into Oracle.
: Use java.util.Timer to schedule to your two
: java programs to run.
: 2. Load your previous extraction java program

r*d2004-02-01 08:02

5 楼

Thanks! What is DTS? :)

【在 e*********s 的大作中提到】

: sigh.... 如果用 DTS 的话...5 分钟就全部搞定了呀 :)

e*s2004-02-01 08:02

6 楼

Guess you wouldn't like it. Its Microsoft SQL Server "data transformation
services"

【在 r*******d 的大作中提到】

: Thanks! What is DTS? :)