Yes Claudia,
I follow the instructions in the manual,
But when I give the instruction: ant fresh_install
It send me the error:
[java] 2008-10-23 12:13:43,804 FATAL
org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
[java] java.sql.SQLException: No suitable driver
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:545)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:171)
[java] at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(Driv
erManagerConnectionFactory.java:65)
[java] at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:294)
[java] at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:974)
[java] at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:525)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:193)
[java] at
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:
550)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:923)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100
)
BUILD FAILED
/opt/dspace/dspace-source/dspace-1.5.1-release/dspace/target/dspace-1.5.1-bu
ild.dir/build.xml:380: Java returned: 1
Saludos cordiales y estoy para servirte.
Sofía
Sofía Alicia Treviño Garza
Universidad Virtual - Dirección de Informática
Tutora de Comercio Electrónico - PACSI
Tecnológico de Monterrey
TEL: (81) 8358200 Ext. 6605
Edificio CEDES - SS1
Av. Eugenio Garza Sada
Monterrey N.L.
http://www.tecvirtual.itesm.mx
http://www.itesm.mx
-----Original Message-----
From: Claudia Jürgen [mailto:[EMAIL PROTECTED]
Sent: jueves, 23 de octubre de 2008 11:45 a.m.
To: [EMAIL PROTECTED]
Cc: [email protected]
Subject: Re: [Dspace-tech] Problem with DB installing
Hi Sofia,
setting up DSpace with oracle differs a bit from the setup with
postgres, did you follow the instructions in the documentation?
Oracle:
a. Setting up oracle is a bit different now. You will need still need to
get a Copy of the oracle JDBC driver, but
instead of copying it into a lib directory you will need to install it
into your local Maven repository. You'll need
to download it first from this location:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/
jdbc_10201.html
$ mvn install:install-file -Dfile=ojdbc14.jar -DgroupId=com.oracle \ -
DartifactId=ojdbc14 -Dversion=10.2.0.2.0 -Dpackaging=jar -DgeneratePom=true
b. Create a database for DSpace. Make sure that the character set is one
of the Unicode character sets. DSpace uses
UTF-8 natively, and it is suggested that the Oracle database use the
same character set. Create a user account
for DSpace (e.g. dspace,) and ensure that it has permissions to add and
remove tables in the database.
c. Edit the [dspace-source]/dspace/config/dspace.cfg database settings:
db.name = oracle
db.url = jdbc.oracle.thin:@//host:port/dspace
db.driver = oracle.jdbc.OracleDriver
d. Go to [dspace-source]/dspace/etc/oracle and copy the contents to
their parent directory,
overwriting the versions in the parent:
cd [dspace-source]/dspace/etc/oracle
cp * ..
You now have Oracle-specific .sql files in your etc directory, and your
dspace.cfg is modified to point to
your Oracle database.
Claudia
Sofia Alicia Treviño Garza schrieb:
> Hello:
>
> I'm trying to install dspace with Oracle.
> I have an Error : java.sql.SQLException: No suitable driver
> Could you please help me with some idea of how can I solve it
>
> Thanks in advance.
> Sofía
>
>
>
[EMAIL PROTECTED]:~/dspace-source/dspace-1.5.1-release/dspace/target/dspace-1.
> 5.1-build.dir> ant fresh_install
> Buildfile: build.xml
>
> init_installation:
>
> init_configs:
>
> setup_database:
> [java] 2008-10-23 11:10:43,063 INFO
> org.dspace.core.ConfigurationManager @ Loading system provided config
> property (-Ddspace.configuration): config/dspace.cfg
> [java] 2008-10-23 11:10:43,070 INFO
> org.dspace.core.ConfigurationManager @ Using default log4j provided log
> configuration,if uninitended, check your dspace.cfg for (log.init.config)
> [java] 2008-10-23 11:10:43,070 INFO
> org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
> [java] 2008-10-23 11:10:43,110 FATAL
> org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
> [java] java.sql.SQLException: No suitable driver
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:545)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:171)
> [java] at
>
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(Driv
> erManagerConnectionFactory.java:65)
> [java] at
>
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
> ionFactory.java:294)
> [java] at
>
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
> l.java:974)
> [java] at
> org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:525)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:193)
> [java] at
>
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:
> 550)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:923)
> [java] at
>
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100
> )
>
> BUILD FAILED
>
/opt/dspace/dspace-source/dspace-1.5.1-release/dspace/target/dspace-1.5.1-bu
> ild.dir/build.xml:380: Java returned: 1
>
> Total time: 1 second
>
>
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
> Build the coolest Linux based applications with Moblin SDK & win great
prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
