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.

ianywhere.ml.jdbcodbc.IDriver

6 posts in General Discussion Last posting was on 2008-04-02 12:55:03.0Z
Dave Westphal Posted on 2008-04-01 19:33:59.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
Subject: ianywhere.ml.jdbcodbc.IDriver
Keywords: JDBC
Lines: 26
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f28e27$1@forums-1-dub>
Date: 1 Apr 2008 11:33:59 -0800
X-Trace: forums-1-dub 1207078439 10.22.241.152 (1 Apr 2008 11:33:59 -0800)
X-Original-Trace: 1 Apr 2008 11:33:59 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6783
Article PK: 5023

I am not sure which news group to post this to, I thought I would start in
the general.

I am trying to configure SalesForce DataLoader to use the
ianywhere.ml.jdbcodbc.IDriver JDBC driver.
I am currently using Adaptive Server Anywhere Network Server Version
9.0.2.3486

I am having difficulty coming up with the correct url to pass.
I have tried "jdbc:odbc:DataSource=FRAME_STAGING",
"jdbc:odbc:dsn=FRAME_STAGING","jdbc:odbc:SERVICENAME=FRAME_STAGING"

My primary error that I receive is: caused by: java.sql.SQLException:
[Microsoft] ODBC Driver manager] Data source name not found and no default
driver specified.

I have gotten Jconnect2 and Jconnect3 to connect, but have seen problems
where records have NULLS in some of the fields and wanted to see if the
"ianywhere.ml.jdbcodbc.IDriver JDBC driver" would work.

Can someone tell me where I can find information to resolve this issue?

Thanks in advance,
Dave


Chris Keating (Sybase iAnywhere) Posted on 2008-04-01 20:13:57.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ianywhere.ml.jdbcodbc.IDriver
References: <47f28e27$1@forums-1-dub>
In-Reply-To: <47f28e27$1@forums-1-dub>
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: <47f29785$1@forums-1-dub>
Date: 1 Apr 2008 12:13:57 -0800
X-Trace: forums-1-dub 1207080837 10.22.241.152 (1 Apr 2008 12:13:57 -0800)
X-Original-Trace: 1 Apr 2008 12:13:57 -0800, vip152.sybase.com
Lines: 46
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6784
Article PK: 5024

It is recommended that you use jdbc.ianywhere versus jdbc.odbc. The
later can get confused with the SUN bridge particularly if using JRE 1.6
or later. The jdbc:ianywhere format was added in an EBF after 9.0.2.3441

The correct syntax is

jdbc:ianywhere:<connection_string>

So, if you are using a DSN, the URL would be

jdbc:ianywhere:DSN=<your_dsn>

or as a DNSLess connection:

jdbc:ianywhere: \
Driver=Adaptive Server Anywhere 9.0;<connection_string>

Dave Westphal wrote:
> I am not sure which news group to post this to, I thought I would start in
> the general.
>
> I am trying to configure SalesForce DataLoader to use the
> ianywhere.ml.jdbcodbc.IDriver JDBC driver.
> I am currently using Adaptive Server Anywhere Network Server Version
> 9.0.2.3486
>
> I am having difficulty coming up with the correct url to pass.
> I have tried "jdbc:odbc:DataSource=FRAME_STAGING",
> "jdbc:odbc:dsn=FRAME_STAGING","jdbc:odbc:SERVICENAME=FRAME_STAGING"
>
> My primary error that I receive is: caused by: java.sql.SQLException:
> [Microsoft] ODBC Driver manager] Data source name not found and no default
> driver specified.
>
> I have gotten Jconnect2 and Jconnect3 to connect, but have seen problems
> where records have NULLS in some of the fields and wanted to see if the
> "ianywhere.ml.jdbcodbc.IDriver JDBC driver" would work.
>
> Can someone tell me where I can find information to resolve this issue?
>
> Thanks in advance,
> Dave
>
>


Dave Westphal Posted on 2008-04-01 21:24:53.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
References: <47f28e27$1@forums-1-dub> <47f29785$1@forums-1-dub>
Subject: Re: ianywhere.ml.jdbcodbc.IDriver
Lines: 185
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f2a825@forums-1-dub>
Date: 1 Apr 2008 13:24:53 -0800
X-Trace: forums-1-dub 1207085093 10.22.241.152 (1 Apr 2008 13:24:53 -0800)
X-Original-Trace: 1 Apr 2008 13:24:53 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6785
Article PK: 5026

Thanks just changing to jdbc:ianywhere got me past the log in issue.
No I am seeing a different error getting logged, but I don't know where the
issue is.
I am attaching the output with the error in it ( ianywhere.txt ).

2008-04-01 16:00:50,877 ERROR [databaseUserExtract] database.DatabaseWriter
writeRowList (DatabaseWriter.java:155) - Database error encountered while
preparing row#1 for writing row#1 through row#102. Database configuration:
updateUser. Sql error: Not implemented.
java.sql.SQLException: Not implemented


If there is a way to log more detail to help pinpoint the error let me know.

Thanks again for all your help on this,
Dave

"Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com> wrote
in message news:47f29785$1@forums-1-dub...
> It is recommended that you use jdbc.ianywhere versus jdbc.odbc. The
> later can get confused with the SUN bridge particularly if using JRE 1.6
> or later. The jdbc:ianywhere format was added in an EBF after 9.0.2.3441
>
> The correct syntax is
>
> jdbc:ianywhere:<connection_string>
>
> So, if you are using a DSN, the URL would be
>
> jdbc:ianywhere:DSN=<your_dsn>
>
> or as a DNSLess connection:
>
> jdbc:ianywhere: \
> Driver=Adaptive Server Anywhere 9.0;<connection_string>
>
>
>
> Dave Westphal wrote:
>> I am not sure which news group to post this to, I thought I would start
>> in
>> the general.
>>
>> I am trying to configure SalesForce DataLoader to use the
>> ianywhere.ml.jdbcodbc.IDriver JDBC driver.
>> I am currently using Adaptive Server Anywhere Network Server Version
>> 9.0.2.3486
>>
>> I am having difficulty coming up with the correct url to pass.
>> I have tried "jdbc:odbc:DataSource=FRAME_STAGING",
>> "jdbc:odbc:dsn=FRAME_STAGING","jdbc:odbc:SERVICENAME=FRAME_STAGING"
>>
>> My primary error that I receive is: caused by: java.sql.SQLException:
>> [Microsoft] ODBC Driver manager] Data source name not found and no
>> default
>> driver specified.
>>
>> I have gotten Jconnect2 and Jconnect3 to connect, but have seen problems
>> where records have NULLS in some of the fields and wanted to see if the
>> "ianywhere.ml.jdbcodbc.IDriver JDBC driver" would work.
>>
>> Can someone tell me where I can find information to resolve this issue?
>>
>> Thanks in advance,
>> Dave
>>
>>


Jeff Albion (Sybase iAnywhere) Posted on 2008-04-01 21:50:14.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ianywhere.ml.jdbcodbc.IDriver
References: <47f28e27$1@forums-1-dub> <47f29785$1@forums-1-dub> <47f2a825@forums-1-dub>
In-Reply-To: <47f2a825@forums-1-dub>
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: <47f2ae16@forums-1-dub>
Date: 1 Apr 2008 13:50:14 -0800
X-Trace: forums-1-dub 1207086614 10.22.241.152 (1 Apr 2008 13:50:14 -0800)
X-Original-Trace: 1 Apr 2008 13:50:14 -0800, vip152.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6786
Article PK: 5027

Dave,

You raised a SQLException ("Not Implemented") by calling
Statement.clearBatch() in DatabaseWriter.java on line 155.

Our implementation of the java.sql.Statement interface does not support
this method.

Regards,

Dave Westphal wrote:
> Thanks just changing to jdbc:ianywhere got me past the log in issue.
> No I am seeing a different error getting logged, but I don't know where the
> issue is.
> I am attaching the output with the error in it ( ianywhere.txt ).

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Dave Westphal Posted on 2008-04-02 11:47:20.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
References: <47f28e27$1@forums-1-dub> <47f29785$1@forums-1-dub> <47f2a825@forums-1-dub> <47f2ae16@forums-1-dub>
Subject: Re: ianywhere.ml.jdbcodbc.IDriver
Lines: 224
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f37248$1@forums-1-dub>
Date: 2 Apr 2008 03:47:20 -0800
X-Trace: forums-1-dub 1207136840 10.22.241.152 (2 Apr 2008 03:47:20 -0800)
X-Original-Trace: 2 Apr 2008 03:47:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6790
Article PK: 5028

Thanks, I was able to reduce my batch size down to 1 to get past that error.

Now I am getting the following error:
Error creating PreparedStatement for the database configuration updateUser.
Error replacing parameter: Title with value: null of type: null. Sql error:
JZ0SE: Invalid object type (or null object) specified for setObject()..
java.sql.SQLException: JZ0SE: Invalid object type (or null object) specified
for setObject().

I am attaching the Ianywhere.txt file with the error in it.

Not sure why null error is occurring, is it that the value being written to
the database can not be null?
Are there any settings in the database that can be altered to allow the null
value?

I am getting this same error with JConnect2, JConnect3 and the JDBCODBC
bridge.

Is there a way around this issue?

Any help on this would be appreciated.

Thanks in advance
Dave

"Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com> wrote in
message news:47f2ae16@forums-1-dub...
> Dave,
>
> You raised a SQLException ("Not Implemented") by calling
> Statement.clearBatch() in DatabaseWriter.java on line 155.
>
> Our implementation of the java.sql.Statement interface does not support
> this method.
>
> Regards,
>
> Dave Westphal wrote:
>> Thanks just changing to jdbc:ianywhere got me past the log in issue.
>> No I am seeing a different error getting logged, but I don't know where
>> the
>> issue is.
>> I am attaching the output with the error in it ( ianywhere.txt ).
>
> --
> Jeff Albion, Product Support Analyst
> Sybase iAnywhere
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs :
> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Dave Westphal Posted on 2008-04-02 12:55:03.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
References: <47f28e27$1@forums-1-dub> <47f29785$1@forums-1-dub> <47f2a825@forums-1-dub> <47f2ae16@forums-1-dub> <47f37248$1@forums-1-dub>
Subject: Re: ianywhere.ml.jdbcodbc.IDriver
Lines: 74
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47f38227$1@forums-1-dub>
Date: 2 Apr 2008 04:55:03 -0800
X-Trace: forums-1-dub 1207140903 10.22.241.152 (2 Apr 2008 04:55:03 -0800)
X-Original-Trace: 2 Apr 2008 04:55:03 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6791
Article PK: 5030

Sorry for the confusion the last log posted was from JConnect2 environment
not the iAnywhere JDBC driver.
The iAnywhere JDBC driver continues to error regarding ClearBatch. I will
check with the Vendor if there is away around the calling of ClearBatch()
for the iAnywhere Driver.

Just wanted to clarify that the error regarding nulls is not from the
iAnywhere driver it is from the JConnect2 driver as well as the JConnect3
driver.

"Dave Westphal" <Dave_Westphal@aal.org> wrote in message
news:47f37248$1@forums-1-dub...
> Thanks, I was able to reduce my batch size down to 1 to get past that
> error.
>
> Now I am getting the following error:
> Error creating PreparedStatement for the database configuration
> updateUser. Error replacing parameter: Title with value: null of type:
> null. Sql error: JZ0SE: Invalid object type (or null object) specified
> for setObject()..
> java.sql.SQLException: JZ0SE: Invalid object type (or null object)
> specified for setObject().
>
> I am attaching the Ianywhere.txt file with the error in it.
>
> Not sure why null error is occurring, is it that the value being written
> to the database can not be null?
> Are there any settings in the database that can be altered to allow the
> null value?
>
> I am getting this same error with JConnect2, JConnect3 and the JDBCODBC
> bridge.
>
> Is there a way around this issue?
>
> Any help on this would be appreciated.
>
> Thanks in advance
> Dave
>
> "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com> wrote
> in message news:47f2ae16@forums-1-dub...
>> Dave,
>>
>> You raised a SQLException ("Not Implemented") by calling
>> Statement.clearBatch() in DatabaseWriter.java on line 155.
>>
>> Our implementation of the java.sql.Statement interface does not support
>> this method.
>>
>> Regards,
>>
>> Dave Westphal wrote:
>>> Thanks just changing to jdbc:ianywhere got me past the log in issue.
>>> No I am seeing a different error getting logged, but I don't know where
>>> the
>>> issue is.
>>> I am attaching the output with the error in it ( ianywhere.txt ).
>>
>> --
>> Jeff Albion, Product Support Analyst
>> Sybase iAnywhere
>>
>> iAnywhere Developer Community : http://www.ianywhere.com/developer
>> iAnywhere Documentation :
>> http://www.ianywhere.com/developer/product_manuals
>> ASA Patches and EBFs :
>> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
>
>
>