wood burning stoves 2.0*
The moose likes Websphere and the fly likes WSAD 5.1.2 - Database Alias Name or DB name could not be found Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "WSAD 5.1.2 - Database Alias Name or DB name could not be found" Watch "WSAD 5.1.2 - Database Alias Name or DB name could not be found" New topic
Author

WSAD 5.1.2 - Database Alias Name or DB name could not be found

Rob Clawson
Greenhorn

Joined: May 19, 2010
Posts: 2
Just got handed some very old code to do some maintenance on. Using WSAD 5.1.2. I have a couple of data sources defined that work with no problem. When I go to update these to point to a different test server, I get this error (in the Admin console - Test Connection):

Test Connection failed for datasource Data source 1 on server server1 at node localhost with the following exception: java.lang.Exception: com.ibm.db2.jcc.b.nm: [jcc][4038][12241][3.50.152] T2LUW exception: SQL1013N The database alias name or database name "NEW_DB" could not be found. SQLSTATE=42705 ERRORCODE=-1013, SQLSTATE=42705. View JVM logs for further details.

When updating the datasource definition for the new server, here's what I did:

1. Updated Security->JAAS Authentication Entries -> my_entry with new user Id/password
2. Updated Data Source -> DB2 Universal JDBC Driver Provider (XA) -> MyDataSource->Resource Properties
- updated databaseName
- updated serverName
- updated portNumber

I've restarted the server and restarted the IDE, but still get this error. I have verified that the connection information is correct by connecting via DBVisualizer.

I must be missing something that I need to change, but can't figure out what it might be. Any ideas?

Thanks,
Rob
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WSAD 5.1.2 - Database Alias Name or DB name could not be found
 
Similar Threads
Installing Websphere
Datasource JNDI Lookup in WSAD from standalone app
DB2 datasource lookup in WSAD, SQLSTATE=42705
Reg DB2 sample database
WSAD 5.1.0 - JNDI - Resource Ref. Could Not Be Located.