Reed Peters

Ranch Hand
+ Follow
since Jul 23, 2002
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Reed Peters

I have encountered this problem several times! Please someone is there a way to recover the list of applications without rebuilding the entire server? HELP!!!
18 years ago
I got the answer for this in another forum. Here it is...

When you create a meet-in-the-middle mapping between the cmp bean and the table you can use the schema name 'NULLID'.
Then WAS omits a schema name and the default schema name or the schema set by the property SQLID of the datasource is used.

FYI
19 years ago
You might try right-clicking in the package explorer paine at the top project level and selecting the "Refreash" option. Then exit the client normally and restart and see if that helps.
19 years ago
On the menu bar at the top click on Help option the select Help Contents option. This pops up a new window that is in a sence the "help perspective".
19 years ago
Resource references are in the project's web.xml file (in WEB-INF). Double click on it to bring up the editor, click on references tab at the bottom. On references screen click on resources tab at the top.
19 years ago
I reinstalled v5.0 but not for the same reason...
19 years ago
I got this before when I turned off automatic commitment and then ended the program before specifically excuting a commit.
19 years ago
Hi, I hope someone can give me a clue on how to make the schema name that a table exists in a configurable item during deployment of the EJB to the WAS server. I have two environments, a test environment and a live environment, and I don't want to have to re-map the RDB to EJB mappings to move from one environment to the other, just to change the schema name. Both environments have their own WAS v5 server with a DB2 (iSeries) datasource defined with CMP, but the datasource's default schema name is not being "respected", and the tables accessed by the EJBs are always the ones I used to do the RDB to EJB maping (the test environment). If anyone has any suggestions, I would sure appreciate it.

Thanks,
19 years ago
There is tons of information on how to expose legacy backend systems via web services, but I can't find any information on how to make legacy backend system be consumers of web services. Maybe you can help. We have an RPG application that runs on an iSeries box (AS400). Periodically it wakes up and wants to send some data out to an external application via that external application web service interface. What archecture should I use to faciliate this? Should the web service java proxy and supporting java classes run in the AS400's native JVM and utilize a sockets or dataqueue interface to the backend RPG application? Or, is there some way to have a sockets host server java class running in the WebSphere Application Server's JVM listening for backend RPG socket connections. Once made, the java class contacts the web service via the proxy as usual. If this latter is the case, how to I instantiate the java sockets listener in the web container of WAS. It's not a servlet it's just a class...
Any ideas?
Thanks
19 years ago
I am getting a ClassNotFoundException on the DB2 native driver and can not for the life of me figure out why. If you are familiar with running Java programs on an iSeries (AS400), not in WebSphere AS but in QShell, I sure wish you would help. Below you will find my environment variable setting for classpath (WRKENVVAR), followed by the QShell display echoing the classpath and running the java program "JavaApp1". After that the Java program is listed.
Thanks, Reed Peters
--------------------------------
Environment Variable CLASSPATH
--------------------------------
Display Environment Var (*JOB)
Name . . . . . . . . . : CLASSPATH
Value . . . . . . . . . : '.:/QIBM/ProdData/Java400/:/QIBM/ProdData/OS400/Java400/ext/jdbc2_0-stdext.jar:/QIBM/ProdData/OS400/Java400/ext/db2_classes.jar'
------------------------------
QShell Display - Showing error
------------------------------
STRQSH
$
echo $CLASSPATH

.:/QIBM/ProdData/Java400/:/QIBM/ProdData/OS400/Java400/ext/jdbc2_0-stdext.jar:/QIBM/ProdData/OS400/Java400/ext/db2_classes.jar
$
java JavaApp1
Pgm Version: C
Statement: Class.forName(com.ibm.db2.jdbc.app.DB2Driver)
Exception occured Step 1!
Message: com/ibm/db2/jdbc/app/DB2Driver
java.lang.ClassNotFoundException: com/ibm/db2/jdbc/app/DB2Driver java/lang/Throwable.<init>(Ljava/lang/String V+4 (Throwable.java:90)
java/lang/Exception.<init>(Ljava/lang/String V+1 (Exception.java:38)
java/lang/ClassNotFoundException.<init>(Ljava/lang/String V+1 (ClassNotFoundException.java:65)
java/lang/Class.forName(Ljava/lang/String Ljava/lang/Class;+5 (Class.java:121)
JavaApp1.main([Ljava/lang/String V+18 (JavaApp1.java:21)
Statement: DriverManager.registerDriver(new com.ibm.db2.jdbc.app.DB2Driver())

java.lang.NoClassDefFoundError: com/ibm/db2/jdbc/app/DB2Driver java/lang/Throwable.<init>(Ljava/lang/String V+4 (Throwable.java:90)
java/lang/Error.<init>(Ljava/lang/String V+1 (Error.java:46)
java/lang/NoClassDefFoundError.<init>(Ljava/lang/String V+1 (NoClassDefFoundError.java:43)
JavaApp1.main([Ljava/lang/String V+73 (JavaApp1.java:30)
$
---------------------------------
Java Code:
---------------------------------
public class JavaApp1 {
public static void main(String[] args) {
Connection con = null;

System.out.println("Pgm Version: C");
System.out.println("Statement: Class.forName(com.ibm.db2.jdbc.app.DB2Driver)");
try {
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
} catch (Exception e) {
System.out.println("Exception occured Step 1!");
System.out.println("Message: " + e.getMessage());
e.printStackTrace();
}
System.out.println("Statement: DriverManager.registerDriver(new com.ibm.db2.jdbc.app.DB2Driver())");
try {
DriverManager.registerDriver(new com.ibm.db2.jdbc.app.DB2Driver());
} catch (Exception e) {
System.out.println("Exception occured Step 2!");
System.out.println("Message: " + e.getMessage());
e.printStackTrace();
}
try {
con = DriverManager.getConnection("jdbc b2://localhost", "user", "password");
} catch (Exception e) {
System.out.println("Exception occured Step 3!");
System.out.println("Message: " + e.getMessage());
e.printStackTrace();
}
try {
if (con instanceof com.ibm.db2.jdbc.app.DB2Connection)
System.out.println("con is running under the native JDBC driver.");
} catch (Exception e) {
System.out.println("Exception occured Step 4!");
System.out.println("Message: " + e.getMessage());
e.printStackTrace();
}
try {
con.close();
} catch (Exception e) {
System.out.println("Exception occured Step 5!");
System.out.println("Message: " + e.getMessage());
e.printStackTrace();
}
}
}
I am getting these messages when I try to connect to a datasource in the WSAD v5 test server environment. The connection fails. Anybody have any ideas what these mean?
[5/27/03 13:40:20:453 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'receiveBufferSize'.
[5/27/03 13:40:20:469 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'soTimeout'.
[5/27/03 13:40:20:469 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'tcpNoDelay'.
[5/27/03 13:40:20:469 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'soLinger'.
[5/27/03 13:40:20:469 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'loginTimeout'.
[5/27/03 13:40:20:484 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'serverTraceCategories'.
[5/27/03 13:40:20:484 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'sendBufferSize'.
[5/27/03 13:40:20:484 PDT] 6eebcec8 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'keepAlive'.
[5/27/03 13:40:20:594 PDT] 6eebcec8 ConnectionFac I J2CA0107I: Component-managed authentication alias not specified for connection factory or datasource Data source 1.
20 years ago
I know a "feature" is that all files that you open are visible in every perspective that you switch to. Personally, I prefer the way v4 worked: the files you open are only open in the perspective that you originally opened them in. Is there anyway to make v5 act like v4 in this case?
I want to know too! I liked v4 in this aspect.
20 years ago
Hello,
I am trying to setup the data source to connect to an iSeries DB2 database in the WebSphere Development Studio Client (WDSC) v5. I have converted my Servlets to v2.3 (J2EE 1.3) and am trying to determine the proper data source settings for the v5 test environment server. My settings for WDSC v4 were:
JDBC driver List:
(Name) AS400JDBCDriver
(Desc) blanks
(Imple) com.ibm.as400.access.AS400JDBCConnectionPoolDataSource
(URL) jdbc b2
(Class) c:/ � /jt400.jar
Data Source:
(Name) AS400DataSource
(JNDI) jdbc/cmas400
(Desc) blanks
(Category) blanks
(Database) cmas400/cmas400
Resource Property
(Name) serverName
(Type) java.lang.String
(Value) cmas400
In my servlet the code to get the connection is:
Properties parms = new Properties();
parms.put(Context.INITIAL_CONTEXT_FACTORY,
"com.ibm.websphere.naming.WsnInitialContextFactory");
Context context = new InitialContext(parms);
DataSource ds = (DataSource) context.lookup("jdbc/cmas400");
connection = ds.getConnection("<userid>", "<password>");
In WDSC v4 this worked fine, but I can�t determine the proper settings in WDSC v5 to make it work. The execution of the below statement
DataSource ds = (DataSource) context.lookup("jdbc/cmas400");
Results in the below error in the server log: (HELP!)
[5/23/03 9:44:48:906 PDT] 144d8f38 ConnectionFac I J2CA0122I: Resource reference jdbc/cmas400 could not be located, so default values of the following are used: [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[5/23/03 9:44:49:375 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'soTimeout'.
[5/23/03 9:44:49:391 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'cursorSensitivity'.
[5/23/03 9:44:49:391 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'soLinger'.
[5/23/03 9:44:49:391 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'behaviorOverride'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'receiveBufferSize'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'serverTraceCategories'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'savePasswordWhenSerialized'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'tcpNoDelay'.
[5/23/03 9:44:49:406 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'sendBufferSize'.
[5/23/03 9:44:49:422 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'keepAlive'.
[5/23/03 9:44:49:422 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'loginTimeout'.
[5/23/03 9:44:49:422 PDT] 144d8f38 DSConfigurati W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: property not found for com.ibm.as400.access.AS400JDBCConnectionPoolDataSource: 'extendedMetaData'.
[5/23/03 9:44:49:516 PDT] 144d8f38 ConnectionFac I J2CA0107I: Component-managed authentication alias not specified for connection factory or datasource AS400DataSource.
Thanks for your help in advance!
[ May 23, 2003: Message edited by: Reed Peters ]
[ May 27, 2003: Message edited by: Reed Peters ]
20 years ago