invoking Ejbean for getting DB Connection Object

[sameer_inn]

Hello
i have a ejbean that return a Connection object using Datasource.

i am invoking the bean method from normal java client but it's throwing exception

java.lang.reflect.UndeclaredThrowableException: java.io.NotSerializableException: org.jboss.resource.adapter.j
dbc.local.LocalConnection
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)
at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:138)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:108)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:111)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
at $Proxy1.getDBConnection(Unknown Source)
at DBConnectionClient.main(DBConnectionClient.java:26)
Exception: null


could u tell me how to get DBConnection Object from Ejbean to client

thanx

[adrian.brock]

That is correct db connections are not
serializable and so cannot be used outside the VM

This is why entity beans were invented.

Regards,
Adrian

[juhalindfors]

you cannot serialize connections to clients

[sameer_inn]

Thank for ur reply

actually i am having a client application which run
independent of Application Server

my client application connect to application server
and perform various operation including it will
lookup for the datasource and perform many
database operations

as it's working fine in weblogic for datasource lookup from client and it does not work in jboss
so i thougt of writiing a bean for connection
and getting the connection object to the clinet
now that's also doesn't support


can u tell me what's the best way to deal with the current situation

thanx

[juhalindfors]

Write a server side component (a stateless session bean for instance) that does your lookups and connection handling and acts as a facade to your client.

[sameer_inn]

sorry for troubling u again
actaully

i want my client to perform all database operation
independently without any serverside component
my client need to talk directly to the database.

my ejbean should just return a datasource to the client then the client get's connections and do
db operations directly...

do u have any solution for this.

sameer