Invalid path separator specified in db2.DbLibrary

I was getting this error when i was trying to validate the database driver information that i entered in wkplc_dbtype.properties file by executing ConfigEngine.bat validate-database-driver configuration command.

In my case i am trying to connect to DB2 using the Type 4 driver. In order to do that i did set db2.DBLibrary property like this in wkplc_dbtype.properties file

db2.DbLibrary=/software/IBM/db2jcc.jar;/software/IBM/db2jcc_license_cu.jar




action-validate-database-driver-dbdomain:
Sat May 16 15:07:36 EDT 2009


[sqlproc] action: validate-db-driver
[sqlproc] _________________________________________________________
[sqlproc] DbDomain: release
[sqlproc] Invalid path separator specified in db2.DbLibrary

BUILD FAILED
/software/WebSphere/PortalServer/base/wp.db.impl/config/includes/wp.db.impl_cfg.xml:659: The following error occurred while executing this line:
/software/WebSphere/PortalServer/base/wp.db.impl/config/includes/wp.db.impl_cfg.xml:665: Invalid path separator specified in db2.DbLibrary

Total time: 55 seconds
isIseries currently set to: null
uploading registry
Created admin client: com.ibm.ws.management.AdminClientImpl@6e406e4
Created config Service Proxy: com.ibm.websphere.management.configservice.ConfigServiceProxy@24322432
CELL: spinfotech
Websphere:_Websphere_Config_Data_Type=Registry,_Websphere_Config_Data_Id=cells/spinfotech|registry.xml#Registry_1242441339497,_WEBSPHERE_CONFIG_SESSION=anonymous1242500859524


db2.DbLibrary=/software/IBM/db2jcc.jar;/software/IBM/db2jcc_license_cu.jar


action-validate-database:
Sat May 16 15:17:32 EDT 2009
[echo] domain 'release'
[echo] DbtDbDriver 'com.ibm.db2.jcc.DB2Driver'
[echo] DbtDbLibrary '/software/IBM/db2jcc.jar'
[echo] DbtDbUser 'db2admin'
[echo] DbtDbUrl 'jdbc:db2://dbserver.wpcertification.com:50000/reldb61:returnAlias=0;'
[echo] DbtDbName 'reldb61'
[java] [05/16/09 15:17:35.954 EDT] Attempting to make connection using: jdbc:db2://dbserver.wpcertification.com:50000/reldb61:returnAlias=0; :: db2admin :: PASSWORD_REMOVED
[java] [05/16/09 15:17:36.473 EDT] ERROR: Error obtaining connecting for jdbc:db2://dbserver.wpcertification.com:50000/reldb61:returnAlias=0;
[java] com.ibm.db2.jcc.b.SqlException: No license is present.
[java] at com.ibm.db2.jcc.b.o.d(o.java:563)
[java] at com.ibm.db2.jcc.b.p.(p.java:859)
[java] at com.ibm.db2.jcc.c.b.(b.java:324)
[java] at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:572)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:165)
[java] at com.ibm.wps.config.db.Database.init(Database.java:139)
[java] at com.ibm.wps.config.db.validation.ValidationDriver.main(ValidationDriver.java:209)
[java] Exception in thread "main" com.ibm.db2.jcc.b.SqlException: No license is present.
[java] at com.ibm.db2.jcc.b.o.d(o.java:563)
[java] at com.ibm.db2.jcc.b.p.(p.java:859)
[java] at com.ibm.db2.jcc.c.b.(b.java:324)
[java] at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:572)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:165)
[java] at com.ibm.wps.config.db.Database.init(Database.java:139)
[java] at com.ibm.wps.config.db.validation.ValidationDriver.main(ValidationDriver.java:209)

BUILD FAILED
/software/WebSphere/PortalServer/base/wp.db.impl/config/includes/wp.db.impl_cfg.xml:719: The following error occurred while executing this line:
/software/WebSphere/wp_profile/ConfigEngine/config/actions/dbt_cfg.xml:205: Java returned: 1

Total time: 1 minute 33 seconds
isIseries currently set to: null
uploading registry
Created admin client: com.ibm.ws.management.AdminClientImpl@3f923f92
Created config Service Proxy: com.ibm.websphere.management.configservice.ConfigServiceProxy@49664966
CELL: spinfotech
Websphere:_Websphere_Config_Data_Type=Registry,_Websphere_Config_Data_Id=cells/spinfotech|registry.xml#Registry_1242441339497,_WEBSPHERE_CONFIG_SESSION=anonymous1242501459200


So i had to change the wkplc_dbtype.properties file to take out the ; and the db2jcc_license_cu.jar.

db2.DbLibrary=/software/IBM/db2jcc.jar

With this change i could successfully execute ConfigEngine.bat validate-database-driver command but the ConfigEngine.bat validate-database-connection command started failing. So after executing the validate-database-driver we have to revert back to the original version of wkplc_dbtype.properties

1 comment:

Javier said...

If you are installing it under any Unix system type, you should use : instead of ;