Win a copy of Transfer Learning for Natural Language Processing (MEAP) this week in the Artificial Intelligence and Machine Learning forum!

David Rolfe

Greenhorn
+ Follow
since Oct 08, 2003
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by David Rolfe

There's nothing to stop you from putting whatever you like into a comment as part of the SQL staements being issued:

SELECT /* This is freds SQL */ * FROM emp;

If you can get access to the SQL statements the database knows about you can find *your* sql fairly easy.

If your database is Oracle you should google the following:

Oracle v$session
dbms_application_info.set_module
oracle userenv


David Rolfe
Orinda Software, Dublin Ireland.

Makers of OrindaBuild, a Java Web Service Generator for Oracle.
OrindaBuild is now available as a plugin for Eclipse 3.3.

OrindaBuild helps you interact with Oracle by creating a Java service to call your PL/SQL procedures and SQL statements as well as access tables.

OrindaBuild is a commercial product but an unlimited number of expiring demo
versions can be downloaded.

OrindaBuild examines your SQL statements and PL/SQL procedures and writes the Java source files for a service that can be easily integrated with your environment. Using OrindaBuild involves minimal changes to your SQL statements and no changes to your PL/SQL.

Unlike alternative approaches, OrindaBuild does not require that you change your code, your IDE, your development environment, or your database schema. OrindaBuild does not place limitations of the type or order of parameters in PL/SQL procedures and happily supports records and arrays. OrindaBuild also does conventional Object/Relational persistence.

For more information see here:

http://www.orindasoft.com/public/ecfeatures.php4

To download and install from an update site use this URL:

http://www.orindasoft.com/public/ec33/site.xml

The OrindaBuild plugin for Eclipse is 100% new code and follows on from our successful plugins for Oracle JDeveloper and Oracle SQL Developer.

David Rolfe
Orinda Software
Dublin, Ireland
12 years ago
Folks,

OrindaBuild makes complex PL/SQL Procedures accessible from Java without schema changes or SQLJ. The demo version of the OrindaBuild extension for Oracle JDeveloper 10.1.3 is now available from the 'Open Source and Partners Extensions' Update Center. To access this center from within JDeveloper 10.1.3 select 'Help' and then 'Check for Updates'.

Functionality:

The demo version is fully playable, with the only limitation being that it expires after 1 month. You can install the demo multiple times.

In addition to generating Java to call PL/SQL it also allows you to create code to run any SQL statement and access database tables.

OrindaBuild generates code for PL/SQL procedures that take %ROWTYPE and Package Records as parameters. Generated code uses a library. If you buy OrindaBuild you get the source code for the library and end up with a 100% source code solution - i.e. there are no mysterious runtime binary dependencies.

Limitations: The extension does not work with JDeveloper 10.1.2. The extension does not work with the Java edition of JDeveloper. We expect you to buy a licence if you deploy generated code in a production environment.

For more information see http://www.orindasoft.com/public/orcfeatures.php4

David Rolfe
Orinda Software
Dublin, Ireland
[ January 10, 2007: Message edited by: David Rolfe ]
13 years ago

Originally posted by Ben Souther:
It's written in both.

http://www.apache.org/dyn/closer.cgi/ws/axis/1_2RC3/



The 'RC' stands for release candidate - it doesn't work fully. You'd probably be better off with Axis 1.1

David Rolfe
Orinda Software
Dublin, Ireland
15 years ago
OrindaBuild was developed to generate Java code to access run PL/SQL procedures and access tables in Oracle databases. The new version also generates the code to expose PL/SQL stored procedures and SQL statements as an Apache Axis compatible web service with almost no hand coding of Java. It runs by itself or as an Eclipse Plugin.

You can see a Flash demo of it in action here:

http://www.orindasoft.com/public/flashdemotwo.php4

or get more information here:

http://www.orindasoft.com/public/features.php4

David Rolfe
Orinda Software
Dublin, Ireland
15 years ago
OrindaBuild 4.0 examines your Oracle database and writes all the Java source code you need to access its tables and PL/SQL procedures.

OrindaBuild creates human readable JDBC access code for arbitrarily complex procedures and functions that work with records, cursors and arrays without the use of a precompiler.

OrindaBuild 4.0.2054 also creates a new DAOFactory class that implements the J2EE Data Access Object pattern and is integrated with JNDI, Java 1.4 logging and Log4J.

A demo version of OrindaBuild can be downloaded here:
http://www.orindasoft.com/public/Pages.php4?location=Downloadtwo

The OrindaBuild White Paper can be downloaded here:
http://www.orindasoft.com/public/ob4whitePaper.pdf

Complete on line documentation can be found here:
http://www.orindasoft.com/public/Docstwo.php4

Examples of generated code can be found here:
http://www.orindasoft.com/public/Java2HTML

----------------------------------------------------------------------------------------------
David Rolfe
Orinda Software, Dublin, Ireland
www.orindasoft.com
15 years ago
Orinda Software is proud to announce that the latest release of OrindaBuild now runs as a Plugin for Eclipse 3.0.

OrindaBuild is a utility that automatically writes Java code to access tables, stored procedures, packages, functions and sequences in Oracle databases. OrindaBuild also takes files containing SQL statements and generates matching Java source files to run them. By automating the time consuming task of writing access code it dramatically improves productivity. OrindaBuild also helps to reduce the time taken for Java code to catch up with database design changes. OrindaBuild uses Oracle�s own data dictionary to determine exactly what source code needs to be written. It has been designed to create a large amount of useful code with minimal user interaction. It is also Oracle focused, which allows users to use 100% of Oracle�s capabilities. OrindaBuild does not require SQLJ or schema changes in order to work. OrindaBuild can write JDBC calls for arbitrarily complicated stored procedures, even if they take records or arrays as parameters.

The OrindaBuild Plugin for Eclipse 3.0 adds OrindaBuild configuration files to the list of file types recognized by Eclipse. The OrindaBuild GUI is used to edit such configuration files and uses them to generate Java source files to access Oracle. Generated files are added to the Eclipse project as they are created.

A demo version of OrindaBuild can be downloaded here:
http://www.orindasoft.com/public/santamariafour.php4?pdsrc=EC30

The OrindaBuild White Paper can be downloaded here:
http://www.orindasoft.com/public/ob4whitePaper.pdf

The manual for the Eclipse Plugin can be found here:
http://www.orindasoft.com/public/Eclipse%20Plugintwo.php4

Examples of generated code can be found here:
http://www.orindasoft.com/public/Java2HTML

----------------------------------------------------------------------------------------------
David Rolfe
Orinda Software, Dublin, Ireland
www.orindasoft.com
15 years ago
What is OrindaBuild 4.0?
========================

OrindaBuild� is a utility that automatically writes Java� code to access tables, stored procedures, packages, functions and sequences in Oracle� databases. OrindaBuild also takes files containing SQL statements and generates matching Java source files to run them. By automating the tedious task of writing access code, it can dramatically improve productivity.
OrindaBuild 4.0.1862 now runs as an extension to Oracle's new IDE - JDeveloper 10g. OrindaBuild also supports Oracle Server 10.1.0.

How does it work?
=================

OrindaBuild has a Swing GUI to choose Tables, PL/SQL� procedures or files containing SQL statements. Specify the location for code generation, add your comments and other configuration information and click Generate. All the source you need is either created or ships with the product. There is no runtime component and your code continues to work when your license expires. The Swing GUI can also be used as a Oracle JDeveloper 10G Wizard.

Design features:
================

Intuitive and straightforward - A Swing GUI lists existing database objects and makes creating code trivial.
No mysterious runtime component - Everything is done with human readable source code.
No precompilers needed - No requirement to use SQLJ.
Large object support - BLOBs, CLOBs and BFILE parameters can be treated as java.io.File objects.
Pay-As-You-Go Licensing - OrindaBuild is available for periods ranging from one month to a year. When the license expires you can maintain the code by hand. Generated code does not stop working because your licence has expired.
No Schema Changes - OrindaBuild does not create any additional database objects such as Procedures or Tables.
Table Support:
===============

Persistance - Rows can be retrieved or modified using any valid Primary or Unique key.
Navigation - Rows from related tables can be retrevied using methods that follow the table's Foreign Keys.
PL/SQL Support:
===============

Cursor Support - Cursors can't be left open and are returned in a spreadsheet like data structure.
Understands Oracle's privileges - Can call PL/SQL objects owned by other users or referred to by Synonyms.
Support for BOOLEAN parameters - Can call PL/SQL procedures with BOOLEAN parameters without having to create an additional procedure.
Support for records as parameters - Can call PL/SQL Procedures that have %ROWTYPE, %TYPE, PL/SQL Package Record and Oracle Object Type Parameters provided they don't have nested records.
SQL Support:
============

Simple user interface - The only thing users have to do is name and give data types to parameters. This can be done with either the Java user interface or by placing special comments after parameters in the SQL file.
Supports all legal SQL statements - OrindaBuild will make a runnable Java class out of any file that containts a valid SQL statement
All query results can be cached - SELECT statements are turned into classes which can cache query results
Compatible with SQL*Plus - OrindaBuild turns the '&' character into '?' and removes surrounding quotes when reading SQL files. Files which are runnable in SQL*Plus will turn into runnable Java source code without modification.
Downloading OrindaBuild
=======================

Orinda Software's web site is located at:
http://www.orindasoft.com/
A fully functional Version of OrindaBuild can be downloaded from:
http://www.orindasoft.com/public/Pages.php4?location=Downloadtwo
About Orinda Software
=====================

Orinda Software is a privately held startup located in Dublin, Ireland.
Orinda's mission is to create easily usable products that improve productivity for people who use Oracle, Java and JDBC.
Orinda Software is a Sun Independent Software Vendor.
Orinda takes major credit cards and PayPal.
"OrindaBuild" and "Orinda Software" are trademarks of Orinda Software, Ltd.
[ April 15, 2004: Message edited by: David Rolfe ]
16 years ago
What is OrindaBuild 4.0?
========================

OrindaBuild� is a utility that automatically writes Java� code to access tables, stored procedures, packages, functions and sequences in Oracle� databases. OrindaBuild also takes files containing SQL statements and generates matching Java source files to run them. By automating the tedious task of writing access code, it can dramatically improve productivity. OrindaBuild also helps to reduce the time taken for Java code to catch up with database design changes.
How does it work?
=================

OrindaBuild has a Swing GUI to choose Tables, PL/SQL� procedures or files containing SQL statements. Specify the location for code generation, add your comments and other configuration information and click Generate. All the source you need is either created or ships with the product. There is no runtime component and your code continues to work when your license expires.

Design features:
================

Intuitive and straightforward - A Swing GUI lists existing database objects and makes creating code trivial.
No mysterious runtime component - Everything is done with human readable source code.
No precompilers needed - No requirement to use SQLJ.
Large object support - BLOBs, CLOBs and BFILE parameters can be treated as java.io.File objects.
Pay-As-You-Go Licensing - OrindaBuild is available for periods ranging from one month to a year. When the license expires you can maintain the code by hand. Generated code does not stop working because your licence has expired.
No Schema Changes - OrindaBuild does not create any additional database objects such as Procedures or Tables.
Table Support:
===============

Persistance - Rows can be retrieved or modified using any valid Primary or Unique key.
Navigation - Rows from related tables can be retrevied using methods that follow the table's Foreign Keys.
PL/SQL Support:
===============

Cursor Support - Cursors can't be left open and are returned in a spreadsheet like data structure.
Understands Oracle's privileges - Can call PL/SQL objects owned by other users or referred to by Synonyms.
Support for BOOLEAN parameters - Can call PL/SQL procedures with BOOLEAN parameters without having to create an additional procedure.
Support for records as parameters - Can call PL/SQL Procedures that have %ROWTYPE, %TYPE, PL/SQL Package Record and Oracle Object Type Parameters provided they don't have nested records.
SQL Support:
============

Simple user interface - The only thing users have to do is name and give data types to parameters. This can be done with either the Java user interface or by placing special comments after parameters in the SQL file.
Supports all legal SQL statements - OrindaBuild will make a runnable Java class out of any file that containts a valid SQL statement
All query results can be cached - SELECT statements are turned into classes which can cache query results
Compatible with SQL*Plus - OrindaBuild turns the '&' character into '?' and removes surrounding quotes when reading SQL files. Files which are runnable in SQL*Plus will turn into runnable Java source code without modification.
Downloading OrindaBuild
=======================

Orinda Software's web site is located at:
http://www.orindasoft.com/
A fully functional Version of OrindaBuild can be downloaded from:
http://www.orindasoft.com/public/Pages.php4?location=Downloadtwo
About Orinda Software
=====================

Orinda Software is a privately held startup located in Dublin, Ireland.
Orinda's mission is to create easily usable products that improve productivity for people who use Oracle, Java and JDBC.
Orinda Software is a Sun Independent Software Vendor.
Orinda takes major credit cards and PayPal.
"OrindaBuild" and "Orinda Software" are trademarks of Orinda Software, Ltd.
[ January 15, 2004: Message edited by: David Rolfe ]
16 years ago
What is OrindaBuild?
====================

OrindaBuild� is a utility that automatically writes Java� code to access Oracle� databases. OrindaBuild takes files containing SQL statements and generates matching Java source files to run them. It can also examine a database and write access code for its PL/SQL procedures, packages, functions and sequences. By automating the tedious task of writing access code, it can dramatically improve productivity and quality. OrindaBuild also helps to reduce the time taken for Java code to catch up with database design changes.
How does it work?
=================

OrindaBuild has a Swing GUI to choose PL/SQL� procedures or files containing SQL statements. Specify the location for code generation, add your comments and other configuration information and click Generate. All the source you need is either created or ships with the product. There is no runtime component and your code continues to work when your license expires.

Design features:
================

Intuitive and straightforward - A Swing GUI lists existing PL/SQL objects and makes creating code trivial.
No mysterious runtime component - Everything is done with human readable source code.
No precompilers needed - No requirement to use SQLJ.
Large object support - BLOBs, CLOBs and BFILE parameters can be treated as java.io.File objects.
Pay-As-You-Go Licensing - OrindaBuild is available for periods ranging from one month to a year. When the license expires you can maintain the code by hand. Generated code does not stop working because your licence has expired.
No Schema Changes - OrindaBuild does not create any additional database objects such as Procedures or Tables.
PL/SQL Support:
===============

Cursor Support - Cursors can't be left open and are returned in a spreadsheet like data structure.
Understands Oracle's privileges - Can call PL/SQL objects owned by other users or referred to by Synonyms.
Support for BOOLEAN parameters - Can call PL/SQL procedures with BOOLEAN parameters without having to create an additional procedure.
Support for records as parameters - Can call PL/SQL Procedures that have %ROWTYPE, %TYPE, PL/SQL Package Record and Oracle Object Type Parameters provided they don't have nested records.
SQL Support:
============

Simple user interface - The only thing users have to do is name and give data types to parameters. This can be done with either the Java user interface or by placing special comments after parameters in the SQL file.
Supports all legal SQL statements - OrindaBuild will make a runnable Java class out of any file that containts a valid SQL statement
All query results can be cached - SELECT statements are turned into classes which can cache query results
Compatible with SQL*Plus - OrindaBuild turns the '&' character into '?' and removes surrounding quotes when reading SQL files. Files which are runnable in SQL*Plus will turn into runnable Java source code without modification.
Downloading OrindaBuild
=======================

Orinda Software's web site is located at:
http://www.orindasoft.com/
A fully functional Version of OrindaBuild can be downloaded from:
http://www.orindasoft.com/public/Pages.php4?location=Downloadtwo
About Orinda Software
=====================

Orinda Software is a privately held startup located in Dublin, Ireland.
Orinda's mission is to create easily usable products that improve productivity for people who use Oracle, Java and JDBC.
Orinda Software is a Sun Independent Software Vendor and a Paypal Verified Merchant.
"OrindaBuild" and "Orinda Software" are trademarks of Orinda Software, Ltd.
[ November 19, 2003: Message edited by: David Rolfe ]
16 years ago
What is OrindaBuild?
====================

OrindaBuild� is a utility that automatically writes Java� code to access stored procedures, packages, functions and sequences in Oracle� databases. By automating the tedious task of writing access code, it can dramatically improve productivity. OrindaBuild also helps to reduce the time taken for Java code to catch up with database design changes.
How does it work?
=================

OrindaBuild has a Swing GUI to choose Oracle database resources like PL/SQL� procedures. Specify the location for code generation, add your comments and other configuration information and click Generate. All the source you need is either created or ships with the product. There is no mysterious runtime component and your code continues to work when your license expires.
Key Features:
=============

Intuitive and straightforward
A Swing GUI lists existing PL/SQL objects and makes creating code trivial.
No mysterious runtime component
Everything is done with human readable source code.
No Precompilers needed
No requirement to use SQLJ.
Large object support
BLOBs, CLOBs and BFILE parameters can be treated as java.io.File.
Cursor Support
Cursors can't be left open and are retrieved into a standard data structure.
Understands Oracle's privileges
Can call PL/SQL objects owned by other users or referred to by Synonyms.
Support for BOOLEAN parameters
Can call PL/SQL procedures with BOOLEAN parameters without having to create an additional procedure.
Support for records as parameters
Can call PL/SQL Procedures that have %ROWTYPE, %TYPE, PL/SQL Package Record and Oracle Object Type Parameters provided they don't have nested records.
No Schema Changes
OrindaBuild does not create any additional database objects such as Procedures or Tables.
Pay-As-You-Go Licensing
OrindaBuild is available for periods ranging from one month to a year. When the license expires you can maintain the code by hand. Generated code does not stop working because your licence has expired.
Standard Windows App
OrindaBuild comes as a standard Windows installable and can be safely uninstalled when no longer required.
Command Line Support
Code can be generated on any platform the supports Sun Java, thus enabling OrindaBuild to be integrated with tools such as 'make' and 'ant'.
Downloading OrindaBuild
=======================

Orinda Software's web site is located at:
http://www.orindasoft.com/
A fully functional Version of OrindaBuild can be downloaded from:
http://www.orindasoft.com/public/Pages.php4?location=Downloadtwo
About Orinda Software
=====================

Orinda Software is a privately held startup located in Dublin, Ireland.
Orinda's mission is to create easily usable products that improve productivity for people who use Oracle, Java and JDBC.
Orinda Software is a Sun Independent Software Vendor and a Paypal Verified Merchant.
"OrindaBuild" and "Orinda Software" are trademarks of Orinda Software, Ltd.
[ October 08, 2003: Message edited by: David Rolfe ]
16 years ago