Hi Jukka, thank you very much for pointing out this!!! In fact I used "/" as separator before the db name instead of ":"!!! I don't remember why... Probably I didn't bother to test it very much since it was working with the complete TNS... I'll fix it as soon as possibile (when I'll have an Oracle server available)!!! Anyway I think that using the complete TNS string is better, because all sorts of parameters can be specified (for example FAILOVER), that can't be specified with the "normal" syntax. Bye Paolo Rizzi
________________________________ Da: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi] Inviato: gio 08/01/2009 9.56 A: OpenJump develop and use Oggetto: Re: [JPP-Devel] R: [Fwd: [jump-pilot - Problems with PlugIns]RE:Problems getting Oracle Connection] 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
<<winmail.dat>>
------------------------------------------------------------------------------ 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
