From: Grobe, G. <Gar...@bm...> - 2001-07-20 17:16:41
|
I don't want to use an Oracle URL for a Postgresql DB. I'm wanting to know why the URL's ppl have suggested to me are a bit different than mine and maybe if I'm leaving something out. I can connect w/ the URL this URL from servlets: "jdbc:postgresql:acais" But now that I've learned w/ app-servers/jboss you don't make the connections like that, I'm using a DataSource. I don't get any errors or exceptions of any kind. But I know my queries shouldn't be this slow. 10-20 secs per query and I'm using a test dbase w/ like 10 records in it. So as was mentioned in a previous e-mail, I don't think the connection pooling is yet being used and/or conf'd correctly. I've posted the server output before. I get no errors or exceptions. I'm running on an AMD450 w/ 128Mb. I've had a slower configuration of this same application work in subsecond times on this same box w/ other app servers. So something is still wrong w/ my configuration. -----Original Message----- From: Burkhard Vogel [mailto:Bur...@we...] Sent: Friday, July 20, 2001 3:44 AM To: jbo...@li... Subject: Re: [JBoss-user] dbase is acting way too slow Hi, why do you want to use an oracle url for a postgresql DB??? If you can connect with the url you specified: > <attribute name="URL">jdbc:postgresql:acais://localhost:5432</attribute> this is fine! what is the exception you get during startup? NPE? do you see your driver is loaded by the JDBC provider? What in't working if you use the above URL? Burkhard ----- Original Message ----- From: "G.L. Grobe" <ga...@gr...> To: <jbo...@li...> Sent: Friday, July 20, 2001 10:38 AM Subject: Re: [JBoss-user] dbase is acting way too slow > Since I still don't seem to be connecting to the pool, still working on > this. > > What should the <attribute name="URL"> ... of the jboss.jcml file be. I > don't understand the url parts. Chptr 3 says it's the JDBC URL used to > connect to the data source. When making my own connections, it used to be: > > "jdbc:postgresql:acais" where 'acais' is my database name. So I have ... > <attribute name="URL">jdbc:postgresql:acais://localhost:5432</attribute> > > Then I saw this example as was suggested. > > <attribute name="URL">jdbc:oracle:thin:@pluto:1521:servsoft</attribute> > > 1. // or @ (actually tried both ways, same results, slow) > 2. what's the servsoft after the port #. > > Also, from an example that was sent ... what is 'access' in the res-name > below, where'd that come from. > --------------------------------- > <resource-managers> > <resource-manager > res-class="org.jboss.ejb.deployment.JDBCResource"> > <res-name>jdbc/access</res-name> > <res-jndi-name>java:/MyDB</res-jndi-name> > </resource-manager> > </resource-managers> > > <enterprise-beans> > <entity> > <ejb-name>MyBean</ejb-name> > <jndi-name>my/MyBeanHome</jndi-name> > <configuration-name></configuration-name> > <resource-ref> > <res-ref-name>jdbc/MyDB</res-ref-name> > <resource-name>jdbc/access</resource-name> > </resource-ref> > </entity> > </enterprise-beans> > > > > _______________________________________________ > JBoss-user mailing list > JBo...@li... > http://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list JBo...@li... http://lists.sourceforge.net/lists/listinfo/jboss-user |