Good god:
I recently used pb12.5 developed a webservice program, environment is as follows:
The database is oracle 11 g
Server operating system is Windows server 2012 r2
Iis version 8.0
After putting-in-service proactively use so a few questions:
1, database connection lost
Interface after entering the database connection, after the success of the following program, but appeared in the process of application the condition of the missing data path connection, add log real-time view sqlca. Sqlerrtex, quote us the Transaction not connected somehow

2, the problem of the performance test
This program provides a lot of client calls, the special use loadrunner performance tests, 10 consecutive concurrency, prompt the overtime for 15 minutes or so, but if you don't connect to the database, there is no problem, as soon as you connect to the database over

3, server error
Wenservice server, often quoted "" "" program for the application pool pool name "l" Service of Process in with the Windows Process Activation Service communication appear serious mistakes, the Process ID as "8964", "" the mistake, and I don't know what caused the

The database connection code is as follows:
//Profile portal_his
The SQLCA. DBMS="O10 Oracle10g (10.1.0)"
The SQLCA. LogPass='* * * * * * * * *'
The SQLCA. ServerName="* * * * *"
The SQLCA. LogId="* * * * * * *"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="ThreadSafe='Yes', CommitOnDisconnect=' No '"

CONNECT Using the SQLCA;

If the SQLCA. SQLCode & lt;> 0 Then
Return False
End the If

Return True

Each entry interface connection, exit disconnect

Query operations are very simple, is a datawindow, retrieve back information
Amount of data is more than 80

How to return a responsibility? I was depressed dead, support a move give everyone a great god, the pb big affirmative support me

CodePudding user response:

http://download.csdn.net/detail/pcwe2002/9491907
Try this solution

CodePudding user response:

Could it be oracle11g have connection problems?

The Transaction not connected should be not connected to the database

CodePudding user response:

Don't know is Windows 2012 or iis 8 or 11 g which is out of question, the day before yesterday to replace the one server, installed 2008 + will, after deployment, database link broken problem has been solved, but was still in bad performance testing, ten minutes test server no response, I really don't know what happened

CodePudding user response:

Suggest using c #. Net original
Pb in the BS is weak

CodePudding user response:

Can ask a moderator, he mentioned before REST style in written in JAVA, better performance

CodePudding user response:

I use the webservice PB11 development have been used for 5 years, 100 or so the client is still relatively stable

CodePudding user response:

Excuse me upstairs:

I don't know the hard study? Can help me with ideas? Thank you very much!

refer to 6th floor fang3307 response:

I use PB11 development webservice, have been used for 5 years, 100 or so the client is still relatively stable

CodePudding user response:

HTTP is stateless, realize the transaction of CS mode for a long time connection, the transaction can only is disconnected use
Web sites have cookie or session to record who is the client