Getting WSG Adapter Error when creating Select Table Adapter

[jdefan78]

Friends,

We are using Web Services Gateway for integration between JDE and web site. Previousely we were using SQL Server 2000 database. Recently our company has upgraded it to SQL Server 2005. We have placed SQL Server jdbc jar file in to Integration Server/ lib / Jars directory.

Now we are having issue to create new Select Table adapter service. When we create Select Table Adapter, table columns not displaying in to adapter. Instead of it shows "Specs not found" in column name.

Is anybody familiar with this type of issue. Your valuable help will really appreciated. We are stucking very badly.

 

[eewon]

Try changing the SQL Server JDBC driver DataSource class setting in the Configuration Editor Connection Properties to:

com.microsoft.sqlserver.jdbc.SQLServerDataSource

As well as new jar files, the JDBC class names changed going from SQL Server 2000 to 2005.

Dave

 

[jdefan78]

Thanks Dave for your reply.

We have placed SQLJDBC.jar file in Integrationser\lib\jars directory as well as change the property in Adapter setting as well. However our problem remain as it is.

We have got another recommndation from that we need to upgrade our EnterPriseOne Adapter to 8.98 because our JDE OneWorld toolset release is 8.98.4. What is your suggestion regarding this.

 

[eewon]

Not sure what release your E1 Adaptor is currently on. However, I believe support for WSG and SQL Server 2005 started from Tools Release 8.97.

Dave

 

[jdefan78]

Our Enterprise One Adapter version is 8.97. Our present WSG services which are hosted on DV,PY and PD servers are working fine. We have issue with WSG Developer only. From WSG developer we can not create Select / Insert table adapter after our upgrade to SQL Server 2005, however we can create business function adapter.