mysql seems to be hanging on my linux server. it takes a good 5+ minutes to bring up any jsp page that makes a localhost connection to the db. restarting, stopping, starting, nothing seems to fix this problem. it's running at it's normal amount of memory used. anybody have any idea what...
Hi all, I'm having problems trying to explain this, but I have a page with text driven from a DB. I'm using stylesheets to create a box around the text to make it look like a button. You have to click the "button" to bring the description up on the other side of the screen. I think the...
Hi all, I was wondering how I could make this js password prompt NOT case sensitive.
<HTML>
<HEAD>
<SCRIPT language="JavaScript">
<!--hide
var password=prompt('Enter password:','');
var mypass="fish";
if (password==mypass)
{
window.location="continue.html";
}
else
{...
Hi all,
I have a query that returns all the room numbers in a hotel. What would be the proper syntax for a query to return one instance of each room. e.g. i want 1 2 3 4, etc. instead of 1 1 1 1 1 2 2 2 2 2 3 3 3 3 3, etc.)
Thanks
Hi all, I was wondering if there was a way to have a button have 2 functions at once.
Basically, I have a form a user fills out as well as a picture file for them to upload all on one page. What I want is at the bottom of the screen to click a submit button and have the value do a "submit" and...
is there a method to get the size of a result set after executing a query? I have the following code after the query is executed:
...
int rsSize = rs.length(); //<-- length(), size()?
int counter = 0;
while(rs.next()){
String name = rs.getString("first");
if (counter == rsSize -1){...
I believe this is strictly a Java syntax question, but I'm having a problem displaying a String. It's basically setup like this:
<html>
<head>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb);
Statement stmt =...
hi all, I installed a new jtds driver, set the classpath, and wrote a test program to go into a db and print out part of a table. anyways, here's my set up:
I have a linux server running apache tomcat and I'm connecting to a windows server 2000 machine with ms sql 2000 and getting the...
I have mysql installed on a linux box along with apache, tomcat. I need to make a connection to a server with windows NT running MS SQL 2000, does anybody recommend a good odbc:jdbc driver to install on the linux system? Thanks.
I have mysql installed on a linux box along with apache, tomcat. I need to make a connection to a server with windows NT running MS SQL 2000, does anybody recommend a good odbc:jdbc driver to install on the linux system? Thanks.
Greets all. How would I have a page automatically submit a function (redirect) to another jsp page?
e.g. hit the first page (html) that has a js function on it, and instead of clicking a button to submit and take you to the next page, just automatically load the page, then redirect you to...
Hi all, I'm trying to pass a string from a javascript function into jsp all on the same page. I'm not sure how to go about this. Would it be something like?
<html>
<head>
<form name=frm>
<input type="hidden" name="variable" value="???">
<script type="text/javascript">
function myfunction()...
I have a static user page but would like to have it display the user's first name in the corner. Is there a way of doing this without cookies? I have a database with the information I need so I can make a call and display the information needed as a result set, but was wondering if cookies...
Hi all, I have a jsp page that has a block of code to update a record in a mysql DB if it's there, however i'm trying to error trap it so it checks to see if the record is even in the field first before it updates. Would it be something like?
...
else{
String query3 = "select roomnumber...
Hi all, I have a form in jsp that adds info into a database (insert into..) However, as of now I have it set with try catch blocks to capture and display errors on another page instead of getting the apache error pages. I want it to so instead of getting the duplicate key error message to...
Is there a way to update multiple databases on multiple servers at once? e.g. I have identical databases on a few different servers and I made a form in jsp where I select the servers with checkboxes, then enter the info to insert, then submit. I've tested it out and it updates successfully...
I was wondering if there is a way to code a JSP page to wait a few seconds before redirecting to another page.
something like:
<jsp: "wait code here" />
<jsp:forward page="addemployee.jsp"/>
cant use a tag, just wondering if there was a JSP method.
Hi all, I'm having a problem displaying my result set in a jsp file. Here's what I have:
<html>
<head>
<title>Result Set</title>
</head>
<%@ page import="java.sql.*" %>
<body>
<table border="1">
<tr><th>Pet ID<th>Pet Name<th>Description</tr>
<%
Class.forName("com.mysql.jdbc.Driver");
String...
Hi all, I have this problem when trying to connect to a database with the username "root" with a JSP file I wrote.
"Host '...' is not allowed to connect to this MySQL server"
Sounds like a security/permission thing. Any ideas how to allow access?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.