[Dspace-tech] help with IDE Integration instructions

[Pottinger, Hardy J.]

Hi, I'm in the process of implementing these instructions (as a prelude
for reskinning our DSpace repository):

http://wiki.dspace.org/index.php/IDE_Integration:_DSpace,_Eclipse_and_To
mcat

I have gotten pretty far, but am having some difficulty with the
database stage of things. We use Oracle for our live DSpace
installation, so I'd like to use OracleXE for this development
installation. The problem I'm having is that, despite the fact that I've
successfully installed the Oracle OJDBC driver in my local maven
repository, when I attempt to run the ant build script to do a
'fresh_install' of the database, I am getting the following error:

---begin snip---

Buildfile: C:\Documents and
Settings\pottingerhj\workspace\mospace\dspace\target\dspace-1.5.1-build.
dir\build.xml
init_installation:
init_configs:
setup_database:
[java] 2008-11-13 11:51:58,618 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): C:\Documents and
Settings\pottingerhj\workspace\mospace\dspace\config\hardy_dspace.cfg
[java] 2008-11-13 11:51:58,634 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided log
configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2008-11-13 11:51:58,634 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2008-11-13 11:51:58,649 WARN
org.dspace.storage.rdbms.DatabaseManager @ Exception initializing DB
pool
[java] java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
[java] at
java.net.URLClassLoader$1.run(URLClassLoader.java:200)
[java] at java.security.AccessController.doPrivileged(Native
Method)
[java] at
java.net.URLClassLoader.findClass(URLClassLoader.java:188)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
[java] at
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
[java] at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Class.java:164)
[java] at
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java
:1501)
[java] at
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.j
ava:548)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:92
3)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java
:100)
[java] 2008-11-13 11:51:58,649 FATAL
org.dspace.storage.rdbms.InitializeDatabase @ Caught exception:
[java] java.sql.SQLException: java.lang.ClassNotFoundException:
oracle.jdbc.OracleDriver
[java] at
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java
:1625)
[java] at
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.j
ava:548)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:92
3)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java
:100)

BUILD FAILED
C:\Documents and
Settings\pottingerhj\workspace\mospace\dspace\target\dspace-1.5.1-build.
dir\build.xml:380: Java returned: 1

--- end snip ---


Has anyone else encountered this? I'm at a loss for how to proceed.


--
HARDY POTTINGER <potti...@umsystem.edu>
University of Missouri Library Systems
http://lso.umsystem.edu/~hardy/
"No matter how far down the wrong road you've gone,
turn back." --Turkish proverb

[Pottinger, Hardy J.]

Hi, an update, I managed to sidestep this issue by manually copying the
ojdbc14.jar file to the target\dspace-1.5.1-build\lib folder. I don't
feel good about that, but I *have* successfully completed a
fresh_install of the database to my locally-running instance of OracleXE
(fyi, this web page really helped in that regard:
http://en.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-
handler-found/). After much fiddling with various permutations of
dspace.cfg and locations for the [dspace.dir], I have a working mvn
package running from within Eclipse. No luck with getting an Ant build
to work from inside Eclipse, so I've been using ant from the command
line, which does work. Hooray!

HOWEVER, after firing up Tomcat via the Eclipse Tomcat Plugin (the
SysDeo plugin), and browsing to http://localhost:8080/xmlui I see my
familiar error:

java.sql.SQLException: java.lang.ClassNotFoundException:
oracle.jdbc.OracleDriver

I have confirmed that ojdbc14.jar is in [dspace.dir]/lib. Short of
adding ojdbc14.jar to the Java classpath via environment variables (mvn
is supposed to make that sort of silliness obsolete), is there anything
else I can do to get this working?

Please, if anyone is successfully doing development in a Windows-based
Eclipse installation, can you help me figure this one out? Thanks!

--Hardy

> --------------------------------------------------------------
> -----------
> 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
> DSpac...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>

[Pottinger, Hardy J.]

Hi, for what it's worth, I have managed to kludge this together by
simply copying the ojdbc14.jar into the
[dspace.dir]/webapps/xmlui/WEB-INF/lib folder. No amount of fiddling
with the eclipse maven plugin or maven itself has corrected the problem
of this dependency getting properly copied to where it needs to go.
Frustrating, however, I do have a working (enough) development
environment to proceed with my theme building.

I'm posting this info here in case anyone else runs into this problem. I
do hope that at some point someone will offer a better solution than
mine.

As long as I'm leaving breadcrumbs for the future here, these pages were
all helpful in getting this all set up:

https://test.kuali.org/confluence/display/KULRICE091/Setting+up+Eclipse+
for+a+Rice+Project
http://ardb4.ncsi.iisc.ernet.in/dspace/dspacewindows.htm