I was missing it... :-)
First of all you should check your TNS with some other Oracle client,
to ensure the connection can actually be made with those parameters.
There are lots of reason why a connection to Oracle could not be extabilished...
Also check the OpenJump connection dialog, keeping in mind that when
using the "(DESCRIPTION..." syntax, the Address and Port field are not used:
Name => name of the connection [meaningful only inside OJ]
Driver => SISDB
Adapter => oracle
Address => dummy [this is _not_ used]
Port => dummy [this is _not_ used]
Db => (DESCRIPTION... [complete TNS, _must_ start with "("]
Username => the user name
Password => the user password
Schema => "-" [a single dash uses default schema for the specified user]
Bye
Paolo Rizzi
> -----Messaggio originale-----
> Da: Stefan Steiniger [mailto:sst...@geo.uzh.ch]
> Inviato: mercoledì 7 gennaio 2009 16.05
> A: List for discussion of JPP development and use.
> Oggetto: [JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] RE:
> Problems getting Oracle Connection]
>
>
> it continues ;)
>
> -------- Original-Nachricht --------
> Betreff: [jump-pilot - Problems with PlugIns] RE:
> Problems getting
> Oracle Connection
> Datum: Wed, 07 Jan 2009 10:54:22 +0000
> Von: SourceForge.net <nore...@sourceforge.net>
> An: nore...@sourceforge.net
>
>
>
> Read and respond to this message at:
> https://sourceforge.net/forum/message.php?msg_id=6022088
> By: nobody
>
> thanx guys for the infor but i encountered another prob. i
> used the tns description
> syntax
>
> test1
> (SISDB:oracle:DEV3.ADIN.CIPAL.BE:1521:DEV3.ADIN.CIPAL.BE =
> (DESCRIPTION
> = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
> GEDBora5.vm.cipal.net)(PORT
> = 1521)))(CONNECT_DATA = (SERVICE_NAME = DEV3.cipal.be)))
> :stage1:stagiair)
>
> but am getting the following error
>
>
>
> org.springframework.jdbc.CannotGetJdbcConnectionException:
> Could not get JDBC
> Connection; nested exception is
> org.apache.commons.dbcp.SQLNestedException:
> Cannot create PoolableConnectionFactory (I/O-uitzondering: NL
> Exception was
> generated)
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory
> (I/O-uitzondering: NL Exception was generated)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic
> DataSource.jav
> a:855)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat
> aSource.java:5
> 40)
> at
> it.ama_mi.sis.framework.db.jdbc.JdbcDBDataImpl$2.getConnection
> (JdbcDBDataImp
> l.java:260)
> at
> org.springframework.jdbc.datasource.DataSourceUtils.doGetConne
> ction(DataSour
> ceUtils.java:112)
> at
> org.springframework.jdbc.datasource.DataSourceUtils.getConnect
> ion(DataSource
> Utils.java:77)
> at
> it.ama_mi.sis.framework.db.jdbc.JdbcDBDataImpl.getURL(JdbcDBDa
> taImpl.java:21
> 8)
> at
> it.ama_mi.sis.framework.db.jdbc.JdbcDBDataImpl.connect(JdbcDBD
> ataImpl.java:3
> 20)
> at
> it.ama_mi.sis.framework.db.openjump.SISDBDSConnection.getData(
> SISDBDSConnect
> ion.java:47)
> at
> it.ama_mi.sis.framework.db.openjump.SISDBDSMetadata.readContex
> ts(SISDBDSMeta
> data.java:37)
> at
> it.ama_mi.sis.framework.db.openjump.SISDBDSMetadata.getDataset
> Names(SISDBDSM
> etadata.java:42)
> at
> com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatas
> toreLayerPanel
> $7.yield(AddDatastoreLayerPanel.java:270)
> at
> com.vividsolutions.jump.workbench.ui.plugin.datastore.AddDatas
> toreLayerPanel
> $2.run(AddDatastoreLayerPanel.java:76)
> at
> com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$T
> askWrapper.run
> (TaskMonitorManager.java:149)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLException: I/O-uitzondering: NL
> Exception was generated
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErr
> or.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErr
> or.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseErr
> or.java:255)
> at
> oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
> at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnectio
> n.java:414)
> at
> oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverE
> xtension.java:
> 35)
> at
> oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnecti
> on(DriverConne
> ctionFactory.java:37)
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P
> oolableConnect
> ionFactory.java:290)
> at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFact
> ory(BasicDataS
> ource.java:877)
> at
> org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic
> DataSource.jav
> a:851)
> ... 13 more
>
>
> thank you
>
> vee
>
>
> ______________________________________________________________________
> You are receiving this email because you elected to monitor
> this forum.
> To stop monitoring this forum, login to SourceForge.net and visit:
> https://sourceforge.net/forum/unmonitor.php?forum_id=729480
>
>
>
> --------------------------------------------------------------
> ----------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
