what is this SAPClassNotFoundException: com.inet.tds.TdsDriver

[Former Member]

Hi,

PLease help me in solving this issue .

SAPClassNotFoundException: com.inet.tds.TdsDriver

THanks,

Soorya

[sunil_singh13 · Accepted solution]

Hi Surya,

This kind of problem occures when there is problem in the connection parameter that we give in JDBC adapter.

So check out your Drivers .

Reward points if Helpful

Thaanks

Sunil Singh

[Former Member · Accepted solution]

Hello Singh,

I have checked the jars under the location,

C:\usr\sap\<enginename><instance-name>\j2ee\cluster\server<n>\bin\ext\com.sap.aii.af.jmsproviderlib.

I have all the required jars like,

msutil.jar,mssqlserver.jar,ojdbc14.jar,msbase.jar which are helpfull in connecting to MS SQL Server 2000 SP4.

Can you please help me out in solving this problem.

THanks,

Soorya

[Former Member · Accepted solution]

Hi Surya,

It looks like you are connecting to database with jdbc2.0 api. Please download the jar Opta.jar from the link below and install it in your XI server. It will work

https://www.inetsoftware.de/scripts/Download2.asp?id=5

Under the Opta_Trial_7.03.zip you will find one jar file named Opta.jar . Install that in your server, the same way you did other jar files.

Thanks

Amit

Reward points if soultion works

[Former Member · Accepted solution]

Hi Amit,

As you have mentioned, I will download this opta.jar. But this is for ,

Known problems

error:

java.sql.SQLException: This driver not include a Transaction Mananager.

at com.inet.tds.DTCDataSource.getConnection(Unknown Source)

cause: You have lookup to DTCDataSource and not to the VisiTranscation DataSource

Is this some thing related to my problem?

PLease give some inputs?

Thanks,

SOorya

[Former Member · Accepted solution]

Hi,

Did you tried this? It will work. Please try it and let me know in case of any other problem

Thanks

Amit

[Former Member · Accepted solution]

Hello Amit,

AS you said,

It looks like you are connecting to database with jdbc2.0 api. Please download the jar Opta.jar from the link below and install it in your XI server. It will work

https://www.inetsoftware.de/scripts/Download2.asp?id=5

Under the Opta_Trial_7.03.zip you will find one jar file named Opta.jar . Install that in your server, the same way you did other jar files.

But the Opta.jar file is not from Microsoft. And it can be used for 90 days only.

Do you have any other solution.

PLease help me out in this regard,

SOorya

[Former Member · Accepted solution]

Hi,

Can you tell me the complete scenario, your jdbc configuration and exactly where and what time you are getting this error so that I cna help you out.

Thanks

amit

[Former Member · Accepted solution]

Hi Amit,

It is a File to JDBC scenario. I am trying to pick some file and parse that file and try to insert some data into the database MS SQL Server2000 SP4. Now when i am trying to connect to this database i am getting the following error,

Error when attempting to get processing resources:

com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to

create new pooled resource: DriverManagerException: Cannot establish

connection to URL 'jdbc:inetdae:localhost?database=sapxi':

SAPClassNotFoundException: com.inet.tds.TdsDriver

Can you please check why i am getting this error?

Thanks,

Soorya

[Former Member · Accepted solution]

Hi,

It is simple file to jdbc scenario. why are you using inetdae driver in the connection url? Use a microsoft jdbc driver. Is there any particular need for using this driver?

Use the following url and driver to connect with sql server and make sure all the required jar files which are required to connect to ms sql server are present.

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

Thanks

Amit

Reward points if answer is useful

[Former Member]

Surya,

Jars might be there. But the class name you are mentioning might be right.

I have seen this behaviour. SO check whether you are referring the right class name.(case sensitive)

[Former Member]

Hello Thomas,

I have checked everything. I can see the SAPClassNotFoundException only in channel monitoring but not in the default trace files. Why it is not reflected in default trace files?

I didnt get your suggestion for checking the class names (with case sensitive)

Can you please help me in solving this issue?

Thanks

Soorya

[Former Member]

Hi,

Actually CLASSNOTFOUND error will come when jar file is missing. The requiredl class is missing.

In this case driver jar files are missing. check the driver present or not what error mentions.

Thanks,

RamuV

[Former Member]

Soorya,

You need to explain your scenario a bit more. What can one understand reading your post?

What are you trying to do? Where do you get this error?

[Former Member]

Hi,

means that the driver is not installed.

Regards

Patrick

[Former Member]

Hello Patrick,

I have checked the jars under the location,

C:\usr\sap\<enginename><instance-name>\j2ee\cluster\server<n>\bin\ext\com.sap.aii.af.jmsproviderlib.

I have all the required jars like,

msutil.jar,mssqlserver.jar,ojdbc14.jar,msbase.jar which are helpfull in connecting to MS SQL Server 2000 SP4.

Can you please help me out in solving this problem.

THanks,

Soorya