# Oracle connection problem **URL:** \ **Category:** Rails\ **Created:** [September 8, 2006, 4:12pm UTC](https://www.ruby-forum.com/t/oracle-connection-problem/68021 "2006-09-08T16:12:38Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![e6395](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f1d935/32.png) [@e6395](https://www.ruby-forum.com/u/e6395)\ **Post date:** [September 8, 2006, 4:12pm UTC](https://www.ruby-forum.com/t/oracle-connection-problem/68021/1 "2006-09-08T16:12:38Z")
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 ---
**Author:** ![e6395](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f1d935/32.png) [@e6395](https://www.ruby-forum.com/u/e6395)\ **Post date:** [September 8, 2006, 6:46pm UTC](https://www.ruby-forum.com/t/oracle-connection-problem/68021/2 "2006-09-08T18:46:38Z")
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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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/](http://www.ruby-forum.com/). > > > – Cheers, ioana k&a > **[white bread and home made chocolate](https://boulangerie.wordpress.com/)** > > another meek to eat ---
**Author:** ![e6395](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f1d935/32.png) [@e6395](https://www.ruby-forum.com/u/e6395)\ **Post date:** [September 8, 2006, 10:19pm UTC](https://www.ruby-forum.com/t/oracle-connection-problem/68021/3 "2006-09-08T22:19:02Z")
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. ---
**Author:** ![e6395](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f1d935/32.png) [@e6395](https://www.ruby-forum.com/u/e6395)\ **Post date:** [September 9, 2006, 8:35am UTC](https://www.ruby-forum.com/t/oracle-connection-problem/68021/4 "2006-09-09T08:35:56Z")
2006/9/8, Benoit L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > 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.