将C ++程序与Oracle连接 [英] Connecting c++ program with Oracle
问题描述
我的C ++程序是(我在ubuntu中使用g ++编译器), p>
#include< occi.h>
#include< iostream>
使用namespace std;
int main()
{oracle :: occi :: Environment * env = oracle :: occi :: Environment :: createEnvironment();
oracle :: occi :: Connection * conn = env-> createConnection(bsk,oraclepass);
env-> terminateConnection(conn);
oracle :: occi :: Environment :: terminateEnvironment(env);
}
我收到错误
对oracle :: occi :: Environment :: createEnvironment的未定义引用(oracle :: occi :: Environment :: Mode,void *,void *(*)(void *,unsigned long),void *(*)(void *,void *,unsigned long),void(*)(void *,void *))'
Employees.cpp :(。text + 0x169):未定义对`oracle :: occi :: Environment :: terminateEnvironment(oracle :: occi :: Environment *)的引用'
collect2:错误:ld返回1退出状态
我是数据库连接的新手。
您可以帮我解决这个问题吗? 解决方案
From Oracle的网站,这里是一个有效的例子:
const string userName =HR;
const string password =password;
const string connectString =;
Environment * env = Environment :: createEnvironment();
{
Connection * conn = env-> createConnection(userName,password,connectString);
语句* stmt = conn-> createStatement(SELECT blobcol FROM mytable);
ResultSet * rs = stmt-> executeQuery();
rs-> next();
Blob b = rs-> getBlob(1);
cout<< BLOB的长度:<< b.length个();
...
stmt-> closeResultSet(rs);
conn-> terminateStatement(stmt);
env-> terminateConnection(conn);
}
Environment :: terminateEnvironment(env);
您的代码似乎朝着正确的方向发展。所以,似乎有些图书馆已经失踪了!
同样,从
,以下是所需的库: > OCI即时客户端数据共享库(Linux和UNIX上的 libociei.so 和Windows上的oraociei12.dll);正确安装此文件将确定您是否以即时客户端模式运行
库安装在您的机器上。
I'm trying to connect my C++ program to Oracle database(12.2).
My C++ program is (I am using g++ compiler in ubuntu),
#include <occi.h>
#include <iostream>
using namespace std;
int main()
{ oracle::occi::Environment *env = oracle::occi::Environment::createEnvironment();
oracle::occi::Connection *conn = env->createConnection("bsk", "oraclepass");
env->terminateConnection(conn);
oracle::occi::Environment::terminateEnvironment(env);
}
I'm getting the error
undefined reference to `oracle::occi::Environment::createEnvironment(oracle::occi::Environment::Mode, void*, void* (*)(void*, unsigned long), void* (*)(void*, void*, unsigned long), void (*)(void*, void*))'
Employees.cpp:(.text+0x169): undefined reference to `oracle::occi::Environment::terminateEnvironment(oracle::occi::Environment*)'
collect2: error: ld returned 1 exit status
I'm new to database connectivity. Can you please help me with this?
From Oracle's website, here is a valid example:
const string userName = "HR";
const string password = "password";
const string connectString = "";
Environment *env = Environment::createEnvironment();
{
Connection *conn = env->createConnection(userName, password, connectString);
Statement *stmt = conn->createStatement("SELECT blobcol FROM mytable");
ResultSet *rs = stmt->executeQuery();
rs->next();
Blob b = rs->getBlob(1);
cout << "Length of BLOB : " << b.length();
...
stmt->closeResultSet(rs);
conn->terminateStatement(stmt);
env->terminateConnection(conn);
}
Environment::terminateEnvironment(env);
Your code seems to be in the right direction. So, it seems that some libraries are missing!
Again, from a different page on Oracle's website, here are the libraries required:
- OCI Instant Client Data Shared Library (libociei.so on Linux and UNIX and oraociei12.dll on Windows); correct installation of this file determines if you are operating in Instant Client mode
- Client Code Library (libclntsh.so.12.2 on Linux and UNIX and oci.dll on Windows)
- Security Library (libnnz12.so on Linux and UNIX and orannzsbb12.dll on Windows)
- OCCI Library (libocci.so.12.2 on Linux and UNIX and oraocci12.dll on Windows)
Make sure these libraries are installed on your machine.
这篇关于将C ++程序与Oracle连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!