Petstore aka estore
Hello,
I am trying to install/deploy the PetStore application as a proof of
concept. I was able to deploy it - partially. The backend database is
MS-SQLServer and I have setup a third_party driver (Merant) to support the
connections (Type4). According to documentation, this is the only
third-party JDBC driver supported for MSSQLServer for iPlanet. I have
tested the driver and it works just fine.
I followed the directions provided with estore but everytime I make a
request to the database, I get an ODBC (?) error message:
HTML:Error: 500 SC_INTERNAL_SERVER_ERROR
Stdout:
[21/Jun/2001 15:21:50:0] error: ODBC-083: could not load the library
<db2cli.dll> configured in the registry for the driver <256>
[21/Jun/2001 15:21:50:0] warning: ODBC-002: ODBC-002: DriverConnect:
(IM002): [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified (DB Error: 0)
[21/Jun/2001 15:21:50:0] warning: ODBC-027: CreateConn: failed to create
connection [new connection]:
DSN=jdbc/EstoreDataSource,DB=estore,USER=estore,PASS=xxxxxx
[21/Jun/2001 15:21:50:0] error: DATA-108: failed to create a data connection
with any of specified drivers java.sql.SQLException: failed to create a data
connection with any of specified drivers at
com.netscape.server.jdbc.Driver.afterVerify(Unknown Source)
I have turned off access to all of the other drivers from the iAS
Adminsitrator Tool (Data Access Drivers are all unchecked). I have also
checked that the DAE3 driver contains the third party classname and path to
the Merant driver. At appears to be going to the DAE2 driver for 256 which
is the db2cli.dll. I have re-booted and re-deployed several times, with no
luck.
Any help is greatly appreciated.
S. Hobeck
[1928 byte] By [
] at [2007-11-25 4:48:49]
> Hi,
>It seems you have not registered the data sources. For that you need to
> create three xml files, namely,
> EstoreDB-merant-type4.xml,
> InventoryDB-merant-type4.xml,
> SignOnDB-merant-type4.xml.
>
>Please refer to these xml files for merant below. Then you can register
> merant driver and the
> datasources by using "resreg" or "iasdeploy" command. You do not need to
> redeploy the entire
> petstore application once it is deployed. Just register datasources and
> restart the server. Then
> simply run the application.
>
> EstoreDB-merant-type4.xml
>
> <ias-resource>
> <resource>
><jndi-name>jdbc/estore/EstoreDB</jndi-name>
><jdbc>
><database>master</database>
><datasource>master</datasource>
><username>Administrator</username>
><password>devsupport</password >
> <database-url>jdbc:sequelink://sti
> g:19996;databaseName=master;HUser=Administrator;HPassword=devsupport</databa se-url>
>
> <driver-type>SequeDriver</driver-type>
></jdbc>
> </resource>
> </ias-resource>
>
> InventoryDB-merant-type4.xml
>
> <ias-resource>
> <resource>
><jndi-name>jdbc/estore/InventoryDB</jndi-name>
><jdbc>
>
><database>master</database>
><datasource>master</datasource>
><username>Administrator</username>
><password>devsupport</password >
> <database-url>jdbc:sequelink://sti
> g:19996;databaseName=master;HUser=Administrator;HPassword=devsupport</databa se-url>
>
> <driver-type>SequeDriver</driver-type>
> </jdbc>
> </resource>
> </ias-resource>
>
> SignOnDB-merant-type4.xml
>
> <ias-resource>
> <resource>
><jndi-name>jdbc/estore/SignOnDataSource</jndi-name>
><jdbc>
><database>master</database>
><datasource>master</datasource>
><username>Administrator</username>
><password>devsupport</password >
> <database-url>jdbc:sequelink://sti
> g:19996;databaseName=master;HUser=Administrator;HPassword=devsupport</databa se-url>
>
> <driver-type>SequeDriver</driver-type>
></jdbc>
> </resource>
> </ias-resource>
>
> Simply change database, datasource, username, password, database-url,
> driver-type according to
>
> your settings. It should work fine.
>
> Thanks,
> Rakesh
> dev-support.
>
>
> "S. Hobeck" wrote:
>
>Hello,
>
>I am trying to install/deploy the PetStore application as a proof of
>concept. I was able to deploy it - partially. The backend database is
>MS-SQLServer and I have setup a third_party driver (Merant) to support the
>connections (Type4). According to documentation, this is the only
>third-party JDBC driver supported for MSSQLServer for iPlanet. I have
>tested the driver and it works just fine.
>
>I followed the directions provided with estore but everytime I make a
>request to the database, I get an ODBC (?) error message:
>
>HTML:Error: 500 SC_INTERNAL_SERVER_ERROR
>
>Stdout:
>[21/Jun/2001 15:21:50:0] error: ODBC-083: could not load the library
><db2cli.dll> configured in the registry for the driver <256>
>[21/Jun/2001 15:21:50:0] warning: ODBC-002: ODBC-002: DriverConnect:
>(IM002): [Microsoft][ODBC Driver Manager] Data source name not found and no
>default driver specified (DB Error: 0)
>[21/Jun/2001 15:21:50:0] warning: ODBC-027: CreateConn: failed to create
>connection [new connection]:
>DSN=jdbc/EstoreDataSource,DB=estore,USER=estore,PASS=xxxxxx
>[21/Jun/2001 15:21:50:0] error: DATA-108: failed to create a data connection
>
>with any of specified drivers java.sql.SQLException: failed to create a data
>
>connection with any of specified drivers at
>com.netscape.server.jdbc.Driver.afterVerify(Unknown Source)
>
>I have turned off access to all of the other drivers from the iAS
>Adminsitrator Tool (Data Access Drivers are all unchecked). I have also
>checked that the DAE3 driver contains the third party classname and path to
>the Merant driver. At appears to be going to the DAE2 driver for 256 which
>is the db2cli.dll. I have re-booted and re-deployed several times, with no
>luck.
>
>Any help is greatly appreciated.
>
>S. Hobeck
>
>
>
>
at 2007-6-29 8:53:54 >
