What's the code syntax, and what all do I need to install and configure, for connecting to a Derby DB and invoking Derby Stored Procedures (which are really Java code) from a PHP Application?
i.e. In the PHP code, I want to replace the familiar mysql_connect()
and mysql_query()
calls with something that will connect to a Derby database instead, and execute queries and stored procedures there.
Derby suits well when there is need of small RDBMS in an application. MYSQL suits well for both small and large organizational data storage for an application.
Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0. Some key features include: Derby has a small footprint -- about 3.5 megabytes for the base engine and embedded JDBC driver.
If I understand correctly, you want to connect to JavaDB (also called Derby or Apache Derby) from PHP?
If so, you'll need IBM DB2 support on your PHP server.
You can also use PDO with ODBC.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With