Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

PLEASE HELP... Weblogic7.0, SQL server 2000, jDriver and Connection Pooling...

2 views

Skip to first unread message

Sujith Mathew

unread,

Oct 23, 2002, 3:06:45 AM10/23/02

Hello

We need help immediately.

We are using Weblogic7.0,SQL server 2000, and jDriver for JDBC. Connection
to database without connection pool, works fine.

When connection pooling is used, the following error occured. The tags we
used in config.xml are also given below. The Sql server authentication is
"SQL and Windows".

We would very gladly appretiate any help given to us.

CONFIG.XML:

<JDBCConnectionPool DriverName="weblogic.jdbc.mssqlserver4.Driver"
Name="sujithpool2" Password="{3DES}4fxPwA1FPnmKYKvpEyKc/A=="
Properties="" Targets="soft"

URL="jdbc:microsoft:sqlserver://soft:1433;User=sujith;Password=sujith123;dat
abaseName=mydatas"
XAPassword="{3DES}4fxPwA1FPnmKYKvpEyKc/A=="/>

ERROR:

####<Oct 23, 2002 12:20:44 PM IST> <Error> <JDBC> <soft> <soft>
<ExecuteThread: '0' for queue: '__weblogic_admin_html_queue'> <kernel
identity> <> <001060> <Cannot startup connection pool "sujithpool2"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection. Severity 14, State 1,
Procedure 'null null', Line 0 Unable to connect, please check your server's
version and availability.
at
weblogic.jdbc.mssqlserver4.TdsStatement.microsoftLogin(TdsStatement.java:282
3)
at
weblogic.jdbc.mssqlserver4.MicrosoftConnection.beginLogin(MicrosoftConnectio
n.java:44)
at weblogic.jdbc.mssqlserver4.TdsConnection.login(TdsConnection.java:59)
at
weblogic.jdbc.mssqlserver4.MicrosoftConnection.login(MicrosoftConnection.jav
a:55)
at
weblogic.jdbc.mssqlserver4.BaseConnection.prepareConnection(BaseConnection.j
ava:181)
at weblogic.jdbc.mssqlserver4.Driver.newConnection(Driver.java:34)
at weblogic.jdbc.mssqlserver4.ConnectDriver.connect(ConnectDriver.java:148)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:201)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:140)
at
weblogic.jdbc.common.internal.ResourceAllocator.makeResources(ResourceAlloca
tor.java:931)
at
weblogic.jdbc.common.internal.ResourceAllocator.finishInit(ResourceAllocator
.java:457)
at
weblogic.jdbc.common.internal.ResourceAllocator.<init>(ResourceAllocator.jav
a:316)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:292
)
at
weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.java:28
2)
at
weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:270
)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:375)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:154)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
.java:732)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
14)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:417)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
mpl.java:926)
at
weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBeans(Confi
gurationMBeanImpl.java:578)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:419)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
mpl.java:926)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
at $Proxy14.addDeployment(Unknown Source)
at
weblogic.management.internal.DynamicMBeanImpl.unprotectedUpdateDeployments(D
ynamicMBeanImpl.java:1774)
at
weblogic.management.internal.DynamicMBeanImpl.access$0(DynamicMBeanImpl.java
:1727)
at
weblogic.management.internal.DynamicMBeanImpl$1.run(DynamicMBeanImpl.java:17
15)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:744)
at
weblogic.management.internal.DynamicMBeanImpl.updateDeployments(DynamicMBean
Impl.java:1711)
at
weblogic.management.internal.DynamicMBeanImpl.setAttribute(DynamicMBeanImpl.
java:1035)
at
weblogic.management.internal.ConfigurationMBeanImpl.setAttribute(Configurati
onMBeanImpl.java:353)
at
com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:135
8)
at
com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:133
3)
at
weblogic.management.internal.RemoteMBeanServerImpl.setAttribute(RemoteMBeanS
erverImpl.java:872)
at
weblogic.management.internal.MBeanProxy.setAttribute(MBeanProxy.java:324)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:193)
at $Proxy82.setTargets(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.console.info.FilteredMBeanAttribute.doSet(FilteredMBeanA
ttribute.java:92)
at
weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(DoEditMB
eanAction.java:145)
at
weblogic.management.console.actions.internal.ActionServlet.doAction(ActionSe
rvlet.java:171)
at
weblogic.management.console.actions.internal.ActionServlet.doPost(ActionServ
let.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:306)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:5412)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:744)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3086)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)

at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:217)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:140)
at
weblogic.jdbc.common.internal.ResourceAllocator.makeResources(ResourceAlloca
tor.java:931)
at
weblogic.jdbc.common.internal.ResourceAllocator.finishInit(ResourceAllocator
.java:457)
at
weblogic.jdbc.common.internal.ResourceAllocator.<init>(ResourceAllocator.jav
a:316)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:292
)
at
weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.java:28
2)
at
weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:270
)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:375)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:154)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
.java:732)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:7
14)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:417)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
mpl.java:926)
at
weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBeans(Confi
gurationMBeanImpl.java:578)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:419)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerI
mpl.java:926)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
at $Proxy14.addDeployment(Unknown Source)
at
weblogic.management.internal.DynamicMBeanImpl.unprotectedUpdateDeployments(D
ynamicMBeanImpl.java:1774)
at
weblogic.management.internal.DynamicMBeanImpl.access$0(DynamicMBeanImpl.java
:1727)
at
weblogic.management.internal.DynamicMBeanImpl$1.run(DynamicMBeanImpl.java:17
15)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:744)
at
weblogic.management.internal.DynamicMBeanImpl.updateDeployments(DynamicMBean
Impl.java:1711)
at
weblogic.management.internal.DynamicMBeanImpl.setAttribute(DynamicMBeanImpl.
java:1035)
at
weblogic.management.internal.ConfigurationMBeanImpl.setAttribute(Configurati
onMBeanImpl.java:353)
at
com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:135
8)
at
com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:133
3)
at
weblogic.management.internal.RemoteMBeanServerImpl.setAttribute(RemoteMBeanS
erverImpl.java:872)
at
weblogic.management.internal.MBeanProxy.setAttribute(MBeanProxy.java:324)
at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:193)
at $Proxy82.setTargets(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.console.info.FilteredMBeanAttribute.doSet(FilteredMBeanA
ttribute.java:92)
at
weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(DoEditMB
eanAction.java:145)
at
weblogic.management.console.actions.internal.ActionServlet.doAction(ActionSe
rvlet.java:171)
at
weblogic.management.console.actions.internal.ActionServlet.doPost(ActionServ
let.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:306)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:5412)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:744)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3086)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
>

Regards
Sujith Mathew

Mitesh Patel

unread,

Oct 23, 2002, 10:51:00 AM10/23/02

to Sujith Mathew

You should have following type of configuration in your config.xml. Please
modify the entries and try again. It should work.

For NON-XA connectionpool:

<JDBCConnectionPool DriverName="weblogic.jdbc.mssqlserver4.Driver"
Name="sujithpool2"

Properties="db=pubs;port=3339;user=sa;password=test;server=sree"
Targets="soft"
URL="jdbc:weblogic:sqlserver4" />

For XA-connectionpool:
You have to use microsoft's SQL server driver:
<JDBCConnectionPool
DriverName="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"
Name="sujithpool2"

Properties="serverName=nc-answline-w2k;url=jdbc:microsoft:sqlserver;dataSourceName=SQL2000JDBC;user=test;databaseName=test;selectMethod=cusrsor;userNamne=test;password=test;portNumber=1435"

Targets="soft"
URL="jdbc:microsoft:sqlserver"

Also, provide initialcapacity, maxcapacity etc. for connection pools as required
by you.

Thanks,
Mitesh

Sujith Mathew

unread,

Oct 23, 2002, 10:04:38 PM10/23/02

Dear Mithesh

I did as you said but i got another error this time.The file weblogic.jar is
already in the classpath.

CONFIG.XML:

<JDBCConnectionPool DriverName="weblogic.jdbc.mssqlserver4.Driver"
Name="sujithpool1" Password="{3DES}4f1PrA3FPnmKY1l0EuKc/A=="

Properties="db=pubs;port=1433;user=sujith;password=sujith123;server=soft"

Targets="soft" URL="jdbc:weblogic:sqlserver4"

XAPassword="{3DES}4f1PrA3FPnmKY1l0EuKc/A=="/>

ERROR:

<Oct 24, 2002 7:28:44 AM IST> <Error> <JDBC> <001060> <Cannot startup
connection
pool "sujithpool1" java.sql.SQLException: No suitable driver>
weblogic.management.DistributedManagementException: Distributed Management
[1 ex
ceptions]
Error creating connection pool
at
weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBean
s(ConfigurationMBeanImpl.java:635)

at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(Configurat
ionMBeanImpl.java:419)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
57)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
25)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBean
ServerImpl.java:926)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)

at $Proxy15.addDeployment(Unknown Source)

at
weblogic.management.internal.DynamicMBeanImpl.unprotectedUpdateDeploy
ments(DynamicMBeanImpl.java:1774)
at
weblogic.management.internal.DynamicMBeanImpl.access$0(DynamicMBeanIm

pl.java:1727)

at
weblogic.management.internal.DynamicMBeanImpl$1.run(DynamicMBeanImpl.
java:1715)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic

eManager.java:744)

at
weblogic.management.internal.DynamicMBeanImpl.updateDeployments(Dynam
icMBeanImpl.java:1711)
at
weblogic.management.internal.DynamicMBeanImpl.setAttribute(DynamicMBe

anImpl.java:1035)

at
weblogic.management.internal.ConfigurationMBeanImpl.setAttribute(Conf
igurationMBeanImpl.java:353)
at
com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.j
ava:1358)
at
com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.j
ava:1333)
at
weblogic.management.internal.RemoteMBeanServerImpl.setAttribute(Remot
eMBeanServerImpl.java:872)
at
weblogic.management.internal.MBeanProxy.setAttribute(MBeanProxy.java:
324)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:193)

at $Proxy12.setTargets(Unknown Source)

at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.console.info.FilteredMBeanAttribute.doSet(Filtere

dMBeanAttribute.java:92)

at
weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(D
oEditMBeanAction.java:145)
at
weblogic.management.console.actions.internal.ActionServlet.doAction(A

ctionServlet.java:171)

at
weblogic.management.console.actions.internal.ActionServlet.doPost(Act
ionServlet.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:306)

at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:5412)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic

eManager.java:744)

at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3086)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm

pl.java:2544)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)

Distributed update exception
- remote object: rrdomain:Location=soft,Name=soft,Type=ServerConfig
- remote server: weblogic.management.internal.RemoteMBeanServerImpl@268bf1
- actionName: addDeployment
- params: [Ljava.lang.Object;@48cc4a
- signature: [Ljava.lang.String;@5c4381
Distributed update exception
- remote object: rrdomain:Location=soft,Name=soft,Type=ServerConfig
- remote server: weblogic.management.internal.RemoteMBeanServerImpl@268bf1
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:244)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.loadDriver(Connect
ionEnvFactory.java:98)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.<init>(ConnectionE
nvFactory.java:127)
at
weblogic.jdbc.common.internal.ConnectionPool.getResourceFactory(Conne
ctionPool.java:343)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.j
ava:282)

s(ConfigurationMBeanImpl.java:578)

at $Proxy15.addDeployment(Unknown Source)

at
weblogic.management.internal.DynamicMBeanImpl.unprotectedUpdateDeploy
ments(DynamicMBeanImpl.java:1774)
at
weblogic.management.internal.DynamicMBeanImpl.access$0(DynamicMBeanIm

pl.java:1727)

at
weblogic.management.internal.DynamicMBeanImpl$1.run(DynamicMBeanImpl.
java:1715)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic

eManager.java:744)

at
weblogic.management.internal.DynamicMBeanImpl.updateDeployments(Dynam
icMBeanImpl.java:1711)
at
weblogic.management.internal.DynamicMBeanImpl.setAttribute(DynamicMBe

anImpl.java:1035)

at $Proxy12.setTargets(Unknown Source)

at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.console.info.FilteredMBeanAttribute.doSet(Filtere

dMBeanAttribute.java:92)

at
weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(D
oEditMBeanAction.java:145)
at
weblogic.management.console.actions.internal.ActionServlet.doAction(A

ctionServlet.java:171)

pl.java:306)

at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:5412)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic

eManager.java:744)

at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3086)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm

pl.java:2544)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)

--------------- nested within: ------------------
weblogic.management.DeploymentException: Error creating connection pool -
with n
ested exception:
[java.sql.SQLException: No suitable driver]
at
weblogic.jdbc.common.internal.JDBCService.addDeploymentx(JDBCService.
java:285)

at
weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.j
ava:270)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(Depl
oymentTarget.java:375)
at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(
Depl

oymentTarget.java:154)

at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMB

eanImpl.java:732)

at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl
.java:714)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(Configurat
ionMBeanImpl.java:417)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
57)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
25)
at
weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBean
ServerImpl.java:926)
at
weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBean

s(ConfigurationMBeanImpl.java:578)

at $Proxy15.addDeployment(Unknown Source)

at
weblogic.management.internal.DynamicMBeanImpl.unprotectedUpdateDeploy
ments(DynamicMBeanImpl.java:1774)
at
weblogic.management.internal.DynamicMBeanImpl.access$0(DynamicMBeanIm

pl.java:1727)

at
weblogic.management.internal.DynamicMBeanImpl$1.run(DynamicMBeanImpl.
java:1715)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic

eManager.java:744)

at
weblogic.management.internal.DynamicMBeanImpl.updateDeployments(Dynam
icMBeanImpl.java:1711)
at
weblogic.management.internal.DynamicMBeanImpl.setAttribute(DynamicMBe

anImpl.java:1035)

at $Proxy12.setTargets(Unknown Source)

at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.console.info.FilteredMBeanAttribute.doSet(Filtere

dMBeanAttribute.java:92)
at
weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(D
oEditMBeanAction.java:145)

I am looking forward eagerly for your kind response.

With Warm Regards
Sujith
"Mitesh Patel" <Mitesh...@bea.com> wrote in message
news:3DB6B75...@bea.com...

Joseph Weinstein

unread,

Oct 23, 2002, 12:51:46 PM10/23/02

to Sujith Mathew

Sujith Mathew wrote:

> Hello
>
> We need help immediately.

Hi. Two things: The URL you specify is for Microsoft's free driver, but
the driver class you specify is our driver. You should decide which one you
want, and use the class and URL for the one driver.
Second, the exception you get says that the user you are trying to log in as,
has not been set up with a DBMS password, to allow DBMS authentication.
It seems the uer property is null. You should define the pool with the property
'user' to be 'sujith'.

Joe

Joseph Weinstein

unread,

Oct 24, 2002, 12:20:06 AM10/24/02

to Sujith Mathew

Sujith Mathew wrote:

> Dear Mithesh
>
> I did as you said but i got another error this time.The file weblogic.jar is
> already in the classpath.
>
> CONFIG.XML:
>
> <JDBCConnectionPool DriverName="weblogic.jdbc.mssqlserver4.Driver"
> Name="sujithpool1" Password="{3DES}4f1PrA3FPnmKY1l0EuKc/A=="
>
> Properties="db=pubs;port=1433;user=sujith;password=sujith123;server=soft"
> Targets="soft" URL="jdbc:weblogic:sqlserver4"

Hi Sujith. The URL you supply isn't exactly correct. It should be "jdbc:weblogic:mssqlserver4"

Joe Weinstein at BEA

Sujith Mathew

unread,

Oct 24, 2002, 4:28:39 AM10/24/02

Dear Mithesh/Joseph,

Thank you for your excellent support . Finally i have done the connection
pooling with errors.. Now the funny part. How do i get the Connection. Is it
sujithpool1.getconnection(); ?

The working server.xml is :
<JDBCConnectionPool
DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
InitialCapacity="3" MaxCapacity="12" Name="sujithpool1"
Password="{3DES}4faJMA3FP0mVY1v0E8Kc/A=="
Properties="db=pubs;user=sujith;password=sujith123"

Targets="soft" URL="jdbc:microsoft:sqlserver://soft:1433"

XAPassword="{3DES}4faJMA3FP0mVY1v0E8Kc/A=="/>
<JTA Name="rrdomain"/>

Thanks in advance
Sujith Mathew

"Joseph Weinstein" <j...@bea.com.remove.this> wrote in message
news:3DB774F5...@bea.com.remove.this...

0 new messages