Hi,
so how do you get your connections?????
You are doing a lookup on a DataSource Object????
Using Datasource.getConnection is slow???? Is that what you are saying???
access IS AN EXAMPLE. name it as you like, yust make sure both occurences of
access get changed to whatever you need.
Procedure is: you map your db to a resource manager and use the resource
manager in your beans...
AND buy more RAM!!! It'll help heaps. Guess RAM on integrated
Development/Server/Database machines should be 256 MB.
Burkhard
----- Original Message -----
From: "Grobe, Gary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 7:16 PM
Subject: RE: [JBoss-user] dbase is acting way too slow
> 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:[EMAIL PROTECTED]]
> Sent: Friday, July 20, 2001 3:44 AM
> To: [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
