NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
cdoyle
Joined: 18 Aug 2008
Posts: 4
|
 Posted: Mon Aug 18, 2008 10:08 pm Post subject: New to netbeans PHP IDE |
 |
|
Hi,
I'm new to netbeans, and trying to get used to it, and have a couple questions.
The first is, I'm trying to connect to a mySQL database on my webhost, I'm able to get connected, and see the tables. But I've noticed that after a few seconds, I get errors.
For example, I see all the tables, and the fields in the tables. If I try and create a query, I'll drag a table over and then add some fields. Then I go to add another table, and I'll get an error of the connection being closed.
It does this after a very short time, like maybe 5 seconds?
The next question, is when creating a query. Does it help with joins? Or do you have to write it out by hand?
|
|
| Back to top |
|
 |
Petr Pisl
Posted via mailing list.
|
| Posted: Tue Aug 19, 2008 1:42 pm Post subject: New to netbeans PHP IDE |
|
|
Hi,
see my comments inline.
| Quote: | Hi,
I'm new to netbeans, and trying to get used to it, and have a couple questions.
The first is, I'm trying to connect to a mySQL database on my webhost, I'm able to get connected, and see the tables. But I've noticed that after a few seconds, I get errors.
|
Could you specify the error or send a stacktrace?
| Quote: |
For example, I see all the tables, and the fields in the tables. If I try and create a query, I'll drag a table over and then add some fields. Then I go to add another table, and I'll get an error of the connection being closed.
|
Hmm, I haven't seen this. Probably But still it would be great to see
the stacktrace.
| Quote: |
It does this after a very short time, like maybe 5 seconds?
The next question, is when creating a query. Does it help with joins? Or do you have to write it out by hand?
|
Unfortunately not, you have to write it by hand, but there is code
completion which can help you with this.
Regards,
Petr
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@php.netbeans.org
For additional commands, e-mail: users-help@php.netbeans.org
|
|
| Back to top |
|
|
cdoyle
Joined: 18 Aug 2008
Posts: 4
|
| Posted: Tue Aug 19, 2008 4:06 pm Post subject: |
|
|
How do I do a stacktrace?
I could also attach a screenshot of the error window it generates.
bummer on the query builder, the joins are always the problem for me and was hoping it would help build those for me 
|
|
| Back to top |
|
|
Petr Pisl
Posted via mailing list.
|
| Posted: Tue Aug 19, 2008 4:15 pm Post subject: New to netbeans PHP IDE |
|
|
cdoyle wrote:
| Quote: | How do I do a stacktrace?
I could also attach a screenshot of the error window it generates.
|
Yes, it would be great.
Petr
| Quote: |
bummer on the query builder, the joins are always the problem for me and was hoping it would help build those for me :(
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@php.netbeans.org
For additional commands, e-mail: users-help@php.netbeans.org
|
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@php.netbeans.org
For additional commands, e-mail: users-help@php.netbeans.org
|
|
| Back to top |
|
|
cdoyle
Joined: 18 Aug 2008
Posts: 4
|
| Posted: Thu Aug 21, 2008 1:31 pm Post subject: |
|
|
here are the screenshots of the errors I get after netbeans connects and then sits for a few seconds.
| Description: |
|
| Filesize: |
127.02 KB |
| Viewed: |
4367 Time(s) |
|
| Description: |
|
| Filesize: |
29.67 KB |
| Viewed: |
4367 Time(s) |
|
|
|
| Back to top |
|
|
davidvc
Joined: 21 Aug 2008
Posts: 1
Location: Berkeley, California
|
| Posted: Thu Aug 21, 2008 4:45 pm Post subject: |
|
|
The error is coming from the physical network layer - the MySQL driver NetBeans is using to talk to the database keeps losing the network connection to the MySQL server. This could happen if there's something spotty about your network connection. Is the MySQL server running on the same machine as NetBeans, or on a different machine?
Also, to see if we can isolate the issue, can you use some other way to talk to MySQL besides NetBeans? There is a nice freeware tool called SquirrelSQL, see if it happens there as well. You might also try the 'mysql' command line tool that comes with your MySQL installation.
|
|
| Back to top |
|
|
cdoyle
Joined: 18 Aug 2008
Posts: 4
|
| Posted: Fri Aug 22, 2008 2:24 am Post subject: |
|
|
| davidvc wrote: | The error is coming from the physical network layer - the MySQL driver NetBeans is using to talk to the database keeps losing the network connection to the MySQL server. This could happen if there's something spotty about your network connection. Is the MySQL server running on the same machine as NetBeans, or on a different machine?
Also, to see if we can isolate the issue, can you use some other way to talk to MySQL besides NetBeans? There is a nice freeware tool called SquirrelSQL, see if it happens there as well. You might also try the 'mysql' command line tool that comes with your MySQL installation. |
I'm connecting remotely to the db on my webhost's server.
I wasn't sure if you could do this or not, but It's looking like no.
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
