Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Store procedure problems!

0 views
Skip to first unread message

Pete Hollyer

unread,
Nov 10, 2005, 9:07:15 AM11/10/05
to
I'm trying to put in stored procedures into my jDatastore (embedded), and
just cannot get it to work! I've read all the examples and still cant
manage it. Quesitons I have are (and are not limited too!)
1) When building the Stored Procedure Class should this be done outside the
project?
2) Are they serious when they want the CLASS put in the jDatastore
Installation folder? Not the Database repository folder wher the
database.jds lives? My installation folder of jDatastore will NEVER be
deployed to a customer!
3) The sentence from the instructions reads: "Copy the class file in the
"lib/storedproc/classes/com/mycompany/util" subdirectory of the JDataStore
installation directory"

Does this mean I build the tree
c:\jDatastore\lib\storedproc\classes\com\mycompany\util and then put the
compiled class there? (where c:\jDatastore is my installation of the
database application - not the database.jds file.

4) Next sentence in instructions: Create a jar with this class file and
place the jar file in the "lib/storedproc/jars" subdirectory of the
JDataStore installation directory

Can someone tell me how the hell this is accomplished?

5) when I run the SQL sentence in jDatastore to create the stored procedure
I get the following error...what exacly is this trying to tell me?
The Java class: 'db.codes.clsCodes' for the DQL Method/class: LISTCODES2
could not be found on classpath.

HOW on earth do I get it in the class path?

THanks
Pete


0 new messages