Oracle connection problem

Rails
1

I try to connect to a oracle database but I receive a error message.

The database connection file (database.yml) is :
development:
adapter: oci
database: //WASDEV1:1521/D1WAS
username: WBIOTP_E8956
password: WBIOTP_E8956

The error message is :

!ENTRY org.radrails.rails.core 4 0 2006-09-08 16:04:23.187
!MESSAGE Unable to construct database tree
!STACK 0
java.sql.SQLException: Io exception: Invalid connection string format,
a valid format is: “host:port:sid”
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at
oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.radrails.db.core.DatabaseConnector.getConnection(DatabaseConnector.java:73)
at
org.radrails.db.core.oracle.OracleDatabaseConnection.connect(OracleDatabaseConnection.java:75)
at
org.radrails.db.core.DatabaseHelper.connect(DatabaseHelper.java:171)
at
org.radrails.db.core.ProjectDatabaseManager.getConnection(ProjectDatabaseManager.java:94)
at
org.radrails.db.internal.ui.DataNavigator.constructDatabaseTree(DataNavigator.java:184)
at
org.radrails.db.internal.ui.DataNavigator.access$000(DataNavigator.java:45)
at
org.radrails.db.internal.ui.DataNavigator$1.doubleClick(DataNavigator.java:89)
at
org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:796)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:843)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:149)
at
org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:794)
at
org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1216)
at
org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1158)
at
org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:223)
at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:220)
at
org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:281)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.radrails.ide.ui.RadRails.run(RadRails.java:78)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)

I’ve running the following command :
ruby ruby-oci8-0.1.16-mswin32.rb (–> downloaded based on
recommandation oracle forum

Does somebody has a solution ?

Regards

2

Maybe is smth wrong with the name of your db connection string; maybe u
should escape “/”, trying to do it with two “//”.(it’s an “Invalid
connection string format” - error message ) or simply the format should
look
the way it suggests: host:port:sid

Hope it helps…eventually it will work:)

On 9/8/06, Benoit L. [email protected] wrote:

    at
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at

:89)
at
at
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)

:177)
at org.eclipse.core.launcher.Main.run(Main.java:977)

–
Posted via http://www.ruby-forum.com/.

–
Cheers,
ioana k&a

3

Your database name looks kind of odd. It looks like a connection
string rather than a TNSnames entry. Generally the database names in
the TNSnames file are single words (often the database SID). Double
check you are using the connection name. If //WASDEV1:1521/D1WAS
really is your connection name, try adding a duplicate entry to the
TNSnames file that doesn’t have special characters in it; for example,
try calling this connection FRED.

4

2006/9/8, Benoit L. [email protected]:

I try to connect to a oracle database but I receive a error message.

The database connection file (database.yml) is :
development:
adapter: oci
database: //WASDEV1:1521/D1WAS

Ususally this should look something like HOST/SID so maybe this should
read:

database: WASDEV1/D1WAS

username: WBIOTP_E8956
password: WBIOTP_E8956

The error message is :

!ENTRY org.radrails.rails.core 4 0 2006-09-08 16:04:23.187

The trace shows that not even radrails (which is java and is NOT using
ruby binding to oracle) is able to connect to the database! (did you
try with sqlplus or some other tool?)

bye
Luca M.