Thank you so much for helping me out, Chris!
___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-inter
Put a reference to the data that needs to be saved to the database in
the Object that implements HttpSessionBindingListener. Then you
will have access to it when the valueUnbound() method is called.
(*Chris*)On 10/21/05, Ming Li <[EMAIL PROTECTED]> wrote:
I have some data kept in the s
I have some data kept in the session object that can be changed very
frequently by users during each session, so it's not efficient to update
database whenever a user makes a change. I want to update database just
before the session times out. I thought I could do database update in
valueUn
Try this one if your db is MySQL.
http://javamyadmin.sourceforge.net/
Never tried it.
~Jay
http://JavaRSS.com
--- Paul Philion <[EMAIL PROTECTED]> wrote:
> Greetings...
>
> Does anyone know of an open-source web-based app for
> generically
> managing data/databases using JDBC?
>
> I could do s
Greetings...
Does anyone know of an open-source web-based app for generically
managing data/databases using JDBC?
I could do some simple form-based stuff for data management, but I
really need to be able to add/drop tables, edit/manage the data, etc.
If there was a simple, web-based app to do this
Title: RE: How to show an image when fetching from database
Refer to Paul Copeland's response to a similar question earlier. Subject of the response being "Re: How To Insert Image Into Mqsql data type ?(urgent)"
gl,
Rahul
-Original Message-
From: andy susanto
hai,
this is my partial code :
Statement stmt = Con.createStatement();
ResultSet resultSet = stmt.executeQuery("SELECT PIC FROM TransTreatment");
byte[] test = new byte[4096];
res.setContentType("image/jpeg");
while (resultSet.next()) {
// Get data from the binary column
test = r
I have dah succeed to retrieve data from MySQL
database by using servlet, then I want to send it to MIDP
application.
Anybody have suggestion/idea how I should do
it?
TIA,
noeng
___
To unsubscribe, send email to [EMAIL
Title: RE: Check database availability
Type
java
utils.dbping on the command prompt.. and u shall see how to check whether
database is listening...
-Original Message-From: A mailing list for
discussion about Sun Microsystem's Java Servlet API Technology.
[mailto:[
Title: RE: Check database availability
Would
you please specify, for example using WebLogic, what specific class or method
that can be used to tell a remote database availability?
Thanks
lot!
John
-Original Message-From: Hyne, David
[mailto:[EMAIL PROTECTED]Sent: Tuesday
Title: RE: Check database availability
Depending on the container you use, it tells you the state and availability of database server, database itself. Weblogic and Resin are well known for these.
-Original Message-
From: Xu, John [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 29
This may be a programming question but not servlet. However, if you have some idea.
Is there a good way to check database availability that is waiting for connection
without connected to the database server? We know the host is running but don't know
the database server. We need to know
you can limit the time a Statement will take to execute with:
Statement.setQueryTimeout(int seconds)
Then you can continue with closing the connection, etc.
HTH,
--
Becky Norum
Database Administrator
Center for Subsurface Sensing and Imaging Systems (CenSSIS)
Northeastern University
http
Hi friend,
I have some web reports developed which accesses my database and displays the result as a
webpage.
The thing is if due to some reason the query got
stuck and caused delay then if the user closes the window the connection
remained unclosed. Although i have set time out in the
, Neo. I'm trying to tell you that when you're ready - you won't
> have to!
>
>
> -Original Message-
> From: Carlos Portugal B. [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 01, 2003 4:55 AM
> To: [EMAIL PROTECTED]
> Subject: Save character special Ñ int
l you that when you're ready - you won't have
to!
-Original Message-
From: Carlos Portugal B. [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 4:55 AM
To: [EMAIL PROTECTED]
Subject: Save character special Ñ into database
Hello, i'm new in this list.
I have a
Carlos,
What database are you using? For Oracle, you must specify language
settings while creating a database. Not sure about others..
--
Becky Norum
Database Administrator
Center for Subsurface Sensing and Imaging Systems (CenSSIS)
Northeastern University
http://www.censsis.neu.edu
On Fri
Hello, i'm new in this list.
I have a problem with the special characters (spanish characters), i execute
SQL command:
"INSERT INTO table1 (field1) VALUES ('niño')"
The insert is ok, but when i see the table "table1" i see "ni?o", the special
character ñ is replaced by ?. How can i do?
Please
write
to the outputstream of the socket. This way you get the xml contents.
similarly you can do the same for the database update.
regards,
partha
-Original Message-
From: Ashish Sarin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 4:08 PM
To: [EMAIL PROTECTED]
Subject: How
This definitely doesn't belong in a servlet interest group
...but to give you a very simple answer... WEBSERVER (or if you prefer FTP server).
And a database is just a database. No special setups for that.
Frans
On 5 Feb 2003 at 16:08, Ashish Sarin wrote:
> Hi all,
>
> I h
Hi all,
I have a scenario in which a servlet reads an XML file located on the
internet. I know the IP address of the machine on which the XML file is
located. I have to read that XML file and do some processing and then update
another database located on the internet, the IP address of which is
Check the statement if it is null before closing
it.
Vj
- Original Message -
From:
Tom
Kochanowicz
To: [EMAIL PROTECTED]
Sent: Tuesday,February 04,2003 11:43
PM
Subject: Weird database problem &
catching exception
I am using MySQL with R
I am using MySQL with Resin. Recently there has been a lot
of discussion on this list about closing database statements and problems. Has
anyone run into this one?
I have this finally statement
finally{
try{
//
close the statments & DB connec
Nancy, the jdbc/odbc bridge is a toy and used a lot for connecting to an
Acesss database. You should be using Sybases' JDBC driver if you are
connecting to that brand of database.
T.K.
-Original Message-
From: A mailing list for discussion about Sun Microsystem's Java S
public void makeOdbcConn()
throws ClassNotFoundException, SQLException
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:" + dsn, name, passwd);
}
why don't you try this.
this may help you to solve the problem
---
Further reflection -right after posting my initial question- led to one of those "I
could'a had a V-8" moments, and the probable answer to my own question, which is -
that it would most likely be hard for the database to return an exception when it is
not even running. So h
n't happen, the ODBC
driver is lying to you!");
On Friday, November 22, 2002, at 05:47 PM, Susan wrote:
We are connecting to database in standard fashion, using either JDBC
driver, or JDBC:ODBC bridge. Here is the problem: if we try to
connect to a running database but cannot connect(e.
We are connecting to database in standard fashion, using either JDBC driver, or
JDBC:ODBC bridge. Here is the problem: if we try to connect to a running database
but cannot connect(e.g. due to incorrect password), exception is thrown and we trap
the error. This is good. However, if the
Title: UTF8 conversion - send mails from database : failUTF8Conv
Hi All,
We have an application which checks an oracle database and a servlet sends out the mails at regular intervals based on the status whether the message was sent or not.
The application has been running fine until now
I agree; However a connection pool is more scalable.
--- Mark Mascolino-MR/PGI <[EMAIL PROTECTED]> wrote:
> You absolutely do not want to share database connections like this. Each
> request should have its own database connection. Wether the connection is
> created from scratch
You absolutely do not want to share database connections like this.
Each request should have its own database connection. Wether the
connection is created from scratch each time or it is checked out from a
pool doesn't matter in terms of correctness. You will run into
issues with two or
Title: Connection to database from jsp.
HI,
Have a bean class. And there in the
constructor part of the class establish a database connection. Do put a
condition to check if connection is open already if yes then dont do
anything. This worked for me. Looking forward for some comments
Title: Connection to database from jsp.
Who is this guy moderator take him out of this
LIST
- Original Message -
From:
[Your Full Name]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 16, 2002 1:34
PM
Subject: Re: Connection to database from
jsp.
NO
s no controller servlet as it is a simple system. What i
> want is to access the database from the jsps. The problem is that I do not
> want a new connection to be established everytime a request is made. What is
> the solution for this?
> I had initially thought of having a utility cl
stem. What i
> want is to access the database from the jsps. The problem is that I do not
> want a new connection to be established everytime a request is made. What is
> the solution for this?
> I had initially thought of having a utility class and in that I can have a
> getConnectio
PROTECTED]> wrote:
> NO MORE GARBIGE MAIL
>
> thanks
>
> -Original Message-
> From: Anoop Kumar V [mailto:[EMAIL PROTECTED]]
> Sent: 16. lokakuuta 2002 10:59
> To: [EMAIL PROTECTED]
> Subject: Connection to database from jsp.
>
>
>
> We have a system co
Title: Connection to database from jsp.
NO
MORE GARBIGE MAIL
thanks
-Original Message-From: Anoop Kumar V
[mailto:[EMAIL PROTECTED]]Sent: 16. lokakuuta 2002
10:59To: [EMAIL PROTECTED]Subject:
Connection to database from jsp.
We have a system consisting of a group of jsps
Title: Connection to database from jsp.
We have a system consisting of a group of jsps - which have links to one another. There is no controller servlet as it is a simple system. What i want is to access the database from the jsps. The problem is that I do not want a new connection to be
Hi Vijay,
If you make real application do not copy j2ee tutorial. For a tutorial one
DB connection is enough.
Fei Li
- Original Message -
From: "vijay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 24, 2002 5:46 PM
Subject: j2ee and databa
DB creates a (one) database
connection and has a few methods.
My question is, if that application has only one connection, then what if
1000 users access the application at a time?
I'm assuming ServletContext means it's the scope when ever a particular
servlet is deployed r started.
If 1000 us
age-
> From: Geeta Ramani [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 08, 2002 6:59 AM
> To: [EMAIL PROTECTED]
> Subject: Re: code generation from database
>
> Eva:
>
> You may want to look at Expresso. I believe the framework is considered
> excellen
Guys,
I ahve a problem pulling large amount of data from the database taking more
than 3 minutes.
It works on one net work, but not on the other net work.
we donot have any time outs in our code.
I am using JRun and IIS, I have Servlet to pull the data.
thanks in advance,
Venkat
I was trying to compare the performence between JSP/ASP with some benchmark
tests, and when come across database benchs, there are something very
interesting.
The JDBC driver provided by Microsoft (jar files dated around 4/19/2002)
providedslower access time then SUN's JDBC-ODBC d
Thanks to all who responded. I will give the different suggestions a try.
___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java
>In testing I have noticed that if a user runs a servlet that does some
>database access and hits "stop" (the X in IE for example) while the
>database connection is still open, then the database connection remains
>open. This will eventually cause problems if we have 100+
Can i suggest something ?
Logic is something like this ...
initiate a thread in the init() of the servlet
in the doGet( ... ) and in the doPost( ... ) when you open
the database set a flag imme. to indicate an open database connection.
when you
Opened and closed in doGet( ).
Opened in beginning, and closed once the HTML has been generated (from
database query) to be displayed.
The servlet basically generates a report that is displayed as an HTML
table.
The connection is just a local variable. I don't store it in the session
or any
when do you open your connection, and when do you close, and where do you
store it for the duration of its existance?
> -Original Message-
> From: Jeremy W. Redmond [SMTP:[EMAIL PROTECTED]]
> Sent: 18 July 2002 02:13
> To: [EMAIL PROTECTED]
> Subject: Database c
I couldn't find an answer to this question in archives. Maybe there is no solution.
In testing I have noticed that if a user runs a servlet that does some database access
and hits "stop" (the X in IE for example) while the database connection is still open,
then the data
d a servlet to display the saffters info to uses.
Database is MS sql server7.0 . I connected database with generic Connection object.As
thought of performance,I wanna connect database with "Connection Pool."
Follwing is an example offered by Microsoft:
Context ctx = n
Hi,
When you configure a new datasource using the weblogic
console there is a field called the jndi name.
Here you would have given ("jdbc/what-ever-you-wrote")
and also filled up the next textfield pointing this
data-source to use a pre-configured Connection Pool
(say demoPool).
So when you wan
I believe most tools have wizards that generate the XML file for the
datasource. I don't know WebLogic but below is an example generated by
Forte:
-
-
jdbc/EmployeeDB
-
Database
mydb
jdbc:odbc:mydb
scott
tiger
Hello everybody,I'm newbie,I have finised a
servlet to display the saffters info to uses.
Database is MS sql server7.0 . I connected
database with generic Connection object.As thought of performance,I wanna
connect database with "Connection Pool."
Follwing is an exam
Hi
I have a problem with my resin server. It is very unstable and tends to
loose persistence(?). What happens is that database connection is ok for
a while, but as soon as I change a class, or a jsp, it throws the error
mentioned below. What I do is delete all the *.jsp and *.class files form
the
Hi, all
i am newbie for Orion application server and starting tests with it.
First: Is neccesary JNDI programming in Orion??
Second: I have a simple web application with a Database connection
pool and received the following error. Can you help me, please
The thing you have to decide (besides nicF's excellent comments)is :
will the database be updated during a session by other users, either via the servlets
or via annother app?
I so, do you care that the web user won't see the change till they logout and back in ?
If you do decide t
ns.
Last point on this: I once worked on an app that did sorting
extreemly well using client side JavaScript.
> Simplistically, the database contains a list of their clients (as I
> said before, upto 5000), what investment products they have
> available (I believe 100 is typical). A client
> -Original Message-
> From: Nic Ferrier [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 3:41 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Question re servlet database application
>
Thanks for your response, Nic. I'll see what I can ad
Dan Hobbs <[EMAIL PROTECTED]> writes:
> Currently, ALL the data is loaded from the (Oracle) database into
> memory at login time, and held in so-called "Bean" objects (but I'm
> not convinced that's a good name for them). References to these bean
> objec
experience constitutes two weeks reading and a four-day course on Java
basics).
The current state is that we have a set of servlets which reproduce data
from the database, mostly based on some form information (for example return
all products owned by a client: showProducts?clientId=xxx). There will
lto:[EMAIL PROTECTED]]Sent: Tuesday, February 26, 2002
12:20 AM
Hi..I have a servlet which needs to access an
Oracle Database using JDBC..i installed the driver for it...and it works for
local applications...my url string is jdbc:oracle:oci8:@
if i use that in the servlet i dont get any
)
)
)
Best Regards
Bob Jones
Senior Analyst Programmer - FRC MSATS Project
MMS Information Technology
NEMMCO
02 8845 8616
pallav
cc:
Sent by: "A mailing Subject: Connecting to Oracle
dat
Hi..I have a servlet which needs to access an
Oracle Database using JDBC..i installed the driver for it...and it works for
local applications...my url string is jdbc:oracle:oci8:@
if i use that in the servlet i dont get any
connection...what url should i use? i'm using oracle Per
entity.
regards
Pramod Nair
- Original Message -
From: "Gerry Scheetz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 12:02 AM
Subject: Sort of OT: Getting data from database to JavaBeans
> My team is in the process of building a web ap
plenty of parameters (fill a HashMap and pass it to the
constructor).
This is not J2EE.
You create an InitialContext that
is almost completely independent of what the web container has
provided you with and it does have to initiate a new TCP
connection. (This may be as slow
Try "Expresso" from www.jcorporate.com. That framework is built with database
intensive web applications in mind. They have encountered and solved most of the
problems most of us can think of!!
Regards,
Geeta
Gerry Scheetz wrote:
> My team is in the process of building a we
the
Action class returns the location of the JSP page to be displayed. My
problem is all my database access goes through one singleton class, which
uses connection pooling. The run-time performance of this class is fine,
but with multiple developers everyone want to access this file at the same
time
Hello all,
I was wondering if it is at all possible to
somehow, database-independently, get a Date on the exact time a specific tuple
was updated/inserted into a table. I have been looking at DatabaseMetaData and
ResultSetMetaData, but I don't find any obvious solutions. I don&#
I'll try to benchmark it against what I currently got. If it breaks or is
too slow, I'll go for Harish's solution. (building the DB with a script) But
to me, a Java based database would be the ideal platform independent
solution. (easiest way of deploying my application)
Thank
See inline:
- Original Message -
From: "Gert Grenander"
Sent: Monday, February 04, 2002 9:24 AM
Subject: Re: Deployment of servlets & database
> I found a good page about it:
> http://hsqldb.sourceforge.net/internet/hSql.html .
>
> This is a great solution. I
al Message -
From:
Harish Kumar
Kottarathil
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 3:25
AM
Subject: Re: Deployment of servlets &
database
You need not bundle DB s/w along with ur
app. U can write scripts which will create ur DB schema on client&#x
I found a good page about it:
http://hsqldb.sourceforge.net/internet/hSql.html .
This is a great solution. I'll dig into it and see if it's a stable product
and if it fits my needs! I hope it's a speedy database. Do you have
experience in using it? (e.g. are there any drawba
r app will become platform independent, regardless of the underlying
DB.
All the best
:-) Harish
- Original Message -
From:
Gert
Grenander
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 1:23
PM
Subject: Re: Deployment of servlets &
Have you considered Java as a platform for your DB ?
Hypersonic sql (there are others) comes to my mind as an ideal candidate.
Marco
- Original Message -
From: Gert Grenander
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 8:53 AM
Subject: Re: Deployment of servlets & data
for spending your time to give me an
answer on this issue!Regards,Gert
- Original Message -
From:
Harish Kumar
Kottarathil
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 2:39
AM
Subject: Re: Deployment of servlets &
database
There is no MS A
: Deployment of servlets &
database
Hi Harish,
But if I want to bundle the MS Access database
with the application, (for easier deployment, since it's going to be sold as a
module) is there an issue of it being developed in a Windows environment?
Or do I have to build a
Hi Harish,
But if I want to bundle the MS Access database with
the application, (for easier deployment, since it's going to be sold as a
module) is there an issue of it being developed in a Windows environment?
Or do I have to build a database on each different potential platform
well, if u r using java jdbc 2.0 APIs for
database access, ur application can be indepenedent of the underlying DB.
Doesn't make any diff, whether the DB is oracle/DB2 etc.
Harish
- Original Message -
From:
Gert
Grenander
To: [EMAIL PROTECTED]
Sent: M
Hi,
I'm currently developing my first servlet-based web
application, and I really like the concept of Java being platform independent
language. But one thing that bugs me is that I feel that I got platform
dependent when I took the decision of having a real database instead of X
Title: RE: Can Database connection be maintained between servlets ...
Hi Dear,
I think your problem may be solved by using "Connection Pooling".
Thanks & Regards
Naveed Iqbal
-Original Message-
From: Brian Moynihan [mailto:[EMAIL PROTECTED]]
Sent: Tuesd
You can use the session object to share the database connection between
servlets.
After verifying username and password, in the session object you put the
database connection:
//Get the session
HttpSession mySession = req.getSession(true);
//Set
- Original Message -
From: "Brian Moynihan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 11:15 AM
Subject: Can Database connection be maintained between servlets ...
> Hi there,
>
> Does anyone know how to maintain a datab
Brian Moynihan wrote:
>
> i.e. Open the connection through a login servlet which gives the database
> username and password. What we need, is for all other servlets in the
> application to have access to this connection.
>
Search the archives (link at the bottom of every message)
Hi there,
Does anyone know how to maintain a database connection between servlets:
i.e. Open the connection through a login servlet which gives the database
username and password. What we need, is for all other servlets in the
application to have access to this connection.
A possible
vijay <[EMAIL PROTECTED]> writes:
> Hi,
>
> Please advice what's wrong in the following Servlet. Iam not getting a
> value for Connection 'con':
>
>public Connection handle()
>{
> Connection conn=null;
> try {
>Class.forName("oracle.jdbc.driver.OracleDriver");
>
"Simple Servlet Output";
String query = "select NE_FIRST_NAME from ne_applicant where
ne_ssn='123456782'";
database DATA= new database();
Connection con=DATA.handle();
ResultSet rset=DATA.fetchRows(con,query);
String v=""
Hi,
Its not a problem with the SQL Query. The Application is a tested product runnning on
JRUN..
The STackTrace shows an error in the getConnection method.
Do I have to specify any database settings in Server.xml or just by placing the
database driver JAR file in the common/lib directory of
> javax.servlet.ServletException: net/avenir/jdbc2/h (Illegal Field name
"?")
maybe you did not set parameters in your SQL ?
Yuriy
___
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "s
Title: Message
Hello
all,
I recently upgraded
my web server to Tomcat. I successfully created the respective contexts for my
aplications.
However I am unable
to connect to the database in my JSP's. When I run my JSP Page , it throws the
following exception
the first few
D]
Sent: Thursday, December 20, 2001 9:23
AM
Subject: Database Connection in
Tomcat
Hello
all,
I recently
upgraded my web server to Tomcat. I successfully created the respective
contexts for my aplications.
However I am
unable to connect to the database in my JSP
Title: Message
Hello
all,
I recently upgraded
my web server to Tomcat. I successfully created the respective contexts for my
aplications.
However I am unable
to connect to the database in my JSP's. When I run my JSP Page , it throws the
following exception
the first few
Hi
Can you please tell me the restore command syntax
using which you can restore a database ? Which database are you using and what
is the preocess to restore a database (using restore command) fro a backup file.
Can you please explain me? Please anser me at [EMAIL PROTECTED]
Thanks
> Sulakshana Awsarikar wrote:
>
> I am trying to restore a database from a backup file using a
> java program.
>
Try JDBC-INTEREST, it's the official Sun mailing list
for JDBC questions:
http://archives.java.sun.com/archives/jdbc-interest.html
Good luck.
--
Christo
Hi,
I am trying to restore a database from a backup file using a
java program. In this I am establishing a connection to the database and
executing the restore statement. But this fails as the database is in
use.
Is there any way to restore a database programatically
?
regards
Hi all,
I am working with Wepsphere application Server. I am
executing servlets but i cant execute a JDBCServlet. I
also Create a JDBC driver and install it but i cant
interaction it with my JDBCServlet.
__
Do You Yahoo!?
Yahoo! GeoCities - quick
On Tue, 20 Nov 2001, mike dizon wrote:
> Hi All,
>
> I'm trying to make sure that an entry in a database doesn't exist
> before I enter data into the database -- based on information
> entered in on a form.
>
> How do I go about doing that? Any help would be ap
g to get a exception. Act upon that exception by propagating
> it
> or use a "UPDATE" now.
>
> Peter
>
>
> - Original Message -
> From: mike dizon <[EMAIL PROTECTED]>
> Date: Wednesday, November 21, 2001 4:42 am
> Subject: verifying database entries
>
MAIL PROTECTED]>
Date: Wednesday, November 21, 2001 4:42 am
Subject: verifying database entries
> Hi All,
>
> I'm trying to make sure that an entry in a database doesn't exist
> before I enter data into the database -- based on information
> entered in on a form.
2001 4:42
AM
Subject: verifying database entries
Hi All,
I'm trying to make sure that an entry in a
database doesn't exist before I enter data into the database -- based on
information entered in on a form.
How do I go about doing that? Any help wou
Hi All,
I'm trying to make sure that an entry in a database
doesn't exist before I enter data into the database -- based on information
entered in on a form.
How do I go about doing that? Any help would be
appreciated.
Thanks
MD
1 - 100 of 699 matches
Mail list logo
