|
w*r
发帖数: 2421 | 2 Yes, it is working properly.
Test case:
Step 1 : create a python script to generate random strings. (copied from
internet with little mod)
#!/usr/bin/env python
import sys
import random
import string
def id_generator(size=6, chars=string.ascii_uppercase + string.digits):
return ''.join(random.choice(chars) for _ in range(size))
line=int(sys.argv[1])
for x in range(1,line):
print(id_generator())
Step 2: generate test data and put into home folder:
./random_string.py 1000 | hdfs dfs -p... 阅读全帖 |
|
m****r
发帖数: 17 | 3 From Sun's website, it seems there is JDBC-ODBC bridge that supports
JDBC API 2.0. But I can't find it at Sun's homepage. Right now, the
JDBC-ODBC driver shiped with JDK 1.2 only supports JDBC API 1.1.
If I want to purchase a pure JDBC driver(type 2, 3, 4), which vendor is
the best choice?
thanks. |
|
D********g
发帖数: 650 | 4 【 以下文字转载自 Database 讨论区 】
发信人: DataMining (代它慢拧), 信区: Database
标 题: 请问JDBC连SQL server的connect reset问题如何解决？
发信站: BBS 未名空间站 (Mon Dec 5 00:32:16 2011, 美东)
stack trace 如下：
SQL ERROR:Sql server generic error (internal) 4!Connection reset;sql state:
08S01;stacktrace: com.microsoft.sqlserver.jdbc.SQLServerException:
Connection reset at com.microsoft.sqlserver.jdbc.SQLServerConnection.
terminate(SQLServerConnection.java:1352) at com.microsoft.sqlserver.jdbc.
SQLServerConnection.terminate(SQLServerConne... 阅读全帖 |
|
P******d
发帖数: 137 | 5 【 以下文字转载自 Statistics 讨论区 】
发信人: PlayCold (玩酷), 信区: Statistics
标 题: 请问如何用JDBC连接R和Hive
发信站: BBS 未名空间站 (Mon Jan 13 14:48:18 2014, 美东)
因为平时都是在Hive下把数据先从Hadoop中提取出来，放到AWS的S3里面，再下载到自
己的电脑上。我想要尝试直接连接R和Hive，用JDBC Driver。
在stackoverflow上找到这个帖子：
http://stackoverflow.com/questions/6057875/establishing-a-conne
但是我在自己尝试的时候，老是出现错误
Error in .jfindClass(as.character(driverClass)[1]) : class not found
这是我的Code：
hive_connection <- function(hostname='myhostname',
port= myportnumber,
... 阅读全帖 |
|
v**t
发帖数: 25 | 6 我在DB2 server 里设置通信的TCP/IP的端口为9999。从别的机器用db2客户端连可以连
上。
但如果我在java程序中用jdbc连时就会连不上，就会死掉，也没有报错。
如果我在server上运行java, 用如下语句可以连上：
String url = "jdbc:db2:mydb";
DriverManager.registerDriver(new COM.ibm.db2.jdbc.app.DB2Driver());
Connection con = DriverManager.getConnection(url, "myuser", "mypass");
但如果用一下语句就会死掉，好像在不断的连
String url = "jdbc:db2://serverIP:portnumber/mydb";
DriverManager.registerDriver(new COM.ibm.db2.jdbc.net.DB2Driver());
Connection con = DriverManager.getConnection(url, "myuser", "mypass") |
|
D********g
发帖数: 650 | 7 stack trace 如下：
SQL ERROR:Sql server generic error (internal) 4!Connection reset;sql state:
08S01;stacktrace: com.microsoft.sqlserver.jdbc.SQLServerException:
Connection reset at com.microsoft.sqlserver.jdbc.SQLServerConnection.
terminate(SQLServerConnection.java:1352) at com.microsoft.sqlserver.jdbc.
SQLServerConnection.terminate(SQLServerConnection.java:1339) at com.
microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1654) at com.
microsoft.sqlserver.jdbc. |
|
v**t
发帖数: 25 | 8 【 以下文字转载自 Database 讨论区 】
【 原文由 vert 所发表 】
我在DB2 server 里设置通信的TCP/IP的端口为9999。从别的机器用db2客户端连可以连
上。
但如果我在java程序中用jdbc连时就会连不上，就会死掉，也没有报错。
如果我在server上运行java, 用如下语句可以连上：
String url = "jdbc:db2:mydb";
DriverManager.registerDriver(new COM.ibm.db2.jdbc.app.DB2Driver());
Connection con = DriverManager.getConnection(url, "myuser", "mypass");
但如果用一下语句就会死掉，好像在不断的连
String url = "jdbc:db2://serverIP:portnumber/mydb";
DriverManager.registerDriver(new COM.ibm.db2.jdbc.net.DB2Driver());
Connection con = DriverMana |
|
b*********d
发帖数: 20 | 9 I used to use JDBC to connect to SQL server. It worked well. Recently, I
reinstalled my computer(including Jdk1.3 Microsoft SQL 2000 Jdbc driver), and
firewall is stalled into the server with SQL database.
When I run the Java program, it can not work. The error messages are as
follows:
I wonder if the server is configured with firewall, can I still use the JDBC
to access the server?
Thanks a lot!
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[ |
|
b*********d
发帖数: 20 | 10 I check it again and find msutil.jar msbase.jar mssqlserver.jar are all in the
classpath.
JDBC
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
com.microsoft.jdbc.base.BaseDriver.setupExceptionHandling(Unknown |
|
c*****t
发帖数: 1879 | 11 You obtain the JDBC driver through the database vendor, occationally
from third party vendors. Sun only include ODBC-JDBC bridge driver with
its runtime library. Some database vendors sell their JDBC drivers
separately from their database while some others provide them for free.
Normally, you include the .jar library file of the jdbc driver as part of
class path. Read Sun's JDBC tutorial... |
|
P******d
发帖数: 137 | 12 因为平时都是在Hive下把数据先从Hadoop中提取出来，放到AWS的S3里面，再下载到自
己的电脑上。我想要尝试直接连接R和Hive，用JDBC Driver。
在stackoverflow上找到这个帖子：
http://stackoverflow.com/questions/6057875/establishing-a-conne
但是我在自己尝试的时候，老是出现错误
Error in .jfindClass(as.character(driverClass)[1]) : class not found
这是我的Code：
hive_connection <- function(hostname='myhostname',
port= myportnumber,
lib_dir="my/dir" ){
hive_jars <- c('commons-logging-1.1.3.jar',
'hadoop-core-1.2.1.jar',
... 阅读全帖 |
|
l**e
发帖数: 42 | 13 【 以下文字转载自 Java 讨论区 】
【 原文由 lice 所发表 】
Java的兴起和发展加速了Internet与Intranet应用的开发。越来越
多的企业使用不受平台限制的Java语言，开发复杂的商务关键任
务。
作为Java语言的创始者，JavaSoft公司早就预见到市场需要一项针
对Java的数据存取技术，并早已与MERANT公司联手开发Java
JDBC技术，作为Java数据库连接技术的一项标准。
JDBC的四种解决方案
JDBC是通用的SQL(结构化查询语言)数据库访问框架，带有简单且
功能强大的应用程序接口(API)。利用JDBC API，Java开发人员可
以在单一的标准化功能库中编码，生成独立于数据库管理系统
(DBMS)的Java应用系统。
|
|
a*********e
发帖数: 35 | 14 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: airforceone (Roy), 信区: Java
标 题: JDBC 处理日期的问题(日期插入数据库)
发信站: The unknown SPACE (Tue May 23 04:47:05 2000) WWW-POST
通过jdbc对oracle insert
我用 Timestamp ts=getTimestamp(x);得到后,用Escape codes 来搞
定.
insert into mrd.lot_histroy
values('SCIHUN','9035034','8000',{ts '1999-08-02
13:21:27.0' },{ts '1999-07-21 00:00:00.0' })
这样居然出错,我不知道怎样做了,或者不这幺作,有其他的办法么,从
一个数据库的一个表取的一个date字端insert到另一个数据库里.
另:附我看见的jdbc处理日期的文章.
deal with date//JDBC
To get the current date in SQL format.
java.u |
|
r*******d
发帖数: 117 | 15 入门问题.
我想用JDBC打开一个MS access数据库.准备用JDBC:ODBC bridge连接.
在Data Source里定义了User DSN:
Data Source name: access
Driver: MS access Driver
Database: Test.mdb
Connection connectionAccess =
DriverManager.getConnection("JDBC:ODBC:access");
然后程序返回出错:
java.sql.SQLException: No suitable Driver.
这是怎么回事? 是不是还需要先load一个JDBC:ODBC driver,
具体怎么做?
多谢指点. |
|
l******r
发帖数: 99 | 16 the whole steps:
1. make sure you create some good mdb files somewhere your user account have
permission to read and/or write.
2. make data source name, choose MS Access Driver ==> go to User DSN (only for
local usage) or System DSN (for mapped drives and web server usage) to create
your DSN. supposed the name is "example".
3. then your dsn is "jdbc:odbc:example"
4. use JDBC API, load jdbc driver first, then connnect to DB use
"jdbc:odbc:example", after that you can execute your SQL statements. |
|
b*********d
发帖数: 20 | 17 I reinstall SQL Jdbc driver and set the classpath again. Now that part works,
but I have the new problem.
Thank everyone.
the
driver),
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd |
|
r*******d
发帖数: 117 | 18 入门问题.
我想用JDBC打开一个MS access数据库.准备用JDBC:ODBC bridge连接.
在Data Source里定义了User DSN:
Data Source name: access
Driver: MS access Driver
Database: Test.mdb
Connection connectionAccess =
DriverManager.getConnection("JDBC:ODBC:access");
然后程序返回出错:
java.sql.SQLException: No suitable Driver.
这是怎么回事? 是不是还需要先load一个JDBC:ODBC driver,
具体怎么做?
多谢指点. |
|
v******e
发帖数: 63 | 19 Although I am a little rusty on the JDBC driver thing, you are even rusty than
I am from what you said. You can only write a type 2 JDBC driver by yourself.
Type 3 needs a RMI/JNDI server. Type 4 is pure java which means you need to
have contract with Oracle in order to know the detail of wire level format.
If you don't like oracle's jdbc driver, you can use BEA weblogic's JDBC
driver.
own
can't
have
seems
it's |
|
z*******3
发帖数: 13709 | 20 存个档
我用的是macbook，网络上的资料太少了
firebird比起mysql来说资料还是少很多
鉴于对oracle的mysql前景的忧心，还是坚决地转向了firebird
但是装逼是有代价的，代价就是网络上资料几乎为0
之前搞成功过一次，但是几乎是狗屎运好撞到的
也不知道为什么，太久不用就忘了是哪个版本了
前几天正好要用到，捣腾两三天，总算弄明白了
开个贴，存个档，以防将来忘记
先说各个系统的版本
macosx: 10.5
jdk: 1.4-1.6都有，但是选择了1.5的版本
然后就是头大的firebird的版本的问题了
firebird小是小，但是问题不少
第一个就是2.5以上的版本不支持在macosx10.6以下版本的运行
所以对我来说只有选择2.1
第二个问题就是，fb有两个版本，一个classic server，另外一个是superserver
前者理论上是可以直接连接，但是要手动启动服务监听3050端口
而且好像在启动的时候就需要给出connection，这个太扯淡了
jdbc可没有办法在dbserver启动之前建立连接，所以坚决干掉
必需选择superserver（s... 阅读全帖 |
|
s**u
发帖数: 17 | 21 I am trying to connect to access database through JDBC:ODBC in a java
programm
I tried to connect to the following url:
JDBC:ODBC:MyServer;database=mydb.mdb
and establish the access file with corresponding server and filename.
but when I run the program, it keep on telling me the following:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3661)
at sun.jd |
|
f********r
发帖数: 16 | 22 我的MYSQL server 是装在redhat6.2下.我试图从远程访问. 我是第一次接触JDBC
和mysql.自己想的连接结构是这样的: MySQL server在远端,IP is
137.132.159.221 ; 我在另一台pc上试图访问它.该pc上安装了JDK1.2.2,
MM.MySQL. 我的程序应用MM.MySQL提供的class,MM.MySQL再和JDBC communicate.
JDBC 完成网络连接以及数据库存取等工作. 这样来作,有没有问题?
另外,我用MM.MySQL连接remote MySQL server的时候,出现了这种错误:
SQLException:Invalid authorization specification: Access denied for
user:'guest@'(Using passowrd: NO)
SQLState:28000
VendorError:1045
关于建立连接的语句,我是这样写的(实际上是从MM.MySQL的document里抄的,
不该有错:():
Connection C = DriverManage |
|
o*b
发帖数: 42 | 23 in oracle jdbc doc, there is a section called "jdbc and nls" which provides
some information regarding how to convert and set character set. I think
the two doc's (nls, jdbc) should be enough for this topic. |
|
t**i
发帖数: 29 | 24 我在Win2000上装了个Oracle8i,想学用JDBC，但连Oracle自带的Jdbc
Checkup.java都不能编译通过。出错信息如下:
JdbcCheckup.java:19: cannot resolve symbol
symbol : class OracleDriver
location: package driver
DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());
^
1 error
不知是我Oracle8i没装全还是什么设置不对，请各位大侠指教。 |
|
h****r
发帖数: 2056 | 25 Want to know how large is the limiation of one complete SQL
insert string can be place into a JDBC Statement and can
insert the big record successfully. I tried up to 13K, JDBC
still can accept it. Does some experienced guru can tell me
what is the size limitation for insert or update SQL string
JDBC can accept it?
Thanks a lot. |
|
V*****y
发帖数: 26 | 26 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: VastSky (广阔天地), 信区: Java
标 题: jdbc with access 2000 problem
发信站: The unknown SPACE (Sun Aug 10 12:51:17 2003) WWW-POST
Hello everyone,
I am working on jdbc with access 2000 and I'd like to provide a password
protection on the table level. It's easy to set this protection in Access 2000
but my question is how to program it with jdbc. I mean suppose I already set
the password for an Access table, what codes in java do I need to write to
enforce this protection. Seem |
|
n********a
发帖数: 68 | 27 Did you explicitly turn off auto commit for the java.sql.Connection object?
JDBC set auto commit to true by default.
Another thing is to check if the JDBC driver functions correctly.
Did you use a Type4 driver or a JDBC-ODBC bridge?
1010 |
|
c*********3
发帖数: 197 | 28 I installed oracle JDBC thin and OCI driver yesterday.
And immediately noticed that queries using JDBC thin were faster than using
OCI driver.
Why?
Could anybody shed light on this?
Thanks, |
|
m***x
发帖数: 492 | 29 【 以下文字转载自 Database 讨论区,原文如下 】
发信人: minix (格物至知), 信区: Database
标 题: JDBC of Oracle9iRelease2
发信站: The unknown SPACE (Sat Jan 4 01:26:38 2003) WWW-POST
thin works, but oci8 doesn't work.
URL as: "jdbc:oracle:oci8:@tita:1521:tita" doesn't work
URL as: "jdbc:oracle:thin:@tita:1521:tita" works well.
What's wrong? |
|
l**d
发帖数: 42 | 30 What you mean? If you use BMP， you still have to deal with JDBC directly.
Only CMP gives you benifit that you can focus on other business logic.
BTW, normally comerical level application servers have very good JDBC
drivers and JDBCpools. Most of them support both Type 3 and Type 4
JDBC drivers. |
|
V*****y
发帖数: 26 | 31 Hello everyone,
I am working on jdbc with access 2000 and I'd like to provide a password
protection on the table level. It's easy to set this protection in Access 2000
but my question is how to program it with jdbc. I mean suppose I already set
the password for an Access table, what codes in java do I need to write to
enforce this protection. Seems to me jdbc only has password protection on
database level when establishing the database connection. Any suggestion or
comments will be greatly appre |
|
m******t
发帖数: 2416 | 32
classpath.
I think his jdbc driver is fine, as you can see in the log message it's
registered and instantiated. The NoClassDefError was caused by something else
(which is weird indeed).
To bigbaldhead, looks like you have to punch a hole in your firewall for port
1433. You might want to reconsider your architecture, though. It's not a
good idea to expose your db server.
JDBC
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
[...] |
|
w********c
发帖数: 2632 | 33 look for msutil.jar and make sure it's in ur classpath or ext dir
and
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd
DriverManager.getConnection("jdbc:microsoft:sqlserver://128.196.***.***:1433;d
driver[className=com.microsoft.jdbc.sqlserver.SQLServerDriver,com.microsoft.jd |
|
l*****e
发帖数: 1431 | 34 Sorry for being clear at the first place. I am trying to implement my own JDBC
driver for Oracle DBMS. It talks with Oracle CLI (as I understand what a type
4 JDBC driver should do) and provides the standard JDBC interface specified by
Sun to other Java applications.
了， |
|
c*********e
发帖数: 16335 | 35 刚看了本书，上面写，如果用于大规模数据，record大于5000行的话，jdbc比
hibernate好。如果要用stored procedure的话，jdbc比hibernate好。
看来在处理大批量数据方面，比如data warehouse级别的数据，用jdbc是最原始也是最
好的选择。 |
|
d****i
发帖数: 4809 | 36 Spring JDBC很好，把raw JDBC的麻烦都省掉了，看到一片文章说用Spring JDBC以后甚
至连Hibernate, JPA这些ORM都不用了，简单，直接又轻便。goodbug有何高见？
you |
|
t*********u
发帖数: 26311 | 37 需要哪些lib/jar?
现在的问题是 DriverManager.getConnection("jdbc:hive2:// )
会报错
xception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/
conf/Configuration
at org.apache.hive.service.cli.thrift.EmbeddedThriftBinaryCLIService.<
init>(EmbeddedThriftBinaryCLIService.java:33)
at org.apache.hive.jdbc.HiveConnection.(HiveConnection.java:163)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.j... 阅读全帖 |
|
c****g
发帖数: 7 | 38 I install oracle8i personal edition and java one
the same machine.
How to set the url?
getConnection ("jdbc:oracle:thin:@"+ database,
------------what should be here? local
machine
"scott", "tiger");
JDBC 新手. Thanks a lot! |
|
z***h
发帖数: 7 | 39 create a table login then try this code:
import java.sql.*;
import java.io.*;
public class JdbcTest
{
public static void main(String args[])
{
//String update = "INSERT INTO login(user_name, password,
user_type) VALUES ('Guest', '143456', 'adminis')";
String query = "SELECT * FROM login";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:ORACLE";
String username = "scott";
String password = "tiger";
try {
// Load the driver to allow connection to the database
Class.forName( |
|
h****r
发帖数: 2056 | 40 Use Java and JDBC, Oracle 8i, cpu PIII 733, 256MB, by LAN to
server,
server is PII 450, 128MB. Thanks a lot for help. Now I can
get each
second only 30 inserts, boss require at least 100 inserts
per second,
How to know some benchmark for Java and JDBC insert run for
Oracle 8i?
What will be the best insert rates per second(each insert no
more than 512 bytes)?
I already enable connection pooling, everytime during
initing will bring
5 to 20 connections ready to save the operation time.
Another q |
|
x*****n
发帖数: 98 | 41 problem: When I update some rows, how can I get the rows that have just been
updated, genericly?
Solution: 1.I've meant to use the JDBC 2.0's new feasures: updatable Resultset.
Unfortunatly the underlying JDBC DB2 driver didn't support it. Then I have to
write a parser to analyze the value expression. That's use select to get the
rows that will be updated. Then compute the new values according the expression
and update the corresponding columns.
The original purpose of it is: build a layer above |
|
k****i
发帖数: 1072 | 42 用db2jstrt 50000开启了java daemon
而且telnet ip 50000成功
能在server的clp下connet to dbname and select * from tablename
用COM.ibm.db2.jdbc.net.DB2Driver
url = "jdbc:db2://"+"ip:50000"+"/dbname"
正确的用户名和password
connect时返回错误"sql1031N The database directory cannot be found one the
indicated file system.SQLSTATE=58031"
list database directory看dbname and alias正常
有大虾遇到这情况吗？
btw,一样的程序连自己win2000 localhost的db没问题。就是连远程host出问题。 |
|
c********x
发帖数: 93 | 43 what's your question? if you want to load a special JDBC driver and
connect to a database, you can try like below(you need modify the driver
name and location of DB accordingly)
Class.forName("my.sql.Driver").newInstance();
Connection connect =
DriverManager.getConnection("jdbc:mysql://hostname/dbname","yourlogin","yourpa
ssword"); |
|
m***x
发帖数: 492 | 44 thin works, but oci8 doesn't work.
URL as: "jdbc:oracle:oci8:@tita:1521:tita" doesn't work
URL as: "jdbc:oracle:thin:@tita:1521:tita" works well.
What's wrong? |
|
p***n
发帖数: 635 | 45 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: payan (沛岩), 信区: Java
标 题: MS SQL Server JDBC Driver Problem
发信站: Unknown Space (Sun Aug 17 02:35:53 2003) WWW-POST
I am using MS SQL SERVER JDBC DRIVER under Weblogic 7 to call an MS SQL Server
stored procedure. The stored procedure returns a xml string like this:
...
...
...
so far so good.
the problem comes up when there is some characters like "'" is contained in
the string, e.g.,
Let's go and have fun
Then the SP c |
|
g*******e
发帖数: 32 | 46 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 | 47 怎么知道现在用的Oracle(用的是9i)的JDBC是哪个版本的?
如果用的是1.0的
怎么设置让Oracle用2.0版本的JDBC?
DB2都有批处理文件可以进行设置的 |
|
s****r
发帖数: 36 | 48 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! |
|
yb
发帖数: 171 | 49 using jdbc odbc bridge. tried to load db2 drive and only used jdbc, failed. do
not know why.
thanks to those who replied. |
|
e****y
发帖数: 26 | 50 In doing a course project, i need to create table, insert data into a DBMS,
I wonder which interface is better?
JDBC or SQL-C? Which is easier or more powerful?
I have some experiences with Pro*C(C/C++ interface of Oracle) but never
touch JDBC before.
Any suggestion is appreciated. |
|
