Database connection profiles when using connection caches
My client has been creating traditional client / server applications. I've
convinced him to move to multi tier with EAServer. It wasn't a hard sell, he
was already considering it.
In developing his client / server apps he has implemented a security system
on the database based upon the user's database login info - this is complete
with roles and such. It appears a lot of people have read-only access to
certain tables, etc. He would like to maintain that.
However, when connecting with a connection cache I am not using the user's
id unless I have a connection cache fo...How to create a single Oracle Database connection method or function to be used on or by all classes and pages that want to connect to the database?
How to create a single Oracle Database connection method or function to be used on or by all classes and pages that want to connect to the database? How can I create one method or function in csharp to be used on all pages or classes when conenction to the database? Please give an example.I have database connections which I am using on each and very page or classes, but I can I put in one page then I just start calling it?Database connection I am using: OracleConnection dbconnection; this.dbconnection = new System.Data.OracleClient.OracleConnec...Problem in creating Oracle connection cache using EAServer 5.0,Oracle 10g
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="ISO-8859-1"
I am facing problem to create connection cache using
Oracle.I am attaching snapshot of EAServer properties which
I set. I refered query dt. 21 jul,04 topic "EAServer JDBC
connection to Oracle". But it not works.
Content-Type: application/x-zip-compressed; name="Oracle connection cache problem.zip"
Content-Disposition: attachment; filename=&q...REPOST: PB components use only 1 connection from 50 connections connection cache
I'm currently investigating a performance bottleneck in jaguar.
I've reported this problem before and got some helpful hints from this
forum so I'm back for more, since the hints weren't helpful enough.
I have a web application which uses Powerbuilder components as the backend.
Even when I generate 30 calls that each take 1 minute, the Jaguar server
reports that it uses only one connection!! When I check oracle, it reports
that only one session is active from the Jaguar server.
Now I can just handle this if it was only one session but when i teste...How to setup connection property in Connection Cache using EAServer 3.6.1 + JDBC 2.0
The following properties is my connection cache property.
Server Name --->
Class Name ---> com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource
I am using the JDBC 2.0 to connect with my ASE 12.0 Server. I check all of
the books about JDBC API. I could not find more information about
connection property with JDBC 2.0 + Sybase jConnect 5.2.
I already try to use the connection cache property file but it could not
Do anyone know how to put the "PACKETSIZE" property to "Server Na...Connection to Oracle using JDBC Connection
I'm trying to test a connection to Oracle using Jdbc driver.
Can anyone provide me an example of who to this in PB?
I just need to know exactly what are the parameters I need
to set for the transaction Object.
// Profile OracleJDBC
SQLCA.DBMS =3d "JDBC"
SQLCA.LogPass =3d <******>
SQLCA.LogId =3d "oracleuser"
SQLCA.AutoCommit =3d False
> I'm trying ...database connection failed with connection cache
I have a connection cache on jag 3.6.1 using
I am able to ping the connection in jag manager.
My problem is in PowerJ 3.6.1. I setup a transaction object using the
database wizard(very cool), change it to use a cache and even find the
connection cache on the server.
when I try to test the connection, I first select a profile jconnect5 and
try the connection.
I get this error:
database connection failed
jz006: cought a IoException java.net.connectionException
connection refused, no further info.
any ideas would be great!
You can only...Why does it not work when I use connection cache to access Oracle database with PowerJ and EA server 3.6?
Why does it not work when I use connection cache to access Oracle database
with PowerJ and EA server 3.6?
When I use a transaction and a query in a servlet,in the design
time I can see the result accessed from database,but when the servlet
works in a Jaguar CTS 3.6,its return a null resultset.The following is the
que...what options of connection string should i use to connect to oracle
hiI was trying to connect to my oracle server. I am getting the error
OracleConnection oOracleConn = new OracleConnection();
&...Slow connection to Oracle 10g connection cache
First: by slow I mean around 250 milliseconds, not whole seconds or minutes.
PB 10.2.0 7516
EAServer 5.3 53016
Oracle Instant client
I have an Oracle 10g database that I set up a connection cache for in
EAServer. I am connecting to it from a PowerBuilder component with the
sqlca.DBMS = as_dbms
If Len(as_cachename) > 0 Then
sqlca.DBParm = "UseContextObject='Yes',CacheName='" + as_cachename + "'"
If Len(as_dbparm) > 0 Then
sqlca.DBParm += "," + as_dbparm
I have the c...Database Connection???How to connect a Database in an other server?
How to connect a Database(.mdb) in an other server?
Can I use the connection string like below?
mycon.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=http://www.****.com/***/mydb.mdb"
You can not.
Access is file based. No a client/server architecture.Thomas TomiczekPowerNodes ApS(Microsoft MVP C#/.NET)---Building a Website? Try the PowerNodes CMS - http://www.powernodes.com/
Correction: you can. Just make sure you can reach the acces db file - through a file share that is bound as drive.
Not that you should. Performance will be horrib...I cannot ping a new Oracle 8 connection cache and sometimes even the connection caches of PB 7 examples.
I've got two computers running WNT Workstation.
1) In the first one, just after installing PB 7.0.2, I cannot ping the
connection caches used by the PB 7 examples (for examples: SurfSideVideo
3.5). I've tried to create a new connection cache using Oracle 8 driver
(using an Oracle alias as ServerName): Nothing! I can't ping.
2) On the another computer I can ping only the caches of the PB7 examples.
But I still cannot create a proper connection cache directly to Oracle 8 (no
Please help me!!!!!!!!
What types of erro...Unable to connect to Oracle database.
I'm trying to connect to an Oracle 8.1.6 database using perl 5.6.0. My
Oracle client is 8.0.5.My DBI/DBD version is 1.13. OS is SUNOS 5.6.
Error message is given below:
install_driver(Oracle) failed: can't load
for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal : relocation
Symbol Perl_no_modify referenced symbol not found at
@INC has the proper entries. Ca...Force Connection creation using JNDI and connection cache
I'm using JNDI and connection cache to create connections to ASE and IQ.
The problem that I'm facing is that I want that when the max number of
connections is reached, new connections get created if needed by other
users. This can be done using the JCMCache classes using the JCM_FORCE
option in the getconnection method. What I want to know is if that can also
be done using JNDI DataSource.
Thanks in advance,