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
