RE: Will OpenJMS 0.7.6.1 support Derby instead of MySQL

Sure. Realise however that derby is still in "incubation"
at Apache. See http://incubator.apache.org/derby/ for
more details.

To configure derby:

1. copy the derby jar to $OPENJMS_HOME/lib

2. Add the following to your setenv.bat (or equivalent in setenev.sh)
Script:

 set CLASSPATH=%OPENJMS_HOME%/lib/derby-10.0.2.1.jar 
 set JAVA_OPTS=%JAVA_OPTS% -Dderby.system.home=%OPENJMS_HOME%\db

3. create a "db" directory under $OPENJMS_HOME
 > mkdir $OPENJMS_HOME/db

4. Create a file named "derby.properties" in $OPENJMS_HOME/db containing:

derby.storage.fileSyncTransactionLog=true
derby.user.openjms=openjms

# uncomment the following if you want extra log info
# derby.stream.err.logSeverityLevel=0
# derby.language.logStatementText=true

5. Add the following to openjms.xml
  <DatabaseConfiguration>
    <RdbmsDatabaseConfiguration
      driver="org.apache.derby.jdbc.EmbeddedDriver"
      url="jdbc:derby:openjmsdb;create=true" 
      user="openjms" 
      password="openjms"/>
  </DatabaseConfiguration>

6. Run dbtool to create the database


> From: Sale Rahul
> 
> Hello All,
> We would like to use Derby instead of Mysql for
> storing of the messages, so would like to knwo if this
> will work? 
> 
> Please help.
> 
> Thanks in advance.
> 
> 
> Regs
> Rahul Saley
> 
> 
> 		
> Discover Yahoo! 
> Get on-the-go sports scores, stock quotes, news and more. 
> Check it out! 
> http://discover.yahoo.com/mobile.html
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best shot. 4 
> great events, 4 opportunities to win big! Highest score 
> wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. 
> Visit http://www.necitguy.com/?r=20 
> _______________________________________________
> openjms-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openjms-user
> 



-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click