[Dspace-tech] database connection pool
Hi, When I run the command of the 7th step of the installation documentation $ ant fres_install I get the messages: (…) [java] 2008-07-10 11:52:01,334 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2008-07-10 11:52:02,695 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception: [java] org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted (…) My configuration is: Sparc processor Solaris 10 Oracle 10 Java JDK 1.5.0_06 Apache Maven 2.0.8 Apache Ant 1.7.0 Jakarta Tomcat 6.0 The db.url parameter in the dspace.cfg file is fine. In the log file of the oracle listener appears a message *establish*. I don't know which pool it is talking about. The Tomcat configuration is not yet done (step 8). Is there any pool defined in the oracle driver ojdbc14.jar? Could Anybody help me? Thanks. Marisa. -- - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] New problem installing DSpace
Hi, Paulo. Thanks for your answer. I revised the config file a lot of times. Finally I probed to change the db.url, and now I got a new error when I execute $ ant fresh_install (…) [java] 2008-07-10 11:52:01,334 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2008-07-10 11:52:02,695 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception: [java] org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted (…) My configuration is My configuration is: Sparc processor Solaris 10 Oracle 10 Java JDK 1.5.0_06 Apache Maven 2.0.8 Apache Ant 1.7.0 Jakarta Tomcat 6.0 Any other ideas? Marisa Paulo Jobim escribió: > Hi Maria Isabel > Check if your database settings are right in /dspace/config/dspace.cfg > I hope it helps > Paulo Jobim > > On Jul 9, 2008, at 7:35 AM, María Isabel López Sánchez-Huete wrote: > >> Hi, >> >> I don´t now if somebody is really reading this list, but I try to ask >> again. I hope someday somebody can respond to me. >> >> This installation is very difficult to me, perhaps because the >> documentation is written thinking in an linux operating system with a >> Postgres database. But this is not my case: Sparc, Solaris 10 and Oracle. >> >> Now I arrive to the 7 point in the installation instructions, and I >> find a new error. When I execute >> >> ant fres_install >> >> the new error that arise is: >> [java] 2008-07-04 13:37:25,750 INFO >> org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database >> [java] 2008-07-04 13:37:26,391 FATAL >> org.dspace.storage.rdbms.InitializeDatabase @ Caught exception: >> [java] java.sql.SQLException: Listener refused the connection with >> the following error: >> [java] ORA-12514, TNS:listener does not currently know of service >> requested in connect descriptor >> [java] The Connection descriptor used by the client was: >> [java] //machine.subdom.dom:1711/database >> >> The database is up and the connections test are ok. >> >> Somebody knows what is happening? >> >> Thanks in advance. >> >> Marisa. >> >> -- >> >> - >> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! >> Studies have shown that voting for your favorite open source project, >> along with a healthy diet, reduces your potential for chronic lameness >> and boredom. Vote Now at http://www.sourceforge.net/community/cca08 >> ___ >> DSpace-tech mailing list >> DSpace-tech@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/dspace-tech > > - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] New problem installing DSpace
Hello, Khosro Thanks again for your answer. I read the url yo sent me, and it's very interesting. Yesterday I tried others things. My configuration is: Sparc processor Solaris 10 Oracle 10 Java JDK 1.5.0_06 Apache Maven 2.0.8 Apache Ant 1.7.0 Jakarta Tomcat 6.0 I finally put the string conection in two manners: 1) db.url = jdbc:oracle:thin:@//machine.subdomain.domain:port/service_name 2) db.url = jdbc:oracle:thin:@machine.subdomain.domain:port:sid_name I saw the messages in the log of the Oracle listener, with both url in the config file when I executed $ ant fres_install 1) 10-JUL-2008 11:48:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=service_name)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=host_ip)(PORT=48876)) * establish * service_name * 0 2) 10-JUL-2008 11:52:01 * (CONNECT_DATA=(SID=sid_name)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=host_ip)(PORT=48907)) * establish * sid_name * 0 It look then connection is established, but inmediately it is disconnected from the client. Now I have a new error in the output of the $ ant fres_install command: (…) [java] 2008-07-10 11:52:01,334 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2008-07-10 11:52:02,695 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception: [java] org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted (…) Any suggestions? Marisa. khosro asgharifard escribió: > Hello Marisa, > XE is a service name. > Please refer to > http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/connecting.htm#CEGIGEIJ. > In "Connect Strings" subsection you can see the line > "username/[EMAIL PROTECTED]//]host[:port][/service_name]" ,read the bottom of > this line,there is a description. > > Best Regards. > > Khosro. > > > - Original Message > From: María Isabel López Sánchez-Huete <[EMAIL PROTECTED]> > To: khosro asgharifard <[EMAIL PROTECTED]> > Sent: Thursday, July 10, 2008 12:52:02 AM > Subject: Re: [Dspace-tech] New problem installing DSpace > > Hi, Khosro > > Thanks for your rapid answer. > > I have changed the "." by ¨":" in my db.url. It's really a bug in the > documentation > > What does it mean XE? Is it the database name? > > Marisa. > > khosro asgharifard escribió: > > Hello Marisa, > > I am not expert in Dspace.I am a novice.But two days ago when i wanted > > to install Dspace i faced this error. > > You found in install.html in (step3->Oracle->iii) the > > "db.url = jdbc.oracle.thin:@//host:port/dspace" ,As far as i remember i > > changed it > > to "db.url = jdbc:oracle:thin:@//localhost:1521/XE" > > I use Oracle 10g express edition in windows.Please pay attention to > > changing "." to ":" and pay attention to XE. > > Maybe this helps you. > > > > Khosro. > > > > - Original Message > > From: María Isabel López Sánchez-Huete <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> > > To: dspace-tech@lists.sourceforge.net > <mailto:dspace-tech@lists.sourceforge.net> > > Sent: Wednesday, July 9, 2008 3:35:30 AM > > Subject: [Dspace-tech] New problem installing DSpace > > > >Hi, > > > >I don´t now if somebody is really reading this list, but I try to ask > > again. I hope someday somebody can respond to me. > > > >This installation is very difficult to me, perhaps because the > > documentation is written thinking in an linux operating system with a > > Postgres database. But this is not my case: Sparc, Solaris 10 and Oracle. > > > >Now I arrive to the 7 point in the installation instructions, and I > > find a new error. When I execute > > > >ant fres_install > > > >the new error that arise is: > > [java] 2008-07-04 13:37:25,750 INFO > > org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database > > [java] 2008-07-04 13:37:26,391 FATAL > > org.dspace.storage.rdbms.InitializeDatabase @ Caught exception: > > [java] java.sql.SQLException: Listener refused the connection with > > the following error: > > [java] ORA-12514, TNS:listener does not currently know of service > > requested in connect descriptor > > [java] The Connection descriptor used by the client was: > > [jav
[Dspace-tech] New problem installing DSpace
Hi, I don´t now if somebody is really reading this list, but I try to ask again. I hope someday somebody can respond to me. This installation is very difficult to me, perhaps because the documentation is written thinking in an linux operating system with a Postgres database. But this is not my case: Sparc, Solaris 10 and Oracle. Now I arrive to the 7 point in the installation instructions, and I find a new error. When I execute ant fres_install the new error that arise is: [java] 2008-07-04 13:37:25,750 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2008-07-04 13:37:26,391 FATAL org.dspace.storage.rdbms.InitializeDatabase @ Caught exception: [java] java.sql.SQLException: Listener refused the connection with the following error: [java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor [java] The Connection descriptor used by the client was: [java] //machine.subdom.dom:1711/database The database is up and the connections test are ok. Somebody knows what is happening? Thanks in advance. Marisa. -- - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] problem installing Dspace
Hi, Two days ago, a asked to this list about a problem with the instalation of Dspace in an SPARC computer with Solaris 10 Operatting System. That problems was resolved thanks to the maven experts who helped to me. Finally a put the Oracle driver (ojdbc14.jar) using maven. Now I find a new problem with the 7 step of the installation instructions, when I execute the command $ant fresh_install It produce the output: -- (...) setup_database: [java] 2008-07-03 12:31:40,555 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2008-07-03 12:31:40,587 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration,if uninitended, check your dspace.cfg for (log.init.config) [java] 2008-07-03 12:31:40,587 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2008-07-03 12:31:40,703 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(DriverManagerConnectionFactory.java:48) [java] at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) [java] at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840) [java] at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175) [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:514) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:869) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100) BUILD FAILED /usr/local/dspace/dspace-1.5.0-release/dspace/target/dspace-1.5.0-build.dir/build.xml:380: Java returned: 1 Total time: 4 seconds -- I expect somebody can help to me now. Any ideas? Thanks in advance. Marisa. -- - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] problem during installing dspace
Hí, I'm a beginner in this matter, and I'm lost. I expect somebody can help me to run dspace. I´m trying to install dspace 1.5 on Solaris 10 in a SPARC computer. I read the installation documentation, and follow the steps. My problems is about installing the oracle library, in step 3 (Database Setup). I put in my current directory the ojdbc14.jar file, but when I run mvn -e -X install:install-file -Dfile=ojdbc14.jar -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversion=10.2.0.2.0 -Dpackaging=jar -DgeneratePom=true The following error appears (I reproduce only the first lines): + Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] Searching repository for plugin with prefix: ' -X install'. [INFO] org.apache.maven.plugins: checking for updates from central [INFO] org.codehaus.mojo: checking for updates from central [INFO] artifact org.apache.maven.plugins:maven- -X install-plugin: checking for updates from central [WARNING] POM for 'org.apache.maven.plugins:maven- -X install-plugin:pom:LATEST' is invalid. It will be ignored for artifact resolution. Reason: Failed to validate POM for project org.apache.maven.plugins:maven- -X install-plugin at Artifact [org.apache.maven.plugins:maven- -X install-plugin:pom:LATEST] [INFO] [ERROR] BUILD ERROR [INFO] [INFO] Failed to resolve artifact. GroupId: org.apache.maven.plugins ArtifactId: maven- -X install-plugin Version: LATEST Reason: Unable to determine the latest version org.apache.maven.plugins:maven- -X install-plugin:pom:LATEST [INFO] [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: Unable to build project information for plugin 'org.apache.maven.plugins:maven- -X install-plugin': POM 'org.apache.maven.plugins:maven- -X install-plugin' not found in repository: Unable to determine the latest version org.apache.maven.plugins:maven- -X install-plugin:pom:LATEST (...) Any idea? Thanks in advance. -- - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
