• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

JSP connection mysql

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi i have been working with jsp and mysql on win for bout a year...now i am migrating to mac osx panther and cant get jsp to connect to a mysql database....

is the connection different? does it use a different driver?? help!!

lins
 
sharp shooter, and author
Posts: 1913
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It should all work the same, but you might to provide some more details. Which version of MySQL are you using? Is it running on the Mac or another box? Which JSP container are you running? Do you have the MySQL drivers in the right place? Are you getting any error messages? etc, etc. Hopefully somebody will be able to help you out if you give them some more info.
 
Sheriff
Posts: 67753
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yup, we'll need more details. JDBC per se has no cross-platform issues that I am aware of. I have web apps running on Windows, Mac OS X, and Linux that all connect, using the exact same JDBC code, to a PostgreSQL database running on Solaris.
 
Lins Alford
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi ok im running mysql 4.1.7 (in usr/Local), Tomcat 4.1 (in Library folder) catalina container,Apache 1.3 on mac os x 10.3.6 panther...

have used mysql connector "mysql-connector-java-3.0.11-stable-bin.jar" in the past with windows but macs so confuse me as they are unix based and i me and unix dont mix!!

so do i need a different connector?? if so where do i put it??

cheers guys for help!!

lins
 
Lins Alford
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
oh and they all are running on the mac box...

lins
 
Ranch Hand
Posts: 120
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You have the right jar file.

Did you put the mysql jar file in webapps/yourapplication/WEB-INF/lib ?

And what kind of connection error are you getting. Does it say file not found or its some database related connection error? Why dont you post the error for us.
 
Lins Alford
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi there is no server error of such...i just have a simple page that has a routine to connect to a database which doesnt connect....it always fails...

yes did have connector in lib file... am i quoting the correct driver tho?? here is my code to connect:



I just get the failed message when i use safari to view page...

Lins
 
Venkatraman Kandaswamy
Ranch Hand
Posts: 120
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Try org.gjt.mm.mysql.Driver
 
a fool thinks himself to be wise, but a wise man knows himself to be a fool - shakespeare. foolish tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic