AnsweredAssumed Answered

Running the sample Examples with Derby .

Question asked by rv.a.sharma on Mar 5, 2009
Hello,
I am trying to run the simpleexample with DERBY database . I was able to run it with MS-Sql server based installation earlier.
The custom properties which i am using is as mentioned below.

Can you suggest what could be wrong ??


#
# Sample custom content and index data location
#

dir.root=D:/Alfresco/alf_data


db.username=alfresco
db.password=alfresco


#
# MySQL connection (This is default and requires mysql-connector-java-3.1.12-bin.jar, which ships with the Alfresco server)
#
#db.driver=org.gjt.mm.mysql.Driver
#db.url=jdbc:mysql://localhost/alfresco

#
# Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbc:oracle:thin:@localhost:1521:alfresco

#
# Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)
#
#db.driver=com.sybase.jdbc2.jdbc.SybDriver
#db.url=jdbc:sybase:Tds:localhost:2638/alfresco

#
# Derby connection (This is default and requires mysql-connector-java-3.1.12-bin.jar, which ships with the Alfresco server)
#
db.driver=org.apache.derby.jdbc.EmbeddedDriver
db.url=jdbc:derby:@@ALF_DATA@@/derby_data/alfresco;create=true



Can you suggest what is the mistake that I am making in configration in last two lines in configuration files ?
Exception :
Its says this database might be already opened.

Please suggest .

Regards,
Ravi Sharma

Outcomes