jdbc performance Orion vs. WL
Hi all,
decided to find out who is the fastest when working with DB using jdbc. I
wrote a simple servlet that does the following:
1) acquires connection from the App. Server's JNDI tree and selects 7000 records from
an Oracle table.
2) acquires connection using DriverManager (OracleDriver) and selects 7000 records
from the same table.
The results are
1) WL ~4000 ms vs. Orion ~7000 ms
2) WL ~4000 ms vs. Orion ~6600 ms
I agree that WL outperforms Orion because it is using its own DB Driver. But why even
standard OracleDriver on Orion is working ~3 sec slower than on Weblogic 6.1?
May be it is possible to tune Orion so that it could outperform WL when using jdbc?
Egor Savotchkin
try {
System.out.println(
*);
System.out.println(Init ctx ... );
start();
Context ctx = new InitialContext();
end();
System.out.println(Getting DS ...);
start();
DataSource ds = (DataSource) ctx.lookup(JNDI_NAME);
end();
System.out.println(getting connection ...);
start();
Connection conn = ds.getConnection();
end();
System.out.println(Connection : + conn.getClass());
System.out.println(creating statement ...);
start();
Statement st = conn.createStatement();
end();
String query = SELECT * from logs;
DatabaseMetaData dbmd = conn.getMetaData();
System.out.println(executing : + query);
start();
ResultSet rs = st.executeQuery(query);
end();
System.out.println(ResultSet : + rs.getClass());
int i = 0;
System.out.println(rs);
start();
while (rs.next()) {
i++;
}
end();
rs.close();
st.close();
conn.close();
conn = null;
System.out.println(i = + i);
System.out.println();
System.out.println(getting connection ...);
start();
Class.forName(oracle.jdbc.driver.OracleDriver);
conn = DriverManager.getConnection(
url, xxx, xxx);
end();
System.out.println(Connection : + conn.getClass());
System.out.println(creating statement ...);
start();
st = conn.createStatement();
end();
System.out.println(executing query : + query);
start();
rs = st.executeQuery(query);
end();
System.out.println(ResultSet : + rs.getClass());
i = 0;
System.out.println(rs);
start();
while (rs.next()) {
i++;
}
end();
} catch (Exception ex) {
System.out.println(Exception : + ex);
}
test
test
ejb performance
Hi all! I made some tests to find out how transactions affect performance. I called a sessionless' ejb empty function with different transaction attributes. It turned out that call time mean was about 250 ms and it almost not changed depending on attributesn (Requires, supports, ...). So, does transactions have so little impact on perfomance??? Why it takes about 250ms to invoke an empty function on ejb? Is it because ejb are distrubuted objects? What else could affect the ejb performance? Regards, Savotchkin Egor Web-technologies department eMail: [EMAIL PROTECTED] CJSC "SoftPro" - Billing systems tel: (+7-095) 755-5655 (3135) web-site: http://www.cboss.ru
RE: ejb performance
Yeah!!! I forgot that in this function I got not pooled db connection. So, after I turned the pooling on it became 0 to 10 ms (on PIII 600 with 256 RAM) to invoke this function!!! Great indexes!! So given these numbers I may throw away all these transaction attributes and f.ex. always specify requires, since it doesnot affect perfomance... Regards, Savotchkin Egor Web-technologies department eMail: [EMAIL PROTECTED] CJSC "SoftPro" - Billing systems tel: (+7-095) 755-5655 (3135) web-site: http://www.cboss.ru -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Krueger Sent: Saturday, December 16, 2000 2:57 PM To: Orion-Interest Subject: Re: ejb performance At 14:28 16.12.00 , you wrote: Hi all! I made some tests to find out how transactions affect performance. I called a sessionless' ejb empty function with different transaction attributes. It turned out that call time mean was about 250 ms and it almost not changed depending on attributesn (Requires, supports, ...). So, does transactions have so little impact on perfomance??? Why it takes about 250ms to invoke an empty function on ejb? Is it because ejb are distrubuted objects? What else could affect the ejb performance? Regards, Savotchkin Egor you must have made a mistake 250ms is ridiculously slow. that's 4 calls per sec please check your setup. this doesn't reflect our observations at all. even with transactions that's way too slow or are you by any chance using a 386 with 4 Meg RAM and a nojit VM ;-)). regards, robert Web-technologies department eMail: [EMAIL PROTECTED] CJSC "SoftPro" - Billing systems tel: (+7-095) 755-5655 (3135) web-site: http://www.cboss.ru (-) Robert Krüger (-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH (-) Brüder-Knauß-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de
RE: ejb performance
Yes, of course: data-source name="DateSource" class="com.evermind.sql.ConnectionDataSource" location="jdbc/defaultCBOSS" schema="/database-schemas/oracle.xml" pooled-location="jdbc/CBOSS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:oracle:thin:@128.1.5.50:1528:dev" connection-driver="oracle.jdbc.driver.OracleDriver" username="username" password="password" max-connections="10" inactivity-timeout="30" min-connections="5" / Pay attention to use write location in your code, f.ex. I use jdbc/CBOSS to locate the datasource since it is the place where pooled datasources are stored by orion. Regards, Savotchkin Egor Web-technologies department eMail: [EMAIL PROTECTED] CJSC "SoftPro" - Billing systems tel: (+7-095) 755-5655 (3135) web-site: http://www.cboss.ru -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcus Lankenau Sent: Saturday, December 16, 2000 6:30 PM To: Orion-Interest Subject: Re: ejb performance Hi Savotchkin! Could you please describe, what you did to activate pooling? I tried this for my application, but without success... (could you maybe post you datasource xml?) thx in advance Marcus Lankenau Yeah!!! I forgot that in this function I got not pooled db connection. So, after I turned the pooling on it became 0 to 10 ms (on PIII 600 with 256 RAM) to invoke this function!!! Great indexes!! So given these numbers I may throw away all these transaction attributes and f.ex. always specify requires, since it doesnot affect perfomance... Regards, Savotchkin Egor Web-technologies department eMail: [EMAIL PROTECTED] CJSC "SoftPro" - Billing systems tel: (+7-095) 755-5655 (3135) web-site: http://www.cboss.ru -- begin:vcard n:Lankenau;Marcus x-mozilla-html:FALSE url:wwl.de org:wwl vision2market;Interactive adr:;;goebelstr. 46;Lilienthal;D;28865; version:2.1 email;internet:[EMAIL PROTECTED] title:Senior Developer fn:Marcus Lankenau end:vcard
tx timeout
Hello, is it possible to change transaction timeout in orion? Regards, Savotchkin Egor SoftPro company web-site: http://www.cboss.ru tel: (+7-095) 755-5655 (3135) eMail: [EMAIL PROTECTED] Web-technologies department
URGENT!! jms
Hi all! how can I specify for a message-driven-bean to which topic to listen to? Seems that messagelogger ejb only wants to listen to jms/demoTopic... there is no message-driven-bean-deployment tag explanation in orion-ejb-jar.xml :-(( regards, Savotchkin Egor SoftPro company web-site: http://www.cboss.ru tel: (+7-095) 755-5655 (3135) eMail: [EMAIL PROTECTED] Web-technologies department
Some pictures not loaded
Hi all, I've noticed that sometimes not all pictures are loaded on my site . When I right-click on the picture and choose "Show picture" it gets loaded! I treid with the same results on NT and on Solaris as well (all versions of orion). Is it an orion bug or server misconfiguration? Egor Savotchkin. P.S. The html page structure is not complex, so it's not likely an explorer bug.
SSL with Thawte
We changed our web-server software to orion application server. Its a java web server so we successfully insertied the cert to the keystore but now when orion is run it says:"No available certificates correspond to cipher suites enabled". We tried to run a simple java server and made: ...suites = ((SSLServerSocket)ss).getSupportedCipherSuites(); ((SSLServerSocket)ss).setEnabledCipherSuites(suites); ... The above error disappeared (programming error of the orion team??), but now an exception is thrown when attempting to connect using SSL: Runtime Exception: No Cipher Suites in CommonHere is a piece of explanation from JavaSoft FAQ:"Problem: When using Netscape Navigator or Microsoft Internet Explorer (IE) to access files on a server that only has DSA-based certificates, a runtime exception occurs indicating that there are no cipher suites in common. Cause: By default, certificates created with keytool use DSA public keys. Navigator and IE do not use DSA public keys in their enabled cipher suites. Solution: To interact with Navigator or IE, you should create certificates that use RSA-based keys. To do this, you need to specify the -keyalg RSA option when using keytool." Does that mean that I have to recreate our certificate? Thanks in advance, Egor Savotchkin .
Re: orion classloader?
Unfortunately this doesn't help :-(( Anyone could
advice me smth?
Egor Savotchkin
- Original Message -
From:
Tony
Wiegand
To: Orion-Interest
Sent: Wednesday, November 08, 2000 8:36
PM
Subject: Re: orion classloader?
I'm not sure if this will fix
your problem, but try getting the classloader from the
thread.
Thread.currentThread().getContextClassLoader();
Savotchkin Egor wrote:
Hi all, I needed to load
property files on my own without ResourceBundle class because the latter
does a lot of caching which I do not need. So I copied the code from
ResourceBundle class where property files are loaded and included it in my
application. The problem is all this thing works if I start orion by java
com.evermind.server.ApplciationServer and does not work in case of java -jar
orion.jar.Is this
because of different classloaders or something
else?The code
is:class MessageResources
{... private static ClassLoader
getLoader() { ClassLoader cl =
MessageResources.class.getClassLoader(); if
(cl == null) {
cl = ClassLoader.getSystemClassLoader();
} return cl;
}private
InputStream loadResourceAsStream(final String resName) {
final ClassLoader loader
= getLoader(); InputStream stream =
(InputStream)java.security.AccessController.doPrivileged(
new java.security.PrivilegedAction() {
public Object run() {
if (loader != null) {
return loader.getSystemResourceAsStream(resName);
} else {
return ClassLoader.getSystemResourceAsStream(resName);
}
}
} );
return
stream; }..}
JBuilder4.0
Hi all, I try to use JB4.0 with to debug apps in Orion, so when I run orion with jdk1.3 (in dubug mode) it just hangs and finally "java commits a system error ... ". With 1.2.2 it works fine! Is it a jdk 1.3 bug or some other issue? P.S. When I run it (not in debug) everything works ok. Egor Savotchkin.
orion classloader?
Hi all,
I needed to load
property files on my own without ResourceBundle class because the latter does a
lot of caching which I do not need. So I copied the code from ResourceBundle
class where property files are loaded and included it in my application. The
problem is all this thing works if I start orion by java
com.evermind.server.ApplciationServer and does not work in case of java -jar
orion.jar.
Is this because of different classloaders or
something else?
The code is:
class MessageResources {
...
private static ClassLoader
getLoader() { ClassLoader cl =
MessageResources.class.getClassLoader();
if (cl == null)
{ cl =
ClassLoader.getSystemClassLoader();
} return cl;
}
private InputStream
loadResourceAsStream(final String resName)
{ final ClassLoader loader =
getLoader(); InputStream stream =
(InputStream)java.security.AccessController.doPrivileged(
new java.security.PrivilegedAction()
{
public Object run()
{
if (loader != null)
{
return
loader.getSystemResourceAsStream(resName);
} else
{
return
ClassLoader.getSystemResourceAsStream(resName);
}
}
}
); return
stream; }
..
}
Re: Shutting down orion
I faced this problem on Solaris (jdk1.3) and "force" method does not work either. java -jar admin.jar ... -shutdown force just hangs... Egor Savotchkin - Original Message - From: "Ismael Blesa Part" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Wednesday, November 08, 2000 7:40 PM Subject: Re: Shutting down orion Yes, I have experienced this on Solaris also. add "force" at the end of line. more information on www.oriosupport.com Jim Crossley wrote: Although I can shutdown orion using the admin.jar with a 1.2 JVM, I've found that I cannot with a 1.3 JVM. The server ceases to accept connections, but its process does not go away. (Running on Redhat/Debian Linux) Anyone else noticed this?
Re: ssl in production
No, I'm using windows' keystore.
- Original Message -
From:
Juan
Lorandi (Chile)
To: Orion-Interest
Sent: Tuesday, October 24, 2000 3:06
AM
Subject: RE: ssl in production
Are you using linux? the linux jvm has some keystore
certificate problems
-Original Message-From: Savotchkin Egor [mailto:[EMAIL PROTECTED]]Sent:
Lunes, 23 de Octubre de 2000 15:23To:
Orion-InterestSubject: ssl in production
I saw the "extended"
ssl -how-to on the orionsupport.com, I followed and it works indeed. I have
a production certificate from thawte, I import it to the keystore
successfully but when I run orion with the keystore containing this real
certificate the server issues: Error listening to SSLServerSocket: "No
available certificate corresponds to the SSL cipher suites which are
enabled". Do you know what does that mean? My test certificates and the real
are almost the same, except that the first has 1024bit-length key, and the
other - 512!
Regards, Savotchkin
Egor.
ssl in production
I saw the "extended" ssl -how-to on the orionsupport.com, I followed and it works indeed. I have a production certificate from thawte, I import it to the keystore successfully but when I run orion with the keystore containing this real certificate the server issues: Error listening to SSLServerSocket: "No available certificate corresponds to the SSL cipher suites which are enabled". Do you know what does that mean? My test certificates and the real are almost the same, except that the first has 1024bit-length key, and the other - 512! Regards, Savotchkin Egor.
unicode parameters[2]
Hi all! I have problem handling unicode strings in the form of %u (from javascript's escape function). Say url is: http://localhost/foo/foo.jsp?param=%u0455p=%0020 in the jsp we have: QueryString=param=%u0455p=%0020 so far so good, but getParameterValues returns: name=p; value=20 name=param; value=455 Which is not correct.Could Orion handle %u unicode strings? Seems its an getParameterValues implementation error! Help!! Egor Savotchkin
unicode parameters
Hi all, I send an encoded (in unicode by some javascript function from IE ) string of parameters to orion server from an applet. Each character of the string is substituted with its unicode value in the form %u, where X is a hex digit on the client side. On the server side request.getQueryString() returns a string where each character like %u00XX is \uXX, which is wrong. Is it an Orion bug? How Java handles such representation of unicode? Egor Savotchkin.
transport-guarantee
Hi all! Could somebody please explain me what this tag is for in Orion? When I set it to CONFIDENTIAL Orion just serves me with a blank page, so how do I use it? I thought I could use it to set up somethink like ssl to only part of my site... is it so? Egor Savotchkin.
Customize login page
Hi all, when FORM authentication is set up and the user tries to access a protected page the login-form appears, I would like to customize this page depending on the page the user is requesting. I tried to get ServletPath and other request parameters from login page, but they are pointing to the login page itself, is it possible in J2EE to know what protected page the user is requesting? Egor Savotchkin.
URGENT! jsp file size limit
Hi all! Orion seems to have jsp file size limit, when my analog of the ScreenDefinitions.jsp from Pet Store grows beyond this limit orion issues: 500 Internal Server Error Error parsing JSP page /visitor/visitor.html Error creating jsp-page instance: java.lang.VerifyError: (class: __jspPage0_template_jsp, method: _jspService signature: (Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletRespo nse;)V) Illegal target of jump or branch Egor Savotchkin
Re: SSL - Only a few pages need SSL, does that slow things down?,
Hi all! I thought this functionality is handled by the user-data-constraintdescriptionno description/descriptiontransport-guaranteeCONFIDENTIAL/transport-guarantee/user-data-constraint but this doesn't seem to work in orion (I posted this problem without reply). Any comments from orion team?Egor Savotchkin.
Orion on ports 1-1023
Hi all, I cannot set up orion server on ports below 1023. I run orion server as ROOT. Scripts on other languages work well on these ports, is it a JDK feature? If so how can I configure JDK to allow java programs to use these ports. Egor Savotchkin
Orion crashes on Solaris
Hi all! Has anyone experienced problems with Orion on Solaris? Sometimes Orion server crashes writing the following in the server console "SIGSEGV 11* segmentation violation si_signo [11]: SIGSEGV 11* segmentation violation " and "SIGBUS 10* bus error si_signo [10]: SIGBUS 10* bus error ". I am using sun jdk 1.2.1 build Solaris_JDK_1_2_1_04c and Orion version 1.1.37? Egor Savotchkin.
protect pages
Hi all, does smdy know how to protect (with SSL) only part of pages in a web app? I only want to protect the "signin" page in the Java Pet Store Demo. Did smdy manage to use CONFIDENTIAL in user-data-constraint element of the web.xml? Thanks in advance, Egor.
CONFIDENTIAL
Hi all! The USER-DATA-CONSTRAINT doesn't seem to work with orion. I tried to set up registration in PetStore Demo to work over SSL by putting CONFIDENTIAL in the given tag. Now when I access ../signin IE5.0 prompts me to download 0-length file "signin". SSL is working ok on my different web-site. Any ideas? web.xml looks like: .. security-constraintweb-resource-collectionweb-resource-nameAuthentication zone/web-resource-namedescriptionno description/descriptionurl-pattern/control/signin/url-patternhttp-methodGET/http-methodhttp-methodPOST/http-method/web-resource-collectionauth-constraintdescriptionno description/descriptionrole-namecustomer/role-namerole-namesubscriber/role-name/auth-constraintuser-data-constraintdescriptionno description/descriptiontransport-guaranteeCONFIDENTIAL/transport-guarantee/user-data-constraint/security-constraint..
Multiple logins
Hi all! Is it possible to set up different login forms for different protected zones. I tried to include login-config tag into security-constraint, but it doesn't work. Any ideas? Savotchkin Egor
dispatch request
Hi all, I try to forward using requestDispatcher from servlet to the jsp page which is protected - the security exception is thrown. Why?? Is it a bug?? I would expect a login page to appear!! Egos Savotchkin.
Storing sessions
Hello Robert, thank you for quick response, unfortunately that did not help. My snippet from orion-web.xml looks like: orion-web-appdeployment-version="1.1.24"development="true"default-charset="windows-1251"jsp-cache-directory="./persistence"temporary-directory="./temp"servlet-webdir="/servlet/"persistence-path="./persistence/state.ser" The orion still doesn't persist sessions :-( Egor Savotchkin.
SSL
Hi all, I have a valid thawte certificate in "Standard Certificate Format". I want to set up an SSL site using Orion. I installed it using: keytool -keystore keystore -keyalg "RSA" -import -trustcacerts -file cboss.cer it was installed properly (no errors were reported). But when I start Orion it says: "No available certificate corresponds to the SSL cipher suites which are enabled.". What does this error mean? Egor Savotchkin
