what's the number of times the letter "v" appears in:
q: jitterbit - ora-12504, tns:listener was not given the sid in connect_data we're attempting to do upserts to salesforce from a lawson (oracle) database, using jitterbit. we are using the oracle [jdbc] driver on the default port. we have the jitterbit agent running on windows server 2008 on a machine which should be able to connect to the lawson database. however, when we try to initiate a connection to the oracle database from within jitterbit studio, we're refused with:
listener refused the connection with the following error:
ora-12504, tns:listener was not given the sid in connect_data

the question i'm hoping someone can help with is - what exactly is the listener lacking the sid for?
stack trace, in case it's helpful:
details: oracle.net.ns.netexception - listener refused the connection with the following error:
ora-12504, tns:listener was not given the sid in connect_data

    at org.jitterbit.integration.client.ui.interchange.locatable.actions.testconnectionresultdisplayer.showresult(testconnectionresultdisplayer.java:62)
    at org.jitterbit.integration.client.ui.interchange.locatable.actions.testconnectionjob.runimpl(testconnectionjob.java:55)
    at org.jitterbit.application.ui.job.uijob$2.run(uijob.java:509)
    at org.jitterbit.application.worker.defaultapplicationworker$runnablewrapper.run(defaultapplicationworker.java:105)
    at java.util.concurrent.executors$runnableadapter.call(executors.java:471)
    at java.util.concurrent.futuretask.run(futuretask.java:262)
    at java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145)
    at java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615)
    at java.lang.thread.run(thread.java:745)


a: for anyone that stumbles across this, the issue was resolved by constructing a connection string manually - although jitterbit constructs one behind the scenes based on the parameters provided (driver, server name, service name), the support page notes:

depending on how the oracle server is configured you may just have to enter the server name, login and password (and port if the server runs on a non-standard port). however, in most cases you will have to construct the connection string manually, see below. 

to create a connection string, you expand the options section (on the form where you supply the database parameters) and check "construct connection string manually". the string we used took the form:
jdbc:oracle:thin:@//*insert server name*:*insert port*/*insert service name*


user
The given text has 34 "v"s.
assistant