Discussions
Categories
- 382.2K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 521 MySQL Community Space
- 464 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 489 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 127 Programming Languages
- 289.9K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 260 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Write my own Pure Python Oracle DB Module?
I'd like to get my Python application to send a few commands to an Oracle DB.
As often ends up being case when it comes to Windows and Python modules written in C, cx_Oracle isn't installing properly. Even when I install it with the wheel, I'm still getting a
ImportError: DLL load failed: %1 is not a valid Win32 application.
Even if cx_Oracle were to suddenly work, the requirements list would strike me as too long and fragile.
So I'd like to write my own Pure Python Oracle DB module instead. I'm not planning on implementing everything in it - just some basic CRUD. Does anyone know where the protocol is documented? Or has anyone else already done (or started) something similar?
Best Answer
-
The Oracle Net protocol isn't published.
Stick with cx_Oracle. Check that PATH has the Oracle client libraries, e.g. Instant Client. And that those libraries are the version used to build cx_Oracle. And that those libraries are the correct 32 or 64-bitness
Answers
-
The Oracle Net protocol isn't published.
Stick with cx_Oracle. Check that PATH has the Oracle client libraries, e.g. Instant Client. And that those libraries are the version used to build cx_Oracle. And that those libraries are the correct 32 or 64-bitness -
I'm now able to import the cx_Oracle properly... it was necessary to install the 32 bit version of the instant client, since my Python install is 32 bit.
It appears a 64 bit version of the server and 32 bit version of the instant client can peacefully co-exist.I'll just write a wrapper which can automatically handle downloading and installing both the wheel and the Instant Client...
-
I'm glad you are up & running. Can you share your wrapper?