On Mon, Mar 21, 2011 at 6:28 PM, Gundel, Aaron <[email protected]> wrote: > Hi Andrea, > > I've done the modifications you mention, but I'm still running into issues > when I go to run the tests. It looks like the jdbc driver won't connect, > it's giving me... Io exception: The Network Adapter could not establish the > connection. (So it skips the connected tests) This isn't extraordinarily > detailed, I'm guessing it has to do with my oracle.properties file, but I'm > not sure. I'll post the stack trace and the file (though I'll have to remove > all the actual connection details). Anyone have any ideas? Thanks!
Yeah, those property files need some cleanup so that we don't have to type the same info multiple times. Nobody had the time to do that so far, but we can always hope :-) > port=1521 > password=postgis > url=jdbc\:oracle\:thin\:@localhost\:1521\:xe > host=localhost > database=xe > driver=oracle.jdbc.driver.OracleDriver > username=myuser > user=mypassword So mine looks like this: port=1521 password=<thepassword> url=jdbc\:oracle\:thin\:@localhost\:1521\:xe host=localhost database=xe driver=oracle.jdbc.driver.OracleDriver username=<theuser> user=<theuser> see how the username has to be provided twice, but it has to be consistent, and it's two times the same. The password is your database password... do you also like to tease Oracle spatial like me, stating the password is "postgis"? ;-) All the other params have to be customized to your enviroment as well... are you using Oracle XE too? How is your database called? If it's not XE and the db is called "monnalisa" instead of "xe" you'll have to fix both the url and database accordingly. Sorry it's a bit convoluted, we need to keep these files, that are different for each developer, out of svn, and Oracle adds insult to the injury by not allowing us to redistribute the driver in maven repositories. Ah, just remembered another thing. Oracle XE out of the box is pretty unusable even for the task of doing tests because of its very limited number of processes and sessions, you should follow this tutorial and increase both: http://www.markcallen.com/oracle/oracle-xe-tuning And then be patient... running the test suite against Oracle takes ages, it's easily 3 times slower than PostgreSQL/PostGIS: Oracle it's fast in production, but setting up and dropping tables and spatial indexes is glacially slow... Hope this helps Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
