Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Application & Integration Servers >> Application Servers

Error using mySQL connection Pool

I see the following error when my application uses the connection pool - can anyone explain this ?

INFO: CORE3282: stdout: =======================>ERROR :com.sun.enterprise.repository.J2EEResourceException

WARNING: CORE3283: stderr:at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

WARNING: CORE3283: stderr:at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

WARNING: CORE3283: stderr:at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

INFO: CORE3282: stdout: java.lang.NoSuchMethodException: setdataSourceName

[729 byte] By [705485] at [2007-11-25 8:43:15]
«« Triying to set up Rational Rose with Sun One Studio or Forte J 4.0
»» User password change
# 1
I guess the connection pool has been created with incorrect values.You can validate the connection pool created by you using the dbping tool found at http://developer.iplanet.com/tech/tools/dbping_overview.jsp
Amol desai at 2007-7-1 15:23:19 > top of Java-index,Application & Integration Servers,Application Servers...
# 2
Also, can you provide the pool params, ie the pool definition from server.xml
nsegura at 2007-7-1 15:23:19 > top of Java-index,Application & Integration Servers,Application Servers...
# 3

Hi,

You have used dataSourceName property while creating a connection pool.This property is not required to be set while creating a connection pool for MySql

Use the following properties:

<property name="serverName" value="<name of server>"

><property name="port" value="<port number>"

><property name="DatabaseName" value="<your db name>"

><property name="User" value="<user name>"

><property name="Password" value="<passwd>"

Get back in case of any issues

>

Amol desai at 2007-7-1 15:23:19 > top of Java-index,Application & Integration Servers,Application Servers...
# 4

> Hi,

>

> You have used dataSourceName property while creating

> a connection pool.This property is not required to be

> set while creating a connection pool for MySql

thank you, Amol!

I had the same problem with SunAS 7 / MS SQL Server (I use jDTS driver)

Pegas at 2007-7-1 15:23:19 > top of Java-index,Application & Integration Servers,Application Servers...
Application & Integration Servers
Application Servers

Application & Integration Servers New Topic

Application & Integration Servers Hot Topic

Application & Integration Servers

All Classified