JDBC Adapter 601 [Archive]

nathen

03-24-2003, 12:40

Docs for the webMethods JDBC Adapter 6.0.1 can be found on Advantage under Bookshelf -> Adapters -> JDBC or by logging into

http://advantage.webmethods.com/cgi-bin/advantage/main.jsp?targChanId=-536883003

If it does not show up when you run the webMethods Installer, you may need to contact keymaster@webmethods.com.

meetgv

04-02-2003, 10:23

While you are installing, please make sure JDBC Adapter is selected for installation.

This is the one of the default adapter component which installs with the V6.0.

Please go to the webMethods6\IntegrationServer\Packages\WmJDBCAdapter\doc to look at the JDBC Adapter documentation after Installation.

raviusd

04-02-2003, 16:34

Hi Luis,

If the JDBC adapter is installed, go to IS and then

Adapters --> JDBC Adapter

If you dont see this option

Go to Packages --> Management and then look for the WmJDBCAdapter package, check whether this is enabled or not.

If you could not do none of the above, while the software installing in the very first window (you might have missed selecting the following option)
IntegrationPlatforms --> Adapters --> webMethods JDBC Adapter

venkat

04-03-2003, 16:17

i have the jdbc adapter, i have oracle installed on the system where the Webmethods is running, Now what will be the driver name??? i kept Oracle,seems weird but please help me out, and when it asks for the URL name what should i give i.e for example the database is in c://data/users.dbf
Please help me out

Venkateswara. R. Garikapati

05-14-2003, 09:26

Please refer the following Configuration values, which are working for me to connect to Oracle......

Connection Type JDBC Adapter Connection
Package Name - JDBCTestServices
Connection Properties
Transaction Type - LOCAL_TRANSACTION
DataSource Class - oracle.jdbc.pool.OracleDataSource
serverName - Give Your machine name, where Oracle Installed
user - scott
password - ******
databaseName - ORCL or SID
portNumber - if default 1521 or give the port number where
TNS Listener is.
networkProtocol - leave blank

Other Properties - driverType=thin

Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 100000
Expire Timeout (msec) 100000

Thanks,
-GV

binwu

05-16-2003, 13:29

I installed JDBC adapter 6.0.1 on wm6.0.1 IS. Created a JDBC connection (LOCAL_TRANSACTION), and a simple JDBC adapter service. I tried to use explicit transaction.

my flow looks like this:
...
pub.art.transaction:startTransaction
<jdbc>
pub.art.transaction:commitTransaction
...

I got error in startTransaction. On the console I saw this error message:
2003-05-16 15:28:04 EDT [ISS.0015.9998E] Exception --> com.wm.pkg.art.error.DetailedServiceException: [ART.117.4036] Adapter Runtime (Adapter Service): Unable to rollback transaction. Transaction state:Transaction is active .

Implicit transaction works fine.

Any idea?

Thanks,

Bin Wu

udays

05-18-2003, 14:42

Bin Wu,

Just want to make sure..have you given the transaction name in the Start Transaction and are you using the same transaction name for your commit and rollback?.

I used to get similar error and after giving the transaction name this error was gone.

Uday

Sharath (Unregistered Guest)

05-21-2003, 16:01

How to configure the JDBC Adapter for SQL Server 2000. Has anybody tried this before?.

I am seeing a problem while using the DataDirect SQL Server JDBC driver, available in the lib folder of the IS601.

I see an error "Unable to configure manager, JDBC DataSource Class name "com.ddtek.jdbcx.sqlserver.SQLServerDataSource" cannnot be found while trying to enable the JDBC Adapter configuration.

Thanks
SS

Pradeep

06-12-2003, 13:52

Sharath:

Check JDBC driver jar file is in IS CLASSPATH.

you can see classpath in Administrator screen "About".

gonzo

07-11-2003, 05:38

Hi,

I'm getting this Error when trying to use a notification stored procedure on a Sybase datasource: "[stored procedure name] may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode."

Anyone have any idea on the cause and solution for this issue?
I'm using LOCAL_TRANSACTION as the transaction type for the JDBC Connection!

Best Regards,
Gonçalo Santos

chatton

07-13-2003, 19:12

You can use sp_proxmode to set the stored procedure to 'anymode'.
Refer to http://webforums.sybase.com/nntp/nd000041.nsf/0/24528f5ab1e39456df8abdc18bd599cf?OpenDocument for more help info.

gonzo

07-22-2003, 09:21

Hi,

I'm implementing a notification to retrive values from a stored procedure in
a sybase 12 Database.
This is a migration project from an early version of webmethods 3.1 with
standard DB Adapters.

The problem I get is that, within the stored procedures' workflow, some
temporary system tables are created and some insert and updates to other
tables are done.
This creates an error in the JDBC Adapter with a LOCAL_TRANSACTION
connection.

I have to use LOCAL_TRANSACTION to ensure the processing.

I've tried to commit the transaction at the begining of the workflow service
that reports to the Document Type Reference of the notification, and start
transaction at the end of it. The error persists.

Can anybody help?

Best regards,

Gonçalo Santos

narenthota

07-25-2003, 06:30

Hi,

I am using webMethods 6.0.1,Sybase SQL Anywhere Studio 8.0.2 and JConnect 5.5 JDBC Driver. In the documents no where webmethods mentioned that webMethods 6.0.1 supports Sybase. I am able to Connect to the Sybase Server 12.5 using the WmDB Package.Through services it is working fine.

I am trying to configure the JDBC Adapter to connect Sybase Server.
I am getting the following error while enabling the Connection.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SybaseFolder:Test.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource".
JZ0S3: The inherited method getConnection() cannot be used in this subclass.

Can anyone tell, what would be the problem?

Thanks in Advance.
Thota

srdzak

07-29-2003, 18:25

Thota,

The JDBC Adapter 6.0.1 only supports Oracle and SQL Server databases at this time. Your working connection through the WmDB services is the only way to go at this time.

Steve

narenthota

08-19-2003, 04:25

Hi Steve,

Since WmDB package was deprecated, my client doesn't want to use the same. I got the info from webMethods support team that they will support Sybase in the next quarter.

Cheers,
Thota

vijayj76

11-05-2003, 12:57

Did any of you encountered such an error while creatign a service under the XATransaction mode,

enlist failed: oracle.jdbc.xa.OracleXAException OracleSQLError = [-1] OracleError = [65535] XAError = [-3]

Any help is appreciated.
Thank you in advance

-Vijay

imateos

01-13-2004, 04:32

Hi all,

I'm a WebMethods newbie and I'm trying to configure a JDBC Connection to an Orable DB. And after editing all parameters I'm obtaining the next error:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Connection:TestConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
com/ddtek/jdbc/extensions/ExtEmbeddedConnection

This is the configuration I'm using:

Transaction Type : LOCAL_TRANSACTION
DataSource Class : oracle.jdbc.pool.OracleDataSource
Other Properties : driverType = thin

I've also tried the "oracle.jdbc.pool.OracleConnectionPoolDataSource" class, but I obtained the same error.

Does anyone knows what I'm doing wrong?

Thanks in advance,

Ignasi

zygmunt

01-14-2004, 02:14

Hi Jin

Check for the right data source class. It have to be:

com.microsoft.jdbcx.sqlserver.SQLServerDataSource

woody

01-14-2004, 17:11

Hi, Zygmunt,

Thanks for the response.
I am using the right data source class just as you mentioned. Even tried other data sources such as com.microsoft.jdbc.sqlserver.SQLServer and etc. neither of them worked. well, the JDBC adapter works perfectly ok with oracle database. the reason why I am trying MS SQL database is one of my customers is experiencing such difficulty. So I tried to reproduce it here. I double-checked the docs from both webMethods (JDBC adapter) and Microsoft (JDBC Driver for MS SQL2000) to ensure all the steps are completed.

BTW, I downloaded the JDBC driver for MS SQL2000 and SP1 from microsoft. Hope there'd be nothing wrong with the driver itself.

any thoughts on what could cause such problem?

Cheers,

Jin

raymoser

01-14-2004, 18:48

Make sure your jars are in the classpath for webMethods. To do this, click on the "ABOUT" link on the webMethods Integration Server Admin Console.

If the three jars are listed, then they are in your classpath, if not, then put them in your <server_root>/lib/jars/.

Restart the server and then you will see them.

HTH

Ray

woody

01-14-2004, 23:01

Yes, they are in classpath. every piece of the config is in place according to webmethods and Microsoft. also, loaded MSSQL SP2 and MSSQL2000 for JDBC Driver SP2. Well, the result is the same,

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource wmtraining.JDBCAdapter.Services:wmtraining.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/DataSource

there must be something else I am missing.

any help would be much appreciated.

cheers,

Jin

zygmunt

01-15-2004, 03:06

The error appear when you try to enable the connection. Did I'm right???
I'm using MS SQL Server 2000 with the JDBC driver
SP1 Version 2.2.0029 from December 2002
and I have no problems. I can't reproduce the error on my side.
The massage looks strange. Normally when you provide a wrong data source or DB name you will get an additional line which begins with the error number and gives you a better description about what's wrong.

For example I get this error when DB name is wrong:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource D106Exercises.adapters:D106Adapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.jdbcx.sqlserver.SQLServerDataSource".
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Die in der Anmeldung 'WebMethods' angeforderte Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung.

(it's a German DB)
OR this when the data source is wrong:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource D106Exercises.adapters:D106Adapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class "com.microsoft.jdbcx.sqlserver.SQLS" cannot be located.
com.microsoft.jdbcx.sqlserver.SQLS.class not found

As you see the first 2 lines are always the same. I think you have definitely a problem with the driver or something around that.
What we can do is...
I give you a mail with the driver that I have and we will see what happens.

cheers
Zygmunt

woody

01-15-2004, 16:48

Zygmunt,

Thanks a lot for the comments. I am thinking more or less the same thing. Whenever I tried to enable the JDBC connection, it did take some time to process and you got the feeling IS was trying to negotiate with MSSQL2000 but eventually failed. Either it's due to the SQL2000 for JDBC driver or the configuration of my machine since I have quite some applications running on this PC, e.g. Siebel, MSSQL2000, SAP R/3 Java Client, and some other Java applications.

If you can email the driver to me, I shall try it on a clean machine and see how it goes. My feeling is it'll work.

Thanks,

Jin
PS: my email address is jwang_98_1998@yahoo.com

imateos

01-21-2004, 03:52

Hi all,

I've configured a JDBC Connection with JDBC Adapter. It all seems to work, as I enabled it. But when I try to execute an adapter service that uses this connection it doesn't seem to work. In fact, what it happens is that it keeps "running" for hours. I've tried to see what going on by looking at the audit, but all I can see is that this service has started and yet not finished.

Does anyone have any idea what it's happening? Any idea how to determinate? By the way, how can I activate the wmMonitor?

thanks in advance,

Ignasi

imateos

01-21-2004, 10:38

Hi all, again

It's obvious I'm a newbie in the world of WebMethods. Sorry.

I've realized that when I execute for the every first time my adapter service (JDBC adapter) it all works fine, but whenever I try to execute it later, it fails (in fact, what it happens is that keeps in state "running" for hours).

Does anyone have any idea what's going on ?

thanks in advance,

Ignasi

imateos

01-21-2004, 10:48

AnilKumar

01-21-2004, 13:41

Hi folks,

I have problem in enabling JDBC Adapter. The following error was been thrown

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource folder:DBConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleDataSource".
[wm-cjdbc32-0014][Oracle JDBC Driver]Error establishing socket. Connection refused

I really appreciate your help and suggestions

Thanks

anil_ga

01-21-2004, 13:43

imateos

01-22-2004, 02:50

Hi all,

I think I've finally been able to determinate what's going wrong with my JDBC adapter service. The tables where I'm trying to insert don't have primary key (instead of this, a unique index is used). If I insert a record and then erase it, when afterwards I try to insert again the same record my service generates an infinite loop, and doesn't seem to finish.

Does anyone knows if this can be solved without modifying my tables definitions?

Thanks in advance,

Ignasi

ucbabu

02-05-2004, 13:12

Hi Ignasi,

If you want to use a new JDBC Adapter Connection create one using the IS Administrator. And if you want to change the Adapter Settings of an exixting service well you cannot do that. Only thing you can do that is Change the existing Adapter Connection or Recreate the Adapter Service.

thanks
Uppen

bellamine touira

03-09-2004, 08:31

Hi all,
I have the same problem like you Ignasi Mateos
I'm trying to configure a JDBC Connection to an Orable(8.1.7) DB. And after editing all parameters I'm obtaining the next error:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource D106Execrices.adapters:D106Adapter.

[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.

[ADA.1.204] Cannot connect to the database with DataSource class "oracle.jdbc.pool.OracleConnectionPoolDataSource".
Exception d'E/S: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

even if I tried DataSource Calss=oracle.jdbc.pool.OracleDataSource

but when I use DataSource Calss=com.wm.dd.jdbc.oracle.OracleDriver
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource D106Execrices.adapters:D106Adapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
com.wm.dd.jdbc.oracle.OracleDriver

I want to know how did you reolve this problem Ignasi Mateos

and I really appreciate any help and suggestions for all
Thanks

Touria

gasri (Unregistered Guest)

06-17-2004, 08:02

Hello,

I use a Oracle jdbc driver for connecting my IS 6.0 to an oracle database. The problem is when the database restart, my adapter is disabled and then all my transaction are failed. I have to restart manually my conncetion by enabling the jdbc adapter. Is it a webmethods standard beahviour or a problem of my jdbc driver configuration ? Is it possible to get a FIFO queing transaction for insertion in database with order garanted delivery ?

rmg

06-17-2004, 09:33

Actual behaviour is when ever database goes down the Adapter connections gets disabled and the db is up again then connections will be enabled automatically.

I do know why this is not happening in your IS.May be contact tech support regarding this issue.

Regards,

krishna_insol

06-30-2004, 05:43

Hi,
I am using JDBC adapter with MS SQl Server. It connects and works fine. When I use DeleteSQL template to create a adapter service, it deletes the record, but the return value is always zero, even if it deletes or not. In the JDBC adapter documentation, it says that the return field returns the no. of affected rows. Is this the normal behaviour?

Thanks,
Krishna

saurabhm

06-30-2004, 14:04

hey krishna,
I just configured a simple DeleteSQL adapter service using JDBC adapter 6.0.3. And for me, the output field correctly returns the number of rows deleted.

What is the adapter version you are running? may be you need a patch or upgrade to 6.0.3 version?

Dennis C (Unregistered Guest)

10-12-2004, 13:34

Hi,

I'm pretty new to webMethods, I'm trying to connect to SQL Server database and getting the following error.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MyTest.Test:TestSQLConn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class "com.microsoft.jdbcx.sqlserver.SQLServerDataSource" cannot be located.
com.microsoft.jdbcx.sqlserver.SQLServerDataSource

Can anyone please help me in resolving this. I think I'm missing the jar files, but how do I get them.

Dennis

Christian Schuit (NL)

10-13-2004, 02:47

Hi Dennis

The error says that it cannot find the drivers.

Check that:
- You have the correct drivers;
- You have placed the JAR or ZIP containing the drivers in the /lib/jars directory of the IS main directory;

Good luck, Chris

topetee

10-27-2004, 12:17

m'aidez svp...
i get Could not connect: [wm-cjdbc32-0014][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ORCL) was not recognized by the Oracle server.

this is the set-up from wmDB adapter
using url: jdbc:oracle://hostname:port
driver : com.wm.dd.jdbc.oracle.OracleDriver

what should the url for this be as the permutations i'm using are exhausted [nearly!!]

many thanks

fz1231

10-27-2004, 12:46

topster,

I think the url should be:

jdbc:oracle://hostname:port;sid=database_name

without sid=database_name the driver could not connect to the database.

HTH

Fan

raymoser

10-27-2004, 12:47

Topster,

I'm sure that if you do get it configured, it will throw an OEM error stating that the driver is for internal communications (something like that.)

com.jdbc.oracle.OracleDriver should be the correct JDBC class driver and you should have classes12.zip in your /lib/jars directory.

The DB URL should be different though:

jdbc:oracle:thin:@host:1521:<db_name>

HTH,

Ray

rmg

10-27-2004, 12:48

topster,

Use as shown below,

DB URL--jdbc:oracle:thin:@hostname or ip:port:sid
DB Driver---oracle.jdbc.driver.OracleDriver

And also make sure classes12.zip is located in the IS/lib folder,If not put this zip and restart the IS.

HTH,
RMG

rmg

10-27-2004, 12:48

topster,

Use as shown below,

DB URL--jdbc:oracle:thin:@hostname or ip:port:sid
DB Driver---oracle.jdbc.driver.OracleDriver

And also make sure classes12.zip is located in the IS/lib/jars folder,If not put this zip and restart the IS.

HTH,
RMG

topetee

10-28-2004, 02:55

Guys,
As ever very helpful and thank you, I have SQL connections but this is my first foray into Oracle[!?!] - I don't have classes12.zip, would you be able to suggest where I may locate this...

mta

topetee

10-28-2004, 03:34

doh!! sorry I've gone onto the Oracle site and retrieved this, many thanks for your assistance guys!!
http://www.wmusers.com/wmusers/clipart/happy.gif

Christian Schuit (NL)

10-28-2004, 05:48

All

This thread includes many different topics. I would suggest for further use to spawn a new thread with a specific topic regarding your issue.

Summary of this thread (for Oracle):

** Whether or not you can install the JDBC adapter is dependent on the user account you use with the installer
** After installation, check that you have the most recent classes12.zip from oracle.com
** Verify that you have the classes12.zip in your IS classpath
** Depending on whether you are using the thin or thick client the connection url will either be jdbc:oracle://host:port;sid=db_name or jdbc:oracle:thin:@host:port:db_name
** Use sqlplus or isql to verify your username and password for the DB
** Use telnet host:port to test whether you can access the port on the (remote) db host (regarding firewalling & routing)

If you feel you have any additional key points regarding this thread, please add them ;)

chiranjeevi

12-22-2004, 15:15

Hi all,
I am pretty new to webM.I have installed IS & Dev 601 ver.They are working fine.Now I have installed JDBC Adapter..there comes the problem.Now I tried to start my IS,it is starting but again its getting killed..Pls gimme a solution for this..

Thanks in advance..

Chiranjeevi
prasad_msc@yahoo.co.in

san

12-22-2004, 20:32

Chiranjeevi

To figure out the problem you can take a look at the server log. You can find it under <integrationserver>\logs\serverYYYYMMDD.log. Also, you can try to start the WM server from command prompt at debug level 6 and notice error message that appears there. Still if you are unable to find the problem, you can paste the error message that appears in log in your next message to wMUsers.

HTH.
San
"Be Good, Do Good".

thahir

12-26-2004, 02:32

Chiranjeevi

As Schuit rightly mentioned, you should have started a new thread instead of adding at the first thread you saw.

Now to your problem. What did you mean by "getting killed". give more details than that. Did you check the presence of a "lockfile" if you find one delete it before starting it.

Thahir

Archana (Unregistered Guest)

02-01-2005, 10:01

Hi all,
I am unable to configure a new JDBCAdapter Connection to MSSQL server.
It looks like I have all the parameters right, but I get the following error repeatedly.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource archTraining.Adapters:SQLConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.jdbcx.sqlserver.SQLServerDataSource".
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

I have windows XP home edition with SP2 on my system. Is it because of the service pack? I even unistalled SP2 from the system. Can somebody help me configure the connection..Thanks in advance.

Archana

mwr0707

02-01-2005, 14:36

Do you have the Microsoft SQLserver client tools installed on the Integration Server machine?

If so, running QueryAnalyzer on your IS machine, can you connect to the database?

puneetsaxena

03-08-2005, 04:24

Vyas,
Try with this Datasource class "oracle.jdbc.pool.OracleConnectionPoolDataSource" .
put classes12.zip file in <isdir>\lib\jars\ directory.

rest of the parameters will remains same.

Regards,
Puneet Saxena

jeevanrego

03-08-2005, 04:45

Hi

The same datasource class also will work i.e "oracle.jdbc.pool.OracleDataSource" . I have tried a sample.
But "classes12.zip" file has to be put in <is_dir>\lib\jars\ Directory as puneet says.

Regards
Jimmy

dvuckovich

03-15-2005, 15:00

I have a JDBC adapter configured for an Oracle system as shown below. When I try to assign a tablename in a strictly input adapter service, I have no problem. A list of tables in instance OUTSIDE appear to choose from. However, in an update adapter service, when I try to select a table, all I see is instance OUTSIDE and no list of tables.

I am set up as follows:

Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName host.mydomain.com
user MYUSER
password ******
databaseName XTEST
portNumber 1522
networkProtocol tcp
Other Properties driverType=thin;TableFilter=''.'OUTSIDE'
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 10
Maximum Pool Size 100
Pool Increment Size 20
Block Timeout (msec) 1000
Expire Timeout (msec) 1000

(Message edited by mcarlson on March 16, 2005)

dvuckovich

03-17-2005, 10:36

I corrected the above problem and no longer need assistance.

bsbabu81

04-12-2005, 04:03

Hi,

I am getting following error while enabling the connection after creating jdbc connection. plz let me know the solution for this.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource connections:connection1.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.200] The JDBC DataSource class "com.microsoft.jdbcx.sqlserver.SQLServerDataSource" cannot be located.
com.microsoft.jdbcx.sqlserver.SQLServerDataSource.class not found

thanx & Regds

babu

vr_square

04-12-2005, 04:40

Hi Babu,

Keep these files in the <is_dir>\lib\jars directory and restart IS.

msbase.jar
mssqlserver.jar
msutil.jar

You will find these files in your lib folder sql server installation directory.

Regards,
Raghu.

bsbabu81

04-12-2005, 05:07

Hi Raghu,

I searched jar files which u mentioned in last mail. I could not get those jar files in sql server installation directory.

Regards,
babu

vr_square

04-12-2005, 05:47

Hi Babu,

You can download these files from Microsoft site.

http://www.microsoft.com/downloads/details.aspx?familyid=07287b11-0502-461a-b138-2aa54bfdc03a&displaylang=en

Regards,
Raghu

bsbabu81

04-12-2005, 07:10

Hi Raghu,

I copied those files which u said into is/lib directory. Then it giving following error while enabling connection. plz see this error n give me the solution.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource connections:connection1.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection connections:connection1: after 1 attempt(s).
javax/sql/DataSource

Thnx & Regrds

Babu

adam c

04-12-2005, 11:19

BSBabu,

The error you are receiving is caused by the IS inability to find the class 'javax/sql/DataSource'.

In your message you mentioned placing the jars in the IS/lib directory.
You need to place the jars in the IS/lib/jars directory.

Try this.

rmg

04-12-2005, 13:56

Babu,

Also put javaxsql.zip in this directory

- create a directory called "...\packages\WmJDBCAdapter\code\jars\static(new directory)" .Finally restart IS.

bsbabu81

04-12-2005, 22:52

Hi,

I copied msutil.jar, msbase.jar, mssqlserver.jar files into IS\lib\jars directory. I placed javaxsql.zip file into packages\jdbcadapter\code\jars\static directory. while giving connection i gave following parameters

Transaction Type: LOCAL_TRANSACTION
DataSource Class : com.microsoft.jdbcx.sqlserver.SQLServerDataSource
serverName : name of the server
user : sa
password :sa
Retype password: sa
databaseName : database name
portNumber : 1433
networkProtocol :nil
Other Properties :nil
Enable Connection Pooling: true
Minimum Pool Size :default
Maximum Pool Size : default
Pool Increment Size : default
Block Timeout (msec) : default
Expire Timeout (msec) : default
Startup Retry Count: default
Startup Backoff Timeout (sec) : default

After creating connection, while enabling it, I am getting following error.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource conn:conn1.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/PooledConnection

Plz. let me know the solution for this error.

Thnx & Regds

Babu

bsbabu81

04-13-2005, 04:41

Hi,

Plz let me know about this error, while enabling jdbc connection.

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource conn:conn1.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/PooledConnection

Thnx & Regds
Babu

rmg

04-13-2005, 08:38

Babu,
I believe you have all the necessary jar files in the above mentioned locations and restarted IS.

Also one suggestion set this lin the

Other Properties:selectMethod=cursor and also set min and max,timeout parameters etc..

HTH,
RMG

bsbabu81

04-14-2005, 01:08

Hi,

Thank you very much to Raghu, RMG, Adam for cooperation. Atlast I got enabled connection.

thnx & Regds

Babu

bsbabu81

04-14-2005, 04:41

Hi,

Let me know how many rows effected while updating the table by using the jdbc adapter service. which settings we need to set.

Thnx & Regds
Babu

rmg

04-14-2005, 08:32

Babu,

Are you using JDBCAdapter updateSQL template?

jeevanrego

04-14-2005, 09:21

Hi Babu

If u r using JDBCAdapter UpdateSQL Template, the number of rows affecting u'r query depends on WHERE condition you specify.

Regards

Jimmy

meetrajesh81

04-24-2005, 01:13

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource eg:ram.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/DataSource

rmg

04-24-2005, 15:37

Rajesh,

Where you getting this error?

When logging into TNConsole?or when creating JDBC Pools or JDBC Adapter Connection?

Regards,

meetrajesh81

04-26-2005, 00:53

i face this problem after logging in TNconsole and when creating a new profile.

meetrajesh81

04-27-2005, 01:00

no profile is created on tn console,when creating new profile it gives
following errors
1. Error encountered invoking wm.tn.profile:addProfile com.wm.app.tn.profile.ProfileStoreException: Error encountered adding profile to the database.
(0) java.sql.SQLException: [wm-cjdbc32-0014][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
(1) java.sql.SQLException: [wm-cjdbc32-0014][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
(2) java.sql.SQLException: [wm-cjdbc32-0014][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
(3) java.sql.SQLException: [wm-cjdbc32-0014][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
(4) java.sql.SQLException: [wm-cjdbc32-0014][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
.

2. Profile and security information saved with error: Return value for ProfileStore.getProfileStore().getMyId() is null

send u r ways to correct it

rmg

04-27-2005, 08:39

Rajesh,

Please make sure that you executed all the necessary TN DB SQLServer scripts,and also check if the profile data messing anything before inserting into TNDB.

meetrajesh81

04-28-2005, 01:57

sir, i am sure that i executed all the necessary TN DB SQLServer scripts,and also check for the profile data missing anything before inserting into TNDB.is there any other problem for it suggest it to
me THANKS for u r suggestion

regards
rajesh

rmg

04-28-2005, 08:37

Rajesh,

I am not sure what could be the problem other than above,try to contact wm tech support for faster resolution if this is a critical issue and show stopper.

HTH,
RMG

thahir

04-30-2005, 02:01

Rajesh

Try the fix TNS_6-0-1_Fix39 from webMethods assuming u r using 601

http://www.wmusers.com/wmusers/clipart/happy.gif

Thahir

chirag_sanghavi

05-01-2005, 13:45

Hi,

Does anyone have a good sample for Stored Procedure Notification? What would be ideal way to
1. ensure that records do not get deleted, if notification did not reach.
2. What does stored procedure need to return, if there are no records to be notified?

meetrajesh81

05-02-2005, 01:28

hai thahir,
yes i am using webmethods6.0.1,then how can i fix the error,
i can't under stand u r suggestion clearly.let me know u r idea in some elaborate manner.

thahir

05-02-2005, 01:44

Rajesh

U need to download the fix from advantage site.

Put the fix in the updates folder in Integration server install directory. Restart Integration server.

I think I came across a similar error recently and this fix corrected it.

http://www.wmusers.com/wmusers/clipart/happy.gif

Thahir

meetrajesh81

05-03-2005, 09:37

hai thahir
This is rajesh please send a link to download the FIX from advantage
site, i failed to found it on advantage site plase help me.I frequently come accross this problem or if possible sent it an Attachment to me.

regards
rajesh

rmg

05-03-2005, 10:15

Rajesh,

As Thahir mentioned the fix TNS_6-0-1_Fix39,use the search option in the Advantage site,you will see some results.

Or else send request email for the fix with support@webmethods.com,they will send it to you directly.

HTH
RMG.

ghaz (Unregistered Guest)

05-09-2005, 19:24

IS 6.1 - JDBC Adapter
I have a flow service that uses a JDBC Adapter. When I run it standalone it works fine. However when I call it from another flow service it fails. I have checked the values that are being passed in and they look good. I have set my JDBC Adapter for LOCAL_TRANSACTION. Any pointers?? Thanks.

rmg

05-09-2005, 19:43

Ghaz,

What error is it thowing?Please be more elaborate.

Also make sure the AS input values being mapped are accurate ie datatypes,null values etc..,check the pipeline details again.

Are you directly running the flowservice or stepping thru the service that has pub.art:startTransaction wrapped inside?

HTH,
RMG

ppk

05-15-2005, 07:39

Problem:
========
Not able to create JDBC service (Insert, update or any template).

Details:
========
1. Successfully enabled JDBC ADAPTERS.
2. wM Developer is keepon running the New Adapter service, while I am trying to create to NewAdapter Service. It never ends.

Reproduction Steps:
===================
1. created the JDBC ADAPTERS (successfully).
2. Navigate to wM Developer -> myPackage -> myFolder -> new -> Adapter service.
3. select JDBC
4. select SID
5. select Template (insert or any)
6. give the service name
7. wm ADAPTER KEEP ON SHOWING THE MESSAGE BOX "New Adapter Service" Running. It never ends.

Other simptoms:
===============
1. if I try to create JDBC Adapter service for the local machine (where wM installed), then wM-Developer is creating and things are working fine.

2. For the same database, if I am trying to connect from remote wM Developer (I installed webmethod in another mechine) it is giving above problem.

Regards,
PPK

ppk

05-15-2005, 07:44

Please let me know how to resolve the above problem (new JDBC Adapter service). Do I need to do any settings?

Regards,
PPK

ppk

05-17-2005, 09:16

Webmethods Tech/support Team,
Please provide your update...

regards,
PPK

rajesh kumar (Unregistered Guest)

07-22-2005, 01:08

Hi, all

I am rajesh i want how to place EDI ANSI X12 in to sapserver through
SAP Aadpter

please send answer for this as early as possible

regards
rajesh

rmg

07-22-2005, 10:27

Rajesh,

You can only send SAP IDOC/XML using via SAP Adapter.Before this you may have to convert the EDI X12 message to IDOC.

I am not sure what is ur requirment?please elaborate it.

HTH,
RMG

rajesh kumar (Unregistered Guest)

07-23-2005, 00:37

Hai

HTH
RMG

I want Answers for the following questions?
1.How to convert EDI X12 to IDOC.?
2.procedure to send those convrted IDOC to SAPserver?
3.How to get the IDOC of SAPserver to our IS?
4.How to MAP EDI to IDOC?
5.what are RFC,BAPI,ALE for what purpose they are used?

I am learning sapadapter i am new to this so i don't no how IS convert
documents of clients in the form of XML,EDI ANSI X12 with sapsystem with
SAPAdapter

Thanks for u r reply ASAP

Regards
Rajesh

mwr0707

07-23-2005, 16:59

It sounds like you are asking for a complete training course from a volunteer forum.

You may get better results by:

1. Doing some research on your own first. The documentation is a great place to start it is usually installed as PDF files with the webMethods software. Spend some time browsing what is already on this site.

2. Using "this" thread for questions regarding the 6.0.1 JDBC adapter.

3. Focusing on one area at a time and ask questions of limited scope if you want an answer in any kind of detail.

mcarlson

07-24-2005, 10:15

Does your boss have a Palm Pilot?

mwr0707

07-24-2005, 12:44

I was thinking more along the lines of one of these:

http://www.imsai.net/s2-advance_order.htm

rajesh kumar (Unregistered Guest)

07-26-2005, 02:52

Hai

HTH
RMG

I want Answers for the following questions?
1.How to convert EDI X12 to IDOC.?
2.procedure to send those convrted IDOC to SAPserver?
3.How to get the IDOC from SAPserver to our IS?
4.How to MAP EDI to IDOC?
5.what are RFC,BAPI,ALE for what purpose they are used?

I am learning sapadapter i am new to this so i don't no how IS convert
documents of clients in the form of XML,EDI ANSI X12 to sapsystem with
SAPAdapter

Thanks for u r reply ASAP

Regards
Rajesh

topetee

07-26-2005, 02:59

Rajesh,

2 things....
1: your question is not in the correct thread, this is for JDBC Adapter [view previous responses.....]
2. all answers you need are in the SAP adapter documentation. It will take 10 minutes to create a message and get it into/ out of SAP, starting from scratch. Open a thread in the correct area and you will get better answers and also a simple search via this group will also uncover the wealth of knowledge that we bring.

aneelmurari

09-15-2005, 15:35

I have a adapter service to execute a stored procedure inside an Oracle package. The stored procedure takes an integer parameter and returns seven values (Char and Numeric). When I execute the service, I get " ORA-01704: string literal too long " Error. But when I execute the same from sqlplus, the stored proc returns correct results.

My guess: The output parameters which are declared as java.lang.String in the adapter service when converted to VARCHAR or CHAR in the DB is not long enough to hold the results. I may be wrong on this.

Any ideas as to what is the cause or how to fix the problem ?

Thanks in Advance.

26026

10-19-2005, 23:47

what should be the url and driver for MSSQL database?

i am using-
url - jdbc:microsoft:sqlserver://hostName:portnumber;databaseName=;selectMethod=cursor;

driver - com.microsoft.jdbc.sqlserver.SQLServerDriver

i am getting an error "No suitable driver"

can someone tell me the right url and driver for SQL.