Re: {Spam?} Configuring Shark to use Oracle

Hi Greg, make sure the un/pw you are using has admin privilages to your 
oracle database, since the script you will be running deletes old tables 
and creates new ones. For example, line 146 of oracle/LoaderJob.olj has:
<sql commit="true" logMode="normal" name="CreatePrimary1" 
onErrorContinue="false">
        <sqlStmt>
            <include href="sql/CreatePrimary-instancepersistence.sql" 
parse="text"/>
        </sqlStmt>
    </sql>

since the onErrorContinue attribute above is false, your script stops 
there. But my guess is the delets before it didn't complete ether.

Regards,
Geeta




"Dahl, Greg (BLM) - contr" <[email protected]> 
06/21/2005 11:08 AM
Please respond to
[email protected]


To
[email protected]
cc

Subject
{Spam?} [shark] Configuring Shark to use Oracle






I'm trying to configure my Shark 1.1 to use an Oracle database.  I
updated the configure.properties file changing the following parameters:

db_loader_job=oracle
db_ext_dirs=J:/ORAV232/BIN
oracle_JdbcDriver=oracle.jdbc.driver.OracleDriver
oracle_Connection_Url=jdbc:oracle:thin:@validserver:portrunningon:databa
sename
oracle_user=validuserid
oracle_passwd=validpassword

Where 
validserver = the actual server name
Portrunningon = the port the oracle server is running
Databasename = an existing database name
Validuserid = a valid user id
Validpassword = a valid password.

When I run the configure.bat, the output I get follows.  Any ideas?

I did have it running just fine using HSQL.

Thanks for your time,
Greg



Buildfile: configure.xml

init:

_copyNfilter:
     [copy] Copying 41 files to C:\Shark-1.1

_winFileSeparator:
  [replace] Replaced 38 occurrences in 3 files.
   [delete] Deleting 12 files from C:\Shark-1.1

_linFileSeparator:

_recreateDB:
   [delete] Deleting directory C:\Shark-1.1\db\hsql
   [delete] Deleting directory C:\Shark-1.1\repository\internal\history
   [delete] Deleting directory C:\Shark-1.1\repository\internal
    [mkdir] Created dir: C:\Shark-1.1\db\hsql
    [mkdir] Created dir: C:\Shark-1.1\repository\internal\history
     [java] Default (Standard) Logger is load.


     [java] Application is started.

     [java] Loader loads XML file : conf/sql/oracle/LoaderJob.olj


     [java] XML document is valid.


BUILD FAILED
file:C:/Shark-1.1/configure.xml:146: Java returned: 1

Total time: 7 seconds
******* Confidentiality Notice *******
This email, its electronic document attachments, and the contents of its 
website linkages may contain confidential health information.  This 
information is intended solely for use by the individual or entity to whom 
it is addressed.  If you have received this information in error, please 
notify the sender immediately and arrange for the prompt destruction of 
the material and any accompanying attachments.





-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


--
You receive this message as a subscriber of the [email protected] 
mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws


CONFIDENTIALITY NOTICE:This email is intended solely for the person or 
entity to which it is addressed and may contain confidential and/or 
protected health information.  Any duplication, dissemination, action 
taken in reliance upon, or other use of this information by persons or 
entities other than the intended recipient is prohibited and may violate 
applicable laws.  If this email has been received in error, please notify 
the sender and delete the information from your system.  The views 
expressed in this email are those of the sender and may not necessarily 
represent the views of IntelliCare.