Re: jetty transport-guarantee behavior?
Hi David, On Mon, Jan 30, 2006 at 03:35:52PM -0800, David Jencks wrote: On the other hand I couldn't convince myself that the spec required a redirect. I agree - sending a 403 appears to be spec-compliant. Sending a redirect also appears to meet the spec and is way more user- and developer-friendly, though. At the moment I've got a filter that builds an HTTPS URL and redirects the request but this requires turning the transport guarantee off, so that the filter can do its job. It's a workaround but an auto-redirect from Jetty would be great. Maybe a greg or another jetty expert can explain how it is supposed to work? That would be cool. Thanks, Toby
Re: AW: AW: Geronimo CMP update statements
Dan, Michael, Thanks for having reported this problem. This issue has just been fixed and should be shipped as part of 1.0.1. In a few words, by default an UPDATE statement is dynamically generated each time that a CMP needs to be persisted. This statement only updates the modified fields. We are still providing the static generation strategy; this can be enabled at the CMP level via the static-sql element. Thanks, Gianny Ueberbach, Michael wrote: Hello Matt, yes, this works. Thanks for the hint. I think geronimo sends a statement like this one to the database UPDATE table SET col1 = CASE WHEN false THEN null ELSE col1 END, col2 = CASE WHEN true THEN newValue ELSE col1 END, ... and Oracle does not know how to handle the boolean values true and false, so they have to be replaced by some expressions like 1=1 or 1=0. (This way I can reproduce the situation) Nevertheless I think this behaviour should be modified not only for the reason of wrongly fired triggers but also to reduce the transportation load. regards Michael -Ursprüngliche Nachricht- Von: Matt Hogstrom [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 26. Januar 2006 17:22 An: user@geronimo.apache.org Betreff: Re: AW: Geronimo CMP update statements Michael, Add the following lines in your plan: !-- For Oracle database users uncomment the following line. ejb-ql-compiler-factoryorg.tranql.ejbqlcompiler.OracleQLCompilerFactory/ejb-ql-compiler-factory db-syntax-factoryorg.tranql.sql.oracle.OracleDBSyntaxFactory/db-syntax-factory -- These go after the cmp-connection factory. Let me know if this fixes the problem. Ueberbach, Michael wrote: Hello, I think there is another problem concerning this issue. Using an Oracle database (9i) I get this error when updating a cmr- field: (...) Caused by: org.tranql.ql.QueryException: Error executing statement: UPDATE konto SET erzeugt = CASE WHEN ? THEN ? ELSE erzeugt END, bankname = CASE WHEN ? THEN ? ELSE bankname END, bankleitzahl = CASE WHEN ? THEN ? ELSE bankleitzahl END, kontonummer = CASE WHEN ? THEN ? ELSE kontonummer END, kontostand = CASE WHEN ? THEN ? ELSE kontostand END, fk_person = CASE WHEN ? THEN ? ELSE fk_person END WHERE guid = ? (...) Caused by: java.sql.SQLException: ORA-00920: invalid relational operator This not the case when using MySQL. regards Michael -Ursprüngliche Nachricht- Von: Gianny Damour [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 26. Januar 2006 13:16 An: user@geronimo.apache.org Betreff: Re: Geronimo CMP update statements Hi Dan, At the beginning, I was not seeing this as an issue. Based on your remark that triggers are wrongly fired, I now see this as an issue that needs to be fixed. Could you please raise a JIRA for this problem? Thanks, Gianny Daniel John Debrunner wrote: At ApacheConUS 2005 I talked with Matt Hogstrom about the SQL UPDATE statements Geronimo was issuing against Derby for DayTrader. A single UPDATE statement is generated for a table that updates all columns using a CASE statement to ensure un-modified columns are not changed, or in reality changed to the same value. An example is described in GERONIMO-1080, the syntax may be a little different for Derby. http://issues.apache.org/jira/browse/GERONIMO-1080 I see two issues with this approach, one is that for Derby this is inefficient, and two, and probably more important, all SQL update triggers will fire due to this modification of all columns. Thus if an application defines a trigger on update of the address column of a customer table, then when using Geronimo this trigger will fire, even if the CMP application is only updating the customer's balance. This just seems the wrong semantics to me. Matt had said this was a known issue, and that it was going to be fixed. The comments in GERONIMO-1080 seem to indicate that this may not be seen as an issue, though those comments are dated before ApacheCon. I searched Jira and couldn't see any bug for changing this, are there any plans to address this? Thanks, Dan.
Re: Geronimo Eclipse Plugin doesn't start web app
Thanks for the video, thats a first! :) I haven't tried to reproduce yet, but the first thing I noticed is your target runtime is set for Tomcat, not geronimo. WTP may be preventing the client from launching because of this. Try switching your target runtime from Tomcat to Geronimo. (Also your JRE should be set to 1.4.2). Then try again. - sachin On Jan 31, 2006, at 7:55 AM, Edson Carlos Ericksson Richter wrote:I don't have much more info. I produced attached SWF to show what I'm doing.(I expect mail list dont drop it).WTPProblem.swf
Re: Geronimo Eclipse Plugin doesn't start web app
I take my answer back. It works. But I am running against developer daily builds. Are you on WTP 1.0 or 1.0.1 drivers? - sachin On Jan 31, 2006, at 9:18 AM, Sachin Patel wrote:Thanks for the video, thats a first! :) I haven't tried to reproduce yet, but the first thing I noticed is your target runtime is set for Tomcat, not geronimo. WTP may be preventing the client from launching because of this. Try switching your target runtime from Tomcat to Geronimo. (Also your JRE should be set to 1.4.2). Then try again. - sachin On Jan 31, 2006, at 7:55 AM, Edson Carlos Ericksson Richter wrote:I don't have much more info. I produced attached SWF to show what I'm doing.(I expect mail list dont drop it).WTPProblem.swf
Re: How to connect to LDAP server on Geronimo from an LDAP client?
Hi Phani,
opening a JIRA will provide a way to keep track on this issue. You will have to register to *CREATE
A NEW ISSUE*. Pls explain in detail the environment and problem and how to implement your workaround.
Here is the link for the JIRAs
http://issues.apache.org/jira/browse/GERONIMO
I'll keep playing with the password hashing as I am still not having consistent
results.
Cheers!
Hernan
Phani Madgula wrote:
Hi Hernan/Aaron
I developed a small application that uses pure programmatic security
login, using Nescape Java LDAP SDK.
When I store password in MD5/SHA, I applied corresponding hashing on
password sent by user and compared with the passoword retrieved from the
LDAP server. To know how the password is stored in LDAP, we can check
for prefix {md5} for MD5, and {sha} for SHA.
The following is the code snippet
String uname = req.getParameter(userName);
String password = req.getParameter(password);
boolean loginSucceed = false;
String hashMethod = PLAIN;
String hashedPassword = password;
String ldapPassword = getLdapPassword(uname); //Retrieve password
from LDAP for the user
if(ldapPassword.startsWith({md5})){
hashMethod = MD5;
}else if(ldapPassword.startsWith ({sha})){
hashMethod = SHA;
}
if(hashMethod.equals(SHA)){
hashedPassword = getSHAHashedPassword(password);
}else if(hashMethod.equals(MD5)){
hashedPassword = getMD5HashedPassword(password);
}
System.out.println(AuthenticateServlet:service:hashedPassword:+hashedPassword);
System.out.println(AuthenticateServlet:service:ldapPassword:+ldapPassword);
if(hashedPassword.equals (ldapPassword))loginSucceed=true;
.
So, with programmatic login, we can solve the problem. I guess hashing
is not part of specification. With declarative security management, I
guess, current application login implementation must consider MD5/SHA also.
If the above points are valid, we can have a JIRA on this..?
Thanks
phani
On 1/27/06, *Phani Madgula* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Hi Hernan/Aaron
The following is the export of my LDAP entries. I could export using
JXplorer. I also used another LDAP client called LDAP Browser/Editor
2.8.2.
In the below LDAP export, there are two users balaji1, balaji2 whose
passwords are MD5 hashed.
Where as for other users, the passwords are stored PLAIN. So, with
balaji1/balaji2, I am getting Userid/password wrong message in the
browser while authenticating.
I am trying to find the answers for Aaron's questions. I will update
soon.
version: 1
dn: ou=system
objectClass: organizationalUnit
objectClass: top
ou: system
userPassword:: e21kNX1JU012S1hwWHBhZERpVW9PU29BZnd3PT0=
dn: uid=admin,ou=system
objectClass: inetOrgPerson
objectClass: organizationalPerson
objectClass: person
objectClass: top
cn: system administrator
displayName: Directory Superuser
sn: administrator
uid: admin
userPassword:: c2VjcmV0
dn: ou=users,ou=system
objectClass: organizationalUnit
objectClass: top
ou: users
dn: uid=system,ou=users,ou=system
objectclass: inetOrgPerson
objectclass: organizationalPerson
objectclass: person
objectclass: top
cn: John Doe
facsimiletelephonenumber: +1 408 555 5556
givenname: John
l: Las Vegas
mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
ou: People
ou: Human Resources
roomnumber: 4613
sn: Doe
telephonenumber: +1 408 555
uid: system
userPassword:: bWFuYWdlcg==
dn: uid=user1,ou=users,ou=system
objectclass: inetOrgPerson
objectclass: organizationalPerson
objectclass: person
objectclass: top
cn: User
facsimiletelephonenumber: +1 408 555 5556
givenname: User1
l: Las Vegas
mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
ou: People
ou: Human Resources
roomnumber: 4613
sn: One
telephonenumber: +1 408 555
uid: user1
userPassword:: dXNlcjE=
dn: uid=user2,ou=users,ou=system
objectclass: inetOrgPerson
objectclass: organizationalPerson
objectclass: person
objectclass: top
cn: User
facsimiletelephonenumber: +1 408 555 5556
givenname: User2
l: Las Vegas
mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
ou: People
ou: Human Resources
roomnumber: 4613
sn: Two
telephonenumber: +1 408 555
uid: user2
userPassword:: dXNlcjI=
dn: uid=admin,ou=users,ou=system
objectClass: top
objectClass: person
objectClass: organizationalPerson
objectClass: inetOrgPerson
cn: admin
sn: admin
uid: admin
userPassword:: YWRtaW4=
dn: uid=user3,ou=users,ou=system
objectClass: top
objectClass: person
objectClass: organizationalPerson
objectClass: inetOrgPerson
cn: user3
sn: user3
uid: user3
userPassword::
RE: Geronimo Eclipse Plugin doesn't start web app
I'm using latest WTP M200601251151 and geronimo/eclipse/unstable/20060127-1410 I think this is WTP 1.0.1, but I don't know (web site doesn't tell much more! This release isn't even annouced as oficial). Ok, I changed runtime and now I get following problems: Required library cannot denote external folder: 'C:\pgm\geronimo-1.0\repository\org.apache.geronimo.specs\jars' for project GT2006 and The project cannot be built until build path errors are resolved So, now I can't even run the project. Geronimo is 1.0 installed at c:\pgm\geronimo-1.0\ folder, and is geronimo+jetty binary distro. Thanks again, Richter
Re: Geronimo Eclipse Plugin doesn't start web app
I think that M build has a defect regarding applying the Geronimo runtime, that has been recently fixed. I'll keep my eye out for the problem. In the meantime once a new 1.0.1 M driver is released (but I think 1.0.1 will be due out in about a week), try again. - sachin On Jan 31, 2006, at 11:25 AM, Edson Carlos Ericksson Richter wrote:I'm using latest WTP M200601251151 and geronimo/eclipse/unstable/20060127-1410I think this is WTP 1.0.1, but I don't know (web site doesn't tell much more! This release isn't even annouced as oficial).Ok, I changed runtime and now I get following problems:Required library cannot denote external folder: 'C:\pgm\geronimo-1.0\repository\org.apache.geronimo.specs\jars' for project GT2006andThe project cannot be built until build path errors are resolvedSo, now I can't even run the project. Geronimo is 1.0 installed at c:\pgm\geronimo-1.0\ folder, and is "geronimo+jetty" binary distro.Thanks again,Richter
MAIL LIST PROBLEMS
Is only me, or nobody else is receiving messages from the list? Richter
Re: Geronimo, first experiences, compile, install, run
Steve, Thanks for the feedback! Could you raise Jira's for your two suggestions? They'll be less likely to be forgotten... --kevan On Jan 31, 2006, at 12:29 PM, Steve Whitlatch wrote: My thanks to Erik Daughtrey and Christopher Chan for the responses. I got a succefful compile using jdk 1.4. The other problem I was having logging into the administration console application (HTTP Status 408) I solved by allowing cookies in FireFox. Minor suggestions: 1) In the BUILDING.txt file included in the geronimo source tar ball, include a statement as to what JDK is needed, what version, etc. 2) In Geronimo's administration console application, adjust its behavior so that rather than dispalying an HTTP Status 408 error message, it displays a message stating that for the application to work properly cookies must be enabled (that is, if that is actually the case). Thank you very much to all the developers who made Geronimo-1. It's great. Steve Whitlatch
Re: deploying EJB with CMR
Hallo,
I localized that the error is caused by call
PortableRemoteObject.narrow(aReference, UnitLocalHome.class);
Anyway, UnitLocalHome.class executes without exception so it is somewhere
in PortableRemoteObject.narrow.
I got different exception on my page when accessed first time fter server
restart. It mentions CORBA Initialization - IMO,
the problem is that I use JRE 1.5 instead of 1.4 version. I will prefer to stay
with JDK1.5 and don't need CORBA.
Geronimo 1.0-M5 runs fine for me without it.
Is there a way to disable CORBA infrastructure - what modules should be
uninstalled for that? I can test to deploy there
afterwards.
Regards, Milan.
Aaron Mulder wrote / napísal(a):
I don't know a ton about Tapestry, but can you figure out what the
actual problem is? I see two possibilities:
org.apache.hivemind.ApplicationRuntimeException
Unable to read OGNL expression 'parsed OGNL expression' of
[EMAIL PROTECTED]/OrganizationHome]: allUnits
component: [EMAIL PROTECTED]/OrganizationHome]
location: context:/organization/OrganizationHome.html
That's one -- I don't know what that means, what OGNL expression it
might be trying to parse and so on.
ognl.OgnlException
allUnits
java.lang.NoClassDefFoundError -
That's another -- what class is not found? Is it ognl.OgnlException
that is not found or is that part of the previous problem? What JAR
is the missing class in and how is it being loaded?
Thanks,
Aaron
On 1/30/06, Milan Unger [EMAIL PROTECTED] wrote:
I broke all my ejb-relation so that it contains just single
ejb-relationship-role (except for many-to-many relationship) and now
it deploys, thanks.
Anyway, when I access tapestry page that references ejb local interface
there is an exception -- see below -- which does not occur on M5
release. I retried to deploy new openejb-jar.xml on M5 but that has no
effect - it still run fine there.
Both war and EJB jar are part of the same ear application.
The exception is reported by tapestry - I was not able to configure
logging on geronimo to get more detailed info:
org.apache.hivemind.ApplicationRuntimeException
Unable to read OGNL expression 'parsed OGNL expression' of
[EMAIL PROTECTED]/OrganizationHome]: allUnits
component: [EMAIL PROTECTED]/OrganizationHome]
location: context:/organization/OrganizationHome.html
ognl.OgnlException
allUnits
java.lang.NoClassDefFoundError -
Stack Trace:
*
sk.moolab.coordinator.pages.organization.OrganizationHome.getUnitHome(OrganizationHome.java:76)
*
sk.moolab.coordinator.pages.organization.OrganizationHome.getAllUnits(OrganizationHome.java:49)
* sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
*
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
*
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
* java.lang.reflect.Method.invoke(Method.java:585)
* ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:491)
* ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:904)
*
ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:54)
*
ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:122)
OrganizationHome.java (tapestry page component) around line 76 -- the
reference seems to be O.K., the code works fine on M5 release:
private UnitLocalHome getUnitHome()
throws NamingException, FinderException, Exception {
try {
InitialContext aContext = new InitialContext();
Object aReference =
aContext.lookup(java:comp/env/ejb/UnitLocalHome);
UnitLocalHome aHome = (UnitLocalHome)
PortableRemoteObject.narrow(aReference, UnitLocalHome.class);
return aHome;
} catch (Exception anException) {
log.warn(Cannot create a UnitHome, anException);
throw anException;
}
}
---
Aaron Mulder
Fri, 27 Jan 2006 07:42:50 -0800
When you have a one-to-many relationship, you only need mapping
information for one ejb-relationship-role in your openejb-jar.xml.
I'm not sure if that's causing the problem, but can you remove one of
the two and try that? See example 12.8 at
http://chariotsolutions.com/geronimo/ejb-structure.html#id2612837
Thanks,
Aaron
On 1/27/06, Milan Unger [EMAIL PROTECTED] wrote:
Hi,
I'm trying to deploy ear application with EJBs on Geronimo-1.0. The same
application deploys without a problem on Geronimo-1.0M5. After
transforming dependency format and parentIds for Geronimo 1.0 release I
still got following error from the deployer:
Target TransactionBean does not have foreign key attribute
transactionid.
Bellow are some snippets from openejb-jar.xml. Do you know a reason for
this problem?
Regards, Milan.
Re: Need help with db2jcc_license_cu jar file deployment
Hi Prakash,
I'm working on a document for configuring DB2 in Geronimo. I'll post the link here in the dev list
once I have it finished (probably by tomorrow)
Cheers!
Hernan
[EMAIL PROTECTED] wrote:
Hello,
I am very new to Geronimo, have installed Geronimo-Tomcat-J2EE-1.0 just
last week on my Window-XP to evaluate it. I have DB2 UDB Workgroup
server 8.2 running on another Windows server within my LAN and I am
trying to add a database pool for this DB2 using Geronimo Web Console.
I could successfully add the two jar files db2jcc.jar and
db2jcc_license_cu.jar to the Geronimo repository and they are now under
...\geronimo-1.0\repository\db2\jars but renamed as db2jcc-8.2.jar and
db2jcc_license_cu-8.2.jar respectively since I specified their version
as 8.2. They are listed as db2/db2jcc/8.2/jar and
db2/db2jcc_license_cu/8.2/jar respectively under the Current Repository
Entries.
While adding the new database pool, I can successfully step through
until the Test Connection which fails trying to find the appropriate
license file db2jcc_license_cu.jar. Below is the error message:
==
com.ibm.db2.jcc.b.SqlException: The version of the IBM Universal JDBC
driver in use is not licensed for connectivity to DB2 for Unix/Windows
databases. To connect to this DB2 server, please obtain a licensed copy
of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate
license file db2jcc_license_*.jar for this target platform must be
installed to the application classpath. Connectivity to DB2 for
Unix/Windows databases is enabled by any of the following license files:
{ db2jcc_license_cu.jar, db2jcc_license_cisuz.jar }
at com.ibm.db2.jcc.b.o.db(o.java:3103)
at com.ibm.db2.jcc.b.o.cb(o.java:3049)
at com.ibm.db2.jcc.a.b.cb(b.java:629)
at com.ibm.db2.jcc.a.b.init(b.java:306)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.attemptConnect(DatabasePoolPortlet.java:797)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:321)
...
...
...
===
The DB2 license file name is expected to be db2jcc_license_cu.jar, but
the Web Console renames it to db2jcc_license_cu-8.2.jar due to its jar
file naming rules.
I have seen a posting by Mr. Young Skim ([EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]) on 01/12/2006 seeking help on the same
problem and I have tried one of the solutions posted by Mr. Matt
Hogstrom i.e. add dependency to these jar files to the application's
deployment plan. It did not work, may be because I am not sure exactly
to which xml file, I should add this.
Please help me!
Thanks a lot!
Prakash
Re: MAIL LIST PROBLEMS
I got both your msgs. See if your mail server is treating the msgs from the list as spam and dumping them in a Spam or Bulk folder. Cheers Prasad On 1/31/06, Edson Carlos Ericksson Richter [EMAIL PROTECTED] wrote: Is only me, or nobody else is receiving messages from the list? Richter
Re: Need help with db2jcc_license_cu jar file deployment
Prakash,
Here is the setup I am currently using.
I added the DB2 jars to my repository as follows:
[EMAIL PROTECTED]:~/geronimo-1.0/repository/com.ibm.db2/jars ls -al
total 1233
drwxr-xr-x 3 hogstrom users 200 2006-01-31 14:02 .
drwxr-xr-x 3 hogstrom users 72 2006-01-11 09:15 ..
-rw-r--r-- 1 hogstrom users 1249462 2006-01-11 09:16 db2jcc-10.1.jar
-rwxr-xr-x 1 hogstrom users2063 2006-01-11 09:17
db2jcc_license_cisuz-10.1.jar
-rwxr-xr-x 1 hogstrom users1013 2006-01-11 09:17 db2jcc_license_cu-10.1.jar
Ignore the version, I think I was using the Derby version number for some reason
but these are from a DB2 UDB V8 distro.
I added the following lines to my application plan. This is for the DataSource
definition:
ext-module
connectorTradeDataSource/connector
external-pathtranql/tranql-connector-db2-xa/1.0/rar/external-path
connector
xmlns=http://geronimo.apache.org/xml/ns/j2ee/connector;
configId=TradeDataSource
parentId=org/apache/geronimo/Server
dependency
uricom.ibm.db2/db2jcc/10.1/jar/uri
/dependency
dependency
uricom.ibm.db2/db2jcc_license_cisuz/10.1/jar/uri
/dependency
dependency
uricom.ibm.db2/db2jcc_license_cu/10.1/jar/uri
/dependency
I see you do not refer to the cusiz license (and I don't know what it is) :)
Try this out.
[EMAIL PROTECTED] wrote:
Hello,
I am very new to Geronimo, have installed Geronimo-Tomcat-J2EE-1.0 just last
week on my Window-XP to evaluate it. I have DB2 UDB Workgroup server 8.2 running
on another Windows server within my LAN and I am trying to add a database pool
for this DB2 using Geronimo Web Console.
I could successfully add the two jar files db2jcc.jar and db2jcc_license_cu.jar
to the Geronimo repository and they are now under
...\geronimo-1.0\repository\db2\jars but renamed as db2jcc-8.2.jar and
db2jcc_license_cu-8.2.jar respectively since I specified their version as 8.2.
They are listed as db2/db2jcc/8.2/jar and db2/db2jcc_license_cu/8.2/jar
respectively under the Current Repository Entries.
While adding the new database pool, I can successfully step through until the
Test Connection which fails trying to find the appropriate license file
db2jcc_license_cu.jar. Below is the error message:
==
com.ibm.db2.jcc.b.SqlException: The version of the IBM Universal JDBC driver in
use is not licensed for connectivity to DB2 for Unix/Windows databases. To
connect to this DB2 server, please obtain a licensed copy of the IBM DB2
Universal Driver for JDBC and SQLJ. An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application classpath. Connectivity to DB2 for Unix/Windows databases is
enabled by any of the following license files: { db2jcc_license_cu.jar,
db2jcc_license_cisuz.jar }
at com.ibm.db2.jcc.b.o.db(o.java:3103)
at com.ibm.db2.jcc.b.o.cb(o.java:3049)
at com.ibm.db2.jcc.a.b.cb(b.java:629)
at com.ibm.db2.jcc.a.b.init(b.java:306)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.attemptConnect(DatabasePoolPortlet.java:797)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:321)
...
...
...
===
The DB2 license file name is expected to be db2jcc_license_cu.jar, but the Web
Console renames it to db2jcc_license_cu-8.2.jar due to its jar file naming rules.
I have seen a posting by Mr. Young Skim ([EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]) on 01/12/2006 seeking help on the same problem and I
have tried one of the solutions posted by Mr. Matt Hogstrom i.e. add
dependency to these jar files to the application's deployment plan. It did not
work, may be because I am not sure exactly to which xml file, I should add this.
Please help me!
Thanks a lot!
Prakash
Documentation update - was [ Need help with db2jcc_license_cu jar file deployment]
Hi All,
here is an article on how to configure DB2 (or any other DB needing more than
one jar file)
http://opensource2.atlassian.com/confluence/oss/display/GERONIMO/Configuring+DB2+Datasource
Cheers!
Hernan
[EMAIL PROTECTED] wrote:
Hello,
I am very new to Geronimo, have installed Geronimo-Tomcat-J2EE-1.0 just
last week on my Window-XP to evaluate it. I have DB2 UDB Workgroup
server 8.2 running on another Windows server within my LAN and I am
trying to add a database pool for this DB2 using Geronimo Web Console.
I could successfully add the two jar files db2jcc.jar and
db2jcc_license_cu.jar to the Geronimo repository and they are now under
...\geronimo-1.0\repository\db2\jars but renamed as db2jcc-8.2.jar and
db2jcc_license_cu-8.2.jar respectively since I specified their version
as 8.2. They are listed as db2/db2jcc/8.2/jar and
db2/db2jcc_license_cu/8.2/jar respectively under the Current Repository
Entries.
While adding the new database pool, I can successfully step through
until the Test Connection which fails trying to find the appropriate
license file db2jcc_license_cu.jar. Below is the error message:
==
com.ibm.db2.jcc.b.SqlException: The version of the IBM Universal JDBC
driver in use is not licensed for connectivity to DB2 for Unix/Windows
databases. To connect to this DB2 server, please obtain a licensed copy
of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate
license file db2jcc_license_*.jar for this target platform must be
installed to the application classpath. Connectivity to DB2 for
Unix/Windows databases is enabled by any of the following license files:
{ db2jcc_license_cu.jar, db2jcc_license_cisuz.jar }
at com.ibm.db2.jcc.b.o.db(o.java:3103)
at com.ibm.db2.jcc.b.o.cb(o.java:3049)
at com.ibm.db2.jcc.a.b.cb(b.java:629)
at com.ibm.db2.jcc.a.b.init(b.java:306)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.attemptConnect(DatabasePoolPortlet.java:797)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:321)
...
...
...
===
The DB2 license file name is expected to be db2jcc_license_cu.jar, but
the Web Console renames it to db2jcc_license_cu-8.2.jar due to its jar
file naming rules.
I have seen a posting by Mr. Young Skim ([EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]) on 01/12/2006 seeking help on the same
problem and I have tried one of the solutions posted by Mr. Matt
Hogstrom i.e. add dependency to these jar files to the application's
deployment plan. It did not work, may be because I am not sure exactly
to which xml file, I should add this.
Please help me!
Thanks a lot!
Prakash
