cancel
Showing results for 
Search instead for 
Did you mean: 

problem whit jdbc adapter

Former Member
0 Kudos

hello,

a very big problem.

I configured in my PI 7.1 installation a JDBC - PI - rfc interface.

When i active the jdbc comunication channel , all cpu saturated and j2ee crash.

I try to restart java stack but is not possible

I think the problem is on jdbc adapter but i cannot stop it if java part is down.

There are solution for stop or delete this comunication channell from abap stack?

does someone already had a similar problem that jdbc adapter generate a crash of system?

thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

i close the message but problem is not solved

former_member181985
Active Contributor
0 Kudos

If what you explaining is true and the root cause then Temporarily shutdown the database of JDBC.

Restart XI, then stop the JDBC channel from RWB.

Edited by: Praveen Gujjeti on Apr 8, 2009 8:51 PM

Former Member
0 Kudos

RWB??

is not possible restart XI.

XI is donwn and not restart (java part)

suggestions?

Edited by: Alessandro Pederiva on Apr 8, 2009 11:35 AM

former_member181985
Active Contributor
0 Kudos

I said to shutdown temporarily the Database from where you are pooling the data using JDBC sender channel in XI.

Now XI java stack should be up after some time, if not shutdown and restart all stacks from SAP MMC.

Regards,

- Gujjeti.

Former Member
0 Kudos

i try whit this ...many times

J2EE don't restart

former_member181985
Active Contributor
0 Kudos

>

> i try whit this ...many times

> J2EE don't restart

Then the issue seems to be different...................there can be several reasons............

Ask your BASIS person to check trace files & log files.........

Regds,

- Gujjeti.

Former Member
0 Kudos

ok thanks, we try

which is the correct connection string for connection on SQL server??

i used :

driver: sun.jdbc.odbc.JdbcOdbcDriver

connection : jdbc:odbc:Driver={SQL Server};Server=host;Database=dbname

former_member181985
Active Contributor
0 Kudos

>

> ok thanks, we try

> which is the correct connection string for connection on SQL server??

> i used :

>

> driver: sun.jdbc.odbc.JdbcOdbcDriver

> connection : jdbc:odbc:Driver={SQL Server};Server=host;Database=dbname

Are you using a JDBC-ODBC bridge type driver, I am not sure if this is supported by JDBC adapter.....

If it is not try this,

Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://SQLHOSTNAME:PORT;DatabaseName=DBNAME;SelectMethod=cursor

Former Member
0 Kudos

thanks

anyway now we need reinstall XI

terrible situation

Former Member
0 Kudos

Hi,

my suggestion - just ask your basis guys to check the J2EE startup trace and log file to know if some J2EE parameter is not okay............then ask them to start the AS JAVA configurator tool from the OS - they will know how to do it.......then ask them to check the J2EE parameters there and change some parameter value which is indicated by the startup trace file.............

since you guess, it might be because of your JDBC comm channel, so keep your database system down till your XI server is up.............

Regards,

Rajeev Gupta