Mombu the Programming Forum

Go Back   Mombu the Programming Forum > Programming > MySQL connection
User Name
Password
REGISTER NOW! Mark Forums Read




Reply
1 3rd November 14:06
paul
External User
 
Posts: 1
Default MySQL connection



?example in the help? I couldn't find it...

Now, I'm having trouble making a connection to MySQL database.
per the help, I've followed the instructions:
1)from Project->Project Properties->Required Libraries ->
Add...->New... in the new library wizard specified the path to
mysql-connector-java-3.1.10-bin.jar
2) Exitted jBuilder
3) Even shutdown the *&&%!^$(^ computer.
4) Make a new project, new frame.
5) Drop on a Database, try to set connection->
Driver: It's not there.

Any clues?

Paul
  Reply With Quote


 


2 3rd November 14:07
lori m olson [teamb]
External User
 
Posts: 1
Default MySQL connection



If you are using the Developer or Enterprise editions, you should have
an Enterprise | Enterprise Setup menu. In that dialog, select the
"Database Drivers" tab. Add your newly configured MySQL library here.
Restart JBuilder. Now it should work.

--

Regards,

Lori Olson [TeamB]

------------

Save yourself, and everyone else, some time and search the
newsgroups and the FAQ-O-Matic before posting your next
question.

Google Advanced Newsgroup Search
http://www.google.ca/advanced_group_search
Other Newsgroup Searches:
http://www.borland.com/newsgroups/ngsearch.html
Joi Ellis's FAQ-O-Matic:
http://www.visi.com/~gyles19/fom-serve/cache/1.html
  Reply With Quote
3 3rd November 14:07
john moore
External User
 
Posts: 1
Default MySQL connection


Used "Search" in the help for DatabaseMetaData and from there browse the
provided hits.

I quoted the code I found below..

Also, since this is pretty much standard JDBC, a search on Google should
provide a number of examples as well..


--
=============================================
TeamB are volunteer helpers. Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
================================================== ==
  Reply With Quote
4 3rd November 14:07
paul furbacher [teamb]
External User
 
Posts: 1
Default MySQL connection


If the steps you describe above are exactly what you
did, my guess is that when you made the new project
in step 4, you did not add the MySQL driver library
to the required libraries tab. Adding it in step 1 to
some other project does not add it to all subsequently
created projects.


--


Paul Furbacher (TeamB)

Save time, search the archives:
http://info.borland.com/newsgroups/ngsearch.html

Is it in Joi Ellis's Faq-O-Matic?
http://www.visi.com/~gyles19/fom-serve/cache/1.html

Finally, please send responses to the newsgroup only.
That means, do not send email directly to me.
Thank you.
  Reply With Quote
5 3rd November 14:08
paul
External User
 
Posts: 1
Default MySQL connection


Did that (several times) - no good.

I finally just editted the stinkin' setConnection manualy.

<sigh> Just *another* item that doesn't work as designed.

I come up with *at least* one a day. For instance:

I've progressed to setting up a dataset. For a MySql database,
I have an id key field that is a tinyint(3). When I choose the "Persist all Metadata" option, if get a line in the code
of:
column1.setSqlType( --6); // minus, minus 6 ???

So, everytime I make a change, I have watch for that "gotcha".
  Reply With Quote
6 3rd November 14:08
paul
External User
 
Posts: 1
Default MySQL connection


Thanks John.

Doing it by hand is not a problem. In fact, I fired up Eclipse
to figure out what I needed.
  Reply With Quote
7 3rd November 14:09
john moore
External User
 
Posts: 1
Default MySQL connection


I guess I find that odd.. There is no reason why you can not do it
"by hand" in JBuilder (that is, straight JDBC..) I do it all the time..

As far as DX.. I never use dbswing and the GUI wizards for DX.. so
I'm not familiar anymore with what code JB writes.. I mostly use DX on
backend server (Web) systems and so again, I do it all "by hand"..

John...

--
=============================================
TeamB are volunteer helpers. Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
================================================== ==
  Reply With Quote
8 3rd November 14:09
paul
External User
 
Posts: 1
Default MySQL connection


Well I need more assist in coding than what I get in jBuilder.
Eclipse is a wonderful teaching tool, and besides that, I
haven't found *anything* that doesn't work as expected. What
a delight! When I can't figure it out in jBuilder and my blood
pressure rises, I cut/paste it to Eclipse and find a solution.

Paul
  Reply With Quote
9 3rd November 14:10
lori m olson [teamb]
External User
 
Posts: 1
Default MySQL connection


If you are going to use JBuilder, then you need to spend some quality
time with it. Go through all the tutorials/samples which are relevent
to your programming tasks. Learn how to use it properly, or you are
just wasting your time.

--

Regards,

Lori Olson [TeamB]

------------

Save yourself, and everyone else, some time and search the
newsgroups and the FAQ-O-Matic before posting your next
question.

Google Advanced Newsgroup Search
http://www.google.ca/advanced_group_search
Other Newsgroup Searches:
http://www.borland.com/newsgroups/ngsearch.html
Joi Ellis's FAQ-O-Matic:
http://www.visi.com/~gyles19/fom-serve/cache/1.html
  Reply With Quote
10 3rd November 14:11
john moore
External User
 
Posts: 1
Default MySQL connection


Paul,

Just a general side comment..

I think we all find certain "configurations" of IDEs more
comfortable than others.. It is a very "personal" thing. If Eclipse
seems more "natural" and usable to you...that is great! The question
is, why are you beating your head against the wall with JBuilder if it
does not work for you..???

But JBuilder does work for many others.. they and it are not better.
JBuilder just feels more comfortable to them.. (I'm one of "them"..<G>)

We are glad to help you if you really want to grok Jbuilder.. But
let's focus on that and not get into "Well, X is/does it better than Y"
type discussion.. That gets us nowhere.. (Not to mention I have no
interest in the discussion..)

John...


--
=============================================
TeamB are volunteer helpers. Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
================================================== ==
  Reply With Quote


 


Reply


Thread Tools
Display Modes




666