aspose file tools*
The moose likes JBoss/WildFly and the fly likes Problem in getting database connection using Jboss Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Problem in getting database connection using Jboss" Watch "Problem in getting database connection using Jboss" New topic
Author

Problem in getting database connection using Jboss

RajendraKr Kumar
Greenhorn

Joined: Mar 17, 2006
Posts: 6
Hello All,
I am facing some problems while connecting to sybase through Jboss.The sybase version used is 12.5.2.Also i have put the driver jar jconn3.jar in the server/default/lib folder and sysbase-ds.xml in deploy folder. Here is the exception i see on Jboss :


13:28:19,782 WARN [JBossManagedConnectionPool] Throwable while attempting to ge
t a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarning
s chained to this exception for the reason(s).) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:177) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
eateConnectionEventListener(InternalManagedConnectionPool.java:539)

My sybase-ds.xml is like this :



Surprising is that the above does work on other systems but not on mine.What could be the reason?.Any help is highly appreciated.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10266
    
168

Originally posted by RajendraKr Kumar:


13:28:19,782 WARN [JBossManagedConnectionPool] Throwable while attempting to ge
t a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarning
s chained to this exception for the reason(s).) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:177) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
eateConnectionEventListener(InternalManagedConnectionPool.java:539)



The log shows that the exception is thrown from the database server. It mentions that your login failed, are you specifying the correct username and password?


[My Blog] [JavaRanch Journal]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in getting database connection using Jboss