Re: Clearing Shark 1.1-2 database - attempt two

Vladimir Puskas <[email protected]> Thu, 01 Sep 2005 11:01:31 +0200
Newsgroups gmane.comp.java.enhydra.shark
Message-ID <[email protected]>
Hello Greg

If you are building Shark from sources, there are two configure.bat files:
1 - file in the main directory is used to configure the build process
     (find the JDK, set the properties for *build* time)

2 - in output/Shark (or instdir after make install) to configure demo
     applications (shark admin, corba and axis servers) and build web-app
     archive.

File output/Shark/bin/recreateDB.bat should call the latter batch file,
which invokes Ant to execute output/Shark/configure.xml which in turn
contains "_recreateDB" target...
I just re-confirmed that it works after extracting shark-1.1-2.zip on
Win2k machine.

Regarding LoaderJob.olj: it will contain db parameters set in previous
run of this procedure, so if your has HSQL settings it worked at least
once - at the end of main "make".

you wrote:
> Near as I can figure, these should be the instructions for getting
> your database created (in this example, using Oracle in a windows 
> environment) or cleared.  For some reason, what worked under Shark
> 1.1 does not work under Shark 1.1-2.
> 
> Any advice on what would be wrong or does no one clear their
> database?
> 
> 1. run configure.bat
> 
> 2. Edit the configure.properties file jdk_dir=C:\Java\j2sdk1.4.2_08
> 
> db_loader_job=oracle
> 
> # Oracle oracle_JdbcDriver=oracle.jdbc.driver.OracleDriver 
> oracle_Connection_Url=jdbc:oracle:thin:@server:port:database 
> oracle_user=USER oracle_passwd=PASSWORD
> 
> 3. run /bin/recreateDB.bat
> 
> Which, of course, fails because its calling call configure.bat
> _recreateDB
> 
> which "_recreateDB" is an invalid parameter on the configure script.
> 
> So, I'm either missing several steps, or the 1.1-2 distribution is 
> totally screwed up????
> 
> I did notice that the \conf\sql\oracle\LoaderJob.olj file does not
> seem to refer to anything to do with Oracle - but instead points to
> HSQL. Normally this would concern me since nothing indicates this
> file should be editted, but since its never being used, I guess
> that's a minor problem.
> 
> <jdbcDefaultParameters>
>         <jdbcSourceParameters dbVendor="oracle" driverName="oracle">
>             <jdbcSourceParameter name="Password" value=""/>
>             <jdbcSourceParameter name="Connection.Url"
> value="jdbc:hsqldb:C:/Shark-1.1/db/hsql/hsql"/>
>             <jdbcSourceParameter name="JdbcDriver"
> value="org.hsqldb.jdbcDriver"/>
>             <jdbcSourceParameter name="User" value="sa"/>
>         </jdbcSourceParameters>
>         <jdbcTargetParameters dbVendor="oracle" driverName="oracle">
>             <jdbcTargetParameter name="Password" value=""/>
>             <jdbcTargetParameter name="Connection.Url"
> value="jdbc:hsqldb:C:/Shark-1.1/db/hsql/hsql"/>
>             <jdbcTargetParameter name="JdbcDriver"
> value="org.hsqldb.jdbcDriver"/>
>             <jdbcTargetParameter name="User" value="sa"/>
>         </jdbcTargetParameters>
> </jdbcDefaultParameters>
> ******* 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.
> ------------------------------------------------------------------------
> -- 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

hope this helps
-- 
Vlada
message-footer.txt (text/plain, 271 B)
--
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