Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Jconn Bulk insert option fails

2 posts in General Discussion Last posting was on 2010-02-24 13:49:05.0Z
Yaniv C. Posted on 2010-02-24 09:08:27.0Z
Sender: 77de.4b84ebfc.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Jconn Bulk insert option fails
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b84ec8b.77ec.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Feb 2010 01:08:27 -0800
X-Trace: forums-1-dub 1267002507 10.22.241.41 (24 Feb 2010 01:08:27 -0800)
X-Original-Trace: 24 Feb 2010 01:08:27 -0800, 10.22.241.41
Lines: 63
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28995
Article PK: 78232

Hi

I am testing Jconn3 (so far used jconn2) With Java 5

This is the connection string
jdbc:sybase:Tds:10.161.59.2:5000/products?ENABLE_BULK_LOAD=true&PACKETSIZE=4096&CHARSET=utf8&JCONNECT_VERSION=6.05&APPLICATIONNAME=DBS_POOL

We are using:
[root@dbs] /opt/sybase/ASE-15_0/bin # dataserver -v
Adaptive Server Enterprise/15.0.2/EBF 16509 ESD#6
ONE-OFF/P/x86_64/Enterprise
Linux/ase1502/2539/64-bit/FBO/Tue Jan 13 06:41:06 2009

[root@dbs] /opt/sybase/OCS-15_0/bin # isql -v
Sybase CTISQL Utility/15.0/P-EBF15861 ESD
#14/DRV.15.0.6/Linux Intel/Linux 2.4.21-47.0.1.ELsmp
i686/BUILD1500-110/OPT/Wed Jun 11 23:33:14 2008

On java, on line prepare statement
Prepare statement(“insert into myTable values(?,?)”)

Exception rises when ENABLE_BULK_LOAD set to false, no
errors.
What do I miss

The exception is


java.sql.SQLException: JZ0SJ: Metadata accessor information
was not found on this database. Please install the required
tables as mentioned in the jConnect documentation.
at
com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown
Source)
at
com.sybase.jdbc3.jdbc.MdaManager.getMetaDataAccessor(Unknown
Source)
at
com.sybase.jdbc3.jdbc.MdaManager.getMetaDataAccessor(Unknown
Source)
at
com.sybase.jdbc3.jdbc.MdaManager.getMetaDataAccessor(Unknown
Source)
at com.sybase.jdbc3.jdbc.SybBCP.<init>(Unknown Source)
at
com.sybase.jdbc3.jdbc.SybPreparedStatement.a(Unknown Source)
at
com.sybase.jdbc3.jdbc.SybPreparedStatement.<init>(Unknown
Source)
at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown
Source)
at
com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown
Source)
at
com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown
Source)
at com.test.Main.doBulkInsert(Main.java:45)
at com.test.Main.main(Main.java:32)


Thanks,
Yaniv


Neal Stack [Sybase] Posted on 2010-02-24 13:49:05.0Z
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Jconn Bulk insert option fails
References: <4b84ec8b.77ec.1681692777@sybase.com>
In-Reply-To: <4b84ec8b.77ec.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b852e51$1@forums-1-dub>
Date: 24 Feb 2010 05:49:05 -0800
X-Trace: forums-1-dub 1267019345 10.22.241.152 (24 Feb 2010 05:49:05 -0800)
X-Original-Trace: 24 Feb 2010 05:49:05 -0800, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28996
Article PK: 78233

Hello,

Install the stored procedures that jConnect needs:
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32179.0605/html/jconnig/BABDFIDJ.htm
===========================================================================
% isql -Usa -P -w 132
1> sp_version
2> go
Script
Version
Status
------------------------------
-----------
----------
ODBC MDA Scripts
12.5.1.516/Wed 05-10-2006 17:18:22.50
Complete
OLEDB MDA Scripts
12.5.1.500/Fri 12-23-2005 12:59:25.57
Complete
installjdbc
jConnect (TM) for JDBC(TM)/6.05(Build 25963)/P/EBF13722/JDK14/Mon Jun 12
21:30:48 2006
Complete
1> select @@version
2> go

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.4/EBF 16128 ESD#9/P/Sun_svr4/OS
5.8/ase1254/2143/64-bit/FBO/Thu Feb 5 02:50:34 2009
===========================================================================
--
Regards,
Neal