The Db field should contain only the database name, SER1 in your example.
The JDBC URL is then built by the plugin itself.
I'm not an Oracle expert, but with the two servers I worked with, the only way
to get
a JDBC connection (from the plugin or from any other Java program), was to use
a complete Oracle TNS description. I could never connect using the "simple"
syntax.
You have to build the correct TNS string ("(DESCRIPTION....") using an Oracle
client
or any other mean, and then put it inside the Db field (without the
jdbc:oracle..... part).
Also be sure to download the required ojdbc14.jar file directly from Oracle.
Bye
Paolo Rizzi
________________________________
THe field Da: Stefan Steiniger [mailto:[EMAIL PROTECTED]
Inviato: ven 28/11/2008 18.55
A: List for discussion of JPP development and use.
Cc: [EMAIL PROTECTED]
Oggetto: [JPP-Devel] [Fwd: [jump-pilot - Problems with PlugIns] Problems
getting Oracle Connection]
can somebody help?
stefan
-------- Original Message --------
Subject: [jump-pilot - Problems with PlugIns] Problems getting Oracle
Connection
Date: Fri, 28 Nov 2008 08:45:24 +0000
From: SourceForge.net <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Read and respond to this message at:
https://sourceforge.net/forum/message.php?msg_id=5728109
By: simonecampora
Hi to all!
I have a trobule since I cannot get a proper connection to Oracle 10g.
I installed the SISDB datastore plugin
and to connect to my database I'm using (following the connection manager list)
parameters like:
name: Oracle
driver: SISDB
Adapter: Oracle
Address: myserver.epfl.ch
Port: 1521
Db: jdbc:oracle:thin:@myserver.epfl.ch:1521/SER1
user: myuser
password: mypassword
Schema: myuser
but is not getting the proper connection, however all those parameters are ok!
Following the Readme there is "another method to get the connection, i.e. using
a kind of "jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =..." string.
There's anybody that knows how it works?
Unfortunately I have no idea but it seems to me that it could be a solution
for my problem. Am I right?
Thanks for your help
Simone
______________________________________________________________________
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
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
