Home Database Mysql Tutorial 在Oracle中集成java程序的经验之谈!

在Oracle中集成java程序的经验之谈!

Jun 07, 2016 pm 03:39 PM
java oracle for time program integrated

这段时间为公司内部的数据处理开发了一个工具,牵涉到在Oracle中集成java应用,总结了一些经验,以供大家参考了! 程序分两部分,前端界面由VB/VC开发,主要实现数据处理配置及常规记录运算,这部分没有什么好说的了。 后台以Oracle为数据基础处理托管平台,

这段时间为公司内部的数据处理开发了一个工具,牵涉到在Oracle中集成java应用,总结了一些经验,以供大家参考了!

程序分两部分,前端界面由VB/VC开发,主要实现数据处理配置及常规记录运算,这部分没有什么好说的了。

后台以Oracle为数据基础处理托管平台,在数据处理过程中,需要对一些名称、地址什么的进行摘要提取、拆分等等。这部分是以java实现的,loadjava到Oracle中做成相应的处理函数。

在这里,如何在Oracle中集成java大家可以在网上轻松找到,这里就不详细说明了。主要着重说明一些需要注意的细节:

1:在loadjava的时候,最好加上“-genmissing”参数,这样,在对应的jar或java文件上传后,Oracle会马上加载每个类,如果有错误,会马上在命令行中详细列出,从而避免了在运行中出错。运行中出错有时候报错信息很粗陋,很难排查!

2:如果在java程序中牵涉到对系统环境变量、磁盘、IO通道等资源的读写,一定要先给相关用户授权,一般如下:

3:java代码的版本:9i数据库只支持jdk1.3,10g支持1.4,11g以上的才支持jdk1.5,所以如果采用泛型、enum等特性的java代码只能在11g上用,如果实际生产系统中必须使用10g以下的版本,又不想对代码进行大规模修改的话,可以采用“retrotranslator”这个开源工具对jdk1.5以上的类进行1.4兼容处理。关于这方面的内容,可以参考:http://www.ibm.com/developerworks/cn/java/j-jtp02277.html?s_cmp=techccid&s_tact=105agx52

"retrotranslator"的站点:http://retrotranslator.sourceforge.net/

一般的用法:

java -jar retrotranslator-transformer-1.2.9.jar -srcjar M:/Develop/WordSimilarity/dist/WordSimilarity.jar -destjar M:/Develop/WordSimilarity/dist/WordSimilarity14.jar -embed com.navinfo.transformer

4:被集成为Oracle函数的功能,如分词等,一定要设置为全局static,这样可以防止重复加载,提高处理效率

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP: A Key Language for Web Development PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

PHP vs. Python: Core Features and Functionality PHP vs. Python: Core Features and Functionality Apr 13, 2025 am 12:16 AM

PHP and Python each have their own advantages and are suitable for different scenarios. 1.PHP is suitable for web development and provides built-in web servers and rich function libraries. 2. Python is suitable for data science and machine learning, with concise syntax and a powerful standard library. When choosing, it should be decided based on project requirements.

PHP vs. Other Languages: A Comparison PHP vs. Other Languages: A Comparison Apr 13, 2025 am 12:19 AM

PHP is suitable for web development, especially in rapid development and processing dynamic content, but is not good at data science and enterprise-level applications. Compared with Python, PHP has more advantages in web development, but is not as good as Python in the field of data science; compared with Java, PHP performs worse in enterprise-level applications, but is more flexible in web development; compared with JavaScript, PHP is more concise in back-end development, but is not as good as JavaScript in front-end development.

What to do if the oracle can't be opened What to do if the oracle can't be opened Apr 11, 2025 pm 10:06 PM

Solutions to Oracle cannot be opened include: 1. Start the database service; 2. Start the listener; 3. Check port conflicts; 4. Set environment variables correctly; 5. Make sure the firewall or antivirus software does not block the connection; 6. Check whether the server is closed; 7. Use RMAN to recover corrupt files; 8. Check whether the TNS service name is correct; 9. Check network connection; 10. Reinstall Oracle software.

How to solve the problem of closing oracle cursor How to solve the problem of closing oracle cursor Apr 11, 2025 pm 10:18 PM

The method to solve the Oracle cursor closure problem includes: explicitly closing the cursor using the CLOSE statement. Declare the cursor in the FOR UPDATE clause so that it automatically closes after the scope is ended. Declare the cursor in the USING clause so that it automatically closes when the associated PL/SQL variable is closed. Use exception handling to ensure that the cursor is closed in any exception situation. Use the connection pool to automatically close the cursor. Disable automatic submission and delay cursor closing.

PHP: The Foundation of Many Websites PHP: The Foundation of Many Websites Apr 13, 2025 am 12:07 AM

The reasons why PHP is the preferred technology stack for many websites include its ease of use, strong community support, and widespread use. 1) Easy to learn and use, suitable for beginners. 2) Have a huge developer community and rich resources. 3) Widely used in WordPress, Drupal and other platforms. 4) Integrate tightly with web servers to simplify development deployment.

How to create cursors in oracle loop How to create cursors in oracle loop Apr 12, 2025 am 06:18 AM

In Oracle, the FOR LOOP loop can create cursors dynamically. The steps are: 1. Define the cursor type; 2. Create the loop; 3. Create the cursor dynamically; 4. Execute the cursor; 5. Close the cursor. Example: A cursor can be created cycle-by-circuit to display the names and salaries of the top 10 employees.

PHP vs. Python: Use Cases and Applications PHP vs. Python: Use Cases and Applications Apr 17, 2025 am 12:23 AM

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

See all articles