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.<init>(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.<init>(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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
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 Lardy <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > 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.<init>(PhysicalConnection.java:414) > at oracle.jdbc.driver.T4CConnection.<init>(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 > > -- > Posted via http://www.ruby-forum.com/. > > > >-- Cheers, ioana k&a http://boulangerie.wordpress.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
2006/9/8, Benoit Lardy <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:> > 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/D1WASUsusally 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.187The 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 Mearelli --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---