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

4 comments:

Javier said...

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

srjwebsolutions said...


We are leading responsive website designing and development company in Noida.
We are offering mobile friendly responsive website designing, website development, e-commerce website, seo service and sem services in Noida.

Responsive Website Designing Company in Noida
Website Designing Company in Noida
SEO Services in Noida
SMO Services in Noida

EG MEDI said...

Egmedi.com is online medical store pharmacy in laxmi nagar Delhi. You can Order prescription/OTC medicines online.
Cash on Delivery available. Free Home Delivery


Online Pharmacy in Delhi
Buy Online medicine in Delhi
Online Pharmacy in laxmi nagar
Buy Online medicine in laxmi nagar
Onine Medical Store in Delhi
Online Medical store in laxmi nagar
Online medicine store in delhi
online medicine store in laxmi nagar
Purchase Medicine Online
Online Pharmacy India
Online Medical Store


Vikas Chaudhary said...

Battery Mantra is Authorized exide car battery dealer in Noida and Greater Noida. We are providing our service in Indirapuram, Delhi, Ashok Nagar.

Exide Battery Dealer in Noida
Battery Dealer in Noida
Authorized Battery Dealer in Noida
Car Battery Dealer in Noida
Car Battery Dealer
Exide Battery Dealer