473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

JDBC to MySQL

Hello guys

I have question..... I wrote a Java program to connect to MySQL using
JDBC ...and it works fine...it connects and it does what is supposed
to do.....however when I use the same program to connect to another
MySQL server (in another machine) then I get an exception: "Server
Configuration Denies access to data source" ....any ideas???

Thank you
Marios Koumides
Jul 19 '05 #1
2 2730
Ike
yes, you need to connect to a server on the same machine. Workaround - put a
servlet on the same machine as the database, and talk to the servlet. Thats
the commone way of doing it via jdbc. -Ike

"Marios Koumides" <ma*************@cypak.net> wrote in message
news:fe**************************@posting.google.c om...
Hello guys

I have question..... I wrote a Java program to connect to MySQL using
JDBC ...and it works fine...it connects and it does what is supposed
to do.....however when I use the same program to connect to another
MySQL server (in another machine) then I get an exception: "Server
Configuration Denies access to data source" ....any ideas???

Thank you
Marios Koumides

Jul 19 '05 #2
Ike
yes, you need to connect to a server on the same machine. Workaround - put a
servlet on the same machine as the database, and talk to the servlet. Thats
the commone way of doing it via jdbc. -Ike

"Marios Koumides" <ma*************@cypak.net> wrote in message
news:fe**************************@posting.google.c om...
Hello guys

I have question..... I wrote a Java program to connect to MySQL using
JDBC ...and it works fine...it connects and it does what is supposed
to do.....however when I use the same program to connect to another
MySQL server (in another machine) then I get an exception: "Server
Configuration Denies access to data source" ....any ideas???

Thank you
Marios Koumides

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ron | last post by:
this code is giving me an excption and I cannot tell why could someone who is familiar with jdbc help me out, I am using mysql with jdbc, although the exception does not look like it is getting far...
0
by: Nils Valentin | last post by:
Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which...
0
by: sridhar nagabhurshana | last post by:
hello I am trying to connect to mysql database using connector/J jdbc driver this is my code import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
0
by: Robert Mazur | last post by:
MySQL 5.0 alpha (binary install) on Solaris 9 -or- RedHat 8.0 mysql-connector-java-3.0.8-stable ----------------------- Is there something different going on with JDBC and the alpha version...
4
ak1dnar
by: ak1dnar | last post by:
I have downloaded and copied the this Connector/j to lib directory of my java installation dir. and this Jsp page is working with that. <%@ page language="java" import="java.sql.*" %> <%...
13
by: delram | last post by:
Hello All! I've been struggling with this problem for a while. I have a database from which I need to read and display some data on a browser. (The database is set up for remote access). ...
5
oll3i
by: oll3i | last post by:
my librarybean package library.ejb; import java.sql.*; import javax.ejb.*; import library.common.*; @Stateless @Remote
2
by: bevis | last post by:
I'm new to sql server and mysql but this seems like it should be a pretty straight forward jdbc connection. But I have spent almost 2 days just trying to get a jdbc connection. Please help if you...
6
by: IvanJ2EE | last post by:
Hello partners. I have an issue using jdbc and a DB in MySQL. The problem is that I want to make a seach using the Last Name of a person stored in a MySQL DB, from a JSP The problem is that I...
0
by: neuraljay | last post by:
hi everyone. I am trying to build a jsp using webwork, hibernate and mysql. And right now I am doing its unit testing. Everytime I run the test I am getting this error: Error JDBC exception on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.