Eclipse Community Forums: ServerTools (WTP)

Home » Language IDEs » ServerTools (WTP) » Data Connection to MySQL

Data Connection to MySQL [message #31218]

Sun, 25 July 2004 18:50

Eclipse User

Originally posted by: rob.williams.intersperse.com

Installed the drop and opened the view, went into the wizard to connect
to my MySQL database.

1. MySQL is not one of the choices on the left, but I just chose other,
put in the settings, and there was no way to click Test Connection, but
if I check something on the left, and leave all the settings, I can
click test and it will succeed.

2. Clicked through the remaining pages and on the last page, I click
finish and it won't finish, it just hangs there.

Anyone else stuck here?

Re: Data Connection to MySQL [message #31389 is a reply to message #31218]

Sun, 25 July 2004 23:34

Eclipse User

"Rob Williams" <rob.williams@intersperse.com> wrote in message
news:ce1db0$9t$1@eclipse.org...
> Installed the drop and opened the view, went into the wizard to connect
> to my MySQL database. ...I click
> finish and it won't finish, it just hangs there.
>
> Anyone else stuck here?

It would be extremely helpful if you could investigate this hang a bit using
the source code and the debugger and enter a bugzilla about why it hangs and
how the team could fix it. That would be very helpful indeed. I look
forward to it.

Bjorn

Re: Data Connection to MySQL [message #32138 is a reply to message #31389]

Mon, 26 July 2004 22:54

Eclipse User

Originally posted by: rob.williams.intersperse.com

I tried to map the /home/webtools repository. It lets me connect, but
then when I open head, there are no projects....

Bjorn Freeman-Benson wrote:

> "Rob Williams" <rob.williams@intersperse.com> wrote in message
> news:ce1db0$9t$1@eclipse.org...
>
>>Installed the drop and opened the view, went into the wizard to connect
>>to my MySQL database. ...I click
>>finish and it won't finish, it just hangs there.
>>
>>Anyone else stuck here?
>
>
> It would be extremely helpful if you could investigate this hang a bit using
> the source code and the debugger and enter a bugzilla about why it hangs and
> how the team could fix it. That would be very helpful indeed. I look
> forward to it.
>
> Bjorn
>
>

Re: Data Connection to MySQL [message #33565 is a reply to message #32138]

Wed, 28 July 2004 02:12

Eclipse User

Rob,

Not sure why you did not see the source code on HEAD. This is what I got
from the web page. "pserver:anonymous@dev.eclipse.org:/home/webtools"

On your MySQL connection what was the parameter used? Also, do you have a
a eclipse\plugins\com.ibm.etools.sqlmodel_5.1.1\runtime\vendor s\MYSQL_V323
folder under your installation?

Der Ping

Rob Williams wrote:

> I tried to map the /home/webtools repository. It lets me connect, but
> then when I open head, there are no projects....

> Bjorn Freeman-Benson wrote:

> > "Rob Williams" <rob.williams@intersperse.com> wrote in message
> > news:ce1db0$9t$1@eclipse.org...
> >
> >>Installed the drop and opened the view, went into the wizard to connect
> >>to my MySQL database. ...I click
> >>finish and it won't finish, it just hangs there.
> >>
> >>Anyone else stuck here?
> >
> >
> > It would be extremely helpful if you could investigate this hang a bit
using
> > the source code and the debugger and enter a bugzilla about why it hangs
and
> > how the team could fix it. That would be very helpful indeed. I look
> > forward to it.
> >
> > Bjorn
> >
> >

Re: Data Connection to MySQL [message #34039 is a reply to message #33565]

Wed, 28 July 2004 15:05

Eclipse User

Originally posted by: rob.williams.intersperse.com

Der Ping Chou wrote:
> Rob,
>
> Not sure why you did not see the source code on HEAD. This is what I got
> from the web page. "pserver:anonymous@dev.eclipse.org:/home/webtools"

Yeah, I put that into the CVS view and did get a connection, but it just
showed me CVSROOT (which had a bunch of small files in it) and nothing
else...?

>
> On your MySQL connection what was the parameter used? Also, do you have a
> a eclipse\plugins\com.ibm.etools.sqlmodel_5.1.1\runtime\vendor s\MYSQL_V323
> folder under your installation?

That folder is there, but MySQL is not one of the vendor choices??

>
> Der Ping
>
> Rob Williams wrote:
>
>
>>I tried to map the /home/webtools repository. It lets me connect, but
>>then when I open head, there are no projects....
>
>
>>Bjorn Freeman-Benson wrote:
>
>
>>>"Rob Williams" <rob.williams@intersperse.com> wrote in message
>>>news:ce1db0$9t$1@eclipse.org...
>>>
>>>
>>>>Installed the drop and opened the view, went into the wizard to connect
>>>>to my MySQL database. ...I click
>>>>finish and it won't finish, it just hangs there.
>>>>
>>>>Anyone else stuck here?
>>>
>>>
>>>It would be extremely helpful if you could investigate this hang a bit
>
> using
>
>>>the source code and the debugger and enter a bugzilla about why it hangs
>
> and
>
>>>how the team could fix it. That would be very helpful indeed. I look
>>>forward to it.
>>>
>>>Bjorn
>>>
>>>
>
>
>

Re: Data Connection to MySQL [message #34071 is a reply to message #33565]

Wed, 28 July 2004 15:11

Eclipse User

Originally posted by: rob.williams.intersperse.com

Der Ping Chou wrote:
> Rob,
>
> Not sure why you did not see the source code on HEAD. This is what I got
> from the web page. "pserver:anonymous@dev.eclipse.org:/home/webtools"
>
> On your MySQL connection what was the parameter used?

Not sure I understand you here....

> Also, do you have a
> a eclipse\plugins\com.ibm.etools.sqlmodel_5.1.1\runtime\vendor s\MYSQL_V323
> folder under your installation?
>
> Der Ping
>
> Rob Williams wrote:
>
>
>>I tried to map the /home/webtools repository. It lets me connect, but
>>then when I open head, there are no projects....
>
>
>>Bjorn Freeman-Benson wrote:
>
>
>>>"Rob Williams" <rob.williams@intersperse.com> wrote in message
>>>news:ce1db0$9t$1@eclipse.org...
>>>
>>>
>>>>Installed the drop and opened the view, went into the wizard to connect
>>>>to my MySQL database. ...I click
>>>>finish and it won't finish, it just hangs there.
>>>>
>>>>Anyone else stuck here?
>>>
>>>
>>>It would be extremely helpful if you could investigate this hang a bit
>
> using
>
>>>the source code and the debugger and enter a bugzilla about why it hangs
>
> and
>
>>>how the team could fix it. That would be very helpful indeed. I look
>>>forward to it.
>>>
>>>Bjorn
>>>
>>>
>
>
>

Re: Data Connection to MySQL [message #34105 is a reply to message #33565]

Wed, 28 July 2004 15:20

Eclipse User

Originally posted by: rob.williams.intersperse.com

Der Ping:

Mystery deepens. If you go here:
http://dev.eclipse.org/viewcvs/index.cgi/?cvsroot=WebTools_P roject

you will see that there is nothing there, even through this interface?....

Rob

Der Ping Chou wrote:

> Rob,
>
> Not sure why you did not see the source code on HEAD. This is what I got
> from the web page. "pserver:anonymous@dev.eclipse.org:/home/webtools"
>
> On your MySQL connection what was the parameter used? Also, do you have a
> a eclipse\plugins\com.ibm.etools.sqlmodel_5.1.1\runtime\vendor s\MYSQL_V323
> folder under your installation?
>
> Der Ping
>
> Rob Williams wrote:
>
>
>>I tried to map the /home/webtools repository. It lets me connect, but
>>then when I open head, there are no projects....
>
>
>>Bjorn Freeman-Benson wrote:
>
>
>>>"Rob Williams" <rob.williams@intersperse.com> wrote in message
>>>news:ce1db0$9t$1@eclipse.org...
>>>
>>>
>>>>Installed the drop and opened the view, went into the wizard to connect
>>>>to my MySQL database. ...I click
>>>>finish and it won't finish, it just hangs there.
>>>>
>>>>Anyone else stuck here?
>>>
>>>
>>>It would be extremely helpful if you could investigate this hang a bit
>
> using
>
>>>the source code and the debugger and enter a bugzilla about why it hangs
>
> and
>
>>>how the team could fix it. That would be very helpful indeed. I look
>>>forward to it.
>>>
>>>Bjorn
>>>
>>>
>
>
>

Re: Data Connection to MySQL [message #35761 is a reply to message #31389]

Sun, 01 August 2004 11:26

Eclipse User

Originally posted by: rob.williams.intersperse.com

I tried to find the source for the wizard for setting up the SQL
connection, but was unable. I used the usual approaches: looking for
classes that are extending Wizard or WizardPage. But these things
weren't written for Eclipse originally. Then I tried the old walk the
tree and look at the classes. Could someone gimme a hint? I am trying to
figure out why the New Connection wizard is hanging.

Thanks.

Bjorn Freeman-Benson wrote:

> "Rob Williams" <rob.williams@intersperse.com> wrote in message
> news:ce1db0$9t$1@eclipse.org...
>
>>Installed the drop and opened the view, went into the wizard to connect
>>to my MySQL database. ...I click
>>finish and it won't finish, it just hangs there.
>>
>>Anyone else stuck here?
>
>
> It would be extremely helpful if you could investigate this hang a bit using
> the source code and the debugger and enter a bugzilla about why it hangs and
> how the team could fix it. That would be very helpful indeed. I look
> forward to it.
>
> Bjorn
>
>

Re: Data Connection to MySQL [message #36103 is a reply to message #35761]

Mon, 02 August 2004 20:09

Eclipse User

Rob,

See my ealier answer posted for a similar question:

For SQL Server connection, you can use 'Other' driver, making sure that
you have MS SQL Server 2000 JDBC driver class jar file specify in your
class location (mssqlserver.jar, msbase.jar and msutil.jar) You can down
load the driver from MS.

This is some connection sample you can go by:

Class name = com.microsoft.jdbc.sqlserver.SQLServerDriver
URL: jdbc:microsoft:sqlserver://server1:1433;

Rob Williams wrote:

> I tried to find the source for the wizard for setting up the SQL
> connection, but was unable. I used the usual approaches: looking for
> classes that are extending Wizard or WizardPage. But these things
> weren't written for Eclipse originally. Then I tried the old walk the
> tree and look at the classes. Could someone gimme a hint? I am trying to
> figure out why the New Connection wizard is hanging.

> Thanks.

> Bjorn Freeman-Benson wrote:

> > "Rob Williams" <rob.williams@intersperse.com> wrote in message
> > news:ce1db0$9t$1@eclipse.org...
> >
> >>Installed the drop and opened the view, went into the wizard to connect
> >>to my MySQL database. ...I click
> >>finish and it won't finish, it just hangs there.
> >>
> >>Anyone else stuck here?
> >
> >
> > It would be extremely helpful if you could investigate this hang a bit
using
> > the source code and the debugger and enter a bugzilla about why it hangs
and
> > how the team could fix it. That would be very helpful indeed. I look
> > forward to it.
> >
> > Bjorn
> >
> >

Re: Data Connection to MySQL [message #36171 is a reply to message #35761]

Mon, 02 August 2004 20:50

Eclipse User

Rob,

Try com.ibm.etools.rsc.extensions.ui.wizards NewDatabaseWizardPage class.
BTW, what is hanging with SQL Server 2000 connection or MySQL?

Der Ping
Rob Williams wrote:

> I tried to find the source for the wizard for setting up the SQL
> connection, but was unable. I used the usual approaches: looking for
> classes that are extending Wizard or WizardPage. But these things
> weren't written for Eclipse originally. Then I tried the old walk the
> tree and look at the classes. Could someone gimme a hint? I am trying to
> figure out why the New Connection wizard is hanging.

> Thanks.

> Bjorn Freeman-Benson wrote:

> > "Rob Williams" <rob.williams@intersperse.com> wrote in message
> > news:ce1db0$9t$1@eclipse.org...
> >
> >>Installed the drop and opened the view, went into the wizard to connect
> >>to my MySQL database. ...I click
> >>finish and it won't finish, it just hangs there.
> >>
> >>Anyone else stuck here?
> >
> >
> > It would be extremely helpful if you could investigate this hang a bit
using
> > the source code and the debugger and enter a bugzilla about why it hangs
and
> > how the team could fix it. That would be very helpful indeed. I look
> > forward to it.
> >
> > Bjorn
> >
> >

Re: Data Connection to MySQL [message #36239 is a reply to message #36103]

Tue, 03 August 2004 01:36

Eclipse User

Originally posted by: rob.williams.intersperse.com

Der Ping:

Not sure how MS snuck in the door (there's a saying about Satan that
applies, I think... ;)...) I'm doing MySQL....

R

Der Ping Chou wrote:
> Rob,
>
> See my ealier answer posted for a similar question:
>
> For SQL Server connection, you can use 'Other' driver, making sure that
> you have MS SQL Server 2000 JDBC driver class jar file specify in your
> class location (mssqlserver.jar, msbase.jar and msutil.jar) You can down
> load the driver from MS.
>
> This is some connection sample you can go by:
>
> Class name = com.microsoft.jdbc.sqlserver.SQLServerDriver
> URL: jdbc:microsoft:sqlserver://server1:1433;
>
> Rob Williams wrote:
>
>
>>I tried to find the source for the wizard for setting up the SQL
>>connection, but was unable. I used the usual approaches: looking for
>>classes that are extending Wizard or WizardPage. But these things
>>weren't written for Eclipse originally. Then I tried the old walk the
>>tree and look at the classes. Could someone gimme a hint? I am trying to
>>figure out why the New Connection wizard is hanging.
>
>
>>Thanks.
>
>
>>Bjorn Freeman-Benson wrote:
>
>
>>>"Rob Williams" <rob.williams@intersperse.com> wrote in message
>>>news:ce1db0$9t$1@eclipse.org...
>>>
>>>
>>>>Installed the drop and opened the view, went into the wizard to connect
>>>>to my MySQL database. ...I click
>>>>finish and it won't finish, it just hangs there.
>>>>
>>>>Anyone else stuck here?
>>>
>>>
>>>It would be extremely helpful if you could investigate this hang a bit
>
> using
>
>>>the source code and the debugger and enter a bugzilla about why it hangs
>
> and
>
>>>how the team could fix it. That would be very helpful indeed. I look
>>>forward to it.
>>>
>>>Bjorn
>>>
>>>
>
>
>

Re: Data Connection to MySQL [message #36272 is a reply to message #36171]

Tue, 03 August 2004 01:36

Eclipse User

Originally posted by: rob.williams.intersperse.com

With MySQL. Thanks for the tip. I'll try and run it in the debugger and
see what's hanging it up.

Der Ping Chou wrote:

> Rob,
>
> Try com.ibm.etools.rsc.extensions.ui.wizards NewDatabaseWizardPage class.
> BTW, what is hanging with SQL Server 2000 connection or MySQL?
>
> Der Ping
> Rob Williams wrote:
>
>
>>I tried to find the source for the wizard for setting up the SQL
>>connection, but was unable. I used the usual approaches: looking for
>>classes that are extending Wizard or WizardPage. But these things
>>weren't written for Eclipse originally. Then I tried the old walk the
>>tree and look at the classes. Could someone gimme a hint? I am trying to
>>figure out why the New Connection wizard is hanging.
>
>
>>Thanks.
>
>
>>Bjorn Freeman-Benson wrote:
>
>
>>>"Rob Williams" <rob.williams@intersperse.com> wrote in message
>>>news:ce1db0$9t$1@eclipse.org...
>>>
>>>
>>>>Installed the drop and opened the view, went into the wizard to connect
>>>>to my MySQL database. ...I click
>>>>finish and it won't finish, it just hangs there.
>>>>
>>>>Anyone else stuck here?
>>>
>>>
>>>It would be extremely helpful if you could investigate this hang a bit
>
> using
>
>>>the source code and the debugger and enter a bugzilla about why it hangs
>
> and
>
>>>how the team could fix it. That would be very helpful indeed. I look
>>>forward to it.
>>>
>>>Bjorn
>>>
>>>
>
>
>

Re: Data Connection to MySQL [message #37110 is a reply to message #34105]

Thu, 05 August 2004 10:22

Eclipse User

Rob, all the source code is in the zip file for the WTP contribution.
If you use the PDE self host environment, you can import the plugins
that have the code you're interested in debugging.

Der Ping can point you to the correct plugin.

Rob Williams wrote:
> Der Ping:
>
> Mystery deepens. If you go here:
> http://dev.eclipse.org/viewcvs/index.cgi/?cvsroot=WebTools_P roject
>
> you will see that there is nothing there, even through this interface?....
>
> Rob
>
>
> Der Ping Chou wrote:
>
>> Rob,
>>
>> Not sure why you did not see the source code on HEAD. This is what I got
>> from the web page. "pserver:anonymous@dev.eclipse.org:/home/webtools"
>>
>> On your MySQL connection what was the parameter used? Also, do you have a
>> a
>> eclipse\plugins\com.ibm.etools.sqlmodel_5.1.1\runtime\vendor s\MYSQL_V323
>> folder under your installation?
>>
>> Der Ping
>> Rob Williams wrote:
>>
>>
>>> I tried to map the /home/webtools repository. It lets me connect, but
>>> then when I open head, there are no projects....
>>
>>
>>
>>> Bjorn Freeman-Benson wrote:
>>
>>
>>
>>>> "Rob Williams" <rob.williams@intersperse.com> wrote in message
>>>> news:ce1db0$9t$1@eclipse.org...
>>>>
>>>>
>>>>> Installed the drop and opened the view, went into the wizard to
>>>>> connect
>>>>> to my MySQL database. ...I click
>>>>> finish and it won't finish, it just hangs there.
>>>>>
>>>>> Anyone else stuck here?
>>>>
>>>>
>>>>
>>>> It would be extremely helpful if you could investigate this hang a bit
>>
>>
>> using
>>
>>>> the source code and the debugger and enter a bugzilla about why it
>>>> hangs
>>
>>
>> and
>>
>>>> how the team could fix it. That would be very helpful indeed. I look
>>>> forward to it.
>>>>
>>>> Bjorn
>>>>
>>>>
>>
>>
>>
>

Re: Data Connection to MySQL [message #39869 is a reply to message #36272]

Thu, 19 August 2004 17:06

Eclipse User

On Mon, 02 Aug 2004 22:36:52 -0700, Rob Williams <rob.williams@intersperse.com> wrote:
>With MySQL. Thanks for the tip. I'll try and run it in the debugger and
>see what's hanging it up.

Just curious what the latest is with this problem. I'm having the same
problem. My Summary is here:

http://msp.gsfc.nasa.gov/~sardella/eclipse/eclipse-ibm-mysql .gif

This was dumped into my log file after hitting "Finish":

!ENTRY org.eclipse.ui 4 4 Aug 19, 2004 16:50:13.244
!MESSAGE Unhandled event loop exception

!ENTRY org.eclipse.ui 4 0 Aug 19, 2004 16:50:13.244
!MESSAGE java.lang.NullPointerException
!STACK 0
java.lang.NullPointerException
at com.ibm.etools.rsc.core.ui.wizards.NewCWJDBCPage.internalSav eWidgetValues(NewCWJDBCPage.java:1207)
at com.ibm.etools.rsc.core.ui.wizards.NewConnectionWizard.perfo rmFinish(NewConnectionWizard.java:605)
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDi alog.java:609)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDi alog.java:305)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.jav a:506)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe ner.java:89)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:2772)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2431)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:668 )
at org.eclipse.jface.window.Window.open(Window.java:648)
at com.ibm.etools.rsc.ui.actions.NewConnectionAction.run(NewCon nectionAction.java:72)
at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEv ent(BaseSelectionListenerAction.java:166)
at org.eclipse.jface.action.ActionContributionItem.handleWidget Selection(ActionContributionItem.java:915)
at org.eclipse.jface.action.ActionContributionItem.access$2(Act ionContributionItem.java:866)
at org.eclipse.jface.action.ActionContributionItem$7.handleEven t(ActionContributionItem.java:785)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :82)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:796)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:2772)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2431)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:1377)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1348)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:254)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:141)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplicatio n.java:96)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(Pl atformActivator.java:335)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:273)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:129)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.eclipse.core.launcher.Main.basicRun(Main.java:183)
at org.eclipse.core.launcher.Main.run(Main.java:644)
at org.eclipse.core.launcher.Main.main(Main.java:628)

TIA

Previous Topic:	MAC OSX IBM web tools contrib. getting started.
Next Topic:	What to use question

Goto Forum:

-=] Back to Top [=-

Current Time: Wed May 21 12:04:15 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter