Hi,
I can affirm that it is possible to make a connection to Oracle with SISDB
driver by following the instructions that Paolo gave. I took the whole
DESCRIPTION string from the tnsnames.ora file that my SQL Plus is using and
dropped that into "Db" field in the db connection dialog, fed in username,
password and "-" for schema. "Address" and "Port" must be filled but they can
really be dummy parameters.
I could not get connection with alternative method by using
address+port+database name instead of using DESCRIPTION string. Maybe there
is some bug in SISDB in this place. I tried to look at OJ log but could not
find immediately what is going wrong. The connection parameters are stored in
workbench-state.xml file but I am not sure if editing them directly would help.
My guess is that SISDB is forming invalid connection string from input
variables. Perhaps it is even pointed out in SISDB.txt document that says:
"- if it do NOT start with a "(" it will be used as a normal Db name and the
connection URL will be something like:
jdbc:oracle:thin:@address:port/db"
I believe it should be like:
jdbc:oracle:thin:@address:port:db
-Jukka Rahkonen-
> -----Alkuperäinen viesti-----
> Lähettäjä: P.Rizzi Ag.Mobilità Ambiente
> [mailto:paolo.ri...@ama-mi.it]
> Lähetetty: 7. tammikuuta 2009 18:01
> Vastaanottaja: OpenJump develop and use
> Aihe: [JPP-Devel] R: [Fwd: [jump-pilot - Problems with
> PlugIns] RE:Problems getting Oracle Connection]
>
> 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
> >
> >
------------------------------------------------------------------------------
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
