wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes ACCESS To MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ACCESS To MySQL" Watch "ACCESS To MySQL" New topic


Mathias Nilsson
Ranch Hand

Joined: Oct 13, 2003
Posts: 107
Hi Ranchers!
I want to switch from MS ACCESS 2000 to MySQL. I do not use embedded sql in
java, only queries saved in access( some kind of stored procedures ).
Many of my queries uses IIF() functions istead of CASE...WHEN. Since
MySQL don't support stored procedures, yet, then what shall i do to
make the queries work in MySQL.
// MAthias

SCJP2 , MCP( 70-229 ) , Preparing For SCWDC
m hoque

Joined: Oct 22, 2003
Posts: 3
sorry but as far as I know you don't have any other way then writing the queries in you application cause as you know mysql don't support stored procedure or views yet.
Mathias Nilsson
Ranch Hand

Joined: Oct 13, 2003
Posts: 107

The how do you do a search in mySQL. Let's say a user can write in
a name , from and to date and so on in a form and then click the search button. If the user dosn't write anything all records from the database will be retrived. If he writes a name the a like statement should be supplied. If doing this in a stroed procedure you write

How do you do this in mySQL without having to do

// Mathias
[ November 10, 2003: Message edited by: Mathias Nilsson ]
I agree. Here's the link: http://aspose.com/file-tools
subject: ACCESS To MySQL
jQuery in Action, 3rd edition