SV: JDBC error
Hi,
I have done so (it has been verified with the jdbc debug option you
mentioned). I don't explicitly close my result sets, but as the
prepared statements are explictly closed the result sets should
according to the specs be closed as well. If not closing the result
sets is the error, wouldn't you expect to run out of a different type of
resource than child processes?
Ian
-Oprindelig meddelelse-
Fra: The elephantwalker [mailto:[EMAIL PROTECTED]]
Sendt: 2. januar 2002 19:18
Til: Orion-Interest; Ian S. Hagen
Emne: RE: JDBC error
Ian,
Make sure that you are closing your connections properly. eg:
try {
// open connection
} catch () {
// do something
} finally {
try {
// close connections
} catch () {
// do something
}
}
This could be your problem. The try/catch/finally block MUST be used
with
Oracle...or you will run out of process resources as exceptions occur.
You can check if the connections are being closed properly with a debug
property:
java -Djdbc.connection.debug=true -jar orion.jar
This will remote where you are not closing your connections.
Regards,
the elephantwalker
www.elephantwalker.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ian S. Hagen
Sent: Wednesday, January 02, 2002 5:53 AM
To: Orion-Interest
Subject: JDBC error
Has anyone experienced instability when using Orion together with Oracle
9i? I am currently running an Orion 1.5.2 server on a Tru64 platform
against a 9i database using the OCI driver. Everything works fine
initially, but after a few hours of sending HTTP requests to Orion I
find that performance degrades. Eventually, I start getting database
errors. I have seen Oracle go into a state where it returns an SQL
exception:
java.sql.SQLException: ORA-00600: internal error code, arguments:
[kksfbc-new-child-thresh-exceeded], [], [], [], [], [], [], []
I have also experienced the OCI driver core dumping when executing the
same test:
OCI-21503: program terminated by fatal error
OCI-04030: out of process memory when trying to allocate 30056 bytes
(Alloc environm,eoj_stmt_malloc)
Obviously, I am running out of resources. The thing I don't understand
is where! I have run Orion setting the JDBC debug parameters
jdbc.connection.debug, datasource.verbose and jdbc.debug to true, and it
seems as though the connections are being created and returned correctly
(no connections leaked).
Has this problem got anything to do with me running it on Tru64? The
Orion FAQ doesn't mention Tru64 as a supported OS.
My datasources.xml looks like this:
?xml version=1.0?
!DOCTYPE data-sources PUBLIC Orion data-sources
http://xmlns.oracle.com/ias/dtds/data-sources.dtd;
data-sources
!-- Setting up the data source for the ben provider --
data-source
class=com.evermind.sql.DriverManagerDataSource
name=zellsoft
location=jdbc/zellsoft
xa-location=jdbc/xa/zellsoft
ejb-location=jdbc/ejb/zellsoft
connection-driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:oci8:@vasp
username=ben
password=ben
max-connections=200
min-connections=25
max-connect-attempts=10
connection-retry-interval=1
inactivity-timeout=30
wait-timeout=75
/
/data-sources
Any suggestions are appreciated!
Ian
jdbc problems
Hi, I've a Orion server with Oracle datasources configured I've put the jdbc debug and in error file I look the next message : *** CLOSING STATEMENT WITH 1 OPEN RESULTSET AT: ***java.lang.Exception at com.evermind._bt.close(Unknown Source) at com.evermind._wq.close(Unknown Source) at com.evermind._bt.close(Unknown Source) at com.evermind._wq.close(Unknown Source) at com.evermind._bt.close(Unknown Source) In server-out I look the next message: new DebugConnection(1)Created new physical connection: XA XA Orion Pooled jdbc:oracle:thin:machine:portnew DebugConnection(2)new DebugConnection(3)Created new physical connection: Pooled [Connection 3: oracle.jdbc.driver.OracleConnection@id]new DebugConnection(4)new DebugPreparedStatement(1)new DebugPreparedStatement(2)new DebugPreparedStatement(3)new DebugPreparedStatement(4)new DebugResultSet()new DebugResultSet()new DebugResultSet()new DebugResultSet()closing DebugPreparedStatement(1)closing DebugPreparedStatement(2)closing DebugPreparedStatement(3)closing DebugPreparedStatement(4)Pooled jdbc:oracle:thin:@machine:port Releasing connection Pooled [Connection 3: oracle.jdbc.driver.OracleConnection@id to pool (Pool size: 1) closing DebugConnection(4)null: Releasing connection XA XA Orion Pooled jdbc:oracle:thin:machine:port: to pool (Pool size: 1)closing DebugConnection(2)closing DebugConnection(1)closing DebugConnection(3) What does it mean? Could you help me? Thank,
Unsuscribe
Automated reply from rvirkus@www.scaraboo.com
Sehr geehrte Damen und Herren, ich befinde mich vom 18.12.2001 bis 04.01.2002 im Urlaub. Herr Ochotnicki übernimmt in dieser Zeit meine Aktivitäten. Bitte senden Sie Ihre E-Mail an [EMAIL PROTECTED] Vielen Dank Robert Virkus Director Mobile Solutions - scaraboo GmbH Georg-Wulf-Str. 4-6 28199 Bremen - www.scaraboo.de [EMAIL PROTECTED] - Telefon +49 421-5967-549 Mobil+49 171-3531 635 Fax +49 421 5967-576
Re: Disabling connectivity below 128bit encryption
Dear all, we have similar requirement in our application. According to the Servlet Specification 2.3 (SRV.4.7 SSL Attributes, page 36), there should be two values stored in the request when using https: javax.servlet.request.key_size and javax.servlet.request.cipher_suite, but Orion is not storing this values in the request (Note: old versions of those keys, javax.servlet.request.key-size and javax.servlet.request.cipher-suite are also not stored in the request). We think that this is a bug in the Orion. I am not aware of any other possibility to determine the key length, any suggestions will be highly appreciated. Best Regards, Ivo Rakovac Stephen Davidson wrote: Greetings. I am working with some data that needs to be kept secure. I was wondering if anyone on this list knew how to force browsers to connect at 128bit Encryption or better, or, failing that, figure out what encryption level the browser is using. -Steve
[no subject]
UNSUBSCRIBE
JNDI problems
Dear all, I have just tried deploying a new application-client inside an ear. The app-client has one env-entry inside application-client.xml, like so: ?xml version=1.0? !DOCTYPE application-client PUBLIC -//Sun Microsystems, Inc.//DTD J2EE Application Client 1.2//EN http://java.sun.com/j2ee/dtds/application-client_1_2.dtd; application-client env-entry env-entry-nameportNumber/env-entry-name env-entry-typejava.lang.Integer/env-entry-type env-entry-value2020/env-entry-value /env-entry /application-client The application is included in the ear as a module like so: ?xml version=1.0? !DOCTYPE application PUBLIC -//Sun Microsystems, Inc.//DTD J2EE Application 1.2//EN http://java.sun.com/j2ee/dtds/application_1_2.dtd; application display-namegames/display-name module ejbgames-ejb.jar/ejb /module module javaappclients.jar/java /module /application and I have addedclient-module path=appclients.jar deployment-time=eb2bd89636 auto-start=true user=admin/ to orion-application.xml. The manifest in the client jar specifies the Main-Class. I also have jndi.properties in the application client jar with this in it: java.naming.factory.initial=com.evermind.server.ApplicationClientInitialCont extFactory java.naming.provider.url=ormi://localhost/games java.naming.security.principal=admin java.naming.security.credentials=123abc All this works and I see the following message in the console: Auto-starting appclients.jar... Listening on ServerSocket[addr=0.0.0.0/0.0.0.0,port=0,localport=2020] The problem is that when I try and retrieve the env-entry from the initialcontext like so InitialContext jndiContext = new InitialContext(); Integer portNumber = (Integer) jndiContext.lookup(java:comp/env/portNumber); I get the following message: javax.naming.NotContextException: comp is not a subcontext at tyrex.naming.EnvContext.internalLookup(EnvContext.java, Compiled Code) at tyrex.naming.EnvContext.lookup(EnvContext.java:212) at tyrex.naming.java.JavaContext.lookup(JavaContext.java:147) at javax.naming.InitialContext.lookup(InitialContext.java:354) at afm.utils.socket.SocketServer.main(Unknown Source) at java.lang.reflect.Method.invoke(Native Method) at com.evermind._fn.run(., Compiled Code) at com.evermind._bs.run(., Compiled Code) I'm running orion 1.5.3 on Windows NT, with jdk 1.3. Any ideas, observations, etc are really welcome!
Support for JCA
Does Orion support the JCA (Java Connector Architecture) 1.0 spec - i.e. can I deploy a .RAR file with a resource adapter in it? As always, any help will be greatly appreciated. Marc
Transactions across a cluster Orion GURUS - please advise.
Hi All Has anyone actually tested orion transactions over a cluster ? I am looking at developing a CMP Entity Bean that stores an account balance for a customer. If this entity bean is deployed on a cluster of 4 servers and I have and admin person and the actual customer do transactions, will they be looking at the same object instance even if their requests are being served on different servers ? Will ACID be supported in this scenario ? I would greatly appreciate any help/advice on this. Regards, Manuel
JSP Compilation
How can one call Orion's built in JSP Compiler to do pre-compilation of JSPs? I know other applicaiton server's, such as Tomcat and WL, distribute and support external JSP Compilation. Hopefully, Orion does as well. Thanks, Ted Rice
Re: Support for JCA
ciao Marc i don't know orion but using oc4 2.0 yes. ciao Paolo Marc Rabil wrote: Does Orion support the JCA (Java Connector Architecture) 1.0 spec - i.e. can I deploy a .RAR file with a resource adapter in it? As always, any help will be greatly appreciated. Marc begin:vcard n:ramasso;paolo x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] note;quoted-printable:Senior Sales Consultant=0D=0ASolution Team=0D=0AEMEA Java/XML Professional Community=0D=0A=0D=0A fn:paolo ramasso end:vcard
RE: Transactions across a cluster Orion GURUS - please advise.
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Manuel De Jesus Sent: Thursday, January 03, 2002 11:18 AM To: Orion-Interest Subject: Transactions across a cluster Orion GURUS - please advise. Hi All Has anyone actually tested orion transactions over a cluster ? I am looking at developing a CMP Entity Bean that stores an account balance for a customer. If this entity bean is deployed on a cluster of 4 servers and I have and admin person and the actual customer do transactions, will they be looking at the same object instance even if their requests are being served on different servers ? Simple answer is maybe but probably not. Will ACID be supported in this scenario ? transaction integrety with entity beans is done thru synchronization of the data by ejbload and ejbstore. the database handles this. I would greatly appreciate any help/advice on this. Regards, Manuel
OrionCluster Ignoring Host IP?
Greetings. Orion appears to be ignoring the host that is set in this global-web-application file. I have the following line in the global-web-application file; cluster-config host=10.10.4.5/ Due to the number of machines, subnets and switches that will be invovled, I would prefer to separate out the Muliticasts for each subnet. I really do want the clustering to be machine/server wide, instead of on a per applicaton basis. Suggestions? Steve ===Begin Orion Run=== orion@www3:/usr/local/orion java -server -Xincgc -jar -Dcluster.debug=true -Dhttp.cluster.debug=true orion.jar [1] 1398 orion@www3:/usr/local/orion HTTP-clustering service started... Created cluster-listener for 230.0.0.1/230.0.0.1:9126 as 0... Adding clustering service 'HRneXus'... HTTP-Clustering service initializing... HTTP-Clustering sent I want sessions request... Orion/1.5.3 initialized -- Stephen Davidson Java Consultant Delphi Consultants, LLC http://www.delphis.com Phone: 214-696-6224 x208 ?xml version=1.0? !DOCTYPE orion-web-app PUBLIC '//Evermind//Orion web-application' 'http://www.orionserver.com/dtds/orion-web.dtd' !-- Set development=true to enabvle development, enable this if you want to debug JSP sources etc -- orion-web-app jsp-cache-directory=./persistence servlet-webdir=/servlet development=true persistence-path=./persistence/state.ser !-- The mime-mappings for this server -- mime-mappings path=./mime.types / servlet-chaining servlet-name=xsl mime-type=text/xml / web-app servlet servlet-namexsl/servlet-name servlet-classcom.evermind.servlet.XSLServlet/servlet-class init-param param-namedefaultContentType/param-name param-valuetext/html/param-value /init-param /servlet servlet servlet-namejsp/servlet-name servlet-classcom.evermind.server.http.JSPServlet/servlet-class /servlet servlet servlet-namessi/servlet-name servlet-classcom.evermind.server.http.SSIServlet/servlet-class /servlet servlet servlet-namecgi/servlet-name servlet-classcom.evermind.server.http.CGIServlet/servlet-class /servlet servlet servlet-nameperl/servlet-name servlet-classcom.evermind.server.http.CGIServlet/servlet-class init-param param-nameinterpreter/param-name param-valueperl/param-value /init-param /servlet servlet servlet-namephp/servlet-name servlet-classcom.evermind.server.http.CGIServlet/servlet-class init-param param-nameinterpreter/param-name param-valuephp/param-value /init-param /servlet servlet-mapping servlet-namejsp/servlet-name url-pattern/*.jsp/url-pattern /servlet-mapping servlet-mapping servlet-namecgi/servlet-name url-pattern/*.cgi/url-pattern /servlet-mapping servlet-mapping servlet-nameperl/servlet-name url-pattern/*.pl/url-pattern /servlet-mapping servlet-mapping servlet-namephp/servlet-name url-pattern/*.php/url-pattern /servlet-mapping servlet-mapping servlet-namephp/servlet-name url-pattern/*.php3/url-pattern /servlet-mapping servlet-mapping servlet-namephp/servlet-name url-pattern/*.phtml/url-pattern /servlet-mapping servlet-mapping servlet-namessi/servlet-name url-pattern/*.shtml/url-pattern /servlet-mapping welcome-file-list welcome-fileindex.html/welcome-file welcome-filedefault.jsp/welcome-file /welcome-file-list /web-app cluster-config host=10.10.4.5/ /orion-web-app
