Problem with connect to Oracle

edit

I don't think so... Look at GigaSpacesEE5.2\examples\Advanced\Data_Grid\Database-Integration\JDBCCacheStore\bin\mydb.properties In this file are properities to HSQL!! This file are start in startAllSpaceAPI file: @start "HSQL mydb" java -cp ............\lib\jdbc\hsqldb.jar org.hsqldb.Server -database mydb -port 9003 Are anyone here, who try connect to Oracle?? I try for few day and nothig :/ PLZ help.

Ignore the mydb.properties. This is for the HSQL. The JDBC connection string you need to have to allow the the CacheLoader/Store implementation to connect to Oracle exists within the jdbcspace.properties/jdbcmap.properties files.

Shay

I change: - GigaSpacesEE5.2\examples\Advanced\Data_Grid\Database-Integration\JDBCCacheStore\config\jdbcspace.properties {quote} space-config.persistent.enabled=true space-config.persistent.CacheLoaderClass=com.j_spaces.examples.jdbccachestore.spaceapi.CacheStoreImpl space-config.persistent.StorageAdapterClass=com.j_spaces.sadapter.cache.CacheAdapter space-config.persistent.DataBaseName=jdbc:oracle:thin:@localhost:1521:orcl space-config.engine.cache_policy=0 space-config.engine.cache_size=2000 {quote} - GigaSpacesEE5.2\examples\Advanced\Data_Grid\Database-Integration\JDBCCacheStore\src\com\j_spaces\examples\jdbccachestore\spaceapi\CacheStoreImpl.java {quote} (...) pool = new JDCConnectionDriver("oracle.jdbc.driver.OracleDriver ", dbURL, "system", "orcl"); (...) {quote} - GigaSpacesEE5.2\GenericJDBCProperties\OracleProperties\jdbc.properties {quote} driverClass=oracle.jdbc.driver.OracleDriver connectionUrl=jdbc:oracle:thin:@localhost:1521:orcl userName=system password=orcl {quote}

And it still doesn't work :/

This is much better...

GigaSpacesEE5.2\GenericJDBCProperties\OracleProperties\jdbc.properties is irlevant for this example.

Can you send the exception you are getting when constructing the JDCConnectionDriver?

Shay

This is all exceptions: {quote} C:\GS\GigaSpacesEE5.2\examples\Advanced\Data_Grid\Database-Integration\JDBCCache Store\bin>run_SpaceAPIApplication.bat JAVA_HOME environment variable is set to c:\GS\jdk1.5 in "<gigaspaces root="">\bin\ setenv.bat" Environment set successfully from C:\GS\GigaSpacesEE5.2\bin\.. java version "1.5.0_07" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) Java HotSpot(TM) Server VM (build 1.5.0_07-b03, mixed mode)

Welcome to JDBC CacheStore Implementation using Space API Example! Trying to Connect to Space rmi://localhost/./Jdbc_cacheStoreSpace ... CONFIG: Sets the system property ${com.gs.home} with value: C:\GS\GigaSpacesEE5. 2\ com.j_spaces.core.client.FinderException: Failed to find: rmi://localhost/./Jdbc _cacheStoreSpace?schema=default at com.j_spaces.core.client.SpaceFinder._find(SourceFile:505) at com.j_spaces.core.client.SpaceFinder.internalFind(SourceFile:313) at com.j_spaces.core.client.SpaceFinder.internalFind(SourceFile:303) at com.j_spaces.core.client.SpaceFinder.find(SourceFile:374) at com.j_spaces.examples.jdbccachestore.spaceapi.CacheStoreSpaceApi.main (CacheStoreSpaceApi.java:31) Caused by: javax.naming.NameNotFoundException: GigaSpaces;Jdbc_cacheStoreSpace_c ontainer;Jdbc_cacheStoreSpace at com.sun.jndi.rmi.registry.RegistryContext.lookup(RegistryContext.java :95) at com.sun.jndi.rmi.registry.RegistryContext.lookup(RegistryContext.java :103) at javax.naming.InitialContext.lookup(InitialContext.java:351) at com.j_spaces.core.client.SpaceFinder.a(SourceFile:939) at com.j_spaces.core.client.SpaceFinder._find(SourceFile:479) ... 4 more {quote}

I must add, that when I start basic example (with HSQL database) everything start and execute OK!!