Many thanks for your kind response. I was using a form that was submitted twice
for any given new ssn. I have also benefited from your comments on how to write
a better java code. Turns out my html and javascript skills need improvement.
Many thanks again.
Regards
David Griffiths <[EMAIL P
This is a little dangerous as well; if an exception gets thrown, the
statement doesn't get closed. My sample code is below.
That said, your query looks fine. Add logging to your code to figure out
what's going on. Run your query by hand against your database; I suspect
you have an issue with
I tried everything you suggested. 'Think it is the way I have set up
the table in MYSQL. This is the table
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---
Here is the code:
ps = con.prepareStatement("select first, last from cust where ssn=?");
int ssnint = Integer.parseInt(ssn.trim());
ps.setInt(1, ssnint);
ResultSet rs=ps.executeQuery();
if ( rs.next()) {
rs.close();
out.println("Cust
I am getting the same result in Java code, i.e. the resultset returned is
non-null even though the primary key value is not found in the table.
Hassan Schroeder <[EMAIL PROTECTED]> wrote: On 12/29/06, murthy gandikota
wrote:
> I am posting the relevant JSTL code.
Just to clarify: you're *not
Hi
I have created a table with the following specs:
create table `cust` (
`ssn` int(9) NOT NULL PRIMARY KEY,
`submitdate` date,
`submitto` int(3),
`first` varchar(30),
`last` varchar(30),
`loanAmt` decimal(10,2),
`company` int(3),
If you've installed the jar in $JAVA_HOME/lib/ext it shouldn't
need to be referenced in $CLASSPATH.
- Original Message -
From: "Mahesh S" <[EMAIL PROTECTED]>
To: "my sql" <[EMAIL PROTECTED]>
Sent: Thursday, August 05, 2004 1:36 AM
Subject:
hi all,
i'm using RH linux 9 and MySQL(3.23.54a-11) that comes with the distro. i have
installed the latest jdbc driver (mysql-connector-java-3.0.14-production-bin.jar from
the msql site) for mysql and also have set the CLASSPATH correctly. despite this, t he
jsp application i'm
this side but site I
can't connect Mysql Database with jsp ..
Or Do you know any other method to connect Mysql with JSP
Thanks
Error Message is ;
Error: 500
Location: /sorgu1.jsp
Internal Servlet Error:
javax.servlet.ServletException: S
Dear Sir,
When Iam trying to connect remote mysql database Using JSP on LINUX Os it is
giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
2).MySQL-client-3.23.40-1.i386.rpm
files in to my
Dear Sir/madam,
we are able to connect Mysql database using JSP in Linux RedHat-6.2
OS (with out using user and password).
when we are trying to connect using user and password it was not able to
connect.
We wrote code like this
String DBUrl =
"jdbc:mysql://localhost
Dear Sir/madam,
we are able to connect Mysql database using JSP in Linux RedHat-6.2 OS
(with out using user and password).
when we are trying to connect using user and password it was not able to
connect.
We wrote code like this
String DBUrl =
"jdbc:mysql://localhost
×𾴵Ŀͻ§£¬ÄúºÃ£¡
ʱ´´ÍøÂçJSP PHPÐéÄâÖ÷»úÈ«ÃæÉý¼¶³É¹¦£¬Ö§³Ö×î¸ß°æ±¾£¬¸øÓè
¸ü¶àÖ§³Ö£¬¸ßËÙ¡¢Îȶ¨£¡Êǽ¨Á¢ÆóÒµ¡¢¸öÈËÍøÕ¾µÄ×î¼ÑÑ¡Ôñ:
²ÉÓÃ×îÐÂCatalina ÄÚºË Ö§³ÖServlet 2.3 and JSP 1.2
JDBC mm.mysql-2.0.12 JDBC microsoft.jdbc.sqlserver J2SDK1.4.0
ÖйúµçÐÅ2GÖ±½Ó½ÓÈëCHINANETÖ÷¸É
http://www.cqhost.com/
I have a JSP app hosted there and they are pretty good. They also provide a
MSQL DB
Mark
-Original Message-
From: Ken Anderson <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, March 21, 2002 2:39 PM
Subject: Re: JSP or
Klym wrote:
>
> I have built a MySQL database for a web based survey. I am trying to decide
> between JSP and PHP for my programming interface. The reason I am
> considering Java is because I have some Java experience. What would you
> recommend for someone like me who is st
PHP all the way.
This will give you a lot of information on what your options are:
http://uptime.netcraft.com/up/graph?site=www.klym.ca
and substitute site=www.yourdomainname.com
It will tell you what modules they currently support etc.
PHP is faster than JSP and I think its a whole lot
I have built a MySQL database for a web based survey. I am trying to decide
between JSP and PHP for my programming interface. The reason I am
considering Java is because I have some Java experience. What would you
recommend for someone like me who is starting out?
Also, my two current hosting
Hi,
On Thu, 2002-02-21 at 03:11, subodh kumar wrote:
> I am finding Problem with connecting JSP and mysql,
> it gives no error as well as exception,no output is coming out.
> please help me in this problem
> anticipating quick response
I don't mean to be negative, but c
Hello sir,
I am finding Problem with connecting JSP and mysql,
it gives no error as well as exception,no output is coming out.
please help me in this problem
anticipating quick response
Thanking you!
subodh
-
Before posting
I am using mySQL with tomcat and JSP without any problem.
Hearing about your symptoms, I would guess that your connections need to be
refreshed from time to time (after a certain time an unactive connection
will be dropped which explain why you have to restart tomcat)
You should use a
8PM +0530, aravind gorthy wrote:
> >
> > Hai,
> >
> > I am using MySQL with TOMCAT and JSP for development purpose.
> >
> > 1. Every morning without restarting the tomcat
> > server, i am unable to connect the MySql Database.
> > What might be the probl
On Thu, Jan 17, 2002 at 12:48:58PM +0530, aravind gorthy wrote:
>
> Hai,
>
> I am using MySQL with TOMCAT and JSP for development purpose.
>
> 1. Every morning without restarting the tomcat
> server, i am unable to connect the MySql Database.
> What might be the prob
Hai,
I am using MySQL with TOMCAT and JSP for development
purpose.
1. Every morning without restarting the tomcat
server, i am unable to connect the MySql Database.
What might be the problem..
I did't get this type of problem in Oracle & SQL server.
2. While Running Tomcat Server
> Name: MySQL
> Display Name: MySQL
> Driver: org.gjt.mm.mysql.Driver
> URL:
> jdbc:mysql://192.168.0.2:80/studiosusa?user=root&password=axnolnms
I would assume that here is your problem, most likely mysql is not running
on port 80 on your machine and you should change it to 3306,
Hello Everyone,
I need to run MySQL using JSP.
I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL
guy.
I have successfully installed Allaire JRun 3.0 on Win98 using PWS.
JRun has an application management console and I cannot seem to run
MySQL.
I am totally
Hello -
You may wish to try something a little bit more fundamental if you are new
to the Java thing.
one good way to learn how everything works in JSP is to use a free Java
Server, such as Tomcat, and build pages using Macromedia's ultradev
software. There is an extension that installs
Are you sure MySQL is listening on port 80? The default port is 3306:
jdbc:mysql://192.168.1.2:3306/
-Original Message-
From: Benj Arriola [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:56 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: JSP newbie
Hello Everyone,
I need to run MySQL using JSP.
I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL
guy.
I have successfully installed Allaire JRun 3.0 on Win98 using PWS.
JRun has an application management console and I cannot seem to run
MySQL.
I am totally
Hi !!!
)-Original Message-
)From: aDragon [mailto:[EMAIL PROTECTED]]
)Sent: Thursday, August 23, 2001 10:22 PM
)To: [EMAIL PROTECTED]
)Subject: question about use JDBC to connect with MySQL in JSP,please help
)
)
)hello,everyone,
)I am using JDBC in JSP to connect with MySQL under
hello,everyone,
I am using JDBC in JSP to connect with MySQL under BEA WEBLOgic Server 6.0,
I have copied the following codes from a book, but the server always says that
It was wrong, expecial the variable "con", I don't know why even thinking hard!
please help,thanks.
the
Hi
I am using resin-1.2.3 and mysql at backend on windows 2000...I am trying to connect
to mysql thru my JSP's but gotta bad handshake...I am using mysql-jdbc driver...
My JSP code is like this..
%@ page language="java" import=" java.sql.*, java.util.*" %>
Hi sara,
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
I can able to understand that you want to use mysql database using Jsp.
regards,
S.Chitra
At 6:41 AM -0800 2/2/01, Labs Racing wrote:
>First excuse me for my english,
>
> I should like of knowing if the mysql ago connection
> with the jsp, what if if he may do, drop of knowing
> where I could meet any tutorial, if exist.
> Thank you by attention.
> Sara.
First excuse me for my english,
I should like of knowing if the mysql ago connection
with the jsp, what if if he may do, drop of knowing
where I could meet any tutorial, if exist.
Thank you by attention.
Sara.
__
Get personalized email
hello
Can anybody tell me that if JSP(tomcat) implementation of jdk1.2.2
and twz1 Jdbc driver work together.
--
jaya
It's time to stop comparing yourself to other people. They a
>
> Connection myConn =
> DriverManager.getConnection("jdbc:mysql:///test_db1?user=Username&password=pas
> sword");
>
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
===
Saludos,
Enric Badia
SONRIE,
LA
oing error
>
> error 500
> javax.servlet.ServletException: Server configuration denies access to data
> source
>
> The jsp page it self has code that is as follows
>
> <%@ page language="java" import="java.sql.*" %>
>
: Server configuration denies access to data
source
The jsp page it self has code that is as follows
<%@ page language="java" import="java.sql.*" %>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection myConn =
DriverManager.getConnection("jdbc:mysql
: Server configuration denies access to data
source
The jsp page it self has code that is as follows
<%@ page language="java" import="java.sql.*" %>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection myConn =
DriverManager.getConnection("jdbc:mysql
39 matches
Mail list logo
