Is there a x.xml file in (TOMCAT_HOME)/conf/Catalina/localhost, where
xx is the context name? (this is an independent context configuration
that may have been created independently when you first deployed your
application on Tomcat).
If so, either delete it, or move your data source d
parameter>
url
jdbc:informix-sqli://url:port/dbName:INFORMIXSERVER=serverName
Is that litterally what you have in your server.xml?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
Please ignore my last post - it's wrong.
(Answered before verifying).
John Thompson
|-+>
| | Eric Wulff |
| | <[EMAIL PROTECTED]|
| | >|
| ||
|
java code:
Context ctx = (Context) init.lookup("xx");
server.xml:
web.xml:
xx
javax.sql.DataSource
Container
The entries I've labelled 'xx' should all be the same.
John Thompson
|-+>
| | Eric Wulff |
|
The most likely reason for your connections not being re-used is that your
java code isn't explicitly closing connections, statements and result sets
after use.
If visiting all your code is too onerous a task, you could add the
following parameters to your data-source configuration:
remove
Is your primary key generated automatically?
If so, the combined insert/query is:
String stmt="INSERT INTO SOMEFILE (FLD1,FLD2,FLD3)
VALUES(?,?,?)";
PreparedStatement sql =
conn.prepareStatement(stmt,Statement.RETURN_GENERATED_KEYS);
sql.setInt(1,fld1);
You need to specify swallowOutput="true" on your context tag to get a
separate Tomcat log, eg:
Regards,
John
[EMAIL PROTECTED]
Ph (09) 372-5010
|-+--->
| | "Luc Foisy" |
| | <[EMAIL PROTECTED]|
| |