g*******e
发帖数: 32 | 1 I need some help on the Oracle and JDBC setup.
I downloaded Oracle 9 from our universtiy.
And install it to my local computer ( windows XP)
D:\oracle\
Global DB name : MainDB
SID: MainDB
Now I have some problems about the JDBC and oracle thin server.
And I find the oracle takes a lot of resources of the computer.
After checking the processes, I find there are two java and two apache server
processes plus oracle itself.
The total of the resource cost is about 200 MB memory
Do you have methods to |
|
t********k
发帖数: 808 | 2 怎么知道现在用的Oracle(用的是9i)的JDBC是哪个版本的?
如果用的是1.0的
怎么设置让Oracle用2.0版本的JDBC?
DB2都有批处理文件可以进行设置的 |
|
t********k
发帖数: 808 | 3 数据库是oralce 9i
怎么回事?
last,absolute之类的函数应该是JDBC 2.0以上的
那要在哪儿设置让oralce使用2.0版的JDBC? |
|
a*****a
发帖数: 1429 | 4 There are 4 types of JDBC driver. Oracle supports 2 of them. JDBC-ODBC
is supported by JDK. Don't mess them up. |
|
s****r
发帖数: 36 | 5 How does a Java application insert data into SQL server?
Can Java application talk to SQL Server directly via JDBC? If Yes, is JDBC
Driver included in SQL Server package?
Thanks for help! |
|
c**g
发帖数: 274 | 6 Not sure if I understand your question. Basically the interface for
all JDBC driver is the same, namely package java.sql and javax.sql.
The JDBC specification and java.sql/javax.sql pretty much define
everything. |
|
u**r
发帖数: 166 | 7 getTableName(i) 后面返回值没有, 我用的JDBC-ODBC, 也试过用JDBC DRIVER, 都不行
请问如何解决这个问题?
多谢 |
|
e******r
发帖数: 220 | 8 Is JDBC driver part of JAVA compiler? or part of database?
How to install it?
Where to download JDBC driver?
BTW: I have ORACLE and MS SQL SERVER in my PC installed.
Thanks
|
|
o**1
发帖数: 6383 | 9 可以的
定义 fetch size
不过这不是标准的jdbc, 所以要看具体的数据库是否支持，怎样支持。
有可能需要用到 具体某个数据库自家的 jdbc driver里面的function
那样就没有可移植性了。 |
|
m*********t
发帖数: 24 | 10 because most of JDBC drivers use native code ( like C, or C++ ), which
create objects outside of java heap. Java GC cannot collect those native
object memory. close() method inside finally block can guarantee the
invocation of native memory release method provided by specific JDBC
provider. |
|
m******t
发帖数: 2416 | 11 What is the name you gave to the data source? It has to be
the one you passed to the JDBC:ODBC bridge in your program. |
|
o**k
发帖数: 5 | 12 how to establish sun.jdbc.odbc.JdbcOdbcDriver
in ODBC? and the user DSN in ODBC?
thx |
|
m******t
发帖数: 2416 | 13
You don't need to do that. It's a JDBC-ODBC bridge driver, meaning
you only need to set up the ODBC entry for your database as usual. |
|
w**********k
发帖数: 1135 | 14 mysql 的JDBC支持怎么样?
thanks. |
|
y****r
发帖数: 1 | 15 Hi, I forgot how to get primary key through JDBC. Is there anyone can do
me a favor?
Thanks in advance! |
|
m**i
发帖数: 89 | 16
是Oracle方面的问题，不是JDBC的问题。你可以用to_date()转换
to_date('1999-07-21 00:00:00', 'yyyy-mm-dd hh:mi:ss')
Oracle里的日期格式是"21-JUL-1999"...
详细请看手册。 |
|
f****r
发帖数: 311 | 17 如何配置JDBC支持中文? ( Oracle8i, Server side : Linux)
Client side: Win2k
3x. //bow |
|
f****r
发帖数: 311 | 18 谢了...
document都看了..
现在的问题是直接向oracle里写中文没有问题
但是通过JDBC读写就不灵... |
|
s***s
发帖数: 1841 | 19 【 以下文字转载自 socks 的信箱 】
【 原文由 socks 所发表 】
通过jdbc连接oracle database
前几天还运行顺利，
今天得到error msg:
"The Network Adapter could not establish the connection."
可能是什么问题？ |
|
q***l
发帖数: 17 | 20
I dont really understand yr Q, to me it seems it depends on
which DB
you use, and jdbc driver is specified to the DB. |
|
z*q
发帖数: 29 | 21 Hi,
Anybody know how to get Identity (MS-SQL) after the
"insert"? I mean get the Identity column value without using
another retrieve ("select"). And in some case, the addition
select can't work before the Identity is the ONLY primary
key. I know in PowerBuilder, there is some way to do that.
But I don't know how to do it in JDBC.
Thanks a lot. |
|
w*****h
发帖数: 139 | 22 You have to setup your CLASSPATH to include orcle jdbc classes.
Check your $ORACLE_HOME/java/ path for more info. |
|
m****f
发帖数: 32 | 23 I run MySql under Solaris 8 very well. I inserted a user called
jack into the user table of mysql database like this:
mysql>INSERT INTO user (Host, User, Password)
-> VALUES('localhost', 'jack', PASSWORD('johnson'));
Query OK, 1 row affected (0.00 sec)
I checked the table, and see that user jack is there.
Here is a part of my JDBC test code, which accesses the demodb database
I have created for test use.
import java.net.*;
import java.sql.*;
import java.io.*;
import java.util.*;
class MyS |
|
r*a
发帖数: 1503 | 24 Can any DX recommend some books
for JDBC and embedded SQL programming?
It's better if it could be downloaded. Thanks |
|
|
B**z
发帖数: 153 | 26 many of them
JDBC-ODBC bridge
IDS
AveConnect |
|
u*s
发帖数: 80 | 27 How to load DriverManager to JDBC?
Thanks. |
|
j******f
发帖数: 228 | 28 All,
I'm writing a program to dynamically create tables in a Sybase database
through JDBC. Some of the fields of the tables are VARCHAR type. It seems that
the Sybase DBMS doesn't handle it correctly and keeps throwing exceptions. If
I remove those VARCHAR fields, the program executes correctly. Does any one
have any solution?
Many thanks!! |
|
yb
发帖数: 171 | 29 I am desperately needing help for DB2 connection in the jsp through jdbc.
1) I have DB2 version 7 installed on my own machine ( personal edition) for
both server and client. I created a data base and bunch of tables. I can use
the control center to access the tables.
2) I use tomcat4.0.6 for the web application server. The java I am using is
j2sdk1.4.0_01. I use tomcat's servlet.jar for servlet.
3)The window I use is win NT.
4)I set the class path in the control panel/system/environment and also |
|
c*****t
发帖数: 1879 | 30 【 以下文字转载自 Java 讨论区 】
【 原文由 coconut 所发表 】
Is it possible to create a database file through jdbc/odbc?
In the ODBC data source window, I see
MS Access Database
but, what is the url for creating database? I know that I
could create an empty access database before hand, and put
that file into the User Sources, but that's requires user
configuration, which is bad.
Anyone can help?
BTW, when I get an SQL exception such as
SQLException: [Microsoft][ODBC Microsoft Access Driver] Table 'COFFEES' |
|
w********c
发帖数: 2632 | 31 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); |
|
a***n
发帖数: 1616 | 32 【 以下文字转载自 Java 讨论区 】
【 原文由 adven 所发表 】
用JDBC，最基本的数据库连接访问。开始还是好的。
过了一段时间后，就报错，说用完了shared memory，全被heap占用了。
网上说，要增加large pool size。
可是，我看了pool里的free memory，随着我程序的不断数据库访问，
它占用的pool memory是成递增的，最后就满了fail了。
所以，按这个趋势，无论我pool设多大，memory终究是要溢出的。。。
(我的large pool size已经是80M多了, 我也就做了一些简单的数据库访问而已)
我想是我java程序的问题。是不是要用shared sql? 让所有数据库访问用shared资源？
或者让已经做完的数据库操作把占用的heap dump掉？
这该到底怎么做啊。。。。？
谢了！ |
|
a***n
发帖数: 1616 | 33 Thanks!
This explanation helps a lot! Now I have a better picture of what's going
on in this kind of application.
I think, as a DBA newbie, I need to read more oracle DBA books to grasp the
ideas ...
To tell the truth, I didn't even know:
What is cached? Query Result or Query Statement or both?
Is this shared pool caching only for JDBC or for any client including
sqlplus online transactions?
If it's caching, why can't it dump/replace the cache automatically
|
|
n********a
发帖数: 68 | 34 啦?
sqlplus)?
sqlplus is just another client, nothing different than JDBC, ODBC, Pro C, and
the list goes on and on.
Your worry that Oracle cannot servive sqlplus stuffed with tons of
non-reusable SQL is warranted. There are several points to consider here:
1. sqlplus as you said, is an interactive client. A human being will type in
SQLs. Now, how many SQLs can you type in an hour? How long will it take you
to type hundreds of SQL statements? The point is that you are unlikely to
be able to gener |
|
w*********y
发帖数: 28 | 35 我想用JDBC往数据库里插入几条记录，但每次执行到executeUpdate(...),程序就死住了
。用catch也找不到error，用PreparedStatement也是同样的问题，用新的Connection,St
atement也不行，反正我能想到的都试过了。----有人说是内存溢出，但是只插入一条记
录，怎么会溢出呢？
请问各位有没有遇到类似这样的问题，如何解决？谢谢！
BTW，我用的是Oracle, 以前从来没问题的。 |
|
U*O
发帖数: 2342 | 36 想通过JDBC从本地机器（XP）连到服务器的数据库（Oracle9i）进行数据操作。
请问本地机器应该安装什么开发环境？
-j2eesdk 还是 jdk tm？
-driver怎么办？
谢谢 |
|
u**r
发帖数: 166 | 37 ResultSetMetaData rsmd=.....getMetaData();
再一个for loop里用
String tableName = rsmd.getTableName(i);
这里的tableName返回值是空. 别的都没有问题, 比如getColumnName(i), GetColumnTy
peName(i).
我用的是SQL SERVER 2000, 用JDBC的driver直接连的
是什么问题呢?多谢指教 |
|
r****z
发帖数: 18 | 38 怎样import Oracle的JDBC Driver class? 系统及软件设置如下：
Windows XP， 已装了JDK 6和Oracle Express 10g. 写了个Java小程序，前面几行是：
import java.sql.*;
import oracle.*;
import oracle.pool.OracleDataSource;
javac 就是不认oracle.*和oracle.pool.OracleDataSource。我已经从Oracle网站上下
载了ojdbc6.jar并存于当前目录（放源文件的目录）。我也试了将CLASSPATH改成当前
目录或者在命令行直接输入。这些都不行，到底怎么回事啊？
恳请高人执教！
叩谢！ |
|
r****z
发帖数: 18 | 39 放了，现在编译没有问题了，问题是执行是找不到jar文件。如果我将jar文件放在
Classpath，那java自己的类都找不到了。这怎么办？Java本身的类都放在哪里？试着将
orace提供的jdbc类复制到Java\jdk1.6.0_05\bin或\lib下面好像没用。:(
怎样将jar文件放到classpath而不覆盖原来的？ |
|
|
g***l
发帖数: 352 | 41 有了spring/hibernate，还有人直接用JDBC写database application code吗？ |
|
g***l
发帖数: 352 | 42 For legacy code? Is using JDBC to access database more efficient than using
Spring/hibernate? |
|
P******a
发帖数: 478 | 43 对呀。JDBC只是Java的数据库API,各数据库厂家再为这个API和他们自己的
数据库写驱动程序。 |
|
i**s
发帖数: 97 | 44 Seems you are confused by these concepts.
1. Java has nothing to do with Javascript.
2. JDBC is Java's API to SQL database.
3. If you write ASP program, you can use both VBScript
and Javascript to access ODBC data source.
4. If DBMS and Web server reside in different machines,
it is perfect for ODBC to work. You need to build an
ODBC data source in the machine where web server runs,
while the ODBC specifies the DBMS running in another machine.
5. If you write Java Applet, DBMS should |
|
l********r
发帖数: 36 | 45 where do you install your jconnect at? mine seems can't pick
up the URL or the Driver when i tried to connect it using
the JDBC explorer comes with JBuilder...
btw, shouldn't the driver be in some kinds of directory?
c:..\sybase\..., how come i can't find it after i unzip the
jconnect?
gee..... this thing is putting on so much pressure on me... |
|
o**d
发帖数: 11 | 46 Yes. Applet can use JDBC to make database access. But,
Applet also has lots of security restriction. For example,
it can only make network connections to the host it comes
from. In another word, your database server and web server
needs to be on the machine, which is not always the case. If
your web server and database are located on seperate machine
and you do want your applet to access the database, you can
write an application as a media between the applet and
database. |
|
m******t
发帖数: 2416 | 47 Oracle has only provided support for CLOB/BLOB through
their proprietary classes. You have to cast your
Statement and RecordSet classes downward to the Oracle
implementation, and call some non-JDBC methods on those
classes.
Go to jGuru, search for Oracle and CLOB. |
|
yb
发帖数: 171 | 48 I am desperately needing help for DB2 connection in the jsp through jdbc.
1) I have DB2 version 7 installed on my own machine ( personal edition) for
both server and client. I created a data base and bunch of tables. I can use
the control center to access the tables.
2) I use tomcat4.0.6 for the web application server. The java I am using is
j2sdk1.4.0_01. I use tomcat's servlet.jar for servlet.
3)The window I use is win NT.
4)I set the class path in the control panel/system/environment and a |
|
m******t
发帖数: 2416 | 49
[snip]
[snip]
not familiar with db2's jdbc driver, but are you sure
it's "COM.ibm..." not "com.ibm..."? |
|
z****g
发帖数: 2497 | 50 Doig table creation , data insertion, jdbc is very easy. |
|
