[JBoss-user] [JCA/JBoss] - Re: Jboss - MS SQLSERVER2000 configuration problem
Hi,
Here is the Datasource definition we are using to connect to a MS-SQLServer 2000 from
a Linux Jboss server:
(replace jndi name and properties values with your own...)
jdbc/DSNAME
jdbc:microsoft:sqlserver://DBSERVER:;ServerName=DBSERVER;PortNumber=;DatabaseName=DBNAME;User=DBUSER;Password=DBUSERPWD;SelectMethod=cursor
com.microsoft.jdbc.sqlserver.SQLServerDriver
DBUSER
DBUSERPWD
50
5
50
15
false
Here is also a piece of code:
Context context = new InitialContext();
Object ref_ms = context.lookup("java:/jdbc/DSNAME");
DataSource ds_ms =
(DataSource) PortableRemoteObject.narrow(ref_ms,
DataSource.class);
connection_ms = ds_ms.getConnection();
...
prepStmt = connection_ms.prepareStatement(DbRequest);
rs = prepStmt.executeQuery();
...
rs.close();
prepStmt.close();
connection_ms.close();
...
hope this will help you ;-)
Br,
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845745#3845745
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845745
---
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Dramatic SQL response time moving from jboss 3.0.6 to 3.
Hi, We finally found the trick ;-) It was due to a misconfiguration in the DataSource definition (pointing to a wrong server :-( ). Sorry for that thread!!! By the way, during our tests we discovered that the JTDS driver were 15 to 20 % faster that M$ one. We do recomend the p5spy profiler. Easy to use and efficient. Thanks Adrian for your help. Best Regards, View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845736#3845736 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845736 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Dramatic SQL response time moving from jboss 3.0.6 to 3.
OK, We are making the same tests using p6spy SQL Profiler v.0.3. By the way, is there any difference between v3.0.6 and 3.2.5 that could explain our problem? REM: with both versions, I made the tests using the default config. and both are using the same database located on a remote server. Br, Marc View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845610#3845610 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845610 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: Dramatic SQL response time moving from jboss 3.0.6 to 3.
Hi, (I'm working with Damien, alias DaffyDuck) I made some complementary tests. Withe a simple ejb using a datasource on both JBoss 3.0.6 and 3.2.5, I found the following results (average time executing the same request 25 times) jboss 3.0.6 ~70 ms jboss 3.2.5 ~ 1000 ms !!! I added some debug to my code and here are my results: Executed CODE ms JBOSS 3.0.6 BEGIN - PreparedStatement END - PreparedStatement 0 BEGIN - executeQuery END - executeQuery 0,031 BEGIN - WHILE (loop on resultset) END - WHILE 0,037 BEGIN - RESULTSET.CLOSE END - RESULTSET.CLOSE 0 BEGIN - PREPSTMT.CLOSE END - PREPSTMT.CLOSE 0,001 BEGIN - RS.CLOSE END - RS.CLOSE0 JBOSS 3.2.5 BEGIN - PreparedStatement END - PreparedStatement 0 BEGIN - executeQuery END - executeQuery 0,307 BEGIN - WHILE (loop on resultset) END - WHILE 0,722 BEGIN - RESULTSET.CLOSE END - RESULTSET.CLOSE 0,033 BEGIN - PREPSTMT.CLOSE END - PREPSTMT.CLOSE 0 BEGIN - RS.CLOSE END - RS.CLOSE 0 As you can see, it's the executeQuery execution time that is x10 and the loop on the resultset (rs.next()) execution time that is x20. Additional information: we do have the same kind of results with a different driver (jtds instead of M$). Any sugestion or track to continue our investigations. Br, Marc. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845601#3845601 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845601 --- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
